<div>
The pivot table is a good option. &nbsp;Is there a way to use Crystal reports with the excel spreadsheet being the database?
</div>


The pivot table is a good option.  Is there a way to use Crystal reports with the excel spreadsheet being the database?

<div>
<div class="content wysiwyg-content">
Hello Tech Team,<br />
<br />
I have exported sales info from our accounting software to an excel spreadsheet. &nbsp;I want to make sense of this raw information for our sales staff and management. &nbsp;Currently, the sales manager takes 2-3 days building a report that we want to generate with a click of a button. &nbsp;Is it possible to use Crystal Reports or is there an excel spreadsheet out there that is already setup? &nbsp;<br />
<br />
My aim is to be able to generate volume information by Month and within a given month by Customer ID, Customer Type, Product, Location. &nbsp;Also, to have comparisons of YTD etc<br />
<br />
<br />
Any suggestions would be grateful.
</div>
</div>


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.

Raw Accounting Data in Excel- Need to build Reports

Microsoft applications include a variety of software programs, including development and digital authoring programs (Expression and Media Center), educational programs, Internet software, including Essentials, Skype and the Live family, anti-virus, productivity applications and suites like Office, Excel, Word, Outlook, Access and PowerPoint, video games and server applications such as Exchange, SharePoint, IIS and Virtual Server.

Microsoft Applications

Office Productivity refers both to the act of being productive and efficient in an office or professional environment, as well as the software applications used to "produce" information. This includes the development of professional skills, creating work processes, and almost any program used to create or modify a document, image, audio or video clip. However, business application suites such as Microsoft Office, which include word processing, spreadsheet and presentation programs, are typically called productivity software, as contrasted with a "utility program," such as a file manager, which is used to organize files and folders on the computer. Many office- and business-oriented groups of programs are organized into suites.

Office Productivity

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.