Excel 2013 Training Videos

(30 reviews) Write a Review
SKU:
excel2013v
UPC:
091037704511
Availability:
Usually ships in 1 to 2 business days.
Shipping:
Calculated at Checkout

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
  • Microsoft Excel 2013 Training Videos
$49.95

Description

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!

DVD includes Excel 2013 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 2013 Levels 1, 2 & 3 training videos include all the training you need to pass the Excel 2013 Core (77-420) and Expert Part 1 (77-427) and Part 2 (77-428) Exams and become certified!

Excel 2013 Level 1 (4.5+ hrs):

Basics

  1. Excel 2013 Overview (9:46)
  2. Customize Excel Environment (9:33)
  3. Customize Quick Access Toolbar (6:51)
  4. Customize Ribbon (10:14)
  5. Navigating Excel (5:44)
  6. Creating A Basic Worksheet (4:52)
  7. Save & Save As (5:13)
  8. Convert To 2013 (3:44)
  9. Compatibility Checker (5:20)
  10. Convert To Previous Version (6:10)
  11. 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)
  4. GoTo (5:20)
  5. Transpose Data (3:08)
  6. Adjust Columns & Rows (4:40)
  7. 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)
  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)

Excel 2013 Level 2 (5+ hrs):

Advanced Formulas

  1. Name Range (11:10)
  2. Version Control (4:06)
  3. Linking Data (5:04)
  4. UPPER, LOWER & PROPER (4:38)
  5. CONCATENATE (3:48)
  6. LEFT, FIND & SEARCH (7:41)
  7. RIGHT, FIND & LEN (6:59)
  8. IF, AND & OR (9:27)
  9. Nested IF (3:20)
  10. IFERROR (2:48)
  11. PMT (2:14)
  12. Display & Print Formulas (2:23)
  13. SUMIF(s), COUNTIF(s) & AVERAGEIF(s) (8:33)
  14. LOOKUP (4:47)
  15. VLOOKUP (6:57)
  16. 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)
  5. Sorting & Filtering Tables (3:39)
  6. DSUM, DAVERAGE & DCOUNT (8:18)
  7. Time Functions (6:55)
  8. Database Design Flaws & Sorting (7:18)
  9. AutoFilter (4:00)
  10. Advanced Filter A (9:42)
  11. Advanced Filter B (6:46)
  12. 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)

PivotTable & 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)

Excel 2013 Level 3 (4.5+ hrs):

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)
  13. Protect & Share Workbook (4:29)
  14. Merge Workbooks (4:07)
  15. Digital ID A (7:44)
  16. Digital ID B (7:37)
  17. 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)
  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)

 

Excel 2013 Training Videos

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

View AllClose

30 Reviews

  • 5
    From the very beginning Kirt Kershaw made the training fun and easily understandable,

    Posted by Cary G. - New York on 19th Oct 2015

    I purchased the Video Trainer for Excel 2013 after viewing some online tutorials and not grasping various aspects of the program. From the very beginning Kirt Kershaw made the training fun and easily understandable. The lesson duration is just the right size in order to grasp each and every concept in an easily understandable way. I highly recommend this Video Trainer if you are interested in learning Excel 2013.

  • 5
    This Video Trainer on Excel 2013 Is Well Worth The Money.

    Posted by John P. - New York on 19th Oct 2015

    This video trainer is especially valuable to people like me who need to manipulate/process data skillfully using Excel 2013, however, actually only use that tool occasionally. I love the processing power offered with Excel but don't use it everyday and often need a refresher and/or clear explanation of the steps required to carry out very specific tasks. To me, Kirt Kershaw and the Excel 2013 Training Video offers the "method of choice" to enable one to learn or re-learn specific Excel tasks in a time frame that is most convenient. Kirt is clear and easy to listen to communicator, and his explanations for a whole host of common tasks are detailed and complete.

  • 5
    I'm using this to take the 2013 MOS certification.

    Posted by Dan P. - Texas on 19th Oct 2015

    These videos are great! Learning much faster than following a dull textbook.

  • 5
    Great instruction.

    Posted by John D. - California on 19th Oct 2015

    Easy to follow. From beginner to advanced. Boom.

  • 5
    Excellent Product.

    Posted by Angela O. - Virginia on 19th Oct 2015

    Excellent Product.

  • 5
    Love your training videos!

    Posted by Richard L. - Australia on 19th Oct 2015

    Love your training videos!

  • 5
    Numero Uno Excel 2013.

    Posted by Hamadou G. - Montana on 19th Oct 2015

    I was skeptical about the effectiveness of this training video, but after one week of intensive training I'm now a 'Numero Uno Master' of Excel 2013.

  • 5
    Excellent Computer Based Training for all levels of EXCEL.

    Posted by Harold B. - Georgia on 19th Oct 2015

    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.

  • 5
    I liked the product

    Posted by Leo M. - New York on 19th Oct 2015

    I liked the product and the assistance that it was provided was great.

View AllClose