Solved

Raw Accounting Data in Excel- Need to build Reports

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

Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

Question has a verified solution.

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

Suggested Solutions

Recently Microsoft released a brand new function called CONCAT. It's supposed to replace its predecessor CONCATENATE. But how does it work? And what's new? In this article, we take a closer look at all of this - we even included an exercise file for…
My experience with Windows 10 over a one year period and suggestions for smooth operation
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…
An overview on how to enroll an hourly employee into the employee database and how to give them access into the clock in terminal.

912 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

24 Experts available now in Live!

Get 1:1 Help Now