HomeHome SearchSearch MenuMenu Our productsOur products

Create an Excel Pivot Table in less than five minutes to speed up your accounting process

by , 23 July 2014
It's incredibly time consuming to change your Excel accounting records once you've fixed them. This is why Microsoft Excel Pivot Tables are such a great tool. They enable you to move information from one accounting spreadsheet to another in a matter of seconds. These books are also very easy to change.

But you might think this is just another complicated Excel formula you need to learn and struggle to understand, like me and Excel's 'IF' function.

But it's not complicated at all! In fact, you can create an Excel Pivot Table in less than five minutes with these six steps...

*********** Advertisement ************
Attention accountants and bookkeepers! 
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!

Use these six steps to create an Excel Pivot Table

You can quickly and easily create an Excel Pivot Table for your company's accounting, all you have to do is:
Step #1: Choose the raw data you want in your Pivot Table. This comes from the original Excel spreadsheet. For example, you may want to move your profit figures from your sales records.
Step #2: Click anywhere on the raw data;
Step #3: Click on 'insert menu' which is at the top of your screen;
Step #4: Click on Pivot Table;
Step #5: A 'create Pivot Table' dialog box will pop up. It's shows that Excel has automatically selected the entire data source. It'll also ask you where you want to create the Pivot Table.
If you want to summarise the data, you must choose the 'new worksheet' option on the dialog box.
Step #6: Click 'OK' and Excel will:
- Insert a new spreadsheet into your workbook;
- Put a placeholder for the Pivot Table on it; and
- Open the 'Pivot Table Field List' on the right-hand side of your screen.
Step #7: In the 'Pivot Table Field List', choose the fields you want to add to the report in the top box and drag them into the areas below where you want them displayed. 
And with that, you've created a new Pivot Table with the information from your sales records. This handy trick can cut the time you spend managing your company's bookkeeping in half!
*********** Hot off the press  ************
Here's how to improve cash flow, analyse your financial statements and eliminate fraud in your company…

Vote article

Create an Excel Pivot Table in less than five minutes to speed up your accounting process
Note: 5 of 1 vote

Related articles

Related articles

Related Products