Back to Conditional Formatting, Tables and Charts in Microsoft Excel
Coursera

Conditional Formatting, Tables and Charts in Microsoft Excel

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.

Status: Spreadsheet Software
Status: Data Analysis Software
IntermediateGuided Project1 hour

Featured reviews

EA

5.0Reviewed 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.0Reviewed Mar 29, 2022

Great Course to understand conditional formatting in depth

AS

5.0Reviewed Mar 18, 2024

Best Job by instructor and thanks to Coursera for this wonderful course.

KF

5.0Reviewed Jul 8, 2022

☆Thank God first, then thank Mrs. Paula specially •ᴗ• & you all generally☆

V

5.0Reviewed Sep 6, 2025

why to teach of instructor is best. thank you for guidance

SN

5.0Reviewed Jan 27, 2026

Short videos that make learning quick and fun. Easy to understand.

SL

5.0Reviewed Dec 5, 2022

Steps were explained very well. Would definitely recommend this course.

SK

5.0Reviewed Nov 28, 2025

easily explained and easy to understand. excited to get free certificate

ZK

5.0Reviewed 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.

SR

5.0Reviewed Sep 22, 2025

Went so much better than I could have expected because it was consistently engaging and entertaining!

AG

5.0Reviewed Jul 22, 2025

Great course, easy to follow and apply. Thank you!

All reviews

Showing: 20 of 38

Rais Husmanov
5.0
Reviewed Jun 3, 2024
Zafran khan
5.0
Reviewed Jan 14, 2024
Eddy Alba
5.0
Reviewed Oct 1, 2024
Sarah Richart
5.0
Reviewed Sep 23, 2025
Georgia Martha Sari
5.0
Reviewed Mar 18, 2023
Khaled Fouad
5.0
Reviewed Jul 9, 2022
Salman Khan
5.0
Reviewed Nov 29, 2025
Abdul Samad
5.0
Reviewed Mar 19, 2024
Stephanie Liang
5.0
Reviewed Dec 6, 2022
Stha Ncube
5.0
Reviewed Jan 28, 2026
Hendra Kurniawan
5.0
Reviewed Sep 16, 2024
Vibha SHARMA
5.0
Reviewed Sep 7, 2025
Catherine Robert Munuo
5.0
Reviewed Mar 30, 2022
Arllette Gaona
5.0
Reviewed Jul 22, 2025
Raj Singh
5.0
Reviewed Nov 20, 2022
Member Ojebode
5.0
Reviewed May 1, 2023
Mbali Linda
5.0
Reviewed Jul 8, 2022
Steven Monserrate
5.0
Reviewed Jul 5, 2023
Manish Jain
5.0
Reviewed Sep 13, 2023
Debbie B
5.0
Reviewed Jul 25, 2025