# Hints and 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...

## Word Document Protection – how to prevent editing in part of a document

Word Document Protection – using features to protect part of your documents from being edited, have you done this before? Watch the video to learn more This week’s hint and tip is on Word documents protection. In this hint and tip we are looking at a way...

## Word Shortcuts Part 1 – F9, F7 and Shortcuts for Open and Search/Find

Word Shortcuts Part 1 – the F9 and F7 function keys and the open and find shortcut keys, have you used them? Watch the video to learn more This week’s hint and tip is on Word shortcuts part 1. Part 1 of these shortcuts covers the function buttons F9 and F7...

## PowerPoint Useful Features Part 1: Text to SmartArt and Morphing Transition

PowerPoint useful features part 1 – do you know any of them? Watch the video to learn more This week’s hint and tip is on PowerPoint useful features part 1. PowerPoint allows for some really smart features but they can be quite hidden away. In part 1 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...

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.