Loading... Please wait...

Excel 2007 Training Videos

Excel 2007 Training Videos

$49.95
SKU
excel2007
Rating
Availability
Usually ships in 1 to 2 business days.
Shipping
Calculated at checkout

Product Description

  • After purchase you will be directed to download the training video file.
  • Unlimited viewing of the training video(s) for one computer.
  • After purchase your training video DVD(s) will be shipped to you.
  • Unlimited viewing of the training video(s) for one computer.

Excel 2007 Training Videos will introduce you to the basics of creating a: spreadsheet, with simple formulas and calculations to more powerful ones, and how you can use Excel 2007 as a database with many sorting and filtering options. It's also important to know how to create your database right the first time, like how to avoid common design flaws, and numerous time saving features!

Learn how to create charts from your organized data, how to format your data range into a nice looking table, and more by our Microsoft Certified Trainer training Excel 2007!

DVD includes Excel 2007 Levels 1, 2 & 3 training videos in both: Flash (.swf) and Windows Media Video (.wmv). Our Excel 2007 Levels 1, 2 & 3 training videos include all the training you need to pass the Excel 2007 Core (77-602) and Expert (77-851) Exams and become certified!

Excel Level 1 (4 hrs):

Basics

  1. Excel Getting Started (14:29) - Click Here To Watch Demo!
  2. Quick Access Toolbar (8:51)
  3. Data Entry (14:21)
  4. Converting to 2007 (10:37)
  5. Converting to Previous (4:33)
  6. Move Copy Cut Data (5:41)
  7. AutoFill Feature (3:13)
  8. Editing Data (12:11)
  9. Find and Replace (5:55)
  10. GoTo Feature (3:13)
  11. Spell Check (1:24)

Functions & Formulas

  1. Basic Formulas (10:27)
  2. SUM and AVERAGE (12:59)
  3. MAX and MIN (2:34)
  4. COUNT and COUNTA (3:43)
  5. Absolute Reference (6:21)
  6. Mixed References (11:09)
  7. Text To Columns (3:48)
  8. Combine Columns (4:15)

Formatting

  1. Modifying Fonts (3:20)
  2. Borders and Shading (5:52)
  3. Adding Backgrounds (1:03)

Editing Worksheets

  1. Adjusting Columns Rows (5:20)
  2. Text Wrapping (3:38)
  3. Hide Columns Rows (2:41)
  4. Merge Cells (2:59)
  5. Formatting Numbers (8:41)
  6. Create Modify Styles (4:21)
  7. AutoFormat (2:19)
  8. Applying Themes (8:52)
  9. Modifying Worksheets (7:43)

Modifying Worksheet Appearance

  1. Print Titles (2:23)
  2. Headers and Footers (8:22)
  3. Margins (4:10)
  4. Page Orientation (2:16)
  5. Page Breaks (5:08)
  6. Print Scaling (4:22)
  7. Set Print Area (3:21)
  8. Split Window (2:50)
  9. Freeze Panes (3:14)
  10. Arranging Worksheets (4:10)
  11. Hide Worksheet Books (2:39)
  12. Speak Cells (3:57)

Excel 2007 Level 2 (3.5 hrs):

Customize

  1. Customize Excel 2007 Interface (3:18)
  2. Watermarks and Gridlines (7:53)
  3. Customize Themes (5:04)
  4. Cell Comments (6:25)
  5. Create Hyperlinks (6:39)
  6. Web Research (1:08)
  7. Custom Templates (8:39)

Tables

  1. Create Tables (3:01)
  2. Modifying Tables (5:44)
  3. Custom Table Styles (2:13)

Charts

  1. Create Charts (5:49)
  2. Modify Charts (7:07)
  3. Chart Templates (1:27)
  4. Chart Sharing (1:10)

PivotTable & Charts

  1. Create PivotTables A (9:40)
  2. Create PivotTables B (5:16)
  3. Create PivotCharts (5:07)

Graphics

  1. Insert Pictures (2:28)
  2. Draw Modify Shapes (5:08)
  3. SmartArt Processes (4:37)
  4. Clip Art (2:18)
  5. Layering and Groups (5:44)

