Creating a Chart From Hidden Rows in Excel – how to easily remove unwanted rows with empty cells
Creating a Chart From Hidden Rows in Excel – have you used this option before […]
Read more
New Excel Status Bar Feature Coming Soon! Copying from the status bar in to Excel
New Excel Status Bar Feature Coming Soon – did you know you will be able […]
Read more
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