Mastering Excel 2019 – Advanced
Mastering Excel 2019 – Advanced
What you’ll learn
-
Use multiple worksheets and workbooks to track, retrieve, consolidate and report on data using features like cell links, Group Mode, 3D Reference formulas, and Consolidate.
-
Collaborate with others using Comments, Track Changes, Sharing, Co-Authoring, and Compare and Merge.
-
Prepare a document for sharing by checking for accessibility and sensitive information, as well as multiple ways to protect your worksheets and workbooks from changes.
-
Keep your data consistent and accurate with Data Validation and automate tasks with Macros.
-
Perform complex calculations by developing a deep understanding of Excel’s Lookup functions like VLOOKUP, MATCH, and INDEX.
-
Quickly find and address errors in your formulas with Tracing, Evaluate Formula, and the Watch Window, as well as add error handling with the IFNA and IFERROR functions.
-
Use your data to plan and forecast trends and explore a variety of outcomes based on variables and scenarios.
-
Visualize geographic data with Map Charts and 3D Map Tours.
Requirements
-
An intermediate knowledge of Excel is recommended.
Who this course is for:
- People who have a working knowledge of Excel 2019 or Excel 365, but want to use more complex functions and features to analyze data.