?
Solved

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

Posted on 2013-06-28
4
Medium Priority
?
272 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 1000 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 1000 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

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

Question has a verified solution.

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

This is an article on how to answer questions, earn points and become an expert.
If Skype for Business came with your office 2016 or office 365 installation, you may find that it's almost impossible to either disable or remove it. The application will often launch with each start of Windows, even when explicitly configured not t…
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

601 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