Advanced Filtering Methods – how do you use it?
Advanced Filtering Methods – what are the ways in which you can use it? This […]
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
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
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
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
Word and PDF’s – a warning about protection settings in Word
Word and PDF – how does the new feature of PDF to Word cause issues […]
Read more
Time Calculations in Excel – using cell formatting to allow use of these in spreadsheets
Time Calculations in Excel – how can I use cell formatting to allow use of […]
Read more
Text Wrapping in Word – how to use it plus some extra features
Text wrapping in Word – how do I use this? Watch the video to learn […]
Read more
Changing Excel Chart Types – changing types, styles and location
Changing Excel chart types, styles and location – how do I do this? Watch the […]
Read more
Nested IF Statements – using them in your data with other functions
Nested IF statements – how do I create a nested IF statement? Watch the video […]
Read more
Replicating your spreadsheet layout…surely there must be a quick way?
Replicating your spreadsheet layout…surely there must be a quick way? This week’s hint and tip […]
Read more
Excel tips: Sparklines in Excel – what are they and how do you use them?
Excel tips: taking a look at Sparklines in Excel This week we are bringing you […]
Read more