OpenCourser brand icon
Sign in
We may earn an affiliate commission when you visit our partners.

MO-210

Microsoft Excel (from beginner to intermediate)

Phillip Burton • 850,000+ students so far and I Do Data Limited

The MO-210 certification is the new certification for Excel. Microsoft says that this certification demonstrates that you have the skills needed to get the most out of Excel by earning a Microsoft Office Specialist: Excel Associate (Microsoft 365 Apps) certification.

This course has been created using Udemy's Accessibility guidelines.

In this MO-210 course:

Read more

The MO-210 certification is the new certification for Excel. Microsoft says that this certification demonstrates that you have the skills needed to get the most out of Excel by earning a Microsoft Office Specialist: Excel Associate (Microsoft 365 Apps) certification.

This course has been created using Udemy's Accessibility guidelines.

In this MO-210 course:

  • We’ll start with create and manage worksheets and workbooks. We’ll import data into workbooks, navigate and format workbooks, and prepare them for collaboration and distribution.

  • We’ll then look at managing data cells and ranges and create tables. We’ll insert data into and format workbooks, summarise and organize data, manage table styles and options, and filter and sort table data.

  • We’ll then perform operations with Excel formulas and functions. We’ll use functions for summarising data, performing conditional operations, formatting and modifying text, sorting and generating numeric data.

  • Finally, we’ll look at creating charts and sparklines. We’ll use different chart types, such as line, bar, area and pie charts, we’ll add legends and apply layouts and styles, and insert sparklines.

No prior knowledge is required. And there are 15 Practice Activities, 15 quizzes and a Practice Test to help you remember the information, so you can be sure that you are learning.

Once you have completed this course, you will have an expanded knowledge of Microsoft Excel. With some practice, you could even take the official Microsoft MO-210 exam, which gives you the "Microsoft Office Specialist: Excel Associate (Microsoft 365 Apps)" certificate. This would look good on your CV or resume.

It is also the first stage to you getting the "Microsoft Office Specialist: Associate (Microsoft 365 Apps)" certification.

Enroll now

What's inside

Learning objectives

  • Create, configure and save excel worksheets and workbooks.
  • Navigate through and format worksheets and workbooks.
  • Customise options and views for worksheets and workbooks.
  • Configure excel worksheets and workbooks to print (e.g. page setup).
  • Insert data into and format cells and ranges, and create and modify tables.
  • Highlight, filter, sort and group cells, ranges and tables.
  • Create and format excel charts.
  • Create formulas in excel, including using conditional logic and modifying text.

Syllabus

