800.978.9790
 Loading... Please wait...


  • Excel 2016 Training Videos

Excel 2016 Training Videos

$49.95
SKU:
excel2016v
Condition:
New
Availability:
Usually ships in 1 to 2 business days.
Shipping:
Calculated at checkout
Quantity:

Product Description

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

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. Our Excel 2016 Levels 1, 2 & 3 training videos include all the training you need to pass the Excel 2016 Core (77-727) and Expert (77-728) Exams and become certified!

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 Customer 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
.

 

 

Product Videos

Excel 2016 Basics, Beginner, First Look at Excel 2016 Overview Tutorial 08:58

Excel 2016 introduction for beginners who want to get started with the first look at Excel 2016, by Microsoft Certified Trainer, Excel 2016 Specialist and Expert. All 160 of my Excel 2016 training videos contain everything you need to help pass both the Microsoft Office Excel 2016 Core (77-727), and Expert (77-728) exams and become certified! ONLINE: Microsoft Office training videos including: Access, Excel, Outlook, PowerPoint, Project, Word and Windows, exercise files, quizzes, instructor notes, certificate of completion and more: https://www.patreon.com/KirtKershaw DVD: Microsoft Office training videos including: Access, Excel, Outlook, PowerPoint, Project, Word and Windows, exercise files, quizzes and instructor notes: https://www.DreamForce.us SUBSCRIBE to learn more Microsoft Excel tips, tricks and shortcuts! http://www.youtube.com/subscription_center?add_user=videotrainingpro

  • Excel 2016 Bas...
    Excel 2016 introduction for beginners who want to get started ...
  • Excel 2016 Cre...
    Excel 2016 tutorial on how to create a simple, basic, beginner...

Product Reviews

Write Review

  1. 5 Star Review Highly Recommended.

    Posted by 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.

  2. 5 Star Review Great Training Video!!

    Posted by 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.

  3. 5 Star Review Video Trainer Excel 2016 - Try it, it's great!

    Posted by 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.

  4. 5 Star Review Five Stars

    Posted by on 14th Apr 2017

    Excellent.

  5. 5 Star Review Five Stars

    Posted by on 14th Apr 2017

    Explains the software perfectly.

  6. 5 Star Review Great product must have.

    Posted by on 4th 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.

  7. 5 Star Review I love the careful and clear detail in this video.

    Posted by on 8th Feb 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!

Find Similar Products by Category