-
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 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. -
Microsoft 365 Excel: Part 2: Visualizing Data with Charts
$99.00Create charts Modify and format existing charts Create a trendline Create advanced charts -
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 1: Customizing the Excel Environment
$99.00Customize general, language, formula, proofing, and saving options Use Excels version control features Customize the ribbon and the Quick Access toolbar Customize the functionality of Excel by enabling add-ins Customize advanced and Trust Center options -
Microsoft 365 Excel: Part 2: Creating Advanced Formulas
$99.00Apply range names Use specialized functions -
Microsoft 365 Excel: Part 1: Managing Large Workbooks
$99.00Format worksheet tabs Manage worksheets Manage the view of worksheets and workbooks