# Blogs on Excel functions

Feb 29, 2024 | Excel Hints and Tips

## Over the last few years I have written many blogs about the functions that there are available in Microsoft Excel.Here I consolidate these into one comprehensive list.These cover many of the old favourites but also some of the newer ones that regularly drop in Microsoft 365.Bear in mind that not all the functions will be available in all the versions especially the first ones mentioned in this table which are those that have been added more recently.

Function: TEXT JOIN

Application: Joins the information in multiple cells together

Function: VSTACK and HSTACK

Application: Stack data below or beside each other

Function: CHOOSEROWS and CHOOSECOLS

Application: Select specific rows or columns or change order

Function: TAKE and DROP

Application: Keep or remove rows or columns

Function: EXPAND

Application: Expands an array to a specific number of rows and columns

Link to blog: Using the EXPAND Function to expand an array

Function: WRAPROWS and WRAPCOLS

Application: Transforms a list to a block of data with a certain number of rows and columns

Link to blog: WRAPROWS and WRAPCOLS Functions in Microsoft Excel

Function: XLOOKUP

Application: Looks up data in a table

Link to blog: Using the XLOOKUP Function in Excel

Function: RANDARRAY, SEQUENCE, UNIQUE

Application: Create a random set of numbers, a sequence of numbers or finds unique values

Function: SORT, SORTBY, FILTER

Application: Sort and filter data

Function: DATE Functions

Application: A variety of date manipulations

Link to blog: Top 7 Excel Date functions

Function: TEXTSPLIT, TEXTBEFORE, TEXTAFTER

Application: Splits data into multiple columns

Function: IFS

Application: Perform multiple outcomes based on multiple conditions

Function: SWITCH

Application: An alternative to VLOOKUP or XLOOKUP

Link to blog: How do you SWITCH data in Excel?

Function: TEXT FUNCTIONS

Application: Extract data, combine data, change case and clean data

Link to blog: Top 4 Ways to Manipulate Text using Functions

Function: VLOOKUP

Application: Lookup data in a table

Link to blog: Lookup data from an Excel Table

Want to learn more about Microsoft Excel? Then email lara@laramellortraining.co.uk to discuss how I can help or have a look at the Microsoft Excel Courses I run.