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
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
Related Courses
 | skillpath.com/EX100 |
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!
Module 1: The Fundamentals of Microsoft Excel
In this lesson, you’ll learn the fundamentals of Excel — not the basics of Office.
- Recognize the Excel interface
- Discuss how to employ the 3 layers and 3 rules of worksheets
- Input basic numbers, text and formulas
- Use the Help feature while you work
Module 2: Shortcuts and Formatting in Microsoft Excel
In this lesson, you’ll learn to work more effectively and efficiently with Excel. You’ll also learn essential data entry shortcuts.
- Identify essential shortcuts to rapidly generate text, numbers and formulas
- Describe formatting cells with styles
- Identify how to solve printing problems
- Discuss the steps to generate a well-structured workbook
Module 3: Microsoft Excel Essentials: Tables and PivotTable Reports
In this lesson, you’ll learn the essentials of tables for data input and PivotTable reports for effective data output.
- Recognize the difference between reports, crosstabs and tables
- Build a table
- Work with tables
- Describe how to master the basics of PivotTable reports
Module 4: Absolute vs. Relative Cell References and Formatting
In this lesson, you’ll learn how to write a formula and how to use built-in functions to streamline complicated formulas.
- Write formulas with relative and absolute cell references
- Build formulas with cell references, rather than fixed values
- Audit workbooks with formulas to troubleshoot errors
- Use tables to simplify absolute and relative cell references
Module 5: XLOOKUP and Other Common Functions
In this module, you’ll begin expanding your Excel repertoire by learning the most commonly needed Excel functions.
- Explain text functions
- Describe the family of IF functions
- Discuss XLOOKUP, the replacement for VLOOKUP, INDEX and MATCH
- Define logical formulas (TRUE/FALSE)
- Understand dynamic array functions
Module 6: Spreadsheet Formatting
In this lesson, you’ll explore the methods of formatting a workbook using shortcuts, styles, formulas and functions.
- Format quickly with the format painter
- Recognize the use of formatting styles
- Format with conditional formatting
- Identify formatting using formulas and conditional formatting