Microsoft Excel 365 MOS Certification Training
Course Length: 3 days
Delivery Methods:
Available as private class only
Course Overview
This Microsoft Excel 365 MOS Certification Training course helps prepare students to take the following Microsoft Office 365 MOS and Expert certification exams:
- Excel (Microsoft 365 Apps): Exam MO-210
- Excel Expert (Microsoft 365 Apps): Exam MO-211
Course Benefits
- Create basic worksheets using Microsoft Excel.
- Perform calculations in an Excel worksheet.
- Modify an Excel worksheet.
- Modify the appearance of data within a worksheet.
- Manage Excel workbooks.
- Print the content of an Excel worksheet.
- Learn how to use handy new features.
- Learn to use formulas and functions.
- Create and modify charts.
- Convert, sort, filter, and manage lists.
- Insert and modify illustrations in a worksheet.
- Learn to work with tables.
- Learn to use conditional formatting and styles.
- Create pivot tables and charts.
- Learn to trace precedents and dependents.
- Convert text and validate and consolidate data.
- Collaborate with others by protecting worksheets and workbooks.
- Create, use, edit, and manage macros.
- Import and export data.
ProCert Approved
This course has been tested and approved by ProCert labs, the official tester of Microsoft courseware. The course has been found to meet the highest industry standards of instructional quality.
Microsoft Certified Partner
Webucator is a Microsoft Certified Partner for Learning Solutions (CPLS). Our curriculum has been tested and approved by ProCert Labs, the official tester of Microsoft courseware, and has been found to meet the highest industry standards of instructional quality.
Course Outline
- Office 365 Setup Maneuver
- Logging in to Microsoft 365
- Installing Applications
- Creating New Files and AutoSaving
- Protected View
- File Sharing
- File Collaboration
- Version History
- Getting Updates
- Mac Versions
- Creating a Microsoft Excel Workbook
- Starting Microsoft Excel
- Creating a Workbook
- Saving a Workbook
- The Status Bar
- Adding and Deleting Worksheets
- Copying and Moving Worksheets
- View Options for the Worksheet
- Closing a Workbook
- Creating a Microsoft Excel Workbook (exercise)
- The Ribbon
- Tabs
- Groups and Commands
- Microsoft Search Box
- The Backstage View (The File Menu)
- Introduction to the Backstage View
- Opening a Workbook
- Open a Workbook (exercise)
- New Workbooks and Excel Templates
- Select, Open, and Save a Template Agenda (exercise)
- Printing Worksheets
- Print a Worksheet (exercise)
- Personalizing Microsoft Office
- The Quick Access Toolbar
- Getting Started
- Adding Common Commands
- Adding Additional Commands with the Customize Dialog
- Adding Ribbon Commands or Groups
- Customize the Quick Access Toolbar (exercise)
- Entering Data in Microsoft Excel Worksheets
- Entering Text
- Inserting and Deleting Cells
- Inserting Hyperlinks
- Inserting WordArt
- Using AutoComplete
- Entering Text and Using AutoComplete (exercise)
- Entering Numbers and Dates
- Using the Fill Handle
- Entering Numbers and Dates (exercise)
- Formatting Microsoft Excel Worksheets
- Selecting Ranges of Cells
- Hiding Worksheets
- Adding Color to Worksheet Tabs
- Adding Themes to Workbooks
- Customize a Workbook Using Tab Colors and Themes (exercise)
- Adding a Watermark
- The Font Group
- Working with Font Group Commands (exercise)
- The Alignment Group
- Working with Alignment Group Commands (exercise)
- The Number Group
- Working with Number Group Commands (exercise)
- Editing Worksheets
- Find
- Find and Replace
- Using Find and Replace (exercise)
- Using the Clipboard
- Using the Clipboard (exercise)
- Moving Columns / Rows
- Working with Rows and Columns
- Inserting and Deleting Rows, Columns, and Cells
- Transposing Rows and Columns
- Row Height and Column Width
- Hiding and Unhiding Rows and Columns
- Freezing Panes
- Working with Rows and Columns (exercise)
- Using Formulas in Microsoft Excel
- Math Operators and the Order of Operations
- Entering Formulas
- AutoSum (and Other Common Auto-Formulas)
- Copying Formulas
- Relative, Absolute, and Mixed Cell References
- Working with Formulas (exercise)
- Finalizing Microsoft Excel Worksheets
- Setting Margins
- Setting Page Orientation
- Setting the Print Area
- Print Scaling (Fit Sheet on One Page)
- Repeating Headings
- Headers and Footers
- Preparing to Print (exercise)
- Common Functions
- Using Named Ranges in Formulas
- Using Named Ranges in Formulas (exercise)
- Using Formulas That Span Multiple Worksheets
- Entering a Formula Using Data in Multiple Worksheets (exercise)
- Functions:
IF
andIFS
- Using the
IF
Function (exercise) - Functions:
AND
andOR
- Functions:
NOT
- Functions:
SWITCH
- Functions:
COUNTIF
,AVERAGEIF
, andSUMIF
- Functions:
PMT
andNPER
- Using the
PMT
Function (exercise) - Functions:
TEXTJOIN
andCONCAT
- Using the
TEXTJOIN
Function (exercise) - Text Functions
- Creating Ordinal Numbers (exercise)
- Date and Time Functions
- Using Date Functions (exercise)
- Working with Lists
- What is a List of Data?
- Removing Duplicates from a List
- Removing Duplicates from a List (exercise)
- Sorting Data in a List
- Sorting Data in a List (exercise)
- Filtering Data in a List
- Filtering Data in a List (exercise)
- Adding Subtotals to a List
- Adding Subtotals to a List (exercise)
- Visualizing Your Data
- Chart Basics
- Tools for Editing Charts
- Using the Chart Design Tool Tab (exercise)
- The Format Tool Tab
- Using the Three Chart Buttons
- The Format Task Pane
- Useful Charts
- Line and Area Charts
- Hierarchy Charts
- Statistic Charts
- Other Charts
- Combo Charts
- Using Recommended Charts
- Sparklines
- Inserting and Customizing Sparklines (exercise)
- Add and Format Objects
- Working with Shapes
- Working with Icons
- Working with SmartArt
- Using the Quick Analysis Tool
- Working with Tables
- Format Data as a Table
- Table Design Tool Tab
- Formatting Individual Cells
- Selecting Table Rows and Columns
- Creating and Modifying a Table in Excel (exercise)
- Structured References
- Convert a Table to a Range
- Advanced Formatting
- Cell Styles
- Working with Cell Styles (exercise)
- Conditional Formatting
- Conditional Formatting: Highlight Cells Rules
- Conditional Formatting: Top/Bottom Rules
- Conditional Formatting: Data Bars, Color Scales, and Icon Sets
- Conditional Formatting: Create a New Rule
- Removing Conditional Formatting
- Using Conditional Formatting (exercise)
- Using PivotTables
- How PivotTables Work
- Timeline Filters
- Inserting Slicers
- Grouping Data
- Calculated Fields
- PivotCharts
- Working with PivotTables (exercise)
- Advanced Functions
- Function Syntax
ROWS
,COLUMNS
,INDEX
, andXMATCH
- Arrays and Array Formulas
- Getting Unique Values (exercise)
SORT
,FILTER
, andSORTBY
- Lookup Functions
- Using the
XLOOKUP
Function (exercise) - The
LET
Function - The
TRANSPOSE
Function
- Auditing Workbooks
- Inspecting a Workbook
- Tracing Precedents and Dependents
- Tracing Precedents and Dependents Practice (exercise)
- Watch Window
- Evaluating Formulas
- Error Checking
- Data Tools
- Importing Data from online source
- Converting Text to Columns
- Converting Text to Columns (exercise)
- Importing Files
- Importing Text Files (exercise)
- Linking to External Data
- Controlling Calculation Options
- Data Validation
- Using Data Validation (exercise)
- Consolidating Data
- Consolidating Data (exercise)
- What-If Analysis
- Using Goal Seek (exercise)
- Recording and Using Macros
- Recording Macros
- Recording a Macro (Exercise)
- Running Macros
- Editing Macros
- Adding Macros to the Quick Access Toolbar
- Adding a Macro to the Quick Access Toolbar (Exercise)
- Working with Others
- Comments and Notes
- Protecting Worksheets and Workbooks
- Password Protecting a Workbook (exercise)
- Marking a Workbook as Final
- Other Sharing Concerns
Class Materials
Each student will receive a comprehensive set of materials, including course notes and all the class examples.