UNIQUE Function in Excel – another way of filtering out data in your spreadsheets
UNIQUE Function in Excel – have you used this function before to filter out data […]
Read more
Excel Currency Data Types – a way of adding extra information to your data
Excel Currency Data Types – have you used this feature on the Data Tab to […]
Read more
Excel Table Based Formulas – another way of creating a formula in Excel
Excel Table Based Formulas – have you ever created a formula through an Excel table […]
Read more
Advanced Filtering Methods – how do you use it?
Advanced Filtering Methods – what are the ways in which you can use it? This […]
Read more
Nested XLOOKUP with MIN Function – have you used these functions nested together before?
Nested XLOOKUP with MIN Function – nesting together the XLOOKUP and MIN functions to further […]
Read more
Data Subtotals with Visible Cells – have you used the visible cells only option before?
Data Subtotals with visible cells – using the visible cells only option with the Data […]
Read more
Array Spill in Excel – have you tried using this before?
Array Spill in Excel – another way to do formulas and calculations in Excel that […]
Read more
FILTER vs VLOOKUP Function in Excel – which one should I use?
FILTER vs VLOOKUP Function in Excel – have you used both? Which do you prefer? […]
Read more
Nested XLOOKUP Function in Excel – taking the XLOOKUP function a step further!
Nested XLOOKUP Function in Excel – an example of a nested XLOOKUP, can you follow […]
Read more
Common Office 365 Features: looking at Excel, Word and PowerPoint
Common Office 365 Features – how can I use these features in Excel, Word and […]
Read more
Duplicate Values in Excel – how can I show them?
Duplicate Values in Excel – how can I shows these highlighted in my spreadsheets? This […]
Read more
NETWORKDAYS.Intl Function in Excel – what is it and how do I use it?
NETWORKDAYS.Intl Function in Excel – using this function in your spreadsheets. Have you used it […]
Read more