MSEXCEL-INT.AD1
Microsoft Excel 2021 Intermediate
Online Training course to help you pass Microsoft Office Specialist certification exams, MO-200 & MO-201.
- Practice in 30 Hands-On Labs — nothing to install
- 9 Interactive Lessons and 23 topics mapped to the official exam objectives
- 145 Practice Test Questions
Intermediate Self-paced · 1 year access
30 Hands-On LiveLabs
Practice real IT tasks in guided environments.
- Real environments
- Auto-graded
- No installation
9Interactive Lessons
23Topics
30LiveLab
145Practice Test Questions
39Flashcards
39Glossary of terms
01 / Skills you'll get
What you will be able to do
Try Free →
No credit card required
Elevate your spreadsheet skills with our Microsoft Excel 2021 - Mastering Intermediate Skills training course. The comprehensive course curriculum allows you to explore the full potential of Excel spreadsheets to accelerate your workflow with essential Excel keyboard shortcuts and other tools. You’ll be learning complex functionalities like logic, date and time, text, and specialized functions. You” ll be exploring advanced techniques to organize and analyze data for extracting valuable insights using Microsoft Excel 2021.
- Expertise in using advanced functions like logical, date and time, text, and specialized functions.
- Sort and extract information from a given set of data
- Knowledge of database functions, data outlining, and subtotalling
- Skilled in using PivotTables, and PivotCharts alongside timelines and slicers
- Create various chart types and customize their appearance with advanced chart formatting techniques
- Familiarity with SmartArt graphics to create professional-looking diagrams and illustrations
- Knowledge of keyboard shortcuts for enhanced productivity
- Ability to apply conditional formatting to highlight specific data patterns and trends
Target Career Roles
- Accountants Cost Estimator Data Journalist Retail Manager Project Manager Business Analyst Financial Analyst Information Clerk Administrative Assistant
02 / Lessons & labs
See exactly what you will learn and practice
Lessons
9 Interactive Lessons · 23 topics01 About This Course 1 topics +
- Course Description
02 Working with Functions 5 topics · 12 LiveLab +
- Topic A: Work with Ranges
- Topic B: Use Specialized Functions
- Topic C: Work with Logical Functions
- Topic D: Work with Date and Time Functions
- Topic E: Work with Text Functions
12 LiveLab in this lesson — see the labs panel →
03 Working with Lists 4 topics · 3 LiveLab +
- Topic A: Sort Data
- Topic B: Filter Data
- Topic C: Query Data with Database Functions
- Topic D: Outline and Subtotal Data
3 LiveLab in this lesson — see the labs panel →
04 Analyzing Data 3 topics · 3 LiveLab +
- Topic A: Create and Modify Tables
- Topic B: Apply Intermediate Conditional Formatting
- Topic C: Apply Advanced Conditional Formatting
3 LiveLab in this lesson — see the labs panel →
05 Visualizing Data with Charts 3 topics · 6 LiveLab +
- Topic A: Create Charts
- Topic B: Modify and Format Charts
- Topic C: Use Advanced Chart Features
6 LiveLab in this lesson — see the labs panel →
06 Using PivotTables and PivotCharts 4 topics · 6 LiveLab +
- Topic A: Create a PivotTable
- Topic B: Analyze PivotTable Data
- Topic C: Present Data with PivotCharts
- Topic D: Filter Data by Using Timelines and Slicers
6 LiveLab in this lesson — see the labs panel →
07 Appendix A: Microsoft® Excel® 2021 Common Keyboard Shortcuts +
08 Appendix B: Financial Functions +
09 Appendix C: Working with Graphical Objects 3 topics +
- Topic A: Insert Graphical Objects
- Topic B: Modify Graphical Objects
- Topic C: Work with SmartArt
Hands-On Labs Our edge
30 LiveLabs- Creating Named Ranges
- Editing Range Names
- Using an Existing Range in a Function
- Using the Formula AutoComplete Method to Enter Range Names
- Using the TODAY Function
- Calculating the Years of Service for Each Employee
- Adding the Arguments for the IF Portion of the Nested Function
- Calculating the 1 Percent Goal Bonus for Employees
- Using the NETWORKDAYS Function
- Extracting the Building Code from the Combined Field
- Extracting the Floor Code from the Combined Field
- Concatenating the Names in a Single Field
- Filtering the Data for all Employees
- Creating a Custom Filter
- Using Database Functions
- Converting the Data into a Table
- Applying a Quick Style to a Table
- Adding New Entries to a Table
- Creating a Clustered Column Chart
- Changing the Labels of the Line Chart
- Changing the Chart Type
- Creating the Combo Chart
- Adding the Trendline
- Saving a Chart as a Template
- Adding Fields to the PivotTable
- Building the PivotTable Report
- Sorting the Values
- Modifying the Formatting of the PivotTable Report
- Modifying the PivotTable Report
- Inserting a Timeline
Labs run in your browser — nothing to install.
03 / FAQs
Questions before you start
What are the prerequisites for taking the Microsoft Excel 2021 Intermediate course?+
You need to have a strong foundation of basic Excel skills to pursue this course. Good understanding of the core fundamentals will help you understand the advanced topics better.
What is the difference between an intermediate and an advanced Excel course?+
Intermediate-level focuses on foundational knowledge covering topics like advanced formulas & functions, data-analysis tools, conditional formatting, and so on. Advanced-level, on the other hand, delves into more technical and sophisticated techniques like VBA, PowerPivot, PowerBI, and more. To summarize, Intermediate Excel provides tools to manage and analyze data while advanced Excel empowers you to automate processes.
How long does it take to complete the Microsoft Excel 2021 Intermediate course?+
It’s a self-paced course that can be completed at your own pace from anywhere, anytime.
Does this course require the installation of Microsoft Excel 2021?+
No, this course comes with hands-on Labs that allow you to practice your learning in a virtual environment. You don’t need to get any expensive software licenses.
How can I demonstrate my Excel skills to employers after completing this course?+
Students can easily demonstrate their skills to potential employers by following these steps:
- Create a mock dataset to showcase your practical assignment
- Demonstrate the process with detailed explanation through live video recording
- Highlight your problem-solving ability with creative solutions to project-related challenges
- Last but not the least, create a portfolio on platforms like GitHub, GitLab, or personal websites to showcase your Excel projects
How does this course help in preparing for two Microsoft certifications?+
This course can help you prepare for two certifications including MO-200 & MO-201. The curriculum has been especially designed in sync with the exam objectives for these 2 exams. It covers many essential topics, such as advanced formulas, data analysis, and data visualization. The hands-on Lab exercises will help you develop the hands-on skills needed to pass these exams.
Learn Advanced Excel Skills
Analyze complex datasets, create insightful visualizations, and automate tasks.
- 1 year of full access
- 30 LiveLab included
- Certificate of completion
No credit card required