- What percentage of Excel functions are commonly used?
Office discussion about functionally overloaded applications and Excel came up as as an example.
Someone reckons that 95% of the people only use about 5% of the functions.
Someone else reckons it is 80:20 but that is what most people say (about 80%)
Any guesses or perhaps even facts from STW?Posted 8 years ago
Depends on your field as to which classes of functions you use most (even as a superuser).
Some wil use more statistical tools, others logical and again others will use text manipulators etc.
Even as a very heavy Excel user, I probably only use 30-40% of the functions available but that may represent upto 100% of the functions in one or two classes.
However, secretaries should be forbidden from using Excel and taught to use tables in Word instead for doing their pretty pictures and telephone lists in 😉Posted 8 years agostevomcdSubscriber
Not really a case of a “functionally-overloaded application”, more about users picking an inappropriate application for their needs. That large proportion of users who only use Excel for basic “adding-up” type tasks could easily switch to much simpler (and much cheaper!) software such as Microsoft Works.Posted 8 years ago
my favourite functions are the ones that dont exist:Posted 8 years ago
The DATEDIF function computes the difference between two dates in a variety of different intervals, such as the number of years, months, or days between the dates. This function is available in all versions of Excel since at least version 5/95, but is documented in the help file only for Excel 2000. For some reason, Microsoft has decided not to document this function in any other versions. DATEDIF is treated as the drunk cousin of the Formula family. Excel knows it lives a happy and useful life, but will not speak of it in polite conversationthisisnotaspoonSubscriber
We use a lot of software written in VBA/excel, still amazes me whenever I go into edit the software how many different way people have found to do very similar tasks. Others I just give up, accept it works, and copy and paste the whole lot into a new window and put my own little contribution infront/behind it.Posted 8 years agofootflapsMember
On a related note, if you think you know Excel, buy a copy of ‘Professional Excel Development’ – realised I knew very little after reading that!Posted 8 years agoThe Flying OxMember
What percentage of Excel functions are commonly used?
If only there were some way to record data and then perform statistical analysis of that data. Ideally on a personal computer. The data could then all be “spread” out over one computerised “sheet” of paper for ease of viewing. A “spreadsheet”, if you will…Posted 8 years agonjee20Subscriber
My girlfriend did an ‘Advanced Excel’ course through work – which she found extremely beneficial.
They didn’t get to pivot tables or conditional formatting, which IMO are 2 of the most straightforward ways to impress people who don’t know how to use Excel!
I reckon 99% of people use 1% of the functions frankly! I’ll wager a lot that the vast majority of people never go beyond SUM, or at a push AVERAGE, certainly not beyond basic arithmetic functions!Posted 8 years agobrakesMember
functions I use the most:Posted 8 years ago
and any combination of the above.
I particularly like long and overly complex logical formulas containing IF and VLOOKUP.matthewjbSubscriber
I’m betting quite a few people use 0% of the functions.
When we first got Excel it wasn’t unusual to see spreadsheets with a column of numbers and a manually calculated total at the bottom! It always caused some confusion when you’d change a number in the list and the total just wouldn’t change!Posted 8 years agotitusriderSubscriber
Im a BI developer and we come in and sort out peoples mini empire excel database’s / reporting and turn them into something robust.
This things people do with Excel and the complexity can blow your mind.
From my experiance its a great way of getting yourself a steady job building the comanies reporting suite that only you understand !Posted 8 years agostuartie_cMember
Excellent – I can use the expertise in here…
I want to make a line chart to show a distribution of a range of values. Say I have 100 (or 1000) values in a column, all in the range 1 to 7 (ideally I’d like it to deal with continuous values but I’ll settle for discrete for now). I want a chart showing the distribution from 7 to 1 (ie lowest to highest – 7 is the “lowest” value in the range because they represent grades (discrete) or predictors (continuous, with 2 d.p.)).
I suspect this is tricky but I’d love to discover a simple method. If I can do it in Excel, I can try and tackle it in Filemaker Pro 11 Advanced.Posted 8 years ago
The topic ‘What percentage of Excel functions are commonly used?’ is closed to new replies.