-
Microsoft 365 Excel: Part 2: Analyzing Data with PivotTables, Slicers, and PivotCharts
$0.00Create a PivotTable Filter data using slicers Analyze data using PivotCharts -
Microsoft 365 Excel: Part 1: Managing Large Workbooks
$0.00Format worksheet tabs Manage worksheets Manage the view of worksheets and workbooks -
Microsoft 365 Excel: Part 1: Customizing the Excel Environment
$0.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 2: Organizing Worksheet Data with Tables
$0.00Create and format tables Modify tables Use table references -
Microsoft 365 Excel: Part 2: Creating Advanced Formulas
$0.00Apply range names Use specialized functions -
Microsoft 365 Excel: Part 2: Analyzing Data with Logical and Lookup Functions
$0.00Use text functions Use logical functions Use lookup functions Use date functions Use financial functions -
Microsoft 365 Excel: Part 1: Modifying a Worksheet
$0.00Format text and cells Align cell contents Use Find & Select tools Use Spell Checking -
Microsoft 365 Word: Part 3: Managing Document Versions
$0.00Create a new document version using Microsoft Word and Microsoft SharePoint Server Compare document versions Merge document versions -
Microsoft 365 Excel: Part 3: Exporting and Sourcing Data
$0.00Export data Use data sources Use Microsoft Forms