Introduction
Welcome to Udemy
How to get the best out of your Udemy course
Do you want auto-translated subtitles in more languages?
Read more
Curriculum
Resources
Import data into workbooks and Navigate within workbooks
Microsoft Excel - a quick tour
Inserting text and moving the cursor
Formatting cells
Cut, copy and paste, and saving text
1. Import data from text files (.txt and .csv files)
2. Import data from online sources
3. Search for data within a workbook
5. Insert and remove hyperlinks
Practice Activity Number 1
Practice Activity Number 1 - The Solution
Format worksheets and workbooks
9, 13. Change window views and using zoom
6. Modify page setup
6. Modify margins setup
8. Customize headers and footers - text
8. Customize headers and footers - pictures
16. Set a print area
7. Adjust row height and column width
34. Select multiple items and format multiple worksheets by grouping
Practice Activity Number 2
Practice Activity Number 2 - The Solution
Customize options and views
38. Applying conditional formatting - highlighting
10. Customize the Quick Access toolbar
9, 11. Display and modify workbook content in different views
12. Freeze worksheet rows and columns
14. Modify basic workbook properties
Configure content for collaboration
17. Save workbooks in alternative file formats
20. Manage comments and notes
18. Configure print settings
19. Inspect workbooks for issues
Practice Activity Number 3
Practice Activity Number 3 - The Solution
Manipulate data in worksheets
38, 39. Applying and removing conditional formatting - top/bottom
21. Paste data by using special paste options
22. Fill cells by using Auto Fill
23. Insert and delete multiple columns or rows
24. Insert and delete cells
Practice Activity Number 4
Practice Activity Number 4 - The Solution
Format cells and ranges
28. Format cells by using Format Painter
29. Wrap text within cells
27. Modify cell alignment, orientation, and indentation
26. Merge and unmerge cells
30. Apply number formats - commonly used number formats
30. Apply number formats - less-commonly used number formats
31, 33. Apply cell formats from the Format Cells dialog box, clear formatting
32. Apply cell styles
Practice Activity Number 5
Practice Activity Number 5 - The Solution
Summarize data visually
38, 39. Applying and removing conditional formatting - Bars, Scales and Sets
Practice Activity Number 6
Practice Activity Number 6 - The Solution
Create and format tables
Practice Activity Number 9 - The Solution
40, 42. Create Excel tables from cell ranges & back, and name a table
43. Add or remove table rows and columns
41, 44. Apply table styles and configure table style options
45. Insert and configure total rows
Practice Activity Number 7
Practice Activity Number 7 - The Solution
Filter and sort table data
46. Filter records - numbers
46. Filter records - text
46. Filter records - dates, and setting up your own filter
47. Sort data by multiple columns
Practice Activity Number 8
Practice Activity Number 8 - The Solution
Creating formulas
Using basic operators
Order of operations
Referencing cell ranges in formulas and Practice Activity Number 9
15, 48. Insert relative, absolute, and mixed references & display formulas
Practice Activity Number 10
Practice Activity Number 10 - The Solution
Calculate and transform data
50. Perform calculations by using the AVERAGE(), MAX(), MIN(), SUM() functions
50. More about the SUM() function

Good to know

Know what's good
, what to watch for
, and possible dealbreakers
Prepares learners to take the MO-210 exam, which can lead to the "Microsoft Office Specialist: Excel Associate (Microsoft 365 Apps)" certification, enhancing their professional credentials
Starts with the fundamentals, such as creating and managing worksheets, and progresses to more advanced topics like formulas, charts, and data manipulation
Covers importing, formatting, summarizing, and organizing data, which are essential skills for data analysis and reporting in various professional settings
Teaches skills in Excel, which is a foundational tool for many office jobs, and these skills are highly valued by employers across various industries
Includes 15 practice activities, 15 quizzes, and a practice test, which allows learners to reinforce their understanding and assess their readiness for the MO-210 exam
Focuses on Microsoft 365 Apps, which means that the course may not be as relevant to learners who use older versions of Excel, such as Excel 2019 or Excel 2016

Save this course

Save MO-210: Microsoft Excel (from beginner to intermediate) to your list so you can find it easily later:
Save

Activities

Be better prepared before your course. Deepen your understanding during and after it. Supplement your coursework and achieve mastery of the topics covered in MO-210: Microsoft Excel (from beginner to intermediate) with these activities:
Review Basic Math Concepts
Strengthen your understanding of basic mathematical operations and order of operations. This will help you better understand how formulas work in Excel.
Browse courses on Order of Operations
Show steps
  • Review arithmetic operations (addition, subtraction, multiplication, division).
  • Practice order of operations (PEMDAS/BODMAS).
  • Solve practice problems involving mixed operations.
Read 'Excel 2019 Bible'
Expand your knowledge of Excel features and functions. This book provides in-depth explanations and examples to enhance your understanding.
View Putting Knowledge to Work on Amazon
Show steps
  • Read chapters relevant to the course syllabus.
  • Try out the examples provided in the book.
  • Refer to the book when encountering difficulties in the course.
Practice Excel Functions
Reinforce your understanding of Excel functions through repetitive exercises. This will improve your speed and accuracy in using these functions.
Show steps
  • Choose a set of Excel functions (e.g., SUM, AVERAGE, IF).
  • Create sample data sets to use with the functions.
  • Practice using the functions with different data sets.
  • Check your results against expected values.
