Hints and Tips

UNIQUE Function in Excel – another way of filtering out data in your spreadsheets

Excel Tips

UNIQUE Function in Excel – have you used this function before to filter out data […]

Read more

Automatically Updating Styles in Word – using this option to keep styles in your documents the same

Hints and Tips

Automatically Updating Styles in Word – have you used this option before to update Styles […]

Read more

Excel Currency Data Types – a way of adding extra information to your data

Excel Tips

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 Tips

Excel Table Based Formulas – have you ever created a formula through an Excel table […]

Read more

Outlook Searches – the different ways in which you can search for emails

Hints and Tips

Outlook Searches – have you used these two ways to search for emails in Outlook? […]

Read more

Creating a Word Style – how to create your own Style in Word

Hints and Tips

Creating a Word Style – how can I do this for in my Word documents? […]

Read more

Advanced Filtering Methods – how do you use it?

Excel Tips

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?

Excel Tips

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?

Excel Tips

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?

Excel Tips

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?

Excel Tips

FILTER vs VLOOKUP Function in Excel – have you used both? Which do you prefer? […]

Read more

Column and Section Breaks in Word – do you know how to use these?

Hints and Tips

Column and Section Breaks in Word – what are these and how can I use […]

Read more