Conditional Formatting in Microsoft Excel
Microsoft Excel powers business insights and productivity. This course will teach you the fundamentals of conditional formatting to make your data visually appealing and easier to analyze.
What you'll learn
Excel's conditional formatting can transform raw data into meaningful insights. In this course, Conditional Formatting in Microsoft Excel, you'll explore various conditional formatting options, learn to apply them to different data sets, and create visually appealing and easy-to-read spreadsheets that convey information clearly. When you’re finished with this course, you’ll have a better understanding of how to use conditional formatting to enhance the visual impact and clarity of your data.
Table of contents
- Introduction to Conditional Formatting in Excel 3m
- Demo: Excel Conditional Formatting: Highlight Cells 7m
- Demo: Excel Conditional Formatting: Top/Bottom Rules 4m
- Demo: Excel Conditional Formatting: Data Bars 3m
- Demo: Excel Conditional Formatting: Color Scales 4m
- Demo: Excel Conditional Formatting: Icon Sets 4m
- Demo: Applying Multiple Conditional Formatting Rules 3m
- Learn More 1m
About the author
Vlad is an Office 365 consultant helping organizations get the most out their Microsoft 365 Digital Workplace. IT Professional at heart, Vlad focuses on helping administrators deploy, manage, automate, and configure governance across services such as SharePoint, OneDrive for Business, and Microsoft Teams. As an author, Microsoft Certified Trainer and recognized international speaker, Vlad has helped over a million IT Professionals and end-users across the globe to better understand and to ge... more