Excel 365 Training Overview
This Excel 365 Quick Start for Experienced Excel Users training course gives experienced users of earlier versions of Excel a rapid introduction to Excel 365.
Location and Pricing
This course is taught as a private, live online class for teams of 3 or more. All our courses are hands-on, instructor-led, and tailored to fit your group’s goals and needs. Most Accelebrate classes can be flexibly scheduled for your group, including delivery in half-day segments across a week or set of weeks. To receive a customized proposal and price quote for online corporate training, please contact us.
In addition, some courses are available as live, instructor-led training from one of our partners.
Objectives
- Set up Excel 365
- Create a Workbook using automation
- Work with Tables and Pivot Tables
- Create and use Charts/Pivot Charts
Prerequisites
Prior experience with earlier versions of Excel is welcome, but prior experience with Excel is not presumed.
Outline
Expand All | Collapse All
Introduction to Excel 365
Setting up Excel 365 for Efficiency
- Setting up the QAT
- Setting up the Ribbon
Creating a Workbook using Automation
- Using AutoFill
- Using AutoFit
- Using AutoSum (and other formulas)
- Using AutoFormat (and other formats)
- Using Conditional Formatting
Excel 365 Tips and Tricks
Creating and Using Tables
Creating and Using Pivot Tables
Creating and Using Charts/Pivot Charts
New Features that Cannot be Missed!
- Quick Analysis
- Flash Fill Conclusion
Conclusion
Training Materials
All attendees receive a short handout in electronic format and will be familiarized in class with Excel’s online documentation.
Software Requirements
Microsoft 365 (including Excel), a modern web browser, and Internet access.
