Best Book for Excel Finance

Water Cooler
#1

Wondering what the best book to buy is for learning excel related to finance (complex functions and VBA).

#2

What do you know already?

#3

Basic functions like vlookup, pivot tables (basic), ordering functions, creating complex IF functions with other basic functions.

I can do the intuitive stuff but have no experience with macros

#4

Yo kiddo. You can learn this stuff over a lunch break. Look online for examples, even hitting F1 on Excel is good these days. You don’t need a book. Here are a few examples that are straight ottta my open workbook.

  1. =VLOOKUP(B200,‘M&A Buysidel’!$B$11:$E$313,3,FALSE)

  2. Pivot Tables are pretty trial and error. You’ll learn by doing. Just highlight a sheet of data and click Insert - Pivot Table.

  3. =IF(G16<>"",G16,IF(H16<>"",H16,IF(I16<>"",I16,IF(J16<>"",J16,""))))

Despite what HR wants you to believe during the initial phone interview, this stuff is NOT hard. Parctice with a few examples (F1 on Excel) and you’ll be golden in no time.

#5

These are the things I already know how to do.

I am curious to learn of the more complex functions and macros in specific.

#6

Making your own functions in VBA is fairly easy. If you want some examples, later versions of the Benninga book have some short and simply code to get you started.

#7

This book: http://ixz.es/Dummies-Ebooks-collection-2008/E/VBA%20For%20Dummies%205th%20Ed%20Jan%202007.pdf

and this more advanced one: http://www.amazon.com/Excel-2010-Power-Programming-VBA/dp/0470475358/ref=sr_1_3?s=books&ie=UTF8&qid=1409945045&sr=1-3&keywords=Excel+VBA

#8

Thank you stratman and rawraw

#9

I’ve got a few on my desk that I grabbed from the Goodwill’s book sale. The “For Dummies” books for Excel 2003 and 2010, as well as one titled “Excel Formulas and Functions For Dummies.” I also have one the is Excel VBA 24 hour trainer. It’s OK for learning VBA, but it’s very wordy and the included DVD was not too helpful. I’m still in the infancy stages with teaching myself VBA. I use a lot of Macro’s built to interact with our accounting system and excel, so I’m able to make small adjustments to existing code, but would never figure any of it out on my own.