Four other activities
Expand to see all activities and additional details
Show all seven activities
Create a Cheat Sheet of Excel Functions
Solidify your understanding of Excel functions by creating a cheat sheet. This will help you quickly recall the syntax and usage of different functions.
Show steps
  • List the Excel functions covered in the course.
  • For each function, write a brief description of its purpose.
  • Include the syntax of each function with examples.
  • Organize the cheat sheet for easy reference.
Build a Personal Budgeting Tool in Excel
Apply your Excel skills to create a practical tool for managing personal finances. This project will test your ability to use formulas, charts, and tables.
Show steps
  • Define the categories for income and expenses.
  • Create a table to track income and expenses.
  • Use formulas to calculate totals and balances.
  • Create charts to visualize spending patterns.
  • Add conditional formatting to highlight key trends.
Read 'Microsoft Excel Data Analysis and Business Modeling'
Learn how to use Excel for data analysis and business modeling. This book provides practical examples and case studies to enhance your understanding.
View Microsoft Excel Data Analysis and Business... on Amazon
Show steps
  • Read chapters relevant to data analysis and business modeling.
  • Try out the examples provided in the book.
  • Apply the techniques learned to real-world data sets.
Follow Advanced Excel Tutorials on YouTube
Refine your Excel skills by following advanced tutorials on YouTube. This will expose you to new techniques and approaches.
Show steps
  • Search for tutorials on specific Excel topics (e.g., pivot tables, macros).
  • Follow the tutorials step-by-step.
  • Practice the techniques learned with your own data.
  • Take notes on key concepts and shortcuts.

Career center

