Get Started
101 Labs – Microsoft Excel
Microsoft Excel is a powerful spreadsheet program part of the Microsoft Office suite. It’s used by millions of people worldwide for a wide range of tasks, from simple calculations to complex data analysis.
Excel is used by:
- Businesses: Excel is widely used in businesses of all sizes for tasks like budgeting, forecasting, data analysis, and reporting.
- Individuals: People use Excel for personal finance, tracking expenses, creating lists, and organizing data.
- Students: Excel is a valuable tool for students in various fields, from math and science to business and social sciences.
- Researchers: Researchers use Excel for data analysis, statistical modeling, and creating visualizations.
Overall, Microsoft Excel is a versatile and essential tool for anyone who works with data. Its ability to organize, calculate, and visualize information makes it a valuable asset in various personal and professional settings
Microsoft offers certifications to validate your skills and knowledge using their platform and tools. Passing this associate-level exam demonstrates that you have the skills needed to get the most out of Excel (Microsoft 365 Apps) and earns you the Microsoft Office Specialist (MOS) certification.
This lab course covers how to:
- Manage worksheets and workbooks
- Manage data cells and ranges
- Manage tables and table data
- Perform operations by using formulas and functions
- Manage charts
Updated for the latest exam syllabus:
- Microsoft Office Specialist: Excel Associate (Microsoft 365 Apps) – MO-210
Microsoft Office Specialist: Excel Associate Certification Training
Key aspects of the Excel certification:
1. Individuals seeking to validate their foundational Excel skills:
- Students: Those learning Excel for the first time or looking to demonstrate their basic skills for academic or career purposes.
- Job seekers: Individuals entering the workforce or changing careers who want to prove their competency in Excel to potential employers.
- Employees: Professionals who want to formalize their Excel knowledge or need to meet basic Excel requirements for their roles.
2. Individuals in roles that require essential Excel skills:
- Administrative assistants: Those who use Excel for tasks like data entry, creating simple spreadsheets, and basic formatting.
- Office workers: Professionals who use Excel for day-to-day tasks like creating lists, tracking expenses, and simple calculations.
- Business professionals: Those who need to understand and use basic Excel functions for reporting, data analysis, and presentations.
3. Individuals starting their journey towards higher-level Excel certifications:
- MOS Expert: The MO-210 exam is a prerequisite for the MOS Expert certification in Excel.
- MOS Master: It’s also a prerequisite for the MOS Master certification in Excel.
Key skills measured in the MO-210 exam:
- Creating and managing worksheets and workbooks: Creating, saving, and modifying basic spreadsheets.
- Working with cells and ranges: Entering data, formatting cells, and working with ranges of cells.
- Creating tables: Inserting and formatting tables and using basic table features.
- Applying formulas and functions: Using basic formulas and functions like SUM, AVERAGE, and IF.
- Creating charts and objects: Creating basic charts and inserting objects like pictures and shapes.
Topics Covered:
The certification covers essential web development topics, including:
- Creating and Managing Worksheets and Workbooks
- Creating a workbook from a template
- Saving workbooks in various formats (e.g., xlsx, pdf)
- Managing worksheets: Inserting, deleting, renaming, and moving worksheets within a workbook.
- Navigating within a workbook: Using shortcuts and navigation tools to move efficiently between cells and worksheets.
2. Working with Cells and Ranges
- Entering data: Inputting different types of data (text, numbers, dates) into cells.
- Formatting cells: Applying formatting options like font styles, colors, alignment, and number formats.
- Working with ranges: Selecting, copying, moving, and deleting ranges of cells.
- Using named ranges: Defining and referencing named ranges for easier formula creation and navigation.
3. Creating and Managing Tables
- Inserting tables: Creating tables from data and applying table styles.
- Modifying tables: Adding or deleting rows and columns and resizing tables.
- Formatting tables: Applying table styles, formatting headers and rows, and using banded rows.
- Filtering and sorting table data: Using filters to display specific data and sorting data by different criteria.
4. Applying Formulas and Functions
- Using basic formulas: Performing calculations with basic operators (+, -, *, /) and cell references.
- Applying functions: Using common functions like SUM, AVERAGE, MAX, MIN, COUNT, COUNTA, COUNTBLANK, and IF.
- Understanding relative and absolute cell references: Using different types of cell references in formulas.
5. Creating Charts and Objects
- Creating charts: Creating various types of charts (column, bar, line, pie) from data.
- Formatting charts: Modifying chart elements like titles, legends, axes, and data labels.
- Inserting objects: Adding objects like pictures, shapes, and text boxes to worksheets.
Important Note:
The MO-210 exam is performance-based, meaning you’ll be performing these tasks in Excel, not just answering multiple-choice questions. You’ll need to demonstrate your ability to use Excel’s features and functions to complete tasks independently.
By mastering these skills, you’ll be well-equipped to use Excel effectively for work or personal and academic projects. The Microsoft Excel Associate certification validates your knowledge and demonstrates your readiness to collaborate and contribute to the world of Microsoft Office 365.
Exam Details:
- Exam Code: MO-210
- Format: 50 minutes
- Passing Score: 70% (unofficial)
- Prerequisites: None. Anyone can take the exam
- Validity Period: Lifetime
- Languages: English, Japanese
- Cost: $100
This course is 100% hands-on training.
| Module 1 | Manage Worksheets and Workbooks |
|---|---|
| Unit 1 | Getting Access to Microsoft Excel 365 |
| Unit 2 | Import Data From Text Files |
| Unit 3 | Import Data From Online Sources |
| Unit 4 | Search for Data Within a Workbook |
| Unit 5 | Navigate to Named Cells, Ranges, or Workbook Elements |
| Unit 6 | Navigate to Named Cells, Ranges, or Workbook Elements 2 |
| Unit 7 | Insert and Remove Hyperlinks |
| Unit 8 | Modify Page Setup |
| Unit 9 | Modify Page Setup 2 |
| Unit 10 | Modify Page Setup 3 |
| Unit 11 | Adjust Row Height and Column Width |
| Unit 12 | Customize Headers and Footers |
| Unit 13 | Customize Headers and Footers 2 |
| Unit 14 | Customize Options and Views |
| Unit 15 | Customize Options and Views 2 |
| Unit 16 | Manage the Quick Access Toolbar |
| Unit 17 | Manage the Quick Access Toolbar 2 |
| Unit 18 | Display and Modify Worksheets in Different Views |
| Unit 19 | Display and Modify Worksheets in Different Views |
| Unit 20 | Freeze Worksheet Rows and Columns |
| Unit 21 | Change Window Views |
| Unit 22 | Protect Your Worksheet |
| Unit 23 | Modify Built-in Workbook Properties |
| Unit 24 | Modify Built-in Workbook Properties 2 |
| Unit 25 | Display Formulas |
| Unit 26 | Set a Print Area |
| Unit 27 | Save and Export Workbooks in Alternative File Formats |
| Unit 28 | Configure Print Settings |
| Unit 29 | Inspect Workbooks and Correct Issues |
| Unit 30 | Manage Comments and Notes |
| Module 2 | Manage Data Cells and Ranges |
| Unit 1 | Paste Data by Using Special Paste Options |
| Unit 2 | Paste Data by Using Special Paste Options 2 |
| Unit 3 | Paste Data by Using Special Paste Options 3 |
| Unit 4 | Fill Cells by Using Auto Fill |
| Unit 5 | Insert and Delete Multiple Columns or Rows |
| Unit 6 | Insert and Delete Cells |
| Unit 7 | Generate Numeric Data by Using RANDBETWEEN() and SEQUENCE() |
| Unit 8 | Generate Numeric Data by Using RANDBETWEEN() and SEQUENCE() 2 |
| Unit 9 | Merge and Unmerge Cells |
| Unit 10 | Modify Cell Alignment, Orientation, and Indentation |
| Unit 11 | Format Cells by Using Format Painter |
| Unit 12 | Wrap Text Within Cells |
| Unit 13 | Apply Number Formats |
| Unit 14 | Apply Number Formats 2 |
| Unit 15 | Apply Cell Formats From the Format Cells Dialog Box |
| Unit 16 | Apply Cell Styles |
| Unit 17 | Apply Cell Styles |
| Unit 18 | Clear Cell Formatting |
| Unit 19 | Format Multiple Worksheets by Grouping |
| Unit 20 | Define a Named Range |
| Unit 21 | Reference a Named Range |
| Unit 22 | Insert Sparklines |
| Unit 23 | Insert Sparklines 2 |
| Unit 24 | Apply Built-in Conditional Formatting |
| Unit 25 | Apply Built-in Conditional Formatting 2 |
| Unit 26 | Apply Built-in Conditional Formatting 3 |
| Unit 27 | Apply Built-in Conditional Formatting 4 |
| Unit 28 | Apply Built-in Conditional Formatting 5 |
| Unit 29 | Remove Conditional Formatting |
| Unit 30 | Remove Conditional Formatting 2 |
| Module 3 | Manage Tables and Table Data |
| Unit 1 | Create Excel Tables From Cell Ranges |
| Unit 2 | Create Excel Tables From Cell Ranges 2 |
| Unit 3 | Apply Table Styles |
| Unit 4 | Apply Table Styles 2 |
| Unit 5 | Convert Tables To Cell Ranges |
| Unit 6 | Add Or Remove Table Rows And Columns |
| Unit 7 | Configure Table Style Options |
| Unit 8 | Insert And Configure Total Rows |
| Unit 9 | Filter Records |
| Unit 10 | Sort Data By Multiple Columns |
| Module 4 | Perform Operations by Using Formulas and Functions |
| Unit 1 | Insert Relative, Absolute, And Mixed References |
| Unit 2 | Insert Relative, Absolute, And Mixed References 2 |
| Unit 3 | Use Structured References In Formulas |
| Unit 4 | Use Structured References In Formulas 2 |
| Unit 5 | Perform Calculations By Using The Average(), Max(), Min(), And Sum() Functions |
| Unit 6 | Perform Calculations By Using The Average(), Max(), Min(), And Sum() Functions 2 |
| Unit 7 | Count Cells By Using The Count(), Counta(), And Countblank() Functions |
| Unit 8 | Count Cells By Using The Count(), Counta(), And Countblank() Functions 2 |
| Unit 9 | Perform Conditional Operations By Using The If() Function |
| Unit 10 | Perform Conditional Operations By Using The If() Function 2 |
| Unit 11 | Sort Data By Using The Sort() Function |
| Unit 12 | Get Unique Values By Using The Unique() Function |
| Unit 13 | Format Text By Using Right(), Left(), And Mid() Functions |
| Unit 14 | Format Text By Using Upper(), Lower(), And Len() Functions |
| Unit 15 | Format Text By Using Upper(), Lower(), And Len() Functions 2 |
| Unit 16 | Format Text By Using The Concat() And Textjoin() Functions |
| Module 5 | Charts |
| Unit 1 | Create Charts |
| Unit 2 | Create Charts 2 |
| Unit 3 | Create Charts 3 |
| Unit 4 | Create Chart Sheets |
| Unit 5 | Add Data Series To Charts |
| Unit 6 | Add Data Series To Charts 2 |
| Unit 7 | Switch Between Rows And Columns In Source Data |
| Unit 8 | Add And Modify Chart Elements |
| Unit 9 | Add And Modify Chart Elements 2 |
| Unit 10 | Add And Modify Chart Elements 3 |
| Unit 11 | Apply Chart Layouts |
| Unit 12 | Apply Chart Layouts 2 |
| Unit 13 | Apply Chart Styles |
| Unit 14 | Apply Chart Styles 2 |
| Unit 15 | Add Alternative Text To Charts For Accessibility |
| Module 6 | Final Exam |
| Unit 1 | Practical Exam |
| Unit 2 | Downloadable Exam |
