Solved

Raw Accounting Data in Excel- Need to build Reports

Posted on 2013-06-23
2
320 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

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

Using Word 2013, I was experiencing some incredible lag when typing.  Here's what worked for me....
In this article we discuss how to recover the missing Outlook 2011 for Mac data like Emails and Contacts manually.
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

747 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now