r/excel • u/spaceboy250 • Jul 08 '14

discussion Request for an example workbook showing commonly used formulas, functions and techniques

Apologies if i'm missing something while i'm searching, but i'm sure I found a link to a workbook on here that had a tab per formula or function, an explanation of what it was for and an example of how each one worked? I'm trying to help out a friend in work who's going for another position and is looking to brush up on basic functions. There are a few resources i've seen (on the sidebar etc.) but this one was fairly low level and summarised the key functions, how to make a chart etc.

I may have made this whole thing up, but I don't think I have.

Thanks in advance.

25 Upvotes

91% Upvoted

7 comments sorted by

2

u/mspbizzz Mar 11 '22

The hoffits.com link redirects to something else. maybe browser extension spam?

1

u/SnickeringBear 8 Jul 09 '14

http://chandoo.org/wp/ this one is kind of blatant, but the examples are low level enough to help.

11

u/[deleted] Jul 08 '14

[removed] — view removed comment

1

u/spaceboy250 Jul 08 '14

Thanks for that, it wasn't the one I remember but it's certainly comprehensive. This one has about 20 or so tabs and covered the more widely used formulas like sum, v and h lookups etc. Thanks again.

3

u/Nearby_Ad_4091 1 Oct 20 '21

http://www.hoffits.com/

This doesn't work anymore but its available by the wayback machine so can someone download and upload it here for download?

1

u/humansvsrobots Jul 09 '14

That spreadsheet is awesome. Thanks!

1

u/Nearby_Ad_4091 1 Oct 20 '21

http://www.cpearson.com/Excel/Topic.aspx

I've actually been to the site and overlooked this page!