-
Microsoft 365 Excel: Part 3: Exporting and Sourcing Data
$0.00Export data Use data sources Use Microsoft Forms -
Microsoft 365 Word: Part 3: Collaborating on Documents
$0.00Modify user information in a document Share a document Work with comments Compare document changes Review a document with tracked changes Merge document changes Coauthor documents -
Microsoft 365 Excel: Part 2: Creating Advanced Formulas
$0.00Apply range names Use specialized functions -
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 Excel: Part 3: Auditing and Error Checking
$0.00Tracing cells Error checking Evaluating formulas and using the Watch Window Data List Outlines -
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: Enhancing Workbooks
$0.00Customize workbooks Manage themes Protect files Prepare a workbook for audiences -
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 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 Word: Part 3: Securing a Document
$0.00Suppress information Set editing restrictions Add a digital signature to a document Restrict document access -
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 -
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 1: Managing Large Workbooks
$0.00Format worksheet tabs Manage worksheets Manage the view of worksheets and workbooks