800.978.9790
 Loading... Please wait...


  • Image 1

Excel 2007 Training Videos

$49.95
SKU:
excel2007v
Availability:
Usually ships in 1 to 2 business days.
Shipping:
Calculated at checkout
Quantity:

Product Description

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 2007 Level 1 (4 hrs):

Basics

  1. Excel Getting Started (14:29)
  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

 

Excel 2007 Training Videos

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

Product Reviews

Write Review

Previous | Showing reviews 11-20 of 42 | Next

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

    Posted by on 21st Oct 2015

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

  2. 5 Star Review Very pleased with the Excel 2007 Training.

    Posted by on 21st Oct 2015

    First off let me tell you that I am very pleased with the Excel 2007 Training material I recently purchased from you and that it is my intention to order the Access 2007 material soon.

  3. 5 Star Review GREAT PRODUCT FOR BEGINNNERS!!!

    Posted by on 21st Oct 2015

    I wanted to brush up on my Excel skills for my job search and was having some difficulties with textbooks- I need to "see" what's happening instead of reading about it. I am so glad I found this DVD! I love the teaching style, the different tips and examples given in the lessons, and how it's broken down so you can learn at a pace comfortable for you. I really liked that it is designed for the "real world" user who isn't an expert, so the language and format was easy to follow for the average consumer. Sometimes these teaching DVDs can get too technical for me. I know that Microsoft Office classes given locally cost over $250 per level!! I believe the quality and quantity of information you get from Kirt Kershaw is just as good, if not better. I have already recommended this to a friend and will definitely be purchasing the other DVDs in the future.

  4. 5 Star Review Excellent videos look forward to dealing with you in the future.

    Posted by on 21st Oct 2015

    Excellent videos look forward to dealing with you in the future.

  5. 5 Star Review So happy that I'm going to order the Office 2007 bundle also.

    Posted by on 21st Oct 2015

    received my lessons on DVD for Excel 2007, and I'm very happy with them. So happy that I'm going to order the Office 2007 bundle also.

  6. 5 Star Review Will recommend them to my friends.

    Posted by on 21st Oct 2015

    Your Excel and Access training vids are great and will recommend them to my friends. Do you offer anything for QuickBooks?

  7. 5 Star Review We are all learning and loving the training.

    Posted by on 21st Oct 2015

    I purchased two of your excel training dvd's -- one for my office and one for my husband's. We are all learning and loving the training.

  8. 5 Star Review Live, careful instructional videos show each step and voice over explanation.

    Posted by on 21st Oct 2015

    Dream Force Excellence in Excel-Word-Access. This is the best tutorial available to use if you're tired of trying the old book-cd "click here-type that" routine. Live, careful instructional videos show each step and voice over explanation. Very nice.

  9. 5 Star Review Nearly finished level 3 on Excel 2007; good job!

    Posted by on 21st Oct 2015

    Nearly finished level 3 on Excel 2007; good job! Would it be right to say, that level 3 still only scratches the surface of excel....there are so many formulas that could be used? Having said that, your Excel course is excellent, well designed and prepared...I still have 3 modules in level 3 to finish, but so far so good :) Have you any distribution network to get these disks to Europe and beyond!...the potential market for your product is huge!

  10. 5 Star Review Live, careful instructional videos show each step and voice over explanation.

    Posted by on 21st Oct 2015

    Dream Force Excellence in Excel-Word-Access. This is the best tutorial available to use if you're tired of trying the old book-cd "click here-type that" routine. Live, careful instructional videos show each step and voice over explanation. Very nice.

Previous | Showing reviews 11-20 of 42 | Next

Find Similar Products by Category