Excel 2007 Training Videos

(41 reviews) Write a Review
SKU:
excel2007
UPC:
837654648513
Availability:
Usually ships in 1 to 2 business days.
Shipping:
Calculated at Checkout
  • Excel 2007 Training Videos
$49.95

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 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
.

View AllClose

41 Reviews

  • 5
    Very professional and valuable so far.

    Posted by Tomas M. - Florida on 17th Feb 2015

    Very professional and valuable so far.

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

    Posted by Elia G. - Canada on 17th Feb 2015

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

  • 5
    Keep those training video's coming.

    Posted by Stephen D. - New York on 17th Feb 2015

    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.

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

    Posted by Brad O. - Oregon on 17th Feb 2015

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

  • 5
    Your videos are very professional and easy to follow.

    Posted by Ron V. - Texas on 17th Feb 2015

    Your videos are very professional and easy to follow.

View AllClose