Excel 365 in 30 Minutes – Logical Functions & Auditing (Basics 6 of 10)

Topics covered include:

Using AND, OR functions to perform logical tests on a dataset
Using COUNTIF to determine which data to count
Using SUMIF to determine which data to sum
Using AVERAGEIF to determine which data to average
Using Show Formulas command to see all formulas in a worksheet.
Using Trace Precedents to view source data for a formula.
Using Trace Dependents to view formulas dependent on a value.
Using the Go To dialog box to trace precedents or dependents to another worksheet or workbook.
Identifying common types of formula errors
Using the Trace Errors command to find the source of formula errors
Finding and resolving circular references.
Using the Error Checking command to find formula errors
Changing Excel’s error checking rules