-
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: Exporting and Sourcing Data
$0.00Export data Use data sources Use Microsoft Forms -
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 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 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 -
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 2: Organizing Worksheet Data with Tables
$0.00Create and format tables Modify tables Use table references -
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: Managing Large Workbooks
$0.00Format worksheet tabs Manage worksheets Manage the view of worksheets and workbooks -
Microsoft 365 Word: Part 3: Adding Reference Marks and Notes
$0.00Add captions to objects Insert cross-references Add bookmarks and hyperlinks Insert footnotes and endnotes Add citations Insert a bibliography -
Microsoft 365 Excel: Part 1: Modifying a Worksheet
$0.00Format text and cells Align cell contents Use Find & Select tools Use Spell Checking -
Getting Started with Microsoft 365: Managing Security
$0.00Manage domains Monitor Microsoft 365 security and compliance -
Microsoft 365 Excel: Part 1: Getting Started
$0.00Identify the basic components of Excel Create a basic worksheet Get help in Excel 365
