Excel 2016 Training Videos

(7 reviews) Write a Review
SKU:
excel2016
UPC:
091037704566
Condition:
New
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
  • Excel 2016 Training Videos
$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

7 Reviews

  • 5
    Five Stars

    Posted by James on 14th Apr 2017

    Explains the software perfectly.

  • 5
    Five Stars

    Posted by Unknown on 14th Apr 2017

    Excellent.

  • 5
    Video Trainer Excel 2016 - Try it, it's great!

    Posted by Jana W Halvorson on 14th Apr 2017

    The training video for Excel 2016 was very helpful and the way it is formatted made it very easy to use. I learned a lot in those 15 hours and spent a lot less money than taking a class either on line or in person. Thanks for a great product.

  • 5
    Great Training Video!!

    Posted by Matthew Upton on 14th Apr 2017

    This is such a great training course. I have learned a lot from it and the videos are very easy to follow allowing me to utilize the exercises a bit better. I have applied what I learned into my work and have already seen my work paying off much more. I am currently being offered a detail position as an Analyst that will utilize my Excel skills more due to what I have learned. Everyone looking to learn Microsoft office could benefit from this kind of training course. The only thing I could say would make this better is if it could come in a digital format that I could more easily utilize without having to use my home tv since my iMac doesn't have a disc drive.

  • 5
    Highly Recommended.

    Posted by Mr. Math Expert on 14th Apr 2017

    I feel very confident about using Excel after watching hours of Excel 2016 Training Videos and think I can pass the certification exam. The explanations are very clear, and I am able to stop at any time and practice learned skills on my laptop. I prefer the video over the book because the examples are shown and they are pretty clear. All in all, I highly recommend Excel 2016 Training Videos.

  • 5
    I love the careful and clear detail in this video.

    Posted by City of Fairbanks - Fire Department on 10th Apr 2017

    I love the careful and clear detail in this video. It is also helpful how you can go to a particular subject to either refresh or learn how to do something you are not familiar with. I have used this company for training of earlier versions of MS Office products, and have strongly recommended to anyone interested in learning. I can't wait until the other 2016 products come out!

  • 5
    Great product must have.

    Posted by Martin C. - California on 10th Apr 2017

    Great product and very easy to follow. Would recommend if you're trying to pick up on how to utilize and master excel pick up this video.

View AllClose