Advanced Excel functions BYROW, MAP, SCAN, ... For example, you can use REDUCE to build an array of results using the VSTACK function and then remove initial empty rows with the DROP function, ...

These Excel formulas and functions make me feel like a wizard. advertisement. ... For example, I used XLOOKUP with my dummy data that represents business sales of consumer tech products.

Excel has over 475 formulas in its Functions Library, but we've selected the most popular, from date and time functions to mathematics and simple data manipulation.