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.
Buy Now Free
- Level Intermediate
- Duration 3 hours
- Course by Coursera Project Network
-
Offered by
About
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.Modules
Your Learning Journey
-
1
Readings
-
1
Plugin
-
1
Lab
-
1
Assignment
1
Assignment
- Assess Your Knowledge
1
Labs
- Conditional Formatting, Tables and Charts in Microsoft Excel
1
Readings
- Project Overview
Auto Summary
This intermediate-level course from Coursera focuses on mastering data analysis in Microsoft Excel through conditional formatting, tables, and charts. Over 180 minutes, learners will explore tools to visually highlight and represent data, identify trends, and create PivotTables for insightful summaries. Ideal for IT and computer science enthusiasts, the course offers free enrollment.
Paula Del Rey