Excel Conditional Formatting Master Class

Learn these astonishing hidden Excel secrets and skyrocket your spreadsheets from “Meh” to “WOW” almost immediately!

Created by: Igor Ovchinnikov
The Silicon Valley's Secret Weapon of Training

What Will I Learn?

• Learn the power of conditional formatting in Excel.
• Use Conditional Formatting to save time at work
• Become more creative in Excel.
• Acquire specific ideas and proven strategies to become more productive in Excel.
• Make your spreadsheets more dynamic with conditional formatting
• Learn how to use the conditional formatting tools for maximum efficiency and productivity.
• Learn how to use text-based conditional formatting tools, so you can quickly identify important data at a glance - immediately.
• Learn to take advantage of the date-based conditional formatting rules to zero in on specific dates quickly by automatically highlighting them.
• Discover how to quickly highlight duplicate data by using conditional formatting formatting techniques.
• Know how to use top and bottom conditional formatting rules to identify your “winners” and “losers”.
• Get astonished by the amazing power of the range-based conditional formatting rules. Such as Data Bars, Icon Sets, and Color Scales.
• Go deeper and learn to exploit the mega-flexible custom conditional formatting rules.
• Get even more astonished and learn how to benefit from formula-based conditional formatting rules for keeping close tabs on your constantly changing data.
• Learn secret and creative ways to use the super-powerful VLOOKUP function in your formula-based conditional formatting rules for maximum flexibility. (This is huge!)

Requirements

• Access to a computer with Excel installed.
• Recommended to take my Excel Without Pain course

Target audience

• Excel users of any level.
• Anyone looking for a better way in Excel.
• Anyone who wants to learn to effectively use conditional formatting in Excel