When you enroll through our links, we may earn a small commission—at no extra cost to you. This helps keep our platform free and inspires us to add more value.
Excel Formulas & Functions Part 8: Formula-Based Formatting
Unlock creativity with Skillshare! Learn acrylic painting, AI writing, graphic design, and photography.
Free
This Course Includes
skillshare
0 (0 reviews )
24 minutes 
english
Online - Self Paced
course
SkillShare
About Excel Formulas & Functions Part 8: Formula-Based Formatting
Introduction to Formula-Based Formatting
Creating, Editing & Managing Formula-Based Rules
Highlighting Every Other Row Using the MOD Function
Formatting Cells Based on the Value of Another Cell
Formatting Cells Using Statistical Functions
Formatting Cells Using Text Functions & Logical operators
HOMEWORK: Formula-Based Formatting
What You Will Learn?
- This course is part 8 of a 9-part series on Excel Formulas & Functions: from basic to advanced..
- Formula-based formatting is all about using formulas to create custom, dynamic formatting rules in Excel. This allows you to go beyond the standard, "out of the box" formatting tools and templates, and apply custom styles based on underlying functions. This section introduces several case studies, including highlighting rows using the MOD function, formatting based on the value of other cells, and using text functions and logical operators to trigger custom effects..
- About the Excel Formulas & Functions Series:.
- In this series, you will develop tools to transform Excel from a basic spreadsheet program into a dynamic and powerful analytics tool. Courses cover 75+ formulas, and feature hands-on, contextual demos and practice exercises designed to help you not only memorize formula syntax, but to think like Excel..
- You'll learn how to write complex, powerful functions from scratch, allowing you to:.
- If you're looking for the ONE series covering all of the advanced formulas and functions that you need to become an absolute Excel rock star, you've found it!.