Excel Tips

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

Excel Shortcuts Part 1 – F1, F11 and undo/redo shortcut keys

Excel Tips

Excel Shortcuts Part 1 – the F1 and F11 function keys and undo/redo shortcut keys, […]

Read more

Creating a beep sound in Excel – how to make a beep appear on command!

Excel Tips

Creating a beep sound in Excel – did you know you could make the sound […]

Read more

SORT Function in Excel – using this newer function in your spreadsheets

Excel Tips

SORT Function in Excel – how can I use this function in my spreadsheets? Watch […]

Read more

Excel Useful Features – using flash fill and text to columns in spreadsheets

Excel Tips

Useful Excel Features – how can I use the flash fill and text to columns […]

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