In this project, you will learn how to analyze data and identify trends using a variety of tools in Microsoft Excel. Conditional formatting and charts are two tools that focus on highlighting and representing data in a visual form. With conditional formatting, you can define rules to highlight cells using a range of color scales and icons and to help you analyze data and identify trends or outliers. You will then use PivotTables to create summaries of the data that focuses on specific relationships which you will represent as a line chart and column chart. Both conditional formatting and charts are two useful ways of visually analyzing data and exploring trends.
Conditional Formatting, Tables and Charts in Microsoft Excel
Conditional Formatting, Tables and Charts in Microsoft Excel
Instructor: Paula Del Rey
19,362 already enrolled
Included with 
Gain insight into a topic and learn the fundamentals.
4.7
(205 reviews)
Intermediate level
Recommended experience
1 hour to complete
Flexible schedule
Learn at your own pace
What you'll learn
Use table functionalities in Microsoft Excel to organize, sort, and filter data.
Visually analyze data by highlighting cells on the basis of conditional formatting rules.
Explore trends by graphing data in the form of line and column charts, through the use of PivotTables.
Skills you'll gain
Details to know
Shareable certificate
Add to your LinkedIn profile
Assessments
1 assignment
Taught in English
See how employees at top companies are mastering in-demand skills
Earn a career certificate
Add this credential to your LinkedIn profile, resume, or CV
Share it on social media and in your performance review
There is 1 module in this course
In this project, you will learn how to visually analyze data using a variety of tools in Microsoft Excel. You will use conditional formatting to highlight cells based on a number of conditional formatting rules. You will then use PivotTables to create summaries of the data that focuses on specific relationships which you will represent as a line chart and column chart.
What's included
1 reading1 assignment1 ungraded lab1 plugin
Instructor
Instructor ratings
5.0 (22 ratings)Offered by
Recommended if you're interested in Business Essentials
Coursera Project Network
Coursera Project Network
Coursera Project Network
Coursera Project Network
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."
Learner reviews
4.7
205 reviews
- 5 stars
80%
- 4 stars
15.12%
- 3 stars
3.90%
- 2 stars
0%
- 1 star
0.97%
Showing 3 of 205
EA
5
Reviewed on Sep 30, 2024
Very happy with the contend as person with zero experience with creating Pivot Tables and Charts this session truly helped me.
CM
5
Reviewed on Mar 29, 2022
Great Course to understand conditional formatting in depth
ZK
5
Reviewed on Jan 13, 2024
Hi, i have successfully completed the project within 1 hour.
All credit goes to my instructor and the Coursera team members. Thank you so much Coursera team.
New to Business Essentials? Start here.
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
Yes, you can preview the first video and view the syllabus before you enroll. You must purchase the course to access content not included in the preview.
If you decide to enroll in the course before the session start date, you will have access to all of the lecture videos and readings for the course. You’ll be able to submit assignments once the session starts.
Once you enroll and your session begins, you will have access to all videos and other resources, including reading items and the course discussion forum. You’ll be able to view and submit practice assessments, and complete required graded assignments to earn a grade and a Course Certificate.
More questions
Financial aid available,