News & Helpful Hints
Come back regularly for updated hints and tips
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...
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.
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.
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...
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.
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.
This post will look at how to use the styles options in Microsoft Word and show how they will allow you to update formatting across an entire document from one location.
Virtual Assistants can help you run your business for efficiently and free up time for more important tasks.
Here are our top 5 reasons for why you should hire a VA today.
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.