Excel 2016 Training Videos

(41 reviews) Write a Review
SKU:
excel2016
UPC:
091037704566
Condition:
New
Availability:
Usually ships in 1 business day.
Shipping:
Calculated at Checkout
$49.95

Description

Microsoft Excel 2016 Training Videos - Master Microsoft Excel from Beginner To Advanced!

  • Build a solid understanding on the Basics of Microsoft Excel:
    • Creating a spreadsheet from scratch
    • Simple first steps in formulas and calculations
    • How to use Excel as a database with sorting and filtering options
    • Build your database right the first time and avoid common design flaws
  • Expand your knowledge with Advanced features:
    • Become more efficient with advanced functions and formulas
    • Learn the most common Excel functions used in the Office
    • Learn how to create charts from you organized database
    • Format your data range into a nice looking, functionable table

Unique tips, tricks, shortcuts and other Excel time saving features you won't find taught in ANY other course, by the ONLY multi-certified Microsoft Office trainer since Microsoft Office 2000; including all the training you need to help pass both the Excel 2016 Core (77-727) and Excel Expert (77-728) Exams and become certified, guaranteed.

DVD includes: Excel 2016 Levels 1, 2 & 3 training videos in both MP4 (.mp4) and Windows Media Video (.wmv), Exercise Files, Quiz, Answers and Instructor's Notes.

Excel 2016 Level 1 (5+ hrs):

Basics

  1. Excel 2016 Overview (8:53)
  2. Customize Excel Environment (12:39)
  3. Customize Quick Access Toolbar (5:03)
  4. Customize Ribbon (7:09)
  5. Navigating Excel (5:05)
  6. Creating A Basic Worksheet (5:26)
  7. Save & Save As (7:38)
  8. Convert To 2016 (3:44)
  9. Compatibility Checker (6:05)
  10. Excel 2016 Tell Me or Help (4:52)

Functions & Formulas

  1. Basic Formulas A (8:56)
  2. Basic Formulas B (5:26)
  3. SUM & AVERAGE Functions (15:43)
  4. MAX & MIN Functions (6:08)
  5. COUNT & COUNTA Functions (3:58)
  6. Move, Copy, Cut & Paste Data (11:58)
  7. Absolute References (6:05)
  8. Mixed References (8:44)
  9. AutoFill (7:47)
  10. FlashFill (6:05)
  11. Text To Columns (4:43)

Editing Worksheets

  1. Editing Data (4:49)
  2. Editing Columns, Rows & Cells (5:07)
  3. Find & Replace (6:10)
  4. GoTo (3:56)
  5. Transpose Data (2:37)
  6. Adjust Columns & Rows (4:20)
  7. Spell Check (1:59)
  8. Smart Lookup & Thesaurus (2:54)

Formatting

  1. Formatting Text (3:51)
  2. Basic Number Formats (5:13)
  3. Basic Custom Number Formats (4:52)
  4. Borders & Colors (7:15)
  5. Formatting Shortcuts (3:13)
  6. Adding Background (1:19)
  7. Align, Merge & Wrap Cell Contents (6:05)
  8. Create & Manage Styles (5:33)
  9. AutoFormat (1:52)
  10. Applying Themes (8:17)
  11. Basic Conditional Formatting (3:25)
  12. Conditional Formatting Manager (2:15)

Printing

  1. Print Preview (2:55)
  2. Page Orientation (2:01)
  3. Print Row & Column Page Titles (7:19)
  4. Headers & Footers (9:26)
  5. Page Margins & Centering (4:19)
  6. Page Breaks (10:29)
  7. Print Range & Scaling (8:19)

Modifying Worksheet Appearance

  1. Managing Worksheets (9:18)
  2. Hide Worksheets & Workbooks (4:45)
  3. Split Worksheet (2:26)
  4. Freeze Panes (4:32)
  5. Multiple Worksheet & Workbook Views (2:45)
  6. Formula Options (2:45)
  7. Speak Cells (1:33)

Excel 2016 Level 2 (5.5+ hrs):

Advanced Formulas

  1. Create Name Cell & Ranges (9:07)
  2. Version Control (1:36)
  3. Linking Data (3:58)
  4. UPPER, LOWER & PROPER (3:36)
  5. CONCATENATE (3:53)
  6. LEFT, FIND & SEARCH (7:14)
  7. RIGHT, FIND & LEN (5:01)
  8. MID (1:17)
  9. AND & OR (3:57)
  10. IF (3:21)
  11. Combined or Nested Functions (5:35)
  12. IFERROR (3:32)
  13. PMT (1:58)
  14. Display & Print Formulas (1:54)
  15. SUMIF(s), COUNTIF(s) & AVERAGEIF(s) (6:01)
  16. CONVERT (0:58)
  17. MATCH & INDEX (3:57)
  18. LOOKUP (3:56)
  19. VLOOKUP (8:17)
  20. HLOOKUP (9:09)

