Looking for Spreadsheet of Native Function Examples

PA HS Teacher

Well-known Member
Joined
Jul 17, 2004
Messages
2,838
A friend of mine is learning Excel, and I am looking for a file I have seen before where someone went through all of the native excel functions (or pretty close) and gave examples of their use. Each function was on a separate tab. It even included a hyperlinked table of contents. I can't recall who put this resource together.

Does anyone know where this file exists, or perhaps they have a copy of the file themselves.

Thus far my searches have not yielded much success. Words such as (example, spreadsheet, workbook, functions, excel) have not narrowed my search significantly.
 

Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.
Check your e-mail, I just sent it to you.

FYI - It was written by Peter Noneley.

Smitty
 
Upvote 0
shajueasow

That link does contain a link to the workbook.

Here's the actual link to download it.

bsnapool

I don't think such a thing exists.

I think it would be almost impossible to create something that covered everything in VBA/Access/SQL.

In fact I'm not sure Peter's workbook covers absolutely everything, but it does look like a great resource.:)
 
Upvote 0

Forum statistics

Threads
1,213,510
Messages
6,114,037
Members
448,543
Latest member
MartinLarkin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top