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.