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 31-40 of 41 | Next

  1. The testimonials are right - great customer service and feedback.

    Thanks for getting back to me so promptly. I have high expectations from the course.

    Aditya S. - Virginia (Submitted on 17th Feb 2015)


  2. After watching the videos and taking the exam, I strongly agree with this statement.

    I downloaded this product from the Website, to learn the new elements of Excel 2007, as I was familiar with previous versions of Excel and to gain the training to take a Microsoft Certified Application Specialist Excel 2007 exam. The videos were great. They are clear and provide examples of how to use the different components of the Excel 2007. The videos are broken into sections/topics which allow the user to obtain the knowledge of the application. They are also very comprehensive and cover all the different areas of the application. The website states that the videos contain all the training to pass the exam - After watching the videos and taking the exam, I strongly agree with this statement. Thanks to the videos, I was able to learn the application and pass my MCAS Excel 2007 exam. I recommend it without any hesitation.

    Matthew W. - Barbados (Submitted on 17th Feb 2015)


  3. The instructor has an amazing voice and knows his stuff real well.

    I have purchased the Excel 2007 for an exam that I was preparing for; and this dvd has helped me a lot. The Financial Test went very good. Your video tutorial has all the things that were asked....It's a GREAT video for a small price. The lessons are easy to follow and well presented - you'll be amazed at how quick you can learn. A brilliant DVD - I strongly recommend.

    Leon A. - California (Submitted on 17th Feb 2015)


  4. This is one of the best training vehicles I have used.

    I had always wanted to learn about Excel but never was ambitious enough to go the "trial and error" methods. This video steers you very precisely through anything you want to do with Excel, from the user entry level to very complicated stuff you probably would never learn on your own.

    The DVD's came lickety-split in the mail and you will be able to get right to it.

    My one very small caveat is that Kirt goes through the lessons at somewhat of an accelerated pace so you need to be very alert to keep up with his explanations.

    I will be ordering some of the other Office videos in the near future. I am looking forward to getting the Word series DVD. This will be my second purchase from you after having ordered the Excel video series... and was really learning a lot.

    George R. - Florida (Submitted on 17th Feb 2015)


  5. Very well put together program.

    I just received your Excel 2007 Video Trainer. I would like to say thanks and compliment you on a very well put together program.

    Bobby K. - California (Submitted on 17th Feb 2015)


  6. I enjoy your lessons very much and your support has been awesome.

    I enjoy your lessons very much and your support has been awesome.

    Don M. - Illinois (Submitted on 17th Feb 2015)


  7. Very professional and valuable so far.

    Very professional and valuable so far.

    Tomas M. - Florida (Submitted on 17th Feb 2015)


  8. Your videos are great, and your teaching materials are amazing.

    Your videos are great, and your teaching materials are amazing.

    Elia G. - Canada (Submitted on 17th Feb 2015)


  9. Keep those training video's coming.

    Thanks again for the quick response and great customer service. I am eagerly awaiting your release of Windows 7, it is a great update but very different from Windows XP. I am now up and training on my new laptop, thanks again.

    Stephen D. - New York (Submitted on 17th Feb 2015)


  10. The Microsoft Word 2007 and Excel 2007 training videos are great.

    The Microsoft Word 2007 and Excel 2007 training videos are great.

    Brad O. - Oregon (Submitted on 17th Feb 2015)


Previous | Showing reviews 31-40 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.