HomeHome SearchSearch MenuMenu Our productsOur products

Three ways you can use an Excel Pivot Table in your company's accounting

by , 23 July 2014
Excel is a great tool when it comes to your company's accounting. It's something all computers have and we all know how to use. But there are some tips and tricks you can use to turn your Excel into an accounting power house.

One such trick is to use Excel Pivot Tables to change and transfer data quickly and efficiently.

They're incredibly helpful, especially when you use then in one of these three ways...

*********** Recommended Product  ************
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!
 
******************************************
 

Use Excel Pivot Tables to speed up your accounting process

 
A Microsoft Excel Pivot Table can help you summarise a lot of data very quickly. It can condense it into just a few lines. With Pivot Tables you can get the information you need quickly and accurately. This turns a five hour job into a five minute one!
 
The reason is, when you create a Pivot Table, you can import the fields you want into a new Excel spreadsheet and into a completely changeable format.
 
This is a huge advantage in your efforts to manage your company's bookkeeping. 
 
Pivot Tables are especially useful when you use them in these three ways...
 

Use Pivot Tables in these three ways to make the most use of them

 
To speed up your accounting process, use Excel Pivot Tables to:
 
1. Draft your management accountings; 
2. Itemise your inventory; and
3. Draft your fixed asset register.
 
These are accounting records that need to be flexible and changeable. By using Pivot Tables to create them, that's exactly what they'll be. Otherwise, if you use traditional Excel reports, you'll have to spend hours changing the formatting and entries.
 
So if you want to create your Excel accounting records quickly and effectively and have the option to change them later, you must use Excel Pivot Tables.
 
*********** Advertisement ************
Does your CC follow the CC Act or the Companies Act?
 
Do it right or face penalties
 
***********************************


Related articles




Related articles



Related Products



Comments
0 comments


Recommended for You 

  Quick Tax Solutions for Busy Taxpayers – 35 tax answers at a glance



Here are all the most interesting, thought-provoking and common tax questions
asked by our subscribers over the last tax year – everything from A to Z!

To download Quick Tax Solutions for Busy Taxpayers – 35 tax answers at a glance click here now >>>
  Employees always sick? How to stop it today



Make sure you develop a leave policy to regulate sick leave in your company.

BONUS! You'll find an example of the leave policy and procedure in this report.

To download Employees always sick? How to stop it today click here now >>>
  Absenteeism: Little known ways to reduce absenteeism



This FREE e-report will tell you how you can reduce absenteeism in your workplace while avoiding the CCMA and without infringing your employees' labour rights.

To download Absenteeism: Little known ways to reduce absenteeism click here now >>>
  7 Health & safety strategies to save you thousands



Don't let a health and safety incident cost you one more cent. Implement these seven
strategies in your company today.

To download 7 Health & safety strategies to save you thousands click here now >>>