-
Microsoft 365 Excel: Part 3: Exporting and Sourcing Data
$99.00Export data Use data sources Use Microsoft Forms -
Microsoft 365 Excel: Part 1: Managing Large Workbooks
$99.00Format worksheet tabs Manage worksheets Manage the view of worksheets and workbooks -
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 3: Working with Multiple Workbooks
$99.00Arrange windows Link to data in multiple workbooks Consolidate data -
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 3: Auditing and Error Checking
$99.00Tracing cells Error checking Evaluating formulas and using the Watch Window Data List Outlines -
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 1: Modifying a Worksheet
$99.00Format text and cells Align cell contents Use Find & Select tools Use Spell Checking -
Microsoft Excel Online: Working with Data
$99.00In this course you will learn how to use formulas and functions, work with data, rows, and columns, and sort and filter 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 2: Visualizing Data with Charts
$99.00Create charts Modify and format existing charts Create a trendline Create advanced charts -
Microsoft 365 Excel: Part 2: Enhancing Workbooks
$99.00Customize workbooks Manage themes Protect files Prepare a workbook for audiences -
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