Tables

  1. Single & Multiple Array Formulas (3:48)
  2. Create Tables (3:31)
  3. Modify Tables (6:20)
  4. Format Tables (1:21)
  5. Custom Table Styles (2:18)
  6. Sorting & Filtering Tables (5:24)
  7. DSUM, DAVERAGE & DCOUNT (9:54)
  8. Date & Time Functions A (9:14)
  9. Date & Time Functions B (3:57)
  10. Sorting & Top Database Design Flaws (7:24)
  11. AutoFilter (4:39)
  12. Advanced Filter A (9:14)
  13. Advanced Filter B (7:13)
  14. Subtotals (6:30)

Charts

  1. Create Charts (10:43)
  2. Modify Charts (11:41)
  3. Trend Lines (2:32)
  4. Chart & Axis Titles (5:27)
  5. Format Chart (11:52)
  6. Dual Axis Chart (5:16)
  7. Chart Templates (1:55)
  8. Chart Sharing & Embedding (2:17)

PivotTable & Charts

  1. Create PivotTables (12:27)
  2. Customize PivotTables (11:59)
  3. PivotTable Slicers A (7:34)
  4. PivotTable Slicers B (5:50)
  5. Create PivotCharts (7:18)

Graphics

  1. Insert & Modify Pictures (7:27)
  2. Draw & Modify Shapes (9:32)
  3. SmartArt Graphics (5:11)
  4. Layering & Grouping Objects (6:14)

Customize

  1. Insert & Modify Comments (9:20)
  2. Hyperlinks (8:26)
  3. Watermarks (4:49)
  4. Customize Themes (6:33)
  5. Intermediate Conditional Formatting (3:26)
  6. Custom Workbook Templates (5:17)

Excel 2016 Level 3 (4.5+ hrs):

Workbook

  1. Properties (8:26)
  2. Custom Views (4:32)
  3. Macros A (11:41)
  4. Macros B (12:25)
  5. Edit Macro (2:29)
  6. Absolute & Relative References (3:47)
  7. Advanced Conditional Formatting (5:26)
  8. Quick Analysis (1:21)

Collaborating

  1. Data Validation (9:00)
  2. Protect Worksheets (5:06)
  3. Password Protect Cells (3:45)
  4. Document Inspector (5:09)
  5. Protect Workbook Structure (1:45)
  6. Password To Open And/Or Modify (5:43)
  7. Always Create Backup (4:46)
  8. Share Workbook (9:40)
  9. OneDrive (13:36)
  10. Track Changes (8:42)
  11. Protect & Share Workbook (3:27)
  12. Merge Workbooks (4:56)
  13. Digital Signatures or ID A (8:33)
  14. Digital Signatures or ID B (7:08)
  15. Mark As Final (2:08)

Audit Worksheets

  1. Tracer Errors & Arrows (4:25)
  2. Troubleshoot Invalid Data (3:07)
  3. Watch Window & Evaluate Formulas (5:45)
  4. Outline & Group Data (7:09)

Analyzing Data

  1. Sparklines (6:24)
  2. 3D Map (10:33)
  3. Data Table (4:49)
  4. Scenario Manager (5:17)
  5. Forecast Sheet (2:55)
  6. Goal Seek (2:25)
  7. Solver (5:01)
  8. Random Samples (5:16)
  9. RAND (4:17)
  10. Descriptive Statistics (2:10)
  11. Power View (9:10)

Import & Export Data

  1. Consolidating Data (6:35)
  2. Link Workbooks (9:50)
  3. Form Data (2:54)
  4. Export Data (6:17)
  5. Import Text File (3:19)
  6. Power Pivot (4:52)
  7. Publish to Web (4:28)
  8. XML (8:45)
  9. Advanced Custom Number Format (7:54)
  10. Camera (2:42)
Excel 2016 Training Videos

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

View AllClose

41 Reviews

  • 5
    I would highly recommend this course to a beginning Excel user.

    Posted by Mark Page on 10th Aug 2018

    The course was well thought out and presented in an engaging manner. Kirt was both funny and informative.

  • 5
    Great course for someone who wants to learn Excel 2016.

    Posted by Jose Ramirez on 10th Aug 2018

    Great course for someone who wants to learn Excel 2016. The last excel I worked with was the 2003 version and the changes are really mind boggling. However, the creator of this class explains the basics and shows you how to do it without getting bogged down by minutiae.

  • 5
    Information and comprehensive.

    Posted by Rick Pierson on 10th Aug 2018

    Information and comprehensive.

  • 5
    The instructor knows what he is talking about.

    Posted by Nicole Lasater on 10th Aug 2018

    I just started, and I like the pace. It is obvious that the instructor knows what he is talking about. Looking forward to the rest of the class.

  • 5
    I like the training.

    Posted by Raymond Arrington on 10th Aug 2018

    I like the training.

  • 5
    Very Thorough.

    Posted by Sergey Pareyko on 10th Aug 2018

    The videos are very thorough, lots of information given.

  • 5
    Simple and to the point.

    Posted by Dorothy Doutre on 10th Aug 2018

    Simple and to the point.

  • 5
    Easy to follow and learn Excel.

    Posted by Dodger on 10th Aug 2018

    I like the facilitator's speaking style and easy to follow instruction. It provides a comprehensive video guide for Excel.

  • 5
    stars Excellent Training and Easy to Follow!

    Posted by Customer on 10th Aug 2018

    Easy to use. Simplified teaching. Great training in only 15 hours!

View AllClose