Excel 365 in 30 Minutes – Functions Part 3 (Advanced 4 of 11) 

In this Bigger Brains course, you’ll learn how advanced mathematical, analytical, and database functions support accurate and efficient data analysis. You’ll explore functions like ROUND, INT, and RANK.EQ, along with random number tools such as RAND, RANDBETWEEN, and RANDARRAY. You’ll see how Excel’s database functions work, including DSUM, DAVERAGE, and DCOUNT, and how modifying criteria can limit and refine calculation results for more meaningful analysis. 

You’ll learn how to evaluate and manage your formulas using Excel’s calculation and auditing tools and explore calculation options and iterative calculations. You’ll see how to handle errors and validate data using IFNA, IFERROR, ISNUMBER, and ISBLANK and learn how to solve common financial scenarios using PMT, NPER, and RATE. Finally, you’ll explore how Excel calculates results using Evaluate Formula and how to monitor changing values with the Watch Window—giving advanced Excel 365 users the tools they need to build reliable, expert-level models. 

Topics covered include: 

• Using mathematical functions ROUND and INT 

• Generating a random number using RAND, RANDBETWEEN, and RANDARRAY functions 

• Ranking numbers using the RANK.EQ function 

• Writing formulas using the DSUM, DAVERAGE and DCOUNT functions 

• Modifying criteria to limit results 

• Discussing Calculation options 

• Using IFNA to handle errors in a VLOOKUP 

• Using IFERROR to handle formula errors in functions 

• Using ISNUMBER and ISBLANK to identify data in cells 

• Using the PMT function to calculate the payment for a loan 

• Using the RATE function to find the interest rate for an annuity 

• Using Evaluate formula to see how Excel calculates the result of a formula 

• Using the Watch window to monitor formula results as data changes 

Enjoy award winning HD content in the “Uniquely Engaging”TM 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.