Instructor-Led Training
Mastering Microsoft® Excel® for Office 365® Level 100
Microsoft Excel serves today as the one essential business tool you must understand and master to manage large quantities of data. In this one-day gateway course, you’ll learn what you need to know to catapult your Excel skills to the next level and be prepared for the Level 200 and Level 300 courses. If you’re using Excel like it’s 1999, you’re doing things the hard way!
Course Outcomes
- Teaches the fundamentals of Microsoft Excel without reviewing basic introductory exercises
- Ensures users will receive hands-on practice with data modeling and analysis
- Brings users up to speed with the latest version of Excel, enabling them to take advantage of new solutions for data management
- Prepares users for Excel Level 200 and Level 300 training
- Provides baseline training for Excel users who are self-taught or have not received training for several years
Course Agenda
Instructor-Led Training
Module 1: The Fundamentals of Microsoft Excel
Module 2: Shortcuts and Formatting in Microsoft Excel
Module 3: Microsoft Excel Essentials: Tables and PivotTable Reports
Module 4: Absolute vs. Relative Cell References and Formatting
Module 5: XLOOKUP and Other Common Functions
Module 6: Spreadsheet Formatting
Request group training
Complete the form below to request tailored, private training for your team. We’ll be in touch to discuss your group’s specific goals.
More Courses in
