-
Microsoft 365 Excel: Part 1: Getting Started
$0.00Identify the basic components of Excel Create a basic worksheet Get help in Excel 365 -
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 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 2: Organizing Worksheet Data with Tables
$0.00Create and format tables Modify tables Use table references -
Microsoft 365 Excel: Part 3: Worksheet Automation
$0.00Manage workbook properties Record, create and edit a macro Create and use a template Use data validation in a workbook -
-
Microsoft 365 Word: Part 3: Simplifying and Managing Long Documents
$0.00Add cover pages and blank pages to a document Insert an index Insert a table of contents Insert ancillary tables, such as tables of figures and authorities Manage document outlines Create master and subdocuments -
Microsoft 365 Excel: Part 3: Data Analysis and Presentation
$0.00Use the Quick Analysis tool Add sparklines Perform What-If analysis Load and use the Analysis ToolPak -
Microsoft 365 Excel: Part 2: Working with Graphical Objects
$0.00Insert and modify graphical objects Layer and group graphical objects Incorporate SmartArt into your 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 1: Printing Workbook Contents
$0.00Define the basic page layout for a workbook Refine the page layout and apply print options