If you’ve ever stared at an Excel spreadsheet wondering how to make it do more without making your job harder, the Bigger Brains course, Excel 365 in 30 Minutes – Advanced Functions Part 3 (Advanced 4 of 11), is your answer. In this course, you’ll start by mastering essential mathematical functions like ROUND and INT, which help you clean up messy numbers and keep your calculations precise. Then, you’ll learn to generate random numbers with RAND, RANDBETWEEN, and RANDARRAY, giving you the power to simulate data, test scenarios, or just add a little unpredictability to your models. The RANK.EQ function will sort your data in ascending or descending order, so you can identify top performers or outliers in seconds.
In this course, you’ll learn how to write formulas using DSUM, DAVERAGE, and DCOUNT to pull specific insights from large datasets without the hassle of filters or pivot tables. You’ll also discover how to modify criteria to zero in on exactly what you need, making your analysis more targeted and efficient. The course covers Calculation options, so you can control when and how Excel recalculates your data, saving you from frustrating errors and outdated results. You’ll learn how to handle errors gracefully with IFNA and IFERROR, ensuring your spreadsheets stay clean and professional even when things go wrong.
Watch the course sample below!
The ISNUMBER and ISBLANK functions will become your early warning system, helping you spot missing or incorrect data before it causes problems. And for those who work with financial data, the course unlocks the power of PMT and RATE functions, letting you calculate loan payments or interest rates with confidence. You’ll even get a behind-the-scenes look at how Excel crunches your numbers with Evaluate Formula, and you’ll learn to use the Watch Window to track critical formulas in real time as your data changes.
