Dynamic Arrays in Excel
In this video you will learn about Dynamic Arrays in Excel, including:
Looking at 3 new functions: SORT, SORTBY and FILTER
How you can use this functions in a spreadsheet
In Excel, there are lots of functions that you can use for lots of different reasons but there are still more being added to the mix! Here we look at dynamic arrays specifically 3 functions and how they can be used in your spreadsheets.
Some related videos you might like:
VLOOKUP Function - • Using the VLOOKUP function
The IF Statement - • The IF Statement in Excel
We also have a number of playlists on our channel that you might like to look at. One of these being on Advanced Functions/Formulas in Excel - • Advanced Functions/Formulas in Excel
Our dynamic arrays in Excel video is also included in our hint and tip post that can be found on our website - https://www.jplcomputer.co.uk/2020/07...
If you would like more information about us, pop over to our website here - https://www.jplcomputer.co.uk/
#MsOffice #MsExcel