HomeHome SearchSearch MenuMenu Our productsOur products

Here's how to turn your monthly sales data into an annual trend analysis tool

by , 24 July 2014
Your company's bookkeeping doesn't just keep track of your expenses and profit from month to month.

It helps you track the growth or decline of your company each year. Now if you were to try do your company's accounting the old fashioned way with pen and paper, creating a way of tracking this growth is difficult.

But with Excel, you can turn your monthly sales data into an annual trend analysis chart in just a few clicks...

*********** Product endorsement  ************
Stop wasting time on Excel problems
You'll no longer be wasting time on Excel problems like:
PDF creation in Excel...
Trying to work on spreadsheets received via email...
Anchoring formulas to look at the correct cells...
Extracting information out of lists of data in Excel...
Creating pivot tables...
 
Get a quick solution to your biggest Excel problem today from Excel guru, Adrian Miric. Discover how here...
*****************************************
 

Excel makes it easy to turn your sales data into a trend analysis chart

 
When you use Excel to create your accounting records, it's easy to manipulate the data to create analysis charts. This is useful as it gives you a way to compare your company's profit or loss for different years.
 
This gives you an idea of where you need to make changes to the way you run your business or if you simply need to keep doing what you're doing.
 
And it only takes three steps to turn your raw accounting data into an annual trend analysis chart...
 

Turn your accounting data into an annual trend analysis chart in just four steps

 
Step #1: Right click on any of the data and select 'Group' from the list.
 
Step #2: Excel will have already selected 'Months'. You must left click on 'Years' to select it as well.
 
Step #3: Click 'OK'. You have now grouped your data by month and year. 
 
Step #4: Click on 'Pivot Chart' to display the 'Pivot Table Field List'.
 
From there it's a simple matter of arranging the data you want to appear in your chart and then clicking 'Update'.
 
This will now create a line graph that shows you how your sales data has changed according to each month and each year.
 
Use this tool to quickly and easily examine and analyse your company's financial situation. 
 
*********** Hot off the press  ************
Discover how to analyse financial statements, identify errors with checklists, step-by-step instructions & examples
 
*************************************


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