Advanced Formulas

  1. Create Name Ranges (7:03)
  2. Linking Data (4:43)
  3. Time Functions (3:41)
  4. LEFT and SEARCH A (9:32)
  5. RIGHT SEARCH and LEN B (9:25)
  6. PROPER UPPER and LOWER (2:58)
  7. SUM COUNT AVG Ifs (8:36)
  8. HLOOKUP (7:56)
  9. VLOOKUP (6:50)
  10. IF AND and OR (6:11)
  11. Nested IF (4:13)
  12. IFERROR (5:17)
  13. Display & Print Formulas (2:30)
  14. PMT Payment (4:25)
  15. Sort, Consecutive Sorts & Database Design Flaws (9:22)
  16. Advanced AutoFilter (7:08)
  17. DSUM DAVG DCOUNT (10:40)
  18. Subtotals (4:47)

Excel 2007 Level 3 (2.9 hrs):

Workbook

  1. Macro Basics (8:34)
  2. Editing Macros (4:53)
  3. Advanced Filter and Macros (8:17)
  4. Conditional Formatting (3:47)
  5. Validation Rule (6:32)
  6. Workbook Properties (3:27)
  7. Excel Default Settings (2:04)

Collaborating

  1. Protect Worksheet (7:39)
  2. Protect Structure and Windows (2:06)
  3. Protect  Workbook and  Backup A (3:59)
  4. Protect  Workbook and Backup B (5:29)
  5. Share Workbook (10:15)
  6. Protect Shared Workbook (5:03)
  7. Merge Workbooks (6:07)
  8. Macro Settings (3:20)
  9. Digital Signatures (10:43)
  10. Restrict Access by User (8:54)

Audit Worksheets

  1. Formula Auditing (4:04)
  2. Circle Invalid Data (2:30)
  3. Watch & Evaluate Formulas (5:18)
  4. Automatic Outline and Group (5:57)

Analyzing Data

  1. Chart Trend Lines (1:42)
  2. Scenario Manager (5:36)
  3. Goal Seek (2:52)
  4. Solver (4:59)
  5. Random Sampling (8:10)
  6. Workspace (2:34)
  7. Consolidate Data (4:25)
  8. Link Workbooks (5:54)

Import & Export Data

  1. Export To Word (1:48)
  2. Import Text Files (1:31)
  3. Publish Worksheets To Web (1:39)
  4. Import Data From Web (2:22)
  5. XML Structuring (10:41)
  6. Advanced  Number (6:01)
Excel 2007 Training Videos

Excel 2007 training videos from Dream Force — training videos solutions.
Affordable Excel 2007 training videos
.

Find Similar Products by Category

Product Reviews

Write your own product review

