News & Helpful Hints

Come back regularly for updated hints and tips

Quality Customer Management

Quality Customer Management

A big part of running a business is being able to manage your customers and provide a them with a quality service experience. A client management system that handles new clients, contracts, invoicing and questionnaires can make this process much simpler and give your...

read more
Excel Basics – Lookup Formulas

Excel Basics – Lookup Formulas

In this post we examine the VLOOKUP formula and show how to add one to your spreadsheet. We demonstrate how they can be used to draw information from one master source so that any future changes can be made in one location that will reflect across an entire spreadsheet.

read more
Excel Basics – Conditional Formatting

Excel Basics – Conditional Formatting

We are looking conditional formatting and it’s uses. Conditional formatting can be applied to any cell/s and it will automatically change the format of the cell based on it’s data. In our example we use it to highlight any cells that have a negative value red so it easily highlights poorly performing items.

read more
Auto Correct Options in Word

Auto Correct Options in Word

Have you ever noticed that with some words, if you happen to type them incorrectly, they will automatically correct themselves? Is there a word that, no matter how many times you type it, it is always incorrect? Or what about words that you type all the time like your...

read more
Excel Basics – Using Filters

Excel Basics – Using Filters

We look at how to turn on filters in a spreadsheet and how they are can be used to filter information in multiple criteria as well as being able to sort data alphabetically. We also look at Find and Replace tool.

read more
Excel Basics – Formatting & Formulas

Excel Basics – Formatting & Formulas

We are looking at formatting that can be applied to raw data in an Excel spreadsheet to help make it look better and be more readable. We will also cover adding some simple formulas to give you a total figure.

read more
Time Saving Shortcuts

Time Saving Shortcuts

Constantly having to switch back to your mouse to perform simple tasks can eventually add up to a lot of extra time.

Learning keyboard shortcuts can help you get some of this time back.

read more