Learners who complete MO-210: Microsoft Excel (from beginner to intermediate) will develop knowledge and skills that may be useful to these careers:
Business Analyst
Business analysts use technology as a key tool for data gathering, analysis, and reporting. This course may be helpful for a business analyst in developing skills related to manipulating data and presenting results. In a business analyst role, the ability to create and manage worksheets, format data, utilize formulas and functions, and generate charts is essential. This course provides practice activities to help learners remember how to perform these key tasks in Microsoft Excel. The course helps equip a business analyst with the tools needed for data driven decision-making.
See salaries and explore the career path for Business Analyst
Data Analyst
A data analyst uses software like Microsoft Excel to examine datasets and extract meaningful insights. This analyst role frequently manipulates, organizes, and summarizes data, which is why this course is helpful. The creation of charts and tables is often part of data analysis, skills which this course develops. The ability to use functions and formulas, another element of the course, is also essential for a data analyst when performing calculations and transformations on data. This course may be useful for aspiring data analysts wishing to learn these skills.
See salaries and explore the career path for Data Analyst
Budget Analyst
Budget analysts develop and manage financial plans for organizations. This course is useful for budget analysts because it helps develop expertise in using Microsoft Excel. They may use Excel skills to track expenditures, analyze financial data, and create budget forecasts and reports. The course provides the ability to manage data, format worksheets, create tables, and use formulas and functions, all of which are essential for analyzing budgets and communicating financial information. This course may be helpful for an aspiring budget analyst.
See salaries and explore the career path for Budget Analyst
Financial Analyst
Financial analysts use software like Microsoft Excel to create financial models, forecasts, and reports. This course may be useful in a financial analyst role as it helps build a foundation of skills to manage data in workbooks, format cells, apply formulas, and create charts to visualize data. Performing calculations, using conditional logic, and summarizing information are elements of this course that are also core tasks in financial analysis. The ability to use Excel functions and organize data is crucial for a financial analyst. This course may be useful for aspiring financial analysts.
See salaries and explore the career path for Financial Analyst
Accountant
Accountants use Excel for tasks like organizing financial data, creating reports, and performing calculations. An accountant may find that this course may be helpful for developing core skills in Microsoft Excel. The course includes skills such as how to manage and format data, use formulas and functions, create tables, and generate charts. These kinds of Excel skills are essential for financial reporting, analysis, and other common accounting functions. This course may be useful for an aspiring accountant.
See salaries and explore the career path for Accountant
Sales Operations Analyst
Sales operations analysts use spreadsheets to track sales data, analyze sales performance, and create reports. This course may be helpful as it helps build a foundation for working with data in Microsoft Excel. The course includes how to import, manage, and format data, use formulas and functions, and generate charts to visualize sales trends. The ability to leverage Excel is important for sales forecasting, analysis, and reporting. This course may be useful for aspiring sales operations analysts.
See salaries and explore the career path for Sales Operations Analyst
Project Analyst
Project analysts use Excel for tasks like managing project data, timelines, and resources. This course is useful for a project analyst as it builds a foundation for working with data in Microsoft Excel. The course teaches how to create and manage worksheets, format cells, use formulas, create tables and charts. These are skills that are essential for tracking project progress, analyzing data, and generating reports. This course may be useful for a project analyst.
See salaries and explore the career path for Project Analyst
Research Assistant
Research assistants often use spreadsheets to organize and analyze data collected through research efforts. This course may be useful for a research assistant as it introduces core concepts in manipulating data within Microsoft Excel. The course includes instruction on how to manage data in workbooks, format cells, use formulas, and present data using charts. These are fundamental skills needed to organize data and draw conclusions. These skills may be useful for a research assistant.
See salaries and explore the career path for Research Assistant
Marketing Assistant
Marketing assistants use software like Microsoft Excel to organize campaign data, track marketing metrics, and create reports. This course is helpful for marketing assistants by providing a foundation for using Microsoft Excel efficiently. The skills taught in this course, including creating and managing worksheets and workbooks, formatting data, creating tables, using formulas, and generating charts, are all relevant to the kind of work a marketing assistant does on a daily basis. This course may be useful for an aspiring marketing assistant.
See salaries and explore the career path for Marketing Assistant
Operations Analyst
An operations analyst works to improve the efficiency and effectiveness of an organization's processes. Operations analysts often use spreadsheets and data analysis tools. This course may be helpful for an operations analyst by providing a foundation for managing data, performing calculations, and presenting information using charts. The ability to use functions, formulas, and conditional logic to summarize data, also included in this course, would be relevant for an operations analyst. An operations analyst may find this course to be useful.
See salaries and explore the career path for Operations Analyst
Market Research Analyst
Market research analysts gather and interpret data on consumer behavior, market trends, and competitor activity. A market research analyst needs tools like Microsoft Excel to organize and analyze data. This course helps a market research analyst to manage data by teaching how to import, format, and summarize data using tables, formulas, and functions. The creation of charts and sparklines, also an objective of the course, would be particularly relevant to data visualization and presentation, essential skills for a market research analyst. This course may be useful for aspiring market research analysts.
See salaries and explore the career path for Market Research Analyst
Human Resources Assistant
Human resources assistants often use software like Microsoft Excel to manage employee records, track data, and generate reports. This course may be useful for a human resources assistant interested in developing skills in using Microsoft Excel. The course includes how to manage worksheets, format data, create tables, and use formulas and functions. These types of skills may be useful for everyday human resource tasks. This course may be useful for an aspiring human resources assistant.
See salaries and explore the career path for Human Resources Assistant
Administrative Assistant
Administrative assistants frequently use software like Microsoft Excel for tasks such as data entry, tracking project progress, and organizing information. This course may be useful to an administrative assistant as it provides an introduction to Microsoft Excel. The course teaches skills including how to manage worksheets, format data, create tables, and work with formulas and functions. These technical skills will help in the organization of data and the performance of general administrative tasks. This course may be useful for an administrative assistant.
See salaries and explore the career path for Administrative Assistant
Logistics Coordinator
Logistics coordinators often use spreadsheets to organize and manage shipment data, inventory, and delivery schedules. This course may be helpful for logistics coordinators in developing Excel skills to manage and track data in workbooks. This includes formatting, using formulas, creating tables, and filtering and sorting data, all of which are covered in the course. It may be useful for a logistics coordinator to use Excel for planning and tracking inventory and shipments. This course may be useful for an aspiring logistics coordinator.
See salaries and explore the career path for Logistics Coordinator
Project Coordinator
Project coordinators often use spreadsheets to organize project plans and track progress. This course may be useful to a project coordinator as it provides practice in using Microsoft Excel to manage data, format worksheets, create tables, and use formulas and functions. The course provides instruction on how to work with data in workbooks, skills that are relevant for project planning, tracking, and reporting. A project coordinator may find that the course is a useful introduction to Excel.
See salaries and explore the career path for Project Coordinator

