Any thoughts on what I should read for advanced pivot tables for Excel 2007? I see "Mr Excel" has "Pivot Table Data Crunching" and Deb Dalgleish (contextures) has "Excel Pivot Table Recipes." Anyone read both? Can be an e-book/C D or print.
[edit -- replaced the ** with C D -- teylyn]
Last edited by teylyn; 02-20-2011 at 04:45 AM.
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
I read PT Data Crunching and learned lots. There is lots to learn.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
I've got Bill Jelen's, aka Mr Excel, Pivot Table Data Crunching book and it's pretty good.
Dom
"May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."
Use code tags when posting your VBA code: [code] Your code here [/code]
Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.
No one has read Deb's book? or has a favorite other than "PT Data Crunching?"
Sorry no, got mine as a freebie from Bill and not felt the need to buy anything else.
Dom
Hi,
You can look inside it at http://www.amazon.com/Beginning-Pivo...der_1590598903
Was this the one you were considering?
It's possible but I think I know most of the basic stuff. I'm looking for the more advanced tricks which would probably be the data crunching book or her recipe book. Thanks though. I'll read through what's there.
I decided to buy both (and charged it to work)They arrived today. I'll let you know what I think after I review them.
Hey Chem - can you feedback how you get on with them as it's time i invested in a PT book.
Cheers
Blake 7
If your question has been answered, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.
If any member's response has helped to solve your problem, please consider using the scales icon on the top right of their post to show your appreciation.
http://failblog.org/
I'm not very fond of the D.Dalgiesh book mentioned above. It's fine as a reference, if you already know how pivot tables work in general, and need to look up a certain aspect of a PT. But it's not a step-by-step guide on how to get started with PTs.
To be fair, that is how it's marketed:
"Excel Pivot Tables Recipe Book: A Problem-Solution Approach assumes that you know the basics of Excel and pivot tables, and provides troubleshooting tips and techniques, and programming examples.
This book is for anyone who uses Excel pivot tables, and who only reads the manual when all else fails."
Remember what the dormouse said
Feed your head
romperstomper is right (no surprise there). I just wanted to point out that this book is not about learning how to use Pivot Tables with Excel 2007. "Pivot Table Data Crunching" covers a lot more of the basics and how-to basic knowledge arount PTs. If you already know how to use them, then the "Recipes" book is an excellent reference for specific issues.
cheers,
Just bought this one "Excel Pivot Tables Recipe Book: A Problem-Solution Approach". As I use PT's on a daily basis but would like to use them more efficiently.
I'll ask Deb for a refund if it doesn't cut the mustard!
delete delete delete - oh dear! note to self. DO NOT start/reply to ANY threads after taking 7.5mg's of Zopiclone!!
Last edited by Blake 7; 03-22-2011 at 09:08 AM.
Wow, Blake, did a pivot table crash into your spell-check button?
I type like that during my lunch break, with a dripping, crumbling steak and cheese pie in one hand, the back of my other hand greasy from wiping my chin and only the pinkie and ring finger available for typing ....
Or after one or two beers maybe
Dom
Looooooooool paul. I see what you mean. Just deleted. I often sit on the PC in the evening before going to bed and I sometimes take a sleeping tablet or two! Guess they kicked in as I was typing... how embarrasing!Originally Posted by Paul
Wow, Blake, did a pivot table crash into your spell-check button?
I am now fully alert and able to comment on DD's book. I found it and am finding it a great read!
Cheers guys!
Last edited by Blake 7; 03-22-2011 at 09:06 AM.
"evening"? Your location says London. That would have been about mid-day to early arvo, if I have my time zones lined up correctly. Wish I could take a pill and space out after lunch ....
It was 10.42PM from what I can see. Quite a good lunch, even for me.
Ah, yeees, right. The post shows up as 11:42 AM NZ time and I read it wrong. After all these years, I still don't cope with the AM and PM concept (I vividly remember that I got out of bed at an un-godly early hour to make it to a 6:30 meeting. Only to find out that it was actually happening at 18:30. Arrghh). If people would just use the 24 hr system world wide AND use A4 instead of Letter paper, AND put the month in the proper place in a date (i.e. MY preferred place), my life would be so much easier ...
(but then I wouldn't have anything to moan about, would I?)
A4 paper? Why would anyone want to use A4 paper???
It's more absorbent than A5.
But you can only fold it the same number of times.
Dom
We have our own EF real life Victor Meldrew!(but then I wouldn't have anything to moan about, would I?)
Margaret Meldrew: Want a sucky sweet?
Victor Meldrew: Sucky sweet! I'll be sucking on that exhaust pipe in a minute, much more of this.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks