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

In this Bigger Brains course, you’ll learn how to use powerful lookup and reference functions to work with data more precisely and efficiently. You’ll explore how MATCH identifies the position of values within a range and how INDEX retrieves data from the intersection of rows and columns—giving you greater control and flexibility than basic lookup tools. You’ll see how these functions work together to solve real-world data analysis challenges. 

You’ll also learn advanced text, date, and time techniques that help compare and format information. You’ll see how to split text into multiple cells using LEFT, MID, and RIGHT, update text with REPLACE, and compare values using EXACT. You’ll explore date and time calculations with TODAY, DAY, MONTH, YEAR, and WEEKDAY, along with formulas to measure elapsed days, years, and time. You’ll also learn how to convert dates to text and apply custom time formats—making this course ideal for advanced Excel 365 users who want to sharpen their skills quickly and effectively. 

Topics covered include: 

• Using the MATCH function to determine the location of a value within a range 

• Using the INDEX function to find the value at the intersection of a row and column 

• Splitting text into multiple cells using the LEFT, MID, and RIGHT functions 

• Using the REPLACE function to change text in a character string 

• Using the EXACT function to determine if two cells have the same text 

• Writing a formula using the TODAY function 

• Using the DAY, MONTH, YEAR functions to get information about a date 

• Using the WEEKDAY function to identify the day of the week of a date 

• Using formulas to determine the number of days and years between 2 dates 

• Using the TEXT function to convert a date to text 

• Using formulas to subtract and analyze time 

• Using custom formats for cells with time values 

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.