-
Microsoft 365 Excel: Part 2: Creating Advanced Formulas
$0.00Apply range names Use specialized functions -
-
Microsoft 365 Excel: Part 3: Auditing and Error Checking
$0.00Tracing cells Error checking Evaluating formulas and using the Watch Window Data List Outlines -
Microsoft 365 Excel: Part 3: Worksheet Automation
$0.00Manage workbook properties Record, create and edit a macro Create and use a template Use data validation in a workbook -
Microsoft 365 Excel: Part 2: Organizing Worksheet Data with Tables
$0.00Create and format tables Modify tables Use table references -
Microsoft 365 Excel: Part 3: Data Analysis and Presentation
$0.00Use the Quick Analysis tool Add sparklines Perform What-If analysis Load and use the Analysis ToolPak -
Microsoft 365 Excel: Part 3: Working with Multiple Workbooks
$0.00Arrange windows Link to data in multiple workbooks Consolidate data -
Microsoft 365 Excel: Part 1: Modifying a Worksheet
$0.00Format text and cells Align cell contents Use Find & Select tools Use Spell Checking