Reading list

We've selected two books that we think will supplement your learning. Use these to develop background knowledge, enrich your coursework, and gain a deeper understanding of the topics covered in MO-210: Microsoft Excel (from beginner to intermediate).
Cover image
Putting Knowledge to Work
Save
Comprehensive guide to Excel, covering a wide range of topics from basic to advanced. It serves as a valuable reference for users of all skill levels. It is particularly useful for understanding the more complex functions and features of Excel. This book can be used as a reference text to deepen your understanding of Excel.
Putting Knowledge to Work
Paperback
Check
Putting Knowledge to Work
Kindle Edition
Check
Cover image
Microsoft Excel Data Analysis and Business Modeling...
Save
Focuses on using Excel for data analysis and business modeling. It covers topics such as statistical analysis, forecasting, and optimization. It good resource for those who want to use Excel for more advanced tasks. This book adds more depth to the existing course.
Microsoft Excel Data Analysis and Business Modeling...
Paperback
$$
Microsoft Excel Data Analysis and Business Modeling...
Kindle Edition
$$

Share

Help others find this course page by sharing it with your friends and followers:
Facebook
LinkedIn
Reddit
X
Link
Email

Similar courses

Similar courses are unavailable at this time. Please try again later.
Effort
8.5 total hours
Via
Udemy
Instructors
Phillip Burton • 850,000+ students so far
I Do Data Limited
Language
English
Good to know
Prepares learners to take the MO-210 exam, which can lead to the "Microsoft Office Specialist: Excel Associate (Microsoft 365 Apps)" certification, enhancing their professional credentials
Starts with the fundamentals, such as creating and managing worksheets, and progresses to more advanced topics like formulas, charts, and data manipulation
Covers importing, formatting, summarizing, and organizing data, which are essential skills for data analysis and reporting in various professional settings
Teaches skills in Excel, which is a foundational tool for many office jobs, and these skills are highly valued by employers across various industries
Includes 15 practice activities, 15 quizzes, and a practice test, which allows learners to reinforce their understanding and assess their readiness for the MO-210 exam
Focuses on Microsoft 365 Apps, which means that the course may not be as relevant to learners who use older versions of Excel, such as Excel 2019 or Excel 2016
Share and help others discover this course.
Facebook LinkedIn X Reddit Link Email
Don't miss out
Enroll today to gain access to this course
Enroll in this course
Our mission

OpenCourser helps millions of learners each year. People visit us to learn workspace skills, ace their exams, and nurture their curiosity.

Our extensive catalog contains over 50,000 courses and twice as many books. Browse by search, by topic, or even by career interests. We'll match you to the right resources quickly.

Find this site helpful? Tell a friend about us.

Affiliate disclosure

We're supported by our community of learners. When you purchase or subscribe to courses and programs or purchase books, we may earn a commission from our partners.

Your purchases help us maintain our catalog and keep our servers humming without ads.

Thank you for supporting OpenCourser.

© 2016 - 2025 OpenCourser