Excel Tips

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

Nested XLOOKUP Function in Excel – taking the XLOOKUP function a step further!

Excel Tips

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

Excel Tips

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?

Excel Tips

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?

Excel Tips

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?

Excel Tips

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

Excel Tips

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 Tips

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

Excel Tips

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 Tips

Excel Shortcuts Part 2 – the F2 and F4 function keys and cut, copy and […]

Read more

Cookie Control

Cookie control

We have placed cookies on your device to help make this website better.

I'm fine with this

We use cookies to give you the best online experience.

Please let us know if you agree to all of these cookies.

Some of the cookies we use are essential for the site to work.

We also use some non-essential cookies to collect information for making reports and to help us improve the site. The cookies collect information in an anonymous form.

To control third party cookies, you can also adjust your browser settings.

I'm fine with this
(One cookie will be set to store your preference)
(Ticking this sets a cookie to hide this popup if you then hit close. This will not store any personal information)
Information and Settings Cookie policy