Microsoft Office Specialist: Excel Associate (MO-200)
Microsoft Excel 2019 Associate
Build, format, and analyze spreadsheets in Excel 2019. This course covers the full set of skills tested on the MOS Excel Associate exam, from workbook setup to formulas, tables, and charts.
5 sections · 20 lessons
What you'll learn
1. Unit 1: Manage Worksheets and Workbooks
- Import Data into a Workbook · 📖
- Navigate Within Workbooks · 📖
- Format Worksheets and Workbooks · 📖
- Customize Options and Views · 📖
- Configure Content for Collaboration · 📖
2. Unit 2: Manage Data Cells and Ranges
- Manipulate Data in Worksheets · 📖
- Format Cells and Ranges · 📖
- Define and Reference Named Ranges · 📖
- Apply Conditional Formatting · 📖
3. Unit 3: Manage Tables and Table Data
- Create and Format Tables · 📖
- Modify Tables · 📖
- Filter and Sort Table Data · 📖
4. Unit 4: Perform Operations by Using Formulas and Functions
- Insert References · 📖
- Calculate and Transform Data · 📖
- Use Conditional Logic with IF · 📖
- Count and Total with Conditions · 📖
- Format Text with Functions · 📖
5. Unit 5: Manage Charts
- Create Charts · 📖
- Modify Charts · 📖
- Format Charts · 📖