uCertify

Microsoft Excel 2021 - Mastering Intermediate Skills

Online Training course to help you pass Microsoft Office Specialist certification exams, MO-200 & MO-201.

(MSEXCEL-INT.AD1) / ISBN : 978-1-64459-409-4
Lessons
Lab
TestPrep
AI Tutor (Add-on)
Instructor Led (Add-on)
Get A Free Trial

About This Course

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.

Skills You’ll Get

  • 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

Get the support you need. Enroll in our Instructor-Led Course.

Download Course Outline

1

About This Course

  • Course Description
2

Working with Functions

  • 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
3

Working with Lists

  • Topic A: Sort Data
  • Topic B: Filter Data
  • Topic C: Query Data with Database Functions
  • Topic D: Outline and Subtotal Data
4

Analyzing Data

  • Topic A: Create and Modify Tables
  • Topic B: Apply Intermediate Conditional Formatting
  • Topic C: Apply Advanced Conditional Formatting
5

Visualizing Data with Charts

  • Topic A: Create Charts
  • Topic B: Modify and Format Charts
  • Topic C: Use Advanced Chart Features
6

Using PivotTables and PivotCharts

  • 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
A

Appendix A: Microsoft® Excel® 2021 Common Keyboard Shortcuts

B

Appendix B: Financial Functions

C

Appendix C: Working with Graphical Objects

  • Topic A: Insert Graphical Objects
  • Topic B: Modify Graphical Objects
  • Topic C: Work with SmartArt

1

Working with Functions

  • 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
2

Working with Lists

  • Filtering the Data for all Employees
  • Creating a Custom Filter
  • Using Database Functions
3

Analyzing Data

  • Converting the Data into a Table
  • Applying a Quick Style to a Table
  • Adding New Entries to a Table
4

Visualizing Data with Charts

  • 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
5

Using PivotTables and PivotCharts

  • 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

Any questions?
Check out the FAQs

Know more about our Microsoft Excel 2021 course in this section.

Contact Us Now

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.

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.

It’s a self-paced course that can be completed at your own pace from anywhere, anytime.

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.

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

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.

Related Courses

All Course
scroll to top