Excel 2013 Training Videos
Home     |     About     |     Products     |     Testimonials     |     Contact     |      Newsletter
 
Excel 2013 Training Videos
 

Excel 2013 Training Videos

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

 

Excel 2013 DVD

DVD includes Excel 2013 Levels 1, 2 & 3 training videos in both: Flash and Windows Media Video. Bonus Extras: Exercises, Questions, Answers & Notes. All of our Microsoft Office training videos can help you pass the exams and become certified!
$49.95 - DVD

Excel 2013 Downloads

1) After purchase you'll receive an email with viewer and access key.
2) It's easy and simple to download and watch your Excel 2013 training videos
click here to learn how.
$14.95 Downloads (see below)
# #
Excel 2013 Level 1
Basics
  1. Excel 2013 Overview (9:46)
  2. - VIEW DEMO!
    Flash (.swf)
    Windows Media Video (.wmv)
  3. Customize Excel Environment (9:33)
  4. Customize Quick Access Toolbar (6:51)
  5. Customize Ribbon (10:14)
  6. Navigating Excel (5:44)
  7. Creating A Basic Worksheet (4:52)
  8. Save & Save As (5:13)
  9. Convert To 2013 (3:44)
  10. Compatibility Checker (5:20)
  11. Convert To Previous Version (6:10)
  12. Excel 2013 Help (2:30)
Functions & Formulas
  1. Basic Formulas A (10:31)
  2. Basic Formulas B (6:13)
  3. SUM & AVERAGE A (9:10)
  4. SUM & AVERAGE B (5:44)
  5. MAX & MIN (4:56)
  6. COUNT & COUNTA (4:01)
  7. Move, Copy & Cut Data (10:33)
  8. Absolute References (7:59)
  9. Mixed References (6:38)
  10. AutoFill (7:58)
  11. FlashFill (3:57)
  12. Text To Columns (3:29)

Editing Worksheets

  1. Editing Data (3:13)
  2. Editing Columns, Rows & Cells (3:55)
  3. Find & Replace (5:29)
  1. GoTo (5:20)
  2. Transpose Data (3:08)
  3. Adjust Columns & Rows (4:40)
  4. Spell Check (2:04)
Formatting
  1. Modifying Fonts (2:45)
  2. Basic Number Formats (5:11)
  3. Basic Customer Number Formats (3:54)
  4. Borders & Colors (7:41)
  5. Formatting Shortcuts (3:16)
  6. Adding Background (1:29)
  7. Align & Positioning Contents (5:46)
  8. Create & Manage Styles (5:15)
  9. AutoFormat (2:30)
  10. Applying Themes (11:00)

Printing

  1. Print Preview (2:34)
  2. Page Orientation (2:25)
  3. Print Titles (5:08) - VIEW DEMO!
    Flash (.swf)
    Windows Media Video (.wmv)
  4. Headers & Footers (7:09)
  5. Margins (3:15)
  6. Page Breaks (8:33)
  7. Print Range & Scaling (5:27)
Modifying Worksheet Appearance
  1. Managing Worksheets (8:56)
  2. Hide Sheets & Workbooks (5:02)
  3. Split Worksheet (1:37)
  4. Freeze Panes (4:45)
  5. Multiple Worksheet & Workbook Views (3:13)
  6. Formula Options (2:49)
  7. Speak Cells (1:25)

Download Level 1 (766 MB)
4.5+ hours of training

 
Unlimited viewing of Excel 2013 Level 1 training videos for one computer.
 
$14.95 Download
 
Excel 2013 Level 2
 
Advanced Formulas
  1. Name Range (11:10)
  2. Version Control (4:06)
  3. Linking Data (5:04)
  4. UPPER, LOWER & PROPER (4:38)
  5. - VIEW DEMO!
    Flash (.swf)
    Windows Media Video (.wmv)
  6. CONCATENATE (3:48)
  7. LEFT, FIND & SEARCH (7:41)
  8. RIGHT, FIND & LEN (6:59)
  9. IF, AND & OR (9:27)
  10. Nested IF (3:20)
  11. IFERROR (2:48)
  12. PMT (2:14)
  13. Display & Print Formulas (2:23)
  14. SUMIF(s), COUNTIF(s) & AVERAGEIF(s) (8:33)
  15. LOOKUP (4:47)
  16. VLOOKUP (6:57)
  17. HLOOKUP (6:53)