Previous | Showing reviews 11-20 of 41 | Next

  1. The best video training approach of all the video demos I've looked at.

    The excel 2007 DVD is GREAT! The best video training approach of all the video demos I've looked at - and I've researched them all. Even better is knowing that all the dvd's in your collection will be of the same great quality and presented by the same instructor with the same approach. Do you have any kind of quizzes or practice exercises available for download that go along with the classes? Also, any idea when a 2010 Office set will be available for purchase?

    Mary S. - Illinois (Submitted on 17th Feb 2015)


  2. It is a fantastic video which, I am sure, can help me to improve my excel skills a lot.

    Yes, I received the DVD on Jan.6 which was actually earlier than I expected. Now I am watching the DVD and learning Excel from you every night. It is a fantastic video which, I am sure, can help me to improve my excel skills a lot. I am thinking to write some comments on your website like the others.^_^ Thank you again for the great video. If I want to improve my PowerPoint skills in the future, I will definitely go to you again. Yours sincerely,

    Yong Y. - Canada (Submitted on 17th Feb 2015)


  3. If anyone ever needs a training aid I will definitely give them your address!

    I just want to say thank you for the quick and prompt response. You were very courteous and helpful which is a rarity now a days. Everything works just fine, and if anyone ever needs a training aid I will definitely give them your address! I have your site saved on my favorites bar so you're just a click away! Thanks!

    Vernell J. - Indiana (Submitted on 17th Feb 2015)


  4. I really like your training videos.

    I really like your training videos.

    David G. - North Carolina (Submitted on 17th Feb 2015)


  5. Thank you for the Excellent videos.

    Thank you for the Excellent videos, and I look forward for the purchase of Project 2007 videos.

    Phani S. - India (Submitted on 17th Feb 2015)


  6. Thank you again for the well explanatory videos.

    Thank you again for the well explanatory videos.

    George S. - United Kingdom (Submitted on 17th Feb 2015)


  7. Thanks a million, I will spread the word.....

    Thanks for you immediate action. This program is outstanding, I will finally learn how to use Word, Excel and Power Point. I was using Professor Teaches Word, it worked but, was a little too slow for me. Thanks a million, I will spread the word.....

    Sonia O. - Ohio (Submitted on 17th Feb 2015)


  8. What a stress-free way to learn!

    I purchased both the 2007 Word and Excel training videos by Kirt Kershaw after reading customer reviews of the videos. I had been looking for just this kind of training video to help me be more comfortable and proficient using both programs. I consider myself a novice and really wanted something I could use on my computer and do at home at my own pace. Kirt Kershaw's teaching style is great. He speaks clearly and goes over each detail in the program to help the student get comfortable working within its framework. The lessons are well organized and the instructions easy to follow. I like the fact I can go over and over these training videos whenever I want and learn more each time as I remember more steps. I truly feel I will achieve my goal of becoming more adept with each program after I've worked with the videos over the course of time. This is a much more convenient way for me to learn than going to a computer class at a learning institution or training center, and certainly easier than reading a text book. I also purchased both the above training videos as gifts for my sister as she also had been looking for a convenient way to learn these programs at home at her own pace. Her comments regarding the videos were similar to mine and she also really appreciates Kirt's teaching style. I look forward to learning from other training videos by Kirt Kershaw. What a stress-free way to learn!

    Diana O. - California (Submitted on 17th Feb 2015)


  9. My students really enjoyed the course and most of them made A's and B's in the course because of the Dream Force Excel Training Video.

    I teach Excel at a community college in my town. The Dream Force Excel DVD Video was a wonderful tool in teaching Excel to my students. After each section, I would stop the DVD and have my students to get hands-on-experience by doing the exercises. Some of the students had dropped the class previously because their instructor taught them by using the textbook and it was confusing and was hard for them to understand. My students really enjoyed the course and most of them made A's and B's in the course because of the Dream Force Excel Training Video. I also recommended that my students should purchase a copy of the DVD from Amazon.com if they wanted to take the Microsoft Excel Certification exam in the near future. I give it 5 stars!

    Gary W. - West Virginia (Submitted on 17th Feb 2015)


  10. Actually surprised to find things that I didn't know.

    Very easy to follow from beginner to advanced... I am very pleased with these training videos. I went through the basic videos first even though I am familiar with the basic functions of Excel and was actually surprised to find things that I didn't know. The videos are structured that it is very easy to find the instructions for what you want to do as the videos are separated out so that you don't have to search through hours of video to find one certain thing. All in all, I don't think you can find better training anywhere else at a price like this.

    Dennis K. - Georgia (Submitted on 17th Feb 2015)


Previous | Showing reviews 11-20 of 41 | Next



Sign up to receive information about new videos:

Contact Info

Professional & Certified Training
on Microsoft's Office: Access, Excel, Outlook, PowerPoint, Project and Windows.

Dream Force, LLC
10348 S. 2420 E.
Sandy, UT 84092

800-978-9790
801-278-0892

Kirt Kershaw
Microsoft Certified Trainer

Kirt has over a decade of training experience with Microsoft's Office and Windows. He holds Microsoft Certifications from the year 2000 to the present, and can help you certify too!


Access 2016 Training Videos | Excel 2016 Training Videos | Word 2016 Training Videos | Office 2013 Training Videos | Access 2013 Training Videos | Excel 2013 Training Videos | Outlook 2013 Training Videos | PowerPoint 2013 Training Videos | Project 2013 Training Videos | Word 2013 Training Videos | Office 2010 Training Videos | Access 2010 Training Videos | Excel 2010 Training Videos | Outlook 2010 Training Videos | PowerPoint 2010 Training Videos | Project 2010 Training Video | Word 2010 Training Videos | Office 2007 Training Videos | Access 2007 Training Videos | Excel 2007 Training Videos | Outlook 2007 Training Videos | PowerPoint 2007 Training Videos | Project 2007 Training Videos | Word 2007 Training Videos | Windows 7 Training Videos | Windows Vista Training Videos

Microsoft Office Training Videos Home | DVD | Download | Reviews | About | Contact

Click the button below to add the Excel 2007 Training Videos to your wish list.