Can anyone recommend a good excel reference guide? I am fairly
proficient when it comes to using excel. I am primarily looking for a
book that covers complicated formulas as well as the creation of pivot
tables.

I am primarily looking for a book that
covers complicated formulas

I hope to be writing that book some day!

In the meantime, here's a good list of books:

http://contextures.com/xlbooks.html

Biff

"japc90" wrote in message
ps.com...
Can anyone recommend a good excel reference guide? I am fairly
proficient when it comes to using excel. I am primarily looking for a
book that covers complicated formulas as well as the creation of pivot
tables.

Actually for Pivot Tables you might take a look at
http://www.contextures.com/tiptech.html
and videos at (the first half of the Pivot Table videos are free)
http://www.datapigtechnologies.com/ExcelMain.htm

--
HTH,
David McRitchie, Microsoft MVP - Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"T. Valko" wrote in message ...
I am primarily looking for a book that
covers complicated formulas

I hope to be writing that book some day!

In the meantime, here's a good list of books:

http://contextures.com/xlbooks.html

Biff

"japc90" wrote in message
ps.com...
Can anyone recommend a good excel reference guide? I am fairly
proficient when it comes to using excel. I am primarily looking for a
book that covers complicated formulas as well as the creation of pivot
tables.