HomeHome SearchSearch MenuMenu Our productsOur products

Accounting got you stumped? This simple trick will help make things clearer

by , 01 October 2014
Do you find your company's accounting overwhelming and complicated? Do you struggle to keep track of the endless columns of numbers?

You're not alone! And if you don't have an eye for numbers, it can be confusing.

There's an easy way to resolve this though.

All you have to do is use this simple Excel function and it'll make everything clearer...


Introducing the one Excel function you can use to make your accounting data clearer

The problem most people have with their accounting is they struggle to track all the different kinds of amounts in their books. 
You need a way to quickly identify the different amounts without squinting at the computer screen to see what the description is. 
The easiest way to do this is to use the Excel format cell function. This gives you the ability to change cells so each one looks different.
The best way to make cells look different is to colour code them. 
Here's an easy way to use this function correctly.
*********** Advertisement ************
Are you an accountant or bookkeeper? Don't let an Excel problem interrupt your workflow
Over 5 920 Excel questions are searched on Google in South Africa every month...
If you're adding to that statistic, you'll know how hard it is to find a solution that specifically relates to your Excel problem.
But not anymore!

Here's an easy way to colour code the amounts in your accounting spreadsheet

The first thing you must do is create a colour code key at the top of your accounting spreadsheet. Here you should take a column and make each cell a different colour that you want to use in your coding. 
Next to each colour, write what the colour means. For example, red means monthly fixed expenses, yellow means important once-off expenses and green means regular income. 
Then, as you enter amounts into your spreadsheet, colour them depending on what they are.
This way, when you need to check your accounting records and find a particular piece of information, you can spot it quickly. 
Check out the Practical Guide to Excel for more ways you can use Excel formatting to improve your accounting. 

Vote article

Accounting got you stumped? This simple trick will help make things clearer
Note: 5 of 1 vote

Related articles

Related articles

Related Products