-
Microsoft 365 Excel: Part 3: Worksheet Automation
$99.00Manage workbook properties Record, create and edit a macro Create and use a template Use data validation in a workbook -
Microsoft 365 Excel: Part 3: Working with Multiple Workbooks
$99.00Arrange windows Link to data in multiple workbooks Consolidate data -
Microsoft 365 Excel: Part 1: Working with Data
$99.00Use formulas and functions Work with data, rows, and columns Sort and filter data -
Microsoft 365 Excel: Part 1: Getting Started
$99.00Identify the basic components of Excel Create a basic worksheet Get help in Excel 365 -
Microsoft 365 Excel: Part 2: Analyzing Data with Logical and Lookup Functions
$99.00Use text functions Use logical functions Use lookup functions Use date functions Use financial functions -
Microsoft 365 Excel: Part 2: Organizing Worksheet Data with Tables
$99.00Create and format tables Modify tables Use table references -
Microsoft 365 Excel: Part 3: Auditing and Error Checking
$99.00Tracing cells Error checking Evaluating formulas and using the Watch Window Data List Outlines -
Microsoft Excel Online: Using Pivot-Tables
$99.00In this course you will learn how to insert PivotTables, work with PivotTable data, and sort and filter PivotTable data.
