Advice on what to buy?

[ramsayaj]

Folks, I would like to purchase one or more of the Excel books listed in the online store. Can anyone recommend a particular title(s) for me?

My primary concern is pivot tables, I work with about 19,000 records or rows of data, every day. I am constantly trying to find quicker ways to manipulate the data set, present the data in different ways. I still feel I am missing out on better ways to do my job.

Any thoughts welcome.

Thanks,
Alan

 

[tomrock]

I'd suggest you take a look at this one

http://www.mrexcel.com/pivottablebook.shtml

I don't have it yet but it's on my list to buy. I've heard good things about it.

 

[starl]

I will second the vote of Pivot Table Data Crunching. At first I was surprised that a book could be written on a single function in Excel - but WOW! what function. This book will teach you so many tricks. And it is easy to read. Plus with the downloadable files to help you along, you'll learn quickly.

And the biggest lesson - Data Layout, Data Layout, Data Layout! (yes, I said it 3 times). Pay particular attention to that section. People can create pivot tables with almost any layout, but if you want to really get the most out of your data - Data layout!

ok, I said my piece!

 

[Guest]

Many thanks guys - sold!

I'll let you know how I get on.