-
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 3: Working with Multiple Workbooks
$0.00Arrange windows Link to data in multiple workbooks Consolidate data -
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: Managing Large Workbooks
$0.00Format worksheet tabs Manage worksheets Manage the view of worksheets and workbooks -
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: Modifying a Worksheet
$0.00Format text and cells Align cell contents Use Find & Select tools Use Spell Checking -
Microsoft 365 Excel: Part 2: Creating Advanced Formulas
$0.00Apply range names Use specialized functions -
Microsoft 365 Excel: Part 2: Enhancing Workbooks
$0.00Customize workbooks Manage themes Protect files Prepare a workbook for audiences -
Getting Started with Microsoft 365: Managing Users
$0.00Get started as an administrator Manage users, groups, and resources in Microsoft 365 -
Microsoft 365 Excel: Part 3: Exporting and Sourcing Data
$0.00Export data Use data sources Use Microsoft Forms -
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 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 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 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 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.