Learning Excel 2019 – Advanced (TOSA)

Topics covered include:

Using Autofill and Named Ranges
Working with advanced functions (Date, Time, Conditional, Database, Lookup)
Applying advanced filtering
Using advanced chart features
Inserting and modifying graphics
Creating PivotTables with advanced PivotTable features
Creating internal and external links
Consolidating data
Co-authoring and using Compare and Merge
Adding Digital Signatures
Protecting workbooks and worksheets
Customizing Data Validation
Running and editing Macros
Inserting symbols and characters
Working with Forms