Excel Shortcuts Part 4 – F7, F8 and some other useful shortcuts
Excel Shortcuts Part 4 – the F7 and F8 function keys and some other useful […]
Read more
Excel Shortcuts Part 3 – F3, F5 and some other useful but lesser known shortcut keys
Excel Shortcuts Part 3 – the F3 and F5 function keys and some other useful […]
Read more
Charts from Data with Error Messages – how to to create a chart from data that has error messages in it
Charts from Data with Error Messages – do you know how to create a chart […]
Read more
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