If you’ve ever felt like Excel is holding you back instead of helping you move forward, it’s time to change how you use it. The Bigger Brains course, Excel in 30 Minutes – Advanced Functions Part 2 (Advanced 3 of 11), is your fast track to turning spreadsheets into dynamic, intelligent systems. In this course, you’ll start by learning how to use the MATCH function to pinpoint the exact location of a value in a range, giving you the precision to find what you need without endless scrolling. Then, you’ll learn to pair it with the INDEX function in order to pull specific data from the intersection of rows and columns. These two advanced functions work like a dream, and by the end of this course, you’ll be using them together to solve problems in seconds.
If you’re looking to clean your data, you’ll discover how to split text into multiple cells using LEFT, MID, and RIGHT, so you can break down messy data into organized, usable chunks. Need to replace or modify text? The REPLACE function will become your new best friend, allowing you to edit strings with surgical precision.
Watch the course sample below!
When you need to check for exact matches, the EXACT function will ensure you never confuse similar-looking entries again. Through this course, you’ll learn to write formulas using the TODAY function and to use DAY, MONTH, YEAR, and WEEKDAY to extract specific date details or identify the day of the week at a glance. Calculating the days or years between two dates will be a breeze, as the TEXT function lets you convert dates into custom formats that fit your reporting needs.
For those who work with time-sensitive data, this 30-minute course covers how to subtract and analyze time like a pro, ensuring you never miscalculate deadlines or project timelines again. You’ll even learn to apply custom formats for cells with time values, making your spreadsheets clearer and more professional. These advanced functions are the secret sauce that separates good spreadsheets from great ones. Ready to stop wasting time on manual fixes and start automating your success?
