Very Impressive. Thanks for uploading this video. I have been working on excel and gathering all the valuable information possible. This one is great. By the way if you are having trouble in converting PDF files into excel and word files, then I would suggest the use of 'The Cogniview PDF2XL Converter.' It's effective and i have been using it for quite sometime now. It really works.
Let's say I have a list of 'ages' in my table. I add the 'ages' to my report filter but the report filter only shows the ages individually as they appear in the table. I want the report filter to show the ages in ranges instead, for example: 20-29, 30-39,....etc instead of individual values. How do I do this? Please help!
how can i separate the data in one column? for example ANNUAL ENROLMENT FOR THE MONTH OF JULY 2010..thats the title in the column A. Then below in it are male , female and total? How can i put a line to separate each data? I hope for an answer soon
thanks!
Lumme2008 2 weeks ago
Very Impressive. Thanks for uploading this video. I have been working on excel and gathering all the valuable information possible. This one is great. By the way if you are having trouble in converting PDF files into excel and word files, then I would suggest the use of 'The Cogniview PDF2XL Converter.' It's effective and i have been using it for quite sometime now. It really works.
David52192 1 month ago
This has been flagged as spam show
Great video. I also found this tutorial and article on Vlookup and pivot table very helpful
tutoraccounts.blogspot.com/2011/10/microsoft-excel-2007-tips-and-tricks.html
iibi1367 3 months ago
Good stuff!
rrw1250 7 months ago
Let's say I have a list of 'ages' in my table. I add the 'ages' to my report filter but the report filter only shows the ages individually as they appear in the table. I want the report filter to show the ages in ranges instead, for example: 20-29, 30-39,....etc instead of individual values. How do I do this? Please help!
PlayMoreLoud 10 months ago
thanks soooo much!
tisyababy 11 months ago
how can i separate the data in one column? for example ANNUAL ENROLMENT FOR THE MONTH OF JULY 2010..thats the title in the column A. Then below in it are male , female and total? How can i put a line to separate each data? I hope for an answer soon
jowilouise 1 year ago
thanx ...
it sooo useful
shahinQ8 1 year ago
do you know where can I download .xls files so I can practice with pivot tables?
anitaord 2 years ago
Interesting, thanks! I get a bit confused at first on how to use Pivot tables, but with this explanation now I understand a lot better.
manixxxo 3 years ago
That takes care of one of the requirements for my job
dwaynewadesucks 3 years ago