Skip to main content

In-Depth Excel Conditional Formatting

Date(s): Dec 13, 2022
Time: 8:00AM - 12:00PM
Registration Fee: $99.00
Cancellation Date: Nov 19, 2022
Location: SAO COMPUTER TRAINING ROOM
City: Austin
Parking Info:

Parking for SAO, Professional Development courses is in Garage B (1511 San Jacinto Blvd.). The Garage signage may read 1511 San Jacinto or Garage B. The elevator in Garage B is not reliable. If you are unable to walk the stairs, please contact the professionaldevelopment@sao.texas.gov for alternate parking arrangements. Handicapped parking is free at the meters around the downtown area.

A course coordinator will Email you a parking permit prior to the course start date. A permit must be displayed or you will be ticketed.


Course Description

In Excel, you can use conditional formatting to highlight data based on certain conditions. This allows users to easily identify patterns or trends in data. Basic conditional formatting allows you to highlight cells based on criteria such as greater than or less than a value. Intermediate users might use data bars, icons sets, color scales, and more. More advanced users might use formulas in their conditional formatting. This class covers all of that and more and will help you use the feature it to its fullest potential.


Potential CPE Credits: 3.5

Instruction Type: Live
Experience Level: ALL
Category: Computer Software and Applications

Course Objectives

In this class, we will learn how to use the Excel data bars, icon sets, and color scales to quickly identify changes in your data. You will also learn how to use formulas in conditional formatting. Conditional formatting basics. Topics discussed in this class are:

• Using the Greater Than, Between or Less than options

• Clearing and Managing Rules

• Identifying Duplicates

• Working with Text

• Identifying the Top Values

• Working with Above or Below Average numbers

• Using Data bars

• Using Color Scales

• Working with Icon Sets

• Using Formulas

• Using Conditional Formatting in PivotTables


Prerequisites

An introductory Excel course, or equivalent working knowledge of the software.


Instructors

Darla Cloud

Darla Cloud has been teaching computer classes for over 27 years. She has earned the various Microsoft Office certifications acknowledging her expertise in Microsoft products. Darla is also a Certified Public Accountant and a Certified Technical Trainer. In addition to Darla’s years of teaching, she has over seven years of accounting experience. Darla’s accounting experience and love of teaching help make her an excellent trainer. She has spent years learning tips, tricks and shortcuts that she will pass on during her classes.


Additional Information

TAC Rule 523.142(g) requires the CPE Sponsor to monitor individual attendance and assign the correct number of CPE credits. Participants will be asked to document their time of arrival and departure in compliance with this Rule. Additionally, attendance will be monitored throughout the day and CPE certificates will reflect actual attendance of each participant.

If you are making travel plans to come to Austin, we recommend making "refundable" air and hotel reservations or waiting until 14 days before the class to actually book your reservations. Courses are occasionally canceled or rescheduled due to low enrollment. We determine whether a course has enough participants 16 days prior to the course date. If we cancel or reschedule, we will email the participant and his or her billing contact no later than 14 days before the original class date.

Vending machines with Coca-Cola products and various snack items are available. There is also a refrigerator and microwave in our coffee bar area. Feel free to bring in your own drinks and food if you prefer.

You might want to bring a light sweater or jacket, as room temperatures vary.

To see answers to our Frequently Asked Questions, visit http://www.sao.texas.gov/training/faq.html.