Management
Hands on Training icon
Hands On Training
Hands on Training icon

Conditional Formatting in Spreadsheets

Course Cover
compare button icon

Course Features

icon

Duration

4 hours

icon

Delivery Method

Online

icon

Available on

Limited Access

icon

Accessibility

Mobile, Desktop, Laptop

icon

Language

English

icon

Subtitles

English

icon

Level

Intermediate

icon

Teaching Type

Self Paced

icon

Video Content

4 hours

Course Description

Spreadsheets can be affected by too many data. Conditional formatting can be used to tell the story of data without the need to create additional reports. You can use conditional formatting to highlight significant differences in financial data year over year and display the age of your inventory with a color scale. It can replace filtering or sorting because it uses data already in use. To analyze the payroll of a company, you will be able to create your own report using conditional formatting.

Course Overview

projects-img

Virtual Labs

projects-img

International Faculty

projects-img

Post Course Interactions

projects-img

Hands-On Training,Instructor-Moderated Discussions

Skills You Will Gain

Prerequisites/Requirements

Data Analysis in Spreadsheets

What You Will Learn

In this chapter, you will learn more functions, build your own searches, and make interactive task lists with checkboxes

Learn how to use conditional formatting with your data through built-in options and by creating custom formulas

Learn what conditional formatting is and how it can be used to emphasize the important data in a spreadsheet

Course Instructors

Author Image

Adam Steinfurth

Instructor at DataCamp

Adam enjoys teaching others about software in their jobs and personal lives. He has over one hundred tutorial videos on his YouTube channel Prolific Oaktree, which are mostly about Google Sheets.
Course Cover