Excel Essentials
Keep adding new skills with 10,000+ programs for $239 (usually $399). Save now.
Excel Essentials
Included with
Ask Coursera
19 reviews
Recommended experience
19 reviews
Recommended experience
What you'll learn
Apply conditional formatting techniques to visualize patterns and insights in your data
Use filters and advanced filter tools to extract meaningful information quickly
Organize, sort, and clean datasets for better readability and analysis
Format, protect, and customize Excel workbooks for secure and efficient sharing
Skills you'll gain
Tools you'll learn
Details to know
See how employees at top companies are mastering in-demand skills
There are 10 modules in this course
This course features Coursera Coach!
A smarter way to learn with interactive, real-time conversations that help you test your knowledge, challenge assumptions, and deepen your understanding as you progress through the course. Whether you're new to Excel or looking to sharpen your data analysis skills, this course equips you with essential techniques to transform raw data into meaningful insights. You'll gain hands-on experience with Excel tools like conditional formatting, filters, and sorting to make your spreadsheets more dynamic, efficient, and visually impactful. The course begins by exploring conditional formatting, where you'll learn to highlight, compare, and visualize data with icons, color scales, and heat maps. Next, you’ll dive into filters—mastering basic, text, number, and date filters, as well as advanced methods like removing duplicates and outlining data. Sorting data takes center stage in the following section, teaching you everything from basic sorts to custom orders and randomization. The course then rounds out with essential Excel skills, including formatting cells, managing workbooks and worksheets, printing layouts, and adding protection for security and collaboration. This course is ideal for office professionals, analysts, students, and anyone looking to enhance their productivity with Excel. No prior Excel experience is required, but basic computer literacy will help you navigate smoothly. The difficulty level is beginner, making it accessible to a wide audience. By the end of the course, you will be able to visually analyze data using conditional formatting, filter and sort large datasets, format and protect workbooks, and navigate key Excel functions for efficient data management and presentation.
In this module, we will explore how to utilize Conditional Formatting in Excel to make your data visually compelling. From highlighting values based on predefined rules to managing complex formatting, this section will help you enhance your data analysis with ease.
What's included
10 videos1 reading
10 videos•Total 19 minutes
- Conditional Formatting•3 minutes
- Manage Rules•2 minutes
- Data Bars•2 minutes
- Color Scales•2 minutes
- Icon Sets•2 minutes
- Find Duplicates•2 minutes
- Shade Alternate Rows•2 minutes
- Compare Two Lists•2 minutes
- Conflicting Rules•1 minute
- Heat Map•2 minutes
1 reading•Total 10 minutes
- Full Course Resources •10 minutes
In this module, we will dive into the powerful filtering options in Excel, allowing you to quickly analyze relevant data. Whether you're dealing with simple filters or complex criteria, this section will show you how to refine your data for better insights.
What's included
9 videos1 assignment
9 videos•Total 15 minutes
- Filter•1 minute
- Number & Text Filters•1 minute
- Date Filters•1 minute
- Advanced Filter•2 minutes
- Data Form•2 minutes
- Remove Duplicates•2 minutes
- Outlining Data•2 minutes
- Subtotal•2 minutes
- Unique Values•2 minutes
1 assignment•Total 15 minutes
- Data Analysis - Filter - Assessment•15 minutes
In this module, we will cover how to sort data in Excel, from simple alphabetical ordering to more complex, custom sorting. You’ll also learn advanced techniques such as reversing and randomizing data to gain greater control over your spreadsheets.
What's included
6 videos1 assignment
6 videos•Total 9 minutes
- Sort•2 minutes
- Sort by Color•1 minute
- Custom Sort Order•1 minute
- Reverse List•1 minute
- Randomize List•1 minute
- SORT function•2 minutes
1 assignment•Total 15 minutes
- Data Analysis - Sort - Assessment•15 minutes
In this module, we will explore how to use Excel's Find and Select features to quickly locate, replace, and manage data across worksheets. These tools will save you time and effort when working with large sets of data.
What's included
1 video1 assignment
1 video•Total 2 minutes
- Using Find and Select•2 minutes
1 assignment•Total 15 minutes
- Essentials - Find & Select - Assessment•15 minutes
In this module, we will focus on how to format cells in Excel to make your data easier to read and visually appealing. You’ll learn how to adjust cell sizes, merge multiple cells, and use text wrapping to ensure optimal display.
What's included
4 videos1 assignment
4 videos•Total 6 minutes
- How To Format A Cell•2 minutes
- Decimal Places•1 minute
- How To Merge Cells•1 minute
- Wrapping Text•2 minutes
1 assignment•Total 15 minutes
- Essentials - Formatting Cells - Assessment•15 minutes
In this module, we will guide you through Excel's printing features, showing you how to set page breaks, format print areas, and adjust layouts. This section ensures you can print your spreadsheets efficiently, focusing only on the necessary data.
What's included
2 videos
2 videos•Total 2 minutes
- Page Breaks•1 minute
- Formatting The Print Area•1 minute
In this module, we will explore the different ways to secure your Excel workbooks and worksheets. From password protection to restricting cell editing, this section ensures that your data remains protected from unwanted modifications.
What's included
5 videos1 assignment
5 videos•Total 7 minutes
- Password Protecting•2 minutes
- Protecting A Workbook•1 minute
- Protecting A Sheet•1 minute
- Locking Cells•3 minutes
- Read-only Workbooks•1 minute
1 assignment•Total 15 minutes
- Essentials - Protect - Assessment•15 minutes
In this module, we will take a deep dive into Excel's Ribbon interface. You’ll learn how to customize it for your specific needs, use the Quick Access Toolbar for efficiency, and understand the information available on the status bar.
What's included
4 videos1 assignment
4 videos•Total 9 minutes
- Understanding the Ribbon (Excel Menu)•2 minutes
- Customizing the Ribbon•2 minutes
- Quick Access Toolbar•2 minutes
- Using the Status Bar•3 minutes
1 assignment•Total 15 minutes
- Essentials - Ribbon - Assessment•15 minutes
In this module, we will focus on essential workbook operations, including managing multiple workbooks, applying themes, and using AutoRecover to prevent losing valuable data. These foundational skills will help you work efficiently across large projects.
What's included
4 videos1 assignment
4 videos•Total 7 minutes
- Understanding Workbooks•2 minutes
- Workbook Themes•2 minutes
- Viewing Multiple Workbooks•1 minute
- Using AutoRecover•2 minutes
1 assignment•Total 15 minutes
- Essentials - Workbooks - Assessment•15 minutes
In this module, we will focus on managing and navigating worksheets within Excel. You’ll learn how to organize, freeze, group, and consolidate data from multiple worksheets, improving your ability to work efficiently with large datasets.
What's included
9 videos3 assignments
9 videos•Total 18 minutes
- Understanding Worksheets•2 minutes
- Sheet Names•3 minutes
- Viewing Multiple Worksheets•1 minute
- Spell Check•4 minutes
- Zoom•1 minute
- Splitting Your Worksheet•1 minute
- How To Freeze Panes•2 minutes
- How To Group Worksheets•1 minute
- Consolidating Worksheets•2 minutes
3 assignments•Total 90 minutes
- Essentials - Worksheets - Assessment•15 minutes
- Full Course Assessment•60 minutes
- Full Course Practice Assessment•15 minutes
Instructor
Explore more from Data Analysis
- Status: Free TrialK
Knowledge Accelerators
Course
- Status: Free Trial
Guided Project
- Status: PreviewB
Board Infinity
Course
Why people choose Coursera for their career
Frequently asked questions
Excel Essentials is a comprehensive course designed to teach key features and functionalities of Microsoft Excel. It covers essential topics such as conditional formatting, data analysis, sorting, filtering, formatting cells, workbook protection, and more. Understanding Excel is crucial because it’s a widely used tool in both personal and professional settings for data management, analysis, and presentation. Mastering these basics is essential for anyone looking to boost their productivity and improve their ability to handle data effectively.
This course focuses on the essential Excel skills that allow users to manage and analyze data efficiently. It covers topics such as conditional formatting, data filtering, sorting, and workbook protection. Each lesson builds upon fundamental concepts and techniques that are vital for organizing, visualizing, and securing data in Excel. The course is structured to help learners become proficient with Excel’s powerful features and tools, whether they are new to Excel or looking to strengthen their skills.
After completing this course, you will be able to confidently use Excel’s essential tools to manage data. You will be able to apply conditional formatting, use filters and sorting features, protect and secure your workbooks and worksheets, and optimize data visibility through techniques like data bars, color scales, and icon sets. This knowledge will enable you to streamline your workflow and make better data-driven decisions with Excel.
More questions
Financial aid available,