Excel Formulas & Functions Part 8: Formula-Based Formatting | Chris Dutton | Skillshare

Playback Speed

• 0.5x
• 1x (Normal)
• 1.25x
• 1.5x
• 2x

# Excel Formulas & Functions Part 8: Formula-Based Formatting

## Watch this class and thousands more

Taught by industry leaders & working professionals
Topics include illustration, design, photography, and more

## Watch this class and thousands more

Taught by industry leaders & working professionals
Topics include illustration, design, photography, and more

### 0:34

• --
• Beginner level
• Intermediate level
• All levels

Community Generated

The level is determined by a majority opinion of students who have reviewed this class. The teacher's recommendation is shown until at least 5 student responses are collected.

481

Students

2

Projects

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:

• Build dynamic tools & dashboards to filter, display and analyze your data
• Join datasets from multiple sources in seconds with LOOKUP, INDEX & MATCH functions
• Pull real-time data from APIs directly into Excel using WEBSERVICE & FILTERXML
• Manipulate dates, times, text, and arrays with ease
• Automate tedious and time-consuming analytics tasks (no VBA required!)
• And much more

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!

## Meet Your Teacher

### Chris Dutton

Founder, Excel Maven

Teacher

Chris Dutton is a Certified Microsoft Expert and Founder of Excel Maven, with more than a decade of experience specializing in data science and business intelligence. His work has been featured by Microsoft, the Society of American Baseball Research (SABR) and the New York Times.

Excel Maven provides high-quality online analytics training, hands-on workshops, and project-based consulting services to more than 100,000 students across 180+ countries.

See full profile

Level: All Levels

## Class Ratings

Expectations Met?
Exceeded!
• 0%
• Yes
• 0%
• Somewhat
• 0%
• Not really
• 0%

## Why Join Skillshare?

Take award-winning Skillshare Original Classes

Each class has short lessons, hands-on projects

Your membership supports Skillshare teachers

## Learn From Anywhere

Take classes on the go with the Skillshare app. Stream or download to watch on the plane, the subway, or wherever you learn best.