Excel in 30 Minutes – Conditional Formatting

People who have a basic knowledge of Microsoft® Windows® and want to learn beginner Excel 2019 skills to create and modify spreadsheets. By the end of this course, you will be able to use Conditional Formatting and Comparative Analysis Formatting to easily read and analyze data, as well as access and create templates for predefined formatting.

$39.99

Course Overview

There are two kinds of people: Those who are masters at Excel, and those who wish they were.

When you master Excel, you have one of the most practical and valuable skillsets in modern business.

Our Excel in 30 Minutes Series can help you get started. This course is one in a series of 10 30-minute courses.

By the end of this course, you will be able to use Conditional Formatting and Comparative Analysis Formatting to easily read and analyze data, as well as access and create templates for predefined formatting.

Once the course is complete, you will be able to:

Use Conditional Formatting to make it easy to read and analyze your data.

Apply Conditional Formatting to Text and Dates to easily identify certain values or duplicates

Apply Comparative Analysis Formatting to add Data Bars, Color Scales, and Icon Sets to your worksheets

Access built-in Templates and create your own Custom Templates to use predefined formatting

Course Topics

This course covers the following topics:

Applying Conditional Formatting to Numbers
Applying Conditional Formatting to Text and Dates
Applying Comparative Analysis Formatting
Using Templates

Online Course Duration

Approximately 30 minutes

Pass Mark

Testing conducted throughout this online course is designed to reinforce the information presented. A mark of 80% must be achieved in order to pass this course. The course is able to be taken three times in efforts to achieve the pass mark.

Certificate Of Completion

Upon successful completion of this online course, a certificate of completion will be available for download and printing.

1 780 691 6786

1 780 691 6786