Excel 2010 Level 1 (Download)

(No reviews yet) Write a Review

Bulk discount rates

Below are the available bulk discount rates for each individual item when you purchase a certain amount

Buy 5 - 9 and get 35% off
Buy 10 or above and get 40% off
  • Excel 2010 Level 1 (Download)
$14.95

Description

Excel 2010 Level 1 training videos download comes in Windows Media Video (.wmv) file format, and follow along exercise files! Our Excel 2010 Level 1, with Levels 2 & 3 training videos include all the training you need to pass the Excel 2010 Core (77-882) and Expert (77-888) Exams and become certified!

Excel 2010 training videos will explain first what a database is, and then the foundation of the database which are tables. After you'll want to learn how to quickly extract and enter your data in an organized format by using forms. Also, you'll be shown how fun and easy it is to create reports, a way to extract your data from your tables and into a printable format.

Learn to create relationships between tables including the most popularly misunderstood one-to-one relationship, and more by our Microsoft Certified Trainer training Excel 2010!

Excel 2010 Level 1 (6 hrs):

Basics

  1. Excel Getting Started A (6:24)
  2. Excel Getting Started B (5:26)
  3. Color, Fonts & Save Locations (9:19)
  4. Customize Quick Access Toolbar A (6:52)
  5. Customize Quick Access Toolbar B (4:45)
  6. Customizing Ribbon A (4:01)
  7. Customizing Ribbon B (5:07)
  8. Working With Cells (8:38)
  9. Data Entry (9:56)
  10. Save and Save As (8:47)
  11. Excel 2010 Help (2:25)
  12. Converting to Excel 2010 (4:30)
  13. Compatibility Checker (8:02)
  14. Convert to Previous Versions  (6:46)

Functions & Formulas

  1. Basic Formulas A (10:37)
  2. Basic Formulas B (5:48)
  3. SUM and AVERAGE A (6:39)
  4. SUM and AVERAGE B (11:21)
  5. MAX and MIN (8:44)
  6. COUNT and COUNTA (7:48)
  7. Copying & Pasting Data (8:35)
  8. Clipboard (3:23)
  9. Move, Cut and Paste (5:08)
  10. AutoFill (8:58)
  11. Absolute References (9:47)
  12. Mixed References (8:40)
  13. Text To Columns (7:23)

Editing Worksheets

  1. Editing Data (8:42)
  2. Editing Columns and Rows (6:39)
  3. Find and Replace (10:45)
  4. GoTo (6:29)
  5. Transpose Data (3:46)
  6. Adjusting Columns & Rows (3:38)
  7. Hide Columns & Rows (2:29)
  8. Modifying Fonts (4:22)
  9. Spell Check (2:45)
  10. Number Formats (5:07)
  11. Basic Custom Number Formats (4:35)
  12. Borders and Shading (10:04)
  13. Formatting Shortcuts (5:38)
  14. Applying Background (0:40)
  15. Cell Alignment (2:19)
  16. Merge Cells (4:29)
  17. Cell Text Wrapping (1:20)
  18. Create & Modify Styles (7:40)
  19. AutoFormat (3:02)
  20. Applying Themes (8:55)

Formatting

  1. Print Preview (3:15)
  2. Page Orientation (3:48)
  3. Print Titles (6:21)
  4. Headers and Footers A (5:34)
  5. Headers and Footers B (4:53)
  6. Margins (5:36)
  7. Page Breaks (8:50)
  8. Printing A Range of Data (5:15)

Modifying Worksheet Appearance

  1. Modifying Worksheets (10:04)
  2. Hiding Worksheets & Workbooks (3:41)
  3. Splitting Worksheets (5:28)
  4. Freeze Panes (3:59)
  5. Multi-Worksheet & Book Views (4:17)
  6. Text To Speech (2:03)

 

Excel 2010 Level 1 Training Videos (Download)

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

View AllClose