Mastering Excel 2016 – Advanced

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