Excel 365 in 30 Minutes – Functions (Intermediate 4 of 8)

In this Bigger Brains course, you’ll learn how formulas power Conditional Formatting and how to create rules that highlight the right cells at the right time. You’ll explore how to use mixed references, copy formatting efficiently across columns, and follow best practice guidelines for nesting functions.

You’ll learn how to write formulas that nest one function inside another, giving you more control and precision in your data analysis. You’ll also learn to use logical and statistical functions that help you interpret information quickly, including using the IFS function to evaluate multiple conditions and the SWITCH function to return responses based on specific values. You’ll see how statistical functions can strengthen your analysis and help you make better decisions. This course is ideal for Excel users who are comfortable with basic tasks and want to expand their skills with functions that make data clearer, smarter, and easier to work with. 

Topics covered include: 

• Describing the purpose of formulas in conditional formatting 

• Creating a formula that applies Conditional Formatting to specific cells 

• Using mixed references in a Conditional Formatting rule 

• Copying conditional formatting to another column 

• Listing guidelines for nesting functions 

• Writing a formula that nests one function within another function 

• Analyzing data and selecting from multiple options using the IFS function 

• Evaluating data against specific values and returning a corresponding response using the SWITCH function 

• Using statistical functions to provide an analysis of data 

Enjoy award-winning HD content in the “Uniquely Engaging”™ Bigger Brains Teacher-Learner style! Taught by top subject matter experts, Bigger Brains courses are professionally designed around key learning objectives and include captions and transcripts, downloadable handouts, and optional LinkedIn digital badges on course completion.