Excel Workout: Conditional Formatting

Excel Workout: Conditional Formatting

Conditional formatting provides visual cues to help you quickly make sense of your data. For example, it’ll clearly show highs and lows, or highlights zero values with red fill colour. The objective of this training is to learn how to use conditional formatting.

Contents:

• Highlighting cells based on their value
  • Duplicate values, zero values
  • Above or below average
  • Top or bottom values
• Using Graphs with conditional formatting
  • Data Bars
  • Colour Scales
  • Icon Sets
• Modifying and clearing conditional formatting

To whom?

This workout is an advanced level remote training and you can easily join from your workstation. The training is useful for you if you want to visualize your tables based on data values.

Enroll and start today!

Sovelto Easy workouts make learning easy!

Join in with Microsoft Teams and learn from Sovelto’s experienced instructors. We will cover all O365 tools you use in your daily work.

Check out all Sovelto Easy Workouts here.

Select the time and topic that suits you best, put your headset on and start learning!

Avainsanat: conditional formatting, Excel