Microsoft Excel Associate MO200 | Microsoft 365 in Detroit

Microsoft Excel Associate MO200 Course Outline

Module 1: Manage worksheets and workbooks

• Import Data into Workbooks

• Import Data from .txt files
• Import Data from .csv files

• Navigate within Workbooks

• Search for Data within a Workbook
• Navigate to Named Cells, Ranges, or Workbook Elements
• Insert and Remove Hyperlinks

• Format Worksheets and Workbooks

• Modify Page Setup
• Adjust Row Height and Column Width
• Customize Headers and Footers

• Customize Options and Views

• Customize the Quick Access Toolbar
• Display and Modify Workbook Content in Different Views
• Freeze Worksheet Rows and Columns
• Change Window Views
• Modify Basic Workbook Properties
• Display Formulas

• Configure Content for Collaboration

• Set a Print Area
• Save Workbooks in Alternative File Formats
• Configure Print Settings
• Inspect Workbooks for Issues

Module 2: Manage Data Cells and Ranges

• Manipulate Data in Worksheets

• Paste Data by Using Special Paste Options
• Fill Cells by Using Auto Fill
• Insert and Delete Multiple Columns or Rows
• Insert and Delete Cells

• Format Cells and Ranges

• Merge and Unmerge Cells
• Modify Cell Alignment, Orientation, and Indentation
• Format Cells by Using Format Painter
• Wrap Text Within Cells
• Apply Number Formats
• Apply Cell Formats from the Format Cells Dialog Box
• Apply Cell Styles
• Clear Cell Formatting

• Define and Reference Named Ranges

• Define a Named Range
• Name a Table

• Summarize Data Visually

• Insert Sparklines
• Apply Built-in Conditional Formatting
• Remove Conditional Formatting

Module 3: Manage Tables and Table Data

• Create and Format Tables

• Create Excel Tables from Cell Ranges
• Apply Table Styles
• Convert Tables to Cell Ranges

• Modify Tables

• Add or Remove Table Rows and Columns
• Configure Table Style Options
• Insert and Configure Total Rows

• Filter and Sort Table Data

• Filter Records
• Sort Data by Multiple Columns

Module 4: Perform Operations by Using Formulas and Functions

• Insert References

• Insert Relative, Absolute, and Mixed References
• Reference Named Ranges and Named Tables in Formulas

• Calculate and Transform Datas

• Perform Calculations by Using the AVERAGE(), MAX(), MIN(), and SUM() functions
• Count Cells by Using the COUNT(), COUNTA(), and COUNTBLANK() Functions
• Perform Conditional Operations by Using The IF() Function

• Format and Modify Text

• Format Text by Using RIGHT(), LEFT(), and MID() Functions
• Format Text by Using UPPER(), LOWER(), and LEN() Functions
• Format Text by Using the CONCAT() and TEXTJOIN() Functions

Module 5: Manage Charts

• Create Charts

• Create Charts
• Create Chart Sheets

• Modify Charts

• Add Data Series to Charts
• Switch Between Rows and Columns in Source Data
• Add and Modify Chart Elements

• Format Charts

• Apply Chart Layouts
• Apply Chart Styles
• Add Alternative Text to Charts for Accessibility