When you enroll in this course, you'll also be asked to select a specific program.
Learn new concepts from industry experts
Gain a foundational understanding of a subject or tool
Develop job-relevant skills with hands-on projects
Earn a shareable career certificate
There are 5 modules in this course
This course is intended for learners with some experience using Microsoft Windows, who are seeking to build presentation skills with Microsoft Excel. To be successful in this course you should have an understanding of the basics of using a Windows-based computer. Experience with printing and using a web browser are an asset, but not required.
Knowing how to use Microsoft Office products is essential in any professional setting. Whether you want to expand your expertise to apply for a new role, start your own business, or simply develop a new personal skill this course is for you.
This course will introduce you to Microsoft’s powerful and easy-to-use spreadsheet program, which provides you with an extensive set of tools to organize, analyze, present, and store data. If you are familiar with Excel’s basic features you can take your skills to the next level. If you are a beginner you will get the opportunity to develop basic Excel skills.
In this course, you will become comfortable with creating a new spreadsheet, working with basic formulas and functions, making your spreadsheets look professional and presentable, and saving and printing a spreadsheet.
By the end of this course, you will be comfortable creating advanced formulas, analyzing data with functions, analyzing data using functions and PivotTables, working with tables, visualizing data with charts, working with graphical objects, and enhancing workbooks.
This course will help you prepare for Exam MO-200: Microsoft Excel (Excel and Excel 2019). You will get opportunities to demonstrate the ability to create and edit a workbook with multiple sheets and use a graphic element to represent data visually. You will also show that you can apply the correct application of the principal features of Excel and complete tasks independently.
In this module, you will get started with some entry-level basics in Microsoft Excel. By getting to know Excel, what it does, its interface, and general layout and features. You will get to start creating workbooks and working with data. Before exploring how to modify workbooks, format data, apply layout and prepare to print.
In this module, you will start working with Excel's core features: functions and formulas. You will learn how to implement and use formulas and functions with data in Excel. You will also learn how to use Sorting and Filtering tools, and define data sets by applying range names. Finally, you will explore an array of specialized, text, and logical functions that can boost your abilities in Excel.
What's included
14 videos10 readings7 assignments
Show info about module content
14 videos•Total 55 minutes
Module introduction - Working with functions•3 minutes
A closer look at formulas and functions•7 minutes
Using formulas and functions•5 minutes
Sort and filter Data•5 minutes
Add range names•5 minutes
Use range names in formulas•1 minute
Function categories and syntax•7 minutes
Using specialized functions•2 minutes
Manage text with functions•5 minutes
Trim and case text functions•2 minutes
Join and transpose text functions•3 minutes
Logical functions and operators•1 minute
Using logical functions with conditions•7 minutes
Module summary - Working with functions•2 minutes
10 readings•Total 100 minutes
Exercise: Getting started with formulas•10 minutes
Exercise: Using formulas and functions•10 minutes
Exercise: Sort and filter data•10 minutes
Exercise: Using range names in formulas•10 minutes
Exercise: Using specialized functions•10 minutes
Additional resources•10 minutes
Exercise: Analyzing data using text functions•10 minutes
Additional resources•10 minutes
Exercise: Analyzing data using logical functions•10 minutes
Additional resources•10 minutes
7 assignments•Total 120 minutes
Module quiz: Working with functions•30 minutes
Knowledge check: Working with formulas and functions•15 minutes
Knowledge check: Sorting and filtering data •15 minutes
Knowledge check: Apply range in Excel•15 minutes
Knowledge check: Specialized functions•15 minutes
Knowledge check: Text functions•15 minutes
Knowledge check: Logical functions •15 minutes
Organizing and visualizing data
Module 3•5 hours to complete
Module details
In this module, you will move on to how to organize and visualize data in Excel. You will learn all about tables and charts, how to create, format, and modify them to store organize and display data in the way that you need. You will also learn how to manage large workbooks. Finally, you will be introduced to analyzing data, using Excels pivot tables and slicers.
What's included
16 videos14 readings6 assignments
Show info about module content
16 videos•Total 67 minutes
Module introduction - Organizing and visualizing data•1 minute
Create tables•5 minutes
Format tables•4 minutes
Modifying tables•8 minutes
Name tables and use structured references•6 minutes
Database functions and convert to range•5 minutes
Format worksheet tabs•2 minutes
Manage worksheets•5 minutes
Manage the view of worksheets and workbooks•4 minutes
Create charts•5 minutes
Modify and format charts•4 minutes
Advanced chart elements•2 minutes
Create a PivotTable•6 minutes
Summarize data in a PivotTable•6 minutes
Filtering data using slicers•3 minutes
Module summary - Organizing and visualizing data•2 minutes
14 readings•Total 140 minutes
Exercise: Creating and modifying a table•10 minutes
Exercise: Modifying tables•10 minutes
Subtotal function arguments•10 minutes
List of database functions•10 minutes
Exercise: Using table references•10 minutes
Exercise: Formatting worksheet tabs•10 minutes
Exercise: Managing worksheets•10 minutes
Exercise: Managing the view of worksheets and workbooks•10 minutes
Exercise: Creating charts•10 minutes
Exercise: Modifying and formatting charts•10 minutes
Exercise: Create a trendline•10 minutes
Summary of DAX categories of functions •10 minutes
Exercise: Creating PivotTables•10 minutes
Exercise: Filtering data using slicers•10 minutes
6 assignments•Total 105 minutes
Module quiz: Organizing and visualizing data•30 minutes
Knowledge check: Create and modify tables •15 minutes
Knowledge check: Table references•15 minutes
Knowledge check: Managing large workbooks•15 minutes
Knowledge check: Visualizing data with basic charts •15 minutes
Knowledge check: Analyzing data •15 minutes
Advanced Excel features
Module 4•5 hours to complete
Module details
In this module, you will have the opportunity to try out some of the Advanced features that Excel has to offer. These include customizing formulas, proofing, and interface options, as well as applying conditional formatting. How to customize, manage, enhance and automate large workbooks, and how to export data and use data sources.
Knowledge check: Enhancing and managing workbooks •15 minutes
Knowledge check: Exporting and sourcing data•15 minutes
2 discussion prompts•Total 20 minutes
Why use conditional formatting?•10 minutes
Reflect on learning•10 minutes
Hands-on practice using Microsoft Excel
Module 5•1 hour to complete
Module details
In this module, you will undertake a hands-on project with Microsoft Excel. In this project, you will use the knowledge and experience that you’ve gained from the previous modules by applying your spreadsheet skills to analyze and present sales data, before reviewing and leaving comments.
What's included
1 video1 reading1 peer review1 discussion prompt
Show info about module content
1 video•Total 2 minutes
Project introduction•2 minutes
1 reading•Total 10 minutes
How to submit assignment link•10 minutes
1 peer review•Total 60 minutes
Task 1: Analyze and present data with Excel•60 minutes
1 discussion prompt•Total 10 minutes
The benefits of using Microsoft Excel•10 minutes
Earn a career certificate
Add this credential to your LinkedIn profile, resume, or CV. Share it on social media and in your performance review.
Instructor
Instructor ratings
Instructor ratings
We asked all learners to give feedback on our instructors based on the quality of their teaching style.
Our goal at Microsoft is to empower every individual and organization on the planet to achieve more.
In this next revolution of digital transformation, growth is being driven by technology. Our integrated cloud approach creates an unmatched platform for digital transformation. We address the real-world needs of customers by seamlessly integrating Microsoft 365, Dynamics 365, LinkedIn, GitHub, Microsoft Power Platform, and Azure to unlock business value for every organization—from large enterprises to family-run businesses. The backbone and foundation of this is Azure.
"To be able to take courses at my own pace and rhythm has been an amazing experience. I can learn whenever it fits my schedule and mood."
Jennifer J.
Learner since 2020
"I directly applied the concepts and skills I learned from my courses to an exciting new project at work."
Larry W.
Learner since 2021
"When I need courses on topics that my university doesn't offer, Coursera is one of the best places to go."
Chaitanya A.
"Learning isn't just about being better at your job: it's so much more than that. Coursera allows me to learn without limits."
Learner reviews
4.7
3,334 reviews
5 stars
77.48%
4 stars
17.98%
3 stars
2.27%
2 stars
0.65%
1 star
1.58%
Showing 3 of 3334
A
AX
5·
Reviewed on Apr 9, 2022
This is a great course.  I am a first-time Excel user, but now I am much more confident in my newfound skills.  thank you, coursera.
S
SE
5·
Reviewed on Feb 26, 2024
The course tremendously helps the beginners to have very sufficient knowledge and skills needed to perform the analytical work. I strongly recommend it!
M
MZ
5·
Reviewed on Jul 19, 2025
i recently completed this course and found it veryhelpful it cover practical excel features that can improve productivity especially for people working with data, reports and business works
You'll learn how to create, format, and improve spreadsheets so you can organize, calculate, and present data clearly in Excel. It starts with workbook basics and formatting, then moves into formulas and more advanced ways to analyze and visualize information. In the guided exercises, you'll practice by building worksheets, creating charts, and turning raw data into useful summaries.
Do I need to know Excel before taking this course?
No, you don't need prior Excel expertise to start. You should understand the basics of using a Windows-based computer, and experience with printing or a web browser is helpful but not required. The course begins with the Excel interface and creating workbooks before it asks you to do more advanced tasks.
Is this course beginner-friendly for Excel?
Yes, it's beginner-friendly if you're new to Excel or only know the basics. The course starts with the interface, worksheets, rows and columns, formatting, and printing before it builds into formulas, tables, and charts. It may feel less beginner-friendly only if you're not yet comfortable using a Windows computer.
How long does it take to complete this course?
Plan on about 22 hours in total, or roughly 2 to 3 weeks at around 10 hours a week. The pace is steady, with short lessons followed by readings, guided exercises, and quizzes. The course includes lessons, exercises, quizzes, graded assessments, and an optional peer-reviewed assignment near the end.
Are there hands-on exercises or projects in this course?
Yes, there's guided practice throughout the course. Most of it comes through step-by-step Excel exercises where you'll create workbooks, use formulas, sort and filter data, and turn datasets into charts or PivotTables. There's also an optional peer-reviewed sales report project, so you can pull several skills together in one piece of work.
What skills and topics are covered in this course?
The course covers the core Excel skills people use to build, clean up, analyze, and present spreadsheet data. You'll work on worksheet formatting and management, formulas and functions, sorting and filtering, then move into tables, charts, PivotTables, conditional formatting, and workbook sharing or export options. By the end, you'll have a broad set of Excel tools for handling both everyday spreadsheets and larger data tasks.
What can I actually do after finishing this course?
After finishing, you should be able to create and edit workbooks with multiple sheets, apply formulas and functions, and present data more clearly in Excel. For example, you could take a sales worksheet, calculate totals or averages, turn it into a chart, and summarize it with a PivotTable. You'll also be more comfortable managing tables, printing workbook content, and working with larger files.
Is this course more focused on theory or hands-on learning?
It leans hands-on, but in a guided way. Most topics are introduced in short lessons and then reinforced through exercises and quizzes, so it's a better fit if you like learning Excel by doing rather than by reading about it for long stretches.
Why would I choose this course over other Excel courses?
This course is a strong choice if you want one Excel course that moves from everyday spreadsheet tasks into analysis and presentation skills. The teaching is broad rather than narrow, with guided practice in formulas, charts, PivotTables, workbook management, and advanced features like conditional formatting and data export. If you want step-by-step Excel fluency instead of a course focused on just one topic, this is likely the better fit.