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

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