AWESOME Tip Sheet for EXCEL Functions 10

[ladyck3]

I found this awhile ago and it is just so handy, I thought I'd share it with the group.

http://homepage.ntlworld.com/noneley/

The file is xlfdic01.zip or xlfdic01.xls.

You can use the link above or add either one of the file names to the end of the URL and download the file directly.

Its pretty darn awesome, make sure to enable macros on it. I've used it often. Don't always understand all of it but it sure is full of INFO!!!

Enjoy....

 

[ladyck3]

I posted this later yesterday and have seen that no one has commented. I just want to make sure that folks are seeing this, as it is an extremely good source for help with Functions in Excel. Its rather extensive with great examples.

Take care...

 

[smiley0q0]

WOW!

This stuff is GREAT!!

someone had to have had way too much free time on their hands... but hey, i'm not complaining. I'm just glad there are people out there that do this sort of thing to help all of us out.

thanks for posting it for us

 

[Tonyjstone]

This one of the most helpful 'tip-sheets' I have ever seen for Excel. Well done and a big THANK YOU.

 

[jnix]

I downloaded it but it says the macros are disabled. How do I enable them?
Thanks,
jnix

 

[ChrisBurch]

Thank you, it all helps.

Chris

It worked yesterday.
It doesn't work today.
That's Windows!

 

[ladyck3]

jnix...

In Excel go to Tools > Macros > Security

If you did not get an option to enable the macros, your security is set to HIGH... change it to Medium, then FILE > EXIT to get the setting change to take effect.

Next time you open Excel and the file, you will be prompted with the option to Enable or Disable... choose Enable.

Laurie


LadyCK3

 

[cmpgeek]

i am just starting to teach myself visual basics, and the site you listed will definitely be benficial - thanks a lot!

... always in a state of ... inspiring to some day experience ...

 

[BlaineR]

Great! Thanks ladyck3!

 

[ladyck3]

I'm just happy that finding this link and sharing it has helped so many others!!!

Thanks for the stars ... its appreciated... I'm just happy that I'm able to assist.

I don't understand it all but this sure does help!!

cmpgeek... good luck on the VBA, I'm stumped!

Laurie

LadyCK3

 

[Poduska]

The link no longer works, does anyone know where to get the file as it sounds great?

Thanks

 

[Xaqte]

Try here:

http://www.rondebruin.nl/files/xlfdic01.zip

 

[ranebow]

I tried clicking on the link but it can't be found. Can anyone share with me what this was about?

 

[Poduska]

I just tried it and the file opens in WinZip. It is a worksheet with tabs for each function.

Very helpfull.

David

 

[KenWright]

Peter is working on his site and it is down for a while, but Ron is hosting the file for him at the moment. I just tried the link to the file on Ron's site and it works fine.

Regards
Ken.......

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission
----------------------------------------------------------------------------

 

[compactmad]

Thank you very much, this has been very helpful.
I love this site and use it all the time, but this function dictonary is by far a godsend.

Cheers
Tanya

 

[cspm2003]

wow, thats awsome! thx

 

[VBUser77]

It's no doubt the best source on excel functions. Thanks a lot ladyck3

 

[bez999]

This is excellent - thanks for the link

Regards
Chris Bezant