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
SUMIF and COUNTIF Functions in Excel – what do they do?
SUMIF and COUNTIF Functions in Excel – using these functions in your spreadsheet, have you […]
Read more
Formula Conditional Formatting in Excel – using formulas to apply it
Formula Conditional Formatting in Excel – how can I use formulas to apply conditional formatting […]
Read more
Excel Green Triangle Errors – what do these mean?
Excel green triangle errors – have you ever come across these errors/notifications before? Watch the […]
Read more
RANK and XLOOKUP in Excel: using these in spreadsheets
RANK and XLOOKUP – how can I use both of these my worksheets? This week’s […]
Read more
Excel Shortcuts Part 2 – F2, F4 and cut, copy and paste shortcut keys
Excel Shortcuts Part 2 – the F2 and F4 function keys and cut, copy and […]
Read more