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

Can you AutoAverage in Excel?
There is a drop-down next to the AutoSum symbol. Open the drop-down to choose AVERAGE, COUNT, MAX, or MIN

Smitty

Legend
Joined
May 15, 2003
Messages
29,536
Check your e-mail, I just sent it to you.

FYI - It was written by Peter Noneley.

Smitty
 

bsnapool

Active Member
Joined
Jul 10, 2006
Messages
452

ADVERTISEMENT

That is quality > Thanks very much...

Andrew
 

bsnapool

Active Member
Joined
Jul 10, 2006
Messages
452
Does any one have another of these workbook on either VBA, access OR sql?
 

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
76,300
Office Version
  1. 365
Platform
  1. Windows
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.:)
 

Forum statistics

Threads
1,136,263
Messages
5,674,710
Members
419,521
Latest member
Jasonnie

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
Top