Mastering Excel 2016 – Advanced

Mastering Excel 2016 – Advanced

Part of our online library flat rate.

  • By
  • Triple Tech LLC dba Bigger Brains

Subscription

$16.58

per month

  • 12 Months
  • Single License
  • 700+ eBooks and video tutorials
  • Tips and tricks from experts
  • Instant access
  • Renews automatically

Share this Product

Get Custom offer

  • 10+ Users
  • For departments or complete companies
  • Premium analytics

The world is filled with two kinds of people: a handful of people who are masters of Excel, and the millions of others who wish they were 

If you’ve mastered Microsoft Excel 2016, then you have one of the most practical and valuable skill sets in all of modern business. A spreadsheet guru can work wonders – from organizing lists, to creating multi-layered, interactive reports, to revealing answers to businesses’ critical questions like ROI, budget allocations, tracking expenditures, and more. This course builds on your existing knowledge of Excel and teaches you how to use links, lookup functions, macros, data tables, and more.

This is our most requested training course! If you learn to use Excel 2016, you will start to see how useful it is in your life – from formatting your grocery list to calculating complex ROI values. If you are an experienced Excel user, let our Microsoft Certified Trainers, Barbara Evers and Christina Tankersley, walk you through some advanced tools that will expand the usefulness of your Microsoft Excel 2016. 

Topics covered include: 

  • Using Scenarios and Goal Seek 
  • Working with Macros 
  • Tracing Precedent and Dependent Cells 
  • Comparing and Merging Workbooks 
  • Using 3D References 
  • Using Data Forms and Form Controls 

Lesson

  1. Introduction
  2. Creating Internal Links
  3. Creating External Links
  4. Using Paste Special
  5. Using Group Mode
  6. Using 3D References
  7. Consolidating Data
  8. Adding Comments
  9. Tracking Changes
  10. Co-Authoring, Part 1
  11. Co-Authoring, Part 2
  12. Using Sheet Views
  13. Using Compare and Merge
  14. Preparing to Share
  15. Adding Digital Signatures
  16. Protecting Worksheets
  17. Protecting Workbook Structure
  18. Protecting a Workbook File
  19. Applying Data Validation
  20. Adding a Dropdown List
  21. Customizing Data Validation
  22. Recording a Macro
  23. Running a Macro
  24. Editing a Macro
  25. Using VLOOKUP, Part 1
  26. Using VLOOKUP, Part 2
  27. Using XLOOKUP
  28. More Lookup Functions
  29. Using Array Formulas
  30. Tracing Formulas
  31. Addressing Formula Errors
  32. Watching and Evaluating Formulas
  33. Adding Error Handling
  34. Working with Information Functions
  35. Using Goal Seek
  36. Forecasting with Data Tables
  37. Using Solver
  38. Forecasting with Scenarios
  39. Forecasting Data Trends
  40. Inserting Symbols and Special Characters
  41. Creating Sparklines
  42. Creating a Map Chart
  43. Creating a 3D Map Tour
  44. Creating Custom Lists
  45. Importing and Exporting Data
  46. Creating a Web Query
  47. Using Data Types
  48. Working with Forms
  49. Using ActiveX Controls
  50. Ideas in Office 365