Tables
  1. Create Tables (3:21)
  2. Modify Tables (5:20)
  3. Format Tables (1:46)
  4. Custom Table Styles (2:33)
  1. Sorting & Filtering Tables (3:39)
  2. DSUM, DAVERAGE & DCOUNT (8:18)
  3. Time Functions (6:55)
  4. Database Design Flaws & Sorting (7:18)
  5. AutoFilter (4:00)
  6. Advanced Filter A (9:42)
  7. Advanced Filter B (6:46)
  8. Subtotals (6:33)

Charts

  1. Create Charts (10:31)
  2. Modify Charts (11:16)
  3. Trend Lines (2:55)
  4. Chart Axis Titles (4:06)
  5. Format Chart (10:29)
  6. Dual Axes Chart (5:47)
  7. Chart Template (1:22)
  8. Chart Sharing (2:15)
PivotTables & Charts
  1. Create PivotTables (11:20)
  2. Customize PivotTables (7:39)
  3. Slicers A (6:54)
  4. Slicers B (5:55)
  5. Create PivotCharts (5:27)

Graphics

  1. Insert & Modify Pictures (3:25)
  2. Clip Art (2:28)
  3. Draw & Modify Shapes (6:44)
  4. SmartArt Graphics (5:01)
  5. Layering & Grouping Objects (4:38)

Customize

  1. Insert & Modify Comments (7:36)
  2. Hyperlinks (8:32)
  3. Web Research (3:04)
  4. Watermarks (5:46)
  5. Customize Themes (8:08)
  6. Advanced Themes (3:53)
  7. Workbook Templates (2:51)
  8. Custom Templates (3:48)

Download Level 2 (795 MB)
5+ hours of training

 
Unlimited viewing of Excel 2013 Level 2 training videos for one computer.
 
$14.95 Download
 
Excel 2013 Level 3
 
Workbook
  1. Properties (8:08)
  2. Custom Views (4:27)
  3. Macros A (11:44)
  4. Macros B (10:16)
  5. Edit Macro (2:21)
  6. Absolute & Relative References (3:26)
  7. Conditional Formatting A (10:46)
  8. Conditional Formatting B (3:57)
  9. Data Validation (6:48)
  10. Quick Analysis (2:46)
Collaborating
  1. Protect Worksheets (5:26)
  2. Password Protect Cells (4:24)
  3. Document Inspector (3:39)
  4. Protect Structure & Windows (1:11)
  5. Password To Open And/Or Modify (4:38)
  6. Always Create Backup (5:17)
  7. Share Workbook (7:30)
  8. SkyDrive A (10:33)
  9. SkyDrive B (2:04)
  10. SharePoint Sharing A (8:04)
  11. SharePoint Sharing B (3:34)
  12. Track Changes (5:51)
  1. Protect & Share Workbook (4:29)
  2. Merge Workbooks (4:07)
  3. Digital ID A (7:44)
  4. Digital ID B (7:37)
  5. Mark As Final (2:32)

Audit Worksheets

  1. Tracer Errors & Arrows (5:02)
  2. Troubleshoot Invalid Data (4:33)
  3. Watch Window & Evaluate Formulas (4:27) - VIEW DEMO!
    Flash (.swf)
    Windows Media Video (.wmv)
  4. Outline & Group Data (6:36)
Analyzing Data
  1. Sparklines (6:15)
  2. Scenario Manager (6:18)
  3. Goal Seek (5:01)
  4. Solver (10:30)
  5. Random Samples (5:51)
  6. RAND (3:40)
  7. Descriptive Statistics (2:37)
  8. Power View (8:31)
Import & Export Data
  1. Consolidating Data (7:24)
  2. Link Workbooks (10:06)
  3. Export To Word (4:52)
  4. Import Text File (4:32)
  5. PowerPivot (4:30)
  6. Publish To Web (4:20)
  7. Import From Web (7:29)
  8. XML (10:55)
  9. Advanced Custom Number Format (7:38)
  10. Camera (4:24)

Download Level 3 (862 MB)
4.5+ hours of training

 
Unlimited viewing of Excel 2013 Level 3 training videos for one computer.
 
$14.95 Download
 


Top 10 Excel 2013 Must See Videos!
If you're already familiar with the previous version of Excel, and want to know what's new and/or helpful in Excel 2013 you'll want to check out the following training videos:

  1. Excel 2013 Overview (#1) - new Back Stage view, and how to customize it.
  2. Customize Ribbon (#4) - new Ribbon display options allows more customization.
  3. FlashFill (#22) - new enhancement to the AutoFill feature.
  4. Create & Manage Styles (#38) - using styles over & over again saves time.
  5. Applying Themes (#40) - fast way to format with: fonts, colors & effects.
  6. Charts (#83-84) - new chart buttons that replaces the Layout Tab.
  7. Slicers (#93-94) - a faster way to filter your data in PivotTables & PivotCharts.
  8. Quick Analysis (#118) - new to Excel is a shortcut to analyze data.
  9. SkyDrive Sharing (#126-127) - share Excel 2013 files over the web.
  10. Sparklines (#140) - insert a small chart into a single cell for a selected range.

Excel 2013 Core (77-420) and Expert Parts 1 (77-427) and 2 (77-428) Exams:
Our Excel 2013 training videos include all the training you need to pass both Core and Expert Parts 1 & 2 exams!

 

Excel 2013 Training Videos DVD Bonus Extras!
The Excel 2013 training videos on DVD contain not only Flash files, but also Windows Media Video files. These files make it easier to find the right training video that appears the sharpest and clearest to you on your monitor.
If you prefer not to download the Excel 2013 training videos above, we also have available the Excel 2013 training videos on DVD. 14.5+ hours of training videos, and includes:

  1. Instructor Notes - quick reference notes on the basics covered in detailed videos!
  2. Quiz - a list of questions to quiz yourself on after watching the videos!
  3. Answers - and of course the answers to the questions!
  4. Exercises - a copy of the exercise used during the video to try it yourself!

The videos were recorded at a screen resolution: 1024 x 768 to reveal more tools available on the Excel 2013 Ribbon, and accommodate the average user's higher screen resolution.

Each Project 2013 Levels 1 & 2 (DVD) training video includes a single license.

 
#

Excel 2013 Reviews

Excel 2013 Training"Excel 2013 training video is very educating with thorough explanation of each and every features of Excel. It also covers advance level like pivot tables and macro writing. I have been using Excel from day one when it was competing with Lotus 1-2-3 and I used to write macros in Lotus as well as in Excel. This training video is not only helpful to the beginers but also it points out new locations and features of all the old buttons and menu items of old Excel. Keep up the good work."

Bharat P. - Montana

Excel 2013 Training"Very good training video. I've bought it because I have already bought his Access 2007 course and it was good. Always up to the point, very professional. Keep up with good work, thank you!"

Viktor Y. - New York

Excel 2013 Training"By the way, thank you so much for producing such amazing training videos - I have used different online training courses but yours are the best!"

Masayoshi H. - Australia

Excel 2013 Training"Excellent Computer Based Training for all levels of EXCEL. This is the best computer based training I have ever had on any level. The author is entertaining, knowledgeable and adds to each lesson no matter what your skill level may be. You will walk away from this training with more knowledge and better prepared to work in Excel 2013."

Harold B. - Georgia

Excel 2013 Training"I liked the product and the assistance that it was provided was great."

Leo M. - New York

Send us your review!

 

Excel 2013 Training"Excel 2013 Video Course, the best out there! If you want to get ready for your Microsoft Certification Exam for Excel 2013, this is the way to go. This is the most comprehensive video course that I've ever owned. Kirt Kershaw breaks down Excel 2013 making the learning process as easy as taking candy from a baby. This video course covers not only the basics, but it also covers the most complicated features of the application. It is rare to find study material for the Expert Certification Exam for Excel 2013, so I'm thankful for such an affordable quality video course. My friend just paid $300 for an intensive one-day Excel 2013 course, and he only learned the basics. This video course offers three levels, with exercise files, and quizzes, making the learning experience hands on, an important key in learning Excel. The price is less than half a third of what my friend paid, and the videos are mine to revisit as much as I want."

Edward G. - New York

Excel 2013 Training"So far what I have viewed is terrific!"

Debbie C. - Florida

Excel 2013 Training"Great Product. I got this product and think it's a wonderful product. It will take you from a novice user to an advanced user. I have tried other products to learn Excel like books and other video products and within a few days I had forgotten what I had just learned, with the test I was able to retain 90% of what I had just learned. This product is just superior to other items on the market. I liked everything about this product and didn't find any dislikes. I would highly recommend this product to anyone who wants or needs to learn Excel 2013."

Ken R. - Illinois

Excel 2013 Training"I'm enjoying the Video Trainer Excel 2013! When do you think you will release Word, PowerPoint and Outlook 2013?"

Julie M. - Texas

Excel 2013 Training Videos

Excel 2013 training videos from Dream Force — training solutions.
Certified training on Excel 2013 training videos.