HomeHome SearchSearch MenuMenu Our productsOur products

Make your business' accounting easier with Excel Pivot Tables

by , 23 July 2014
Doing your business' accounting can be tedious. It can take you hours to fill in all the right values and numbers. And even if your use a digital programme to do your accounting it can still take ages.

But there's a little Excel secret you can use to turn that tedious process into an accounting snap!

You can use Excel Pivot Tables to make your spreadsheet more dynamic and much easier to move the information in your books around.

Read on to discover exactly what Excel Pivot Tables are...

*********** Top rated product  ***************
Stop wasting hours trying to figure out a solution to your Excel problem 
If you turned to Google for help, you would have had to search through over 144 000 000 Excel related pages to find an answer to your specific Excel problem... That's hours wasted trying to find a solution to one Excel question!

Here's how you can benefit from using Excel Pivot Tables

A Microsoft Excel Pivot Table is a summary report you can create in Excel. You can use it to report on or analyse any kind of data you want.
With traditional Excel reports, once you've fixed the layout, it's really difficult to change anything. This can make doing your company's bookkeeping very time consuming.
For example, your sales report might have products listed across the page and the months down the side. With a traditional Excel report, changing this format will take you hours!
With a Pivot Table, it'll take you ten seconds.  Here's how...

Here's how to create a Pivot Table in less than ten seconds

1.       Choose the raw data;
2.       Click anywhere on the raw data;
3.       At the top of your screen, click on 'insert menu';
4.       Click 'Pivot Table';
5.       In the dialog box enter where you want the Pivot Table;
6.       Click 'OK'; and
7.       Add the fields you want to your report in the 'Pivot Table field list'.
That's how simple it is to create a Pivot Table. Now you can easily change your Excel reports and make doing your company's accounting much easier.
*********** Reader's choice  ***************
What do SARS and CIPC say about accounting reports?

Related articles

Related articles

Related Products


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 >>>