Solved

Raw Accounting Data in Excel- Need to build Reports

Posted on 2013-06-23
2
338 Views
Last Modified: 2013-06-27
Hello Tech Team,

I have exported sales info from our accounting software to an excel spreadsheet.  I want to make sense of this raw information for our sales staff and management.  Currently, the sales manager takes 2-3 days building a report that we want to generate with a click of a button.  Is it possible to use Crystal Reports or is there an excel spreadsheet out there that is already setup?  

My aim is to be able to generate volume information by Month and within a given month by Customer ID, Customer Type, Product, Location.  Also, to have comparisons of YTD etc


Any suggestions would be grateful.
0
Comment
Question by:cddl
2 Comments
 
LVL 70

Accepted Solution

by:
KCTS earned 500 total points
ID: 39270047
A pivot table will do most, if not all of what you want - see http://spreadsheets.about.com/b/2012/06/01/excel-2007-pivot-table-tutorial-2.htm
0
 

Author Closing Comment

by:cddl
ID: 39282563
The pivot table is a good option.  Is there a way to use Crystal reports with the excel spreadsheet being the database?
0

Featured Post

Create the perfect environment for any meeting

You might have a modern environment with all sorts of high-tech equipment, but what makes it worthwhile is how you seamlessly bring together the presentation with audio, video and lighting. The ATEN Control System provides integrated control and system automation.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article will show you how to use shortcut menus in the Access run-time environment.
This article will shed light on the latest trends when it comes to your resume building needs. For far too long, the traditional CV format has monopolized the recruitment market.
XMind Plus helps organize all details/aspects of any project from large to small in an orderly and concise manner. If you are working on a complex project, use this micro tutorial to show you how to make a basic flow chart. The software is free when…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

821 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question