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

In this Bigger Brains course, you’ll learn how to build condition based formulas using functions like AND, OR, COUNTIF, SUMIF, and AVERAGEIF to analyze your data more effectively. You’ll see how to reveal all formulas in a worksheet, explore where your data is coming from with Trace Precedents, and also see which formulas rely on specific values using Trace Dependents. You’ll explore how to jump across worksheets and workbooks with the Go To dialog box, giving you deeper insight into complex spreadsheets. 

You’ll also learn to identify common formula errors, use Excel’s auditing tools to trace and fix them, and resolve issues like circular references. You’ll see how Error Checking works, explore Excel’s error checking rules, and learn how to customize them for your needs. By the end, you’ll be equipped to troubleshoot formulas with confidence and apply logical functions to make your spreadsheets smarter and more reliable. 

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 

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 in 30 languages, downloadable handouts, and optional LinkedIn digital badges on course completion.