-
Microsoft 365 Excel: Part 2: Creating Advanced Formulas
$99.00Apply range names Use specialized functions -
-
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 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 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 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 Teams: Communicating in Channels
$99.00Manage messages Do more with messages Manage files in a channel Use the wiki -
Microsoft 365 Excel: Part 3: Exporting and Sourcing Data
$99.00Export data Use data sources Use Microsoft Forms -
Getting Started with Microsoft 365: File Storage and Collaboration
$99.00Store files and collaborate with OneDrive for Business Manage an organizations activity with Delve -
Microsoft 365 Teams: Using Other Communication Tools
$99.00Use chat Make audio and video calls Use the Teams calendar to manage meetings Manage files -
Microsoft 365 Outlook Part 1: Managing Your Contacts
$99.00Create and update contacts, and view and organize contacts. -
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: Working with Data
$99.00Use formulas and functions Work with data, rows, and columns Sort and filter data -
Microsoft 365 Outlook Part 1: Reading and Responding to Messages
$99.00Customize reading options, work with attachments, and manage your message responses
