# Excel Tips

## SUMIF and COUNTIF Functions in Excel – what do they do?

SUMIF and COUNTIF Functions in Excel – how can I use these functions in my worksheets? ​This week’s hint and tip is about the SUMIF and COUNTIF functions in Excel and how you can use them in your worksheets. These are covered on our intermediate Excel...

## NETWORKDAYS.Intl Function in Excel – what is it and how do I use it?

NETWORKDAYS.Intl Function in Excel – how can I use this function in my worksheets? ​This week’s hint and tip is about the NETWORKDAYS.Intl function in Excel and how you can use it in your worksheets. This isn’t covered on any of our courses so we...

## Formula Conditional Formatting in Excel – using formulas to apply it

Formula Conditional Formatting in Excel – how can I use formulas to apply conditional formatting in my worksheets? ​This week’s hint and tip is about formula conditional formatting in Excel and how you can use it in your worksheets. This is covered in our...

## Excel Green Triangle Errors – what do these mean?

Excel green triangle errors – have you ever come across these errors/notifications before? Watch the video to learn more This week’s hint and tip is on Excel green triangle errors. This blog is to help you understand a little more about the little green...

## RANK and XLOOKUP in Excel: using these in spreadsheets

RANK and XLOOKUP – how can I use both of these my worksheets? ​This week’s hint and tip is about the functions RANK and XLOOKUP in Excel and how you can use them in your worksheets. In this hint and tip we are showing you how you can use Excel for sporting...

## 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 paste shortcut keys, have you used them? Watch the video to learn more This week’s hint and tip is on Excel shortcuts part 2. Part 2 of these shortcuts covers the function buttons F2...

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.