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.
This course is part of the Microsoft 365 Fundamentals Specialization
34,761 already enrolled
Offered By
About this Course
433,739 recent views
Flexible deadlines
Reset deadlines in accordance to your schedule.
Shareable Certificate
Earn a Certificate upon completion
100% online
Start instantly and learn at your own schedule.
Course 2 of 3 in the
Beginner Level
Understanding of the basics of using a Windows-based computer. Experience with printing and using a web browser are an asset, but not required.
Approx. 20 hours to complete
English
Subtitles: English
Could your company benefit from training employees on in-demand skills?
Try Coursera for BusinessWhat you will learn
You will learn how to create a spreadsheet, work with formulas and functions, make your spreadsheets look professional, and print a spreadsheet.
Skills you will gain
- Manage worksheets and workbooks
- Manage tables and table data
- Manage data cells and ranges
- Manage charts
- Perform operations by using formulas and functions
Flexible deadlines
Reset deadlines in accordance to your schedule.
Shareable Certificate
Earn a Certificate upon completion
100% online
Start instantly and learn at your own schedule.
Course 2 of 3 in the
Beginner Level
Understanding of the basics of using a Windows-based computer. Experience with printing and using a web browser are an asset, but not required.
Approx. 20 hours to complete
English
Subtitles: English
Could your company benefit from training employees on in-demand skills?
Try Coursera for Business
Offered by
Microsoft
Our goal at Microsoft is to empower every individual and organization on the planet to achieve more.
Syllabus - What you will learn from this course
5 hours to complete
Getting started with Excel
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.
5 hours to complete
16 videos (Total 65 min), 16 readings, 5 quizzes
5 hours to complete
Working with functions
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.
5 hours to complete
14 videos (Total 55 min), 10 readings, 7 quizzes
5 hours to complete
Organizing and visualizing data
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.
5 hours to complete
16 videos (Total 67 min), 14 readings, 6 quizzes
4 hours to complete
Advanced Excel features
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.
4 hours to complete
11 videos (Total 39 min), 9 readings, 5 quizzes
Reviews
- 5 stars79.15%
- 4 stars17.33%
- 3 stars2.34%
- 2 stars0.23%
- 1 star0.93%
TOP REVIEWS FROM WORK SMARTER WITH MICROSOFT EXCEL
by PSJul 6, 2022
Excellent course. Well supported with exercises for clarity and understanding concepts more easily.
by KUJul 16, 2022
Great course, easily learnt the tips and tricks of MS Excel, to use in my professional life.
by DAMar 12, 2022
i am so glad to get Microsoft Certificate, thank you for your best work to ofer this training
by EDJun 24, 2022
Very detailed with good exercises to strengthen my skills. My speed, presentation and even thinking will be clearer.
About the Microsoft 365 Fundamentals Specialization
This Specialization is intended to help all novice computer users get up to speed with Microsoft 365 quickly. It covers different features of the interface, shows you how to perform basic tasks, and introduces you to the most important tools in Word, PowerPoint, and Excel. This program will help you to become familiar with the apps and services included in a Microsoft 365 subscription. You will improve your word processing, spreadsheet, and presentation skills to take your productivity to the next level. You will learn how to work smarter and more collaboratively with the latest intelligent features of Office 365. By the end of this program of courses, you will be ready to take and sign-up for the MO-100: Microsoft Word (Word and Word 2019), MO-200: Microsoft Excel (Excel and Excel 2019), and MO-300: Microsoft PowerPoint (PowerPoint and PowerPoint 2019).
Frequently Asked Questions
When will I have access to the lectures and assignments?
What will I get if I subscribe to this Specialization?
Is financial aid available?
More questions? Visit the Learner Help Center.
