Learning Excel 2019 – Expert (TOSA)

Topics covered include:

Customizing the Ribbon and Quick Access Toolbar
Using a wide variety of functions including Logical functions, Text functions, Conditional functions, Lookup functions, Math functions, Database functions, Subtotals, and nested functions
Creating PivotTables to group and summarize data
Presenting data with PivotCharts
Collaborating with others using co-authoring
Using Tracing, Evaluate Formula, and the Watch Window to find and address errors
Forecasting data with Data Tables, Scenarios, Data Trends, and Sparkline
Working with forms and adding ActiveX Controls