800.978.9790
 Loading... Please wait...


  • Image 1

Excel 2007 Level 3 (Download)

$14.95
Quantity:

Product Description

Excel 2007 Level 3 training videos download comes in Windows Media Video (.wmv) file format. Our Excel 2007 Level 3, with Levels 1 & 2 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 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!

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 Level 3 Training Videos (Download)

Excel 2007 Level 3 Training Videos (Download) from Dream Force — training videos solutions.
Affordable Excel 2007 Level 3 Training Videos (Download)
.

Product Reviews

Write Review

This product hasn't received any reviews yet. Be the first to review this product!

Find Similar Products by Category