Solved

What is the quickest way to generate a report from excel?

Posted on 2013-06-28
4
234 Views
Last Modified: 2013-07-03
What is the quickest way to generate a report from excel?

I need to do this and fast!!


Your help would be appreciated.

Thanks
0
Comment
Question by:jazz__man
  • 2
4 Comments
 
LVL 13

Assisted Solution

by:Shanan212
Shanan212 earned 250 total points
ID: 39284737
PivotTables. What sort of report are you looking to generate?

Can you post a sample sheet along with it?
0
 
LVL 23

Accepted Solution

by:
NBVC earned 250 total points
ID: 39284739
That is quite vague request....

Look into Pivot Tables...

http://office.microsoft.com/en-us/excel-help/pivottable-reports-101-HA001034632.aspx
0
 
LVL 2

Author Comment

by:jazz__man
ID: 39284825
I need to query data on flat file excel spreadsheet and present it neatly in a word document all separated into tables.

Is this possible?
0
 
LVL 13

Expert Comment

by:Shanan212
ID: 39284841
You will have to create your tables on Excel then copy the tables in to word.

So yes.
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

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

Deploying a Microsoft Access application in a Citrix environment is not difficult but takes a few steps. However, Citrix system people are often of little help, as they typically know next to nothing about Access. The script provided here will take …
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
The viewer will learn how to  create a slide that will launch other presentations in Microsoft PowerPoint. In the finished slide, each item launches a new PowerPoint presentation and when each is finished it automatically comes back to this slide: …
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

911 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

21 Experts available now in Live!

Get 1:1 Help Now