-
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 365 Excel: Part 3: Data Analysis and Presentation
$99.00Use the Quick Analysis tool Add sparklines Perform What-If analysis Load and use the Analysis ToolPak -
Microsoft 365 Excel: Online: Getting Started
$99.00In this course you will learn how to: get started with Excel Online, describe the basic components of Excel, manage workbooks, and get help in Excel Online. -
Microsoft 365 Excel: Part 2: Analyzing Data with PivotTables, Slicers, and PivotCharts
$99.00Create a PivotTable Filter data using slicers Analyze data using PivotCharts -
Microsoft 365 Excel: Part 1: Customizing the Excel Environment
$99.00Customize general, language, formula, proofing, and saving options Use Excel's 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 3: Excel Online
$99.00How to access and use Excel Online Features that differ between Excel Online and the Excel desktop application -
Microsoft 365 Excel: Part 3: Working with Multiple Workbooks
$99.00Arrange windows Link to data in multiple workbooks Consolidate data -
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 2: Organizing Worksheet Data with Tables
$99.00Create and format tables Modify tables Use table references -
Microsoft 365 Excel: Online: Formatting a Worksheet
$99.00In this course you will learn how to: format text and cells, align cell contents, use Find and Select tools, and apply conditional formatting. -
Microsoft 365 Excel: Part 2: Visualizing Data with Charts
$99.00Create charts Modify and format existing charts Create a trendline Create advanced charts