Mastering Excel 2019 – Advanced

Topics covered include:

Linking cells and consolidating data
Sharing and protecting worksheets
Automating data validation and tasks
Using Lookup functions
Auditing formulas
Forecasting data
Creating geographic visuals like Map Charts and 3D Map Tours
Importing and exporting data
Creating a Web Query
Working with Forms and ActiveX controls