Unlock access to 10,000+ courses with Coursera Plus. Start 7-Day free trial.

Packt

Excel Essentials

Included with Coursera Plus

Learn more

Gain insight into a topic and learn the fundamentals.
Beginner level

Recommended experience

5 hours to complete
Flexible schedule
Learn at your own pace
Gain insight into a topic and learn the fundamentals.
Beginner level

Recommended experience

5 hours to complete
Flexible schedule
Learn at your own pace

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

Details to know

Shareable certificate

Add to your LinkedIn profile

Recently updated!

December 2025

Assessments

10 assignments

Taught in English

See how employees at top companies are mastering in-demand skills

 logos of Petrobras, TATA, Danone, Capgemini, P&G and L'Oreal

There are 10 modules in this course

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

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

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

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

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

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

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

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

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

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

Instructor

Packt - Course Instructors
Packt
1,218 Courses295,149 learners

Offered by

Packt

Explore more from Data Analysis

Why people choose Coursera for their career

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."
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."
Coursera Plus

Open new doors with Coursera Plus

Unlimited access to 10,000+ world-class courses, hands-on projects, and job-ready certificate programs - all included in your subscription

Advance your career with an online degree

Earn a degree from world-class universities - 100% online

Join over 3,400 global companies that choose Coursera for Business

Upskill your employees to excel in the digital economy

Frequently asked questions