Good Book

[Guest]

Hi everyone,

Does anybody have any suggestions about a good Excel book to get to learn
how to use the functions and to learn how to write macros and pivot tables
and vba code?

Thanks

 

[JoeSpareBedroom]

Hi everyone,

Does anybody have any suggestions about a good Excel book to get to learn
how to use the functions and to learn how to write macros and pivot tables
and vba code?

Thanks

For functions, the built-in Excel help systems actually quite good. Have you
looked at it?

 

[Guest]

No I have not Thanks I will look into it.

For functions, the built-in Excel help systems actually quite good. Have you
looked at it?

 

[T. Valko]

Here's a pretty good list:

http://contextures.com/xlbooks.html

Biff

 

[JoeSpareBedroom]

No I have not Thanks I will look into it.

Tip:
Open a blank sheet. Click Insert, Function. Pick a function that interests
you. A dialog box will pop up to help you provide the parameters for the
function. The box contains brief hints. If I recall, there's either a Help
button or a question mark button. Clicking the button will open the actual
help system to a section specific to that function. The trickier functions
often contain some very complete examples for useage.

 

[Bob Phillips]

For VBA, start at http://www.mvps.org/dmcritchie/excel/getstarted.htm

--
HTH

Bob Phillips

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Dave Peterson]

Take a look at Peter Nonely's workbook that describes lots of functions:
http://homepage.ntlworld.com/noneley/

Norman Harker has his version at Debra Dalgleish's site:
http://www.contextures.com/functions.html

 

[Dave Peterson]

I just saw this post by Bob Phillips:

Peter Noneley's Excel Function Dictionary, http://www.xlfdic.com/