Excel 2010 Training Videos

(42 reviews) Write a Review
SKU:
excel2010
UPC:
013964082029
Availability:
Usually ships in 1 to 2 business days.
Shipping:
Calculated at Checkout
$49.95

Description

Excel 2010 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 2010 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 2010!

DVD includes Excel 2010 Levels 1, 2 & 3 training videos in both: Flash (.swf) and Windows Media Video (.wmv), Exercise Files, Quiz, Answers and Instructor's Notes. Our Excel 2010 Levels 1, 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 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 2 (4+ hrs):

Advanced Formulas

  1. Name Cells & Ranges (6:06)
  2. Linking Data (5:48)
  3. UPPER, LOWER & PROPER (3:08)
  4. CONCATENATE (3:50)
  5. LEFT, FIND & SEARCH (8:49)
  6. RIGHT, FIND & LEN (8:31)
  7. IF, AND & OR (6:09)
  8. Nested IF (3:11)
  9. IFERROR (2:20)
  10. PMT Payment Function (3:16)
  11. Display & Print Formulas (1:22)
  12. SUM, COUNT & AVERAGE IF(S) (8:11)
  13. VLOOKUP (7:11)
  14. HLOOKUP (5:44)

Tables

  1. Create Tables (3:39)
  2. Modifying Tables (5:37)
  3. Formatting Tables (1:46)
  4. Custom Table Style (2:50)
  5. Table Sorting & Filtering (4:28)
  6. DSUM, DAVERAGE & DCOUNT (9:04)
  7. Time Functions (3:31)
  8. Sorting & Database  Flaws (7:18)
  9. AutoFilter (6:42)
  10. Advanced Filter (10:06)
  11. Subtotals (4:29)

Charts

  1. Create Charts (5:14)
  2. Modifying Charts A (4:55)
  3. Modifying Charts B (3:15)
  4. Chart Titles (3:26)
  5. Formatting Charts (3:50)
  6. Creating Chart Templates (1:34)
  7. Chart Application Sharing (1:04)

PivotTable & Charts

  1. Create PivotTables (9:58)
  2. Customize PivotTables (10:08)
  3. PivotTable Slicers (8:24)
  4. Create Pivot Charts (5:20)

Graphics

  1. Insert & Modifying Pictures (4:00)
  2. ClipArt (2:26)
  3. Drawing & Modifying Shapes (5:33)
  4. SmartArt Graphics (5:25)
  5. Layering & Grouping Objects (4:21)

Customize

  1. Insert & Modify Comments (7:31)
  2. Hyperlinks (7:01)
  3. Web Research (0:55)
  4. Watermarks & Gridlines (5:00)
  5. Customize Themes (6:58)
  6. Create Workbook Templates (1:15)
  7. Create Custom Templates (3:59)

Excel 2010 Level 3 (3.5+ hrs):

Workbook

  1. Workbook Properties (6:24)
  2. Custom Views (4:50)
  3. Macro Basics (8:42)
  4. Editing Macros (4:30)
  5. Absolute & Relative Macros (3:19)
  6. Conditional Formatting (6:41)
  7. Data Validation (6:44)

Collaborating

  1. Protect Worksheets (6:24)
  2. Password Protect Cells (3:22)
  3. Document Inspector (2:49)
  4. Protect Structure (1:31)
  5. Password to Open/Modify (5:03)
  6. Create Backup (6:03)
  7. Share Workbook (11:26)
  8. SkyDrive Sharing A (4:52)
  9. SkyDrive Sharing B (3:57)
  10. SharePoint Sharing A (4:51)
  11. SharePoint Sharing B (3:38)
  12. Track Changes (4:50)
  13. Protect & Share (3:08)
  14. Merge Workbooks (5:33)
  15. Digital Signatures (9:15)
  16. Restrict Access (6:57)
  17. Mark As Final (1:27)

Audit Worksheets

  1. Tracer Arrows & Errors (4:55)
  2. Troubleshoot Invalid Data (2:46)
  3. Watch & Evaluate Formulas (4:13)
  4. AutoOutline & Grouping Data (9:35)

Analyzing Data

  1. Trend Line (2:40)
  2. Sparklines (2:55)
  3. Scenarios (5:44)
  4. Goal Seek (2:38)
  5. Solver (6:01)
  6. Random Samples (8:24)

Multiple Workbooks

  1. Workspace (2:37)
  2. Consolidating Data (5:13)
  3. Link Workbooks (5:46)

Import & Export Data

  1. Export to Word (3:53)
  2. Import Text File (3:18)
  3. Publish Worksheet to Web (3:36)
  4. Import from Web (4:05)
  5. XML A (6:49)
  6. XML B (4:47)
  7. Advanced Number Formats (5:56)
  8. Camera (3:59)
Excel 2010 Training Videos

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

View AllClose

42 Reviews

  • 5
    I am really impressed by your work.

    Posted by Ibrahim A. - Saudi Arabia on 26th May 2015

    I have purchased all training videos for MS Excel 2010. I am really impressed by your work. So I have decided to purchase the full MS office training videos bundle.

  • 5
    Kirt Kershaw does a great job...

    Posted by John P. - New York on 11th Feb 2015

    Excel 2010 Training Video is a practical way to learn how to use Excel 2010 to do a wide variety of spreadsheet tasks. Kirt Kershaw does a great job as tutor/narrator in the video, similar to what he did in his Excel 2013 Training Video....see my comments about that video, since they generally apply to both!

  • 5
    All smiles with this product.

    Posted by Eban G. - Florida on 7th Jan 2015

    All smiles with this product.

  • 5
    Perfect.

    Posted by Dieane W. - Pennsylvania on 2nd Jan 2015

    Regarding teaching myself Excel to help with my job. This video teacher is perfect for me. Clearly teaches each area and provides great practice sections!

  • 5
    Highly recommend it.

    Posted by Verna K. - Florida on 2nd Jan 2015

    If you need to learn Excel basics quickly, this software is easy to use and understand.

  • 5
    Thank you Kirt Kershaw.

    Posted by Dana S. - Illinois on 2nd Jan 2015

    I love the way you teach and what you teach, very much. I will have to put my kudos in a social media location.

  • 5
    I highly recommend.

    Posted by Thomas M. - New Jersey on 2nd Jan 2015

    Bought Excel, Word, Access and Word and loved them all. Great instructor and great product. I'm very happy I purchased this product. What I have learned has really helped me at work.

  • 5
    Good. Money well spent.

    Posted by Rohit S. - Michigan on 2nd Jan 2015

    I wish I bought all MS office training videos. Very explanatory, good examples, and short videos.

  • 5
    I passed the EXPERT test!!!!

    Posted by Peter S. - Wisconsin on 2nd Jan 2015

    The Expert test was one of the most difficult ones I have taken. While I did well on the Specialist one using the "yellow" book, the Expert one was a fail using the "green" book. I used this, studied through all of the lessons twice, and aced the test. I am currently using your Word 2010 DVD for study. Thanks so much as I shoot for MOS Master!!!! Thanks Kirt!!!!!!

View AllClose