VOOZH about

URL: https://www.coursera.org/learn/microsoft-excel-work-smarter

⇱ Work Smarter with Microsoft Excel | Coursera

Work Smarter with Microsoft Excel

Keep adding new skills with 10,000+ programs for $239 (usually $399). Save now.

Work Smarter with Microsoft Excel

This course is part of multiple programs.

300,833 already enrolled

Included with

Ask Coursera

Gain insight into a topic and learn the fundamentals.
4.7

3,349 reviews

Beginner level

Recommended experience

Flexible schedule
2 weeks at 10 hours a week
Learn at your own pace
97%
Most learners liked this course
Gain insight into a topic and learn the fundamentals.
4.7

3,349 reviews

Beginner level

Recommended experience

Flexible schedule
2 weeks at 10 hours a week
Learn at your own pace
97%
Most learners liked this course

What you'll learn

  • You will learn how to create a spreadsheet, work with formulas and functions, make your spreadsheets look professional, and print a spreadsheet.

  • How to manage worksheets, workbooks, tables table data, data cells and ranges, and charts

  • How to perform operations by using formulas and functions

Details to know

Shareable certificate

Add to your LinkedIn profile

Assessments

24 assignments¹

AI Graded see disclaimer
Taught in English

Build your subject-matter expertise

This course is available as part of
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.

What's included

16 videos16 readings5 assignments1 discussion prompt

16 videos•Total 65 minutes
  • Introduction to Work Smarter with Excel•3 minutes
  • Navigating this course•4 minutes
  • Get to know Excel•5 minutes
  • Create a workbook•5 minutes
  • Save and share a workbook•5 minutes
  • Get help in Microsoft Excel•2 minutes
  • Work with data•6 minutes
  • Work with rows and columns•4 minutes
  • Format text•5 minutes
  • Format cells•3 minutes
  • Align cell content•2 minutes
  • Search for and replace data•5 minutes
  • Spell check a worksheet•3 minutes
  • Define the basic page layout for a workbook•6 minutes
  • Refine the page layout and apply print options•5 minutes
  • Module summary - Getting started with Excel•2 minutes
16 readings•Total 141 minutes
  • Course syllabus - Work Smarter with Excel•10 minutes
  • How to be successful in this course•5 minutes
  • How to use the video settings on Coursera•5 minutes
  • Exercise: Creating workbooks•10 minutes
  • Exercise: Getting help in Excel•10 minutes
  • Additional resources•10 minutes
  • Exercise: Working with data•10 minutes
  • Exercise: Working with rows and columns•10 minutes
  • Exercise: Formatting text•10 minutes
  • Regional number formatting•10 minutes
  • Exercise: Formatting cells•10 minutes
  • Exercise: Aligning cell content•1 minute
  • Exercise: Searching for and replacing data•10 minutes
  • Exercise: Spell checking a worksheet•10 minutes
  • Exercise: Previewing a workbook before printing•10 minutes
  • Exercise: Refining the page layout and applying print options•10 minutes
5 assignments•Total 90 minutes
  • Module quiz: Getting started with Excel•30 minutes
  • Knowledge check: Get started with Excel •15 minutes
  • Knowledge check: Get started with data •15 minutes
  • Knowledge check: Modifying a worksheet •15 minutes
  • Knowledge check: Printing workbook content•15 minutes
1 discussion prompt•Total 5 minutes
  • Share your experience and objectives•5 minutes

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

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

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

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

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.

What's included

11 videos9 readings6 assignments2 discussion prompts

11 videos•Total 39 minutes
  • Customizing formula options•2 minutes
  • Customize proofing and save options•3 minutes
  • Customize the ribbon and Quick Access Toolbar•2 minutes
  • Conditional formatting•4 minutes
  • Conditional formatting rules•5 minutes
  • Customize workbooks•6 minutes
  • Manage workbook properties•4 minutes
  • Export data•3 minutes
  • Use data sources•7 minutes
  • Module summary - Advanced Excel features•1 minute
  • Course wrap up - Work Smarter with Microsoft Excel•2 minutes
9 readings•Total 85 minutes
  • Exercise: Customizing formula options•10 minutes
  • Customizing proofing and save options•10 minutes
  • Exercise: Customizing the Quick Access Toolbar•10 minutes
  • Exercise: Apply conditional formatting•10 minutes
  • Exercise: Customizing workbooks•10 minutes
  • Exercise: Managing workbook properties•10 minutes
  • Exercise: Exporting worksheet data•10 minutes
  • Exercise: Using data sources•10 minutes
  • Next steps•5 minutes
6 assignments•Total 180 minutes
  • Module quiz: Advanced Excel features•30 minutes
  • Course quiz: Work Smarter with Microsoft Excel•90 minutes
  • Knowledge check: Customize the Excel environment•15 minutes
  • Knowledge check: Conditional formatting •15 minutes
  • 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

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

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
4.7 (985 ratings)
343 Courses•2,617,428 learners

Explore more from Business Essentials

Why people choose Coursera for their career

👁 Image

Felipe M.

Learner since 2018
"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."
👁 Image

Jennifer J.

Learner since 2020
"I directly applied the concepts and skills I learned from my courses to an exciting new project at work."
👁 Image

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."
👁 Image

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

  • 5 stars

    77.42%

  • 4 stars

    18%

  • 3 stars

    2.26%

  • 2 stars

    0.68%

  • 1 star

    1.61%

Showing 3 of 3349

SE
·

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!

ZW
·

Reviewed on Jul 21, 2023

For a Mac user like me, I need to figure out how do some features function on Mac myself and all contents are based on Windows version of Excel.

AX
·

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.

Frequently asked questions

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.

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.

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.

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.

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.

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.

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.

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.

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.

Financial aid available,

¹ Some assignments in this course are AI-graded. For these assignments, your data will be used in accordance with Coursera's Privacy Notice.