Excel Conditional Formatting
This virtual Microsoft Suite series class taught by Neal Otto will follow the schedule below. Each class must be registered for by emailing steph@nacmint.com; cost per class is $135/pp. The series is a la carte and no one must attend every class. All times are Mountain.
Excel Conditional Formatting
This in-depth course on Excel’s Conditional Formatting begins with foundational concepts and rapidly progresses to advanced techniques. Students will learn to make key data stand out by applying a range of visual enhancements, including colors, icons, and data bars, making it easier to identify trends, patterns, and outliers in their datasets.
Key Takeaways:
• Utilize basic conditional formatting for quick data insights
• Apply formatting rules to entire rows or columns based on single or multiple cell values
• Format data dynamically to reflect specific dates or date ranges
• Identify and highlight duplicate entries for cleaner data management
• Integrate the AND/OR functions to create more sophisticated formatting rules
• Use advanced formatting options, such as icon sets, three/four color scales, and data bars, to visually represent data variations
Neal Otto Bio:
“People work too hard to get simple things done!” quotes Neal Otto, Jumpstart Computer Training. Neal and Jumpstart believe that technology should reduce waste and help us all get more of the right things done, faster. Since 1996, Neal and Jumpstart have helped tens of thousands of individuals improve their use of Microsoft technologies.
Neal, a former high school teacher, is known for his broad knowledge of an extensive array of Microsoft software and his ability to connect with students of all abilities and styles. Given his background, he can keep audiences engaged and entertained.
Neal lives in Corvallis Oregon with his sweetheart Shannon. Linus THE Wonder Dog and Cali THE Wonder Dog 2 keep Neal company in his office during webinars. Neal is a long-distance bicyclist and loves to spend any spare time in his shop making sawdust or in the kitchen making bread. Son Nathan is the CFO of Fluke Healthcare; daughter Brynne is self-employed and resides in Bellingham Washington.
Subject |
Start |
End |
Excel Essentials |
Tue 1/27/2026 9 AM |
Tue 1/27/2026 1 PM |
Excel Calculations and Charts |
Tue 2/10/2026 9 AM |
Tue 2/10/2026 1 PM |
Outlook - Simplify, Organize, and Boost Productivity |
Tue 2/24/2026 9 AM |
Tue 2/24/2026 1 PM |
Excel Database/List Management |
Tue 3/10/2026 9 AM |
Tue 3/10/2026 1 PM |
Excel Get and Transform |
Tue 3/24/2026 9 AM |
Tue 3/24/2026 1 PM |
Word for Contracts, Manuals, and Other Large Documents |
Tue 4/7/2026 9 AM |
Tue 4/7/2026 1 PM |
Excel Conditional Formatting |
Tue 4/21/2026 9 AM |
Tue 4/21/2026 11 AM |