Excel Advanced: Useful Array Formulas and Functions

This course is designed for users of Excel who want to gain a thorough understanding of some more advanced formulas. These functions are extremely useful for manipulating text, arrays, and doing business analysis. Billy covers some of the most used functions such as SUMIFS, COUNTIFS, MAX, and FILTER. You will also learn some of the more recent array functions such as XLOOKUP, TEXTSPLIT, VSTACK, and others. Whether you’re a seasoned user or new to Excel, this course will help you become more proficient and efficient with a few advanced functions.