Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 4
Default How many functions in Excel 2003

Sorry, the question should be
"Is THERE any statistics of the average excel user % knowledge and
usage of these funtionalities?

  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3,365
Default How many functions in Excel 2003

I believe you'll find 333 functions available in Excel 2003. That can be
obtained or verified through Excel 2003's Help feature.

As to how many of those an individual 'average' Excel user has knowledge of
or makes regular use of, well I don't have any stats on that at all.

But the question is 'what is an average user'? The functions are divided
into 11 major groups, and I can envision particular niche users being
familiar with perhaps a basic core group or two (math and text) with a
smattering from other areas, and yet no knowledge of anything in other areas
at all. For example: if someone asked me about the proper use of the BESSELI
or BESSELY functions, I'd be totally clueless. Those are in the Engineering
group. But then so are Bin2Hex and Bin2Dec which I am familiar with.

A rough guess, based on nothing other than gut feeling, is that any given
'average' Excel user who actually has figured out there are functions that
can be used is somewhere in the neighborhood of 5 to 10%, or roughly 15 to 35
functions that they use. I may be overly generous in my estimation.

"Prov31" wrote:

Sorry, the question should be
"Is THERE any statistics of the average excel user % knowledge and
usage of these funtionalities?


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How many functions in Excel 2003 Prov31 Excel Worksheet Functions 3 February 26th 07 12:42 AM
Functions in Excel 2003 Mike Excel Worksheet Functions 2 January 8th 07 10:07 PM
Excel 2003 Functions Carl Fenty Excel Worksheet Functions 3 November 2nd 06 05:43 PM
Not all Functions Available in Excel 2003 Brent - Tokyo Setting up and Configuration of Excel 1 September 14th 05 02:43 PM
Excel 2003 functions dacm19 Excel Discussion (Misc queries) 5 April 30th 05 05:38 PM


All times are GMT +1. The time now is 02:05 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"