-
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 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: 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 Teams: Using Other Communication Tools
$0.00Use chat Make audio and video calls Use the Teams calendar to manage meetings Manage files -
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 3: Working with Multiple Workbooks
$0.00Arrange windows Link to data in multiple workbooks Consolidate data -
Microsoft Office 365: 2018 Feature Updates
$0.00By the end of this course, users should be comfortable using the new features released in 2018 for the desktop version of Microsoft Office 365, including features of Microsoft Word, Excel, PowerPoint, Outlook, Access, and Visio. -
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: Working with Graphical Objects
$0.00Insert and modify graphical objects Layer and group graphical objects Incorporate SmartArt into your workbooks