Excel Tips

Creating a Chart From Hidden Rows in Excel – how to easily remove unwanted rows with empty cells

Excel Tips

Creating a Chart From Hidden Rows in Excel – have you used this option before […]

Read more

New Excel Status Bar Feature Coming Soon! Copying from the status bar in to Excel

Excel Tips

New Excel Status Bar Feature Coming Soon – did you know you will be able […]

Read more

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

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

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

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

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