Mathwejb +1 - I still catch people using a calculator to add things in Excel?!
Pivot tables are cool - and lets hope no one else in my company figures out how I do what I do!
Chat Forum
What percentage of Excel functions are commonly used?
-
Posted 7 months ago #
-
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 7 months ago # -
Surely that's just a basic Scatter chart? If you right click the axis you can manually set the limits, such that it's 7-1 rather than 0-7.
Unless I'm over simplifying...
Posted 7 months ago # -
Use sum, choose, if, count and a few (copy and pasted) macros here.
One function I don't use is the one that auto inserts a footer with page totals. Not because it wouldn't be useful, but because the stupid programme doesn't seem to have one...
Posted 7 months ago # -
I use DATEDIF Stoner!
Posted 7 months ago # -
No-one's mentioned the flight simulator yet?
Posted 7 months ago # -
Posted 7 months ago # -
Double post.
Posted 7 months ago # -
I love nested array formulas.
I had to learn to do these to solve a problem for my bosses wife accountancy firm, man was I a hero.
Working in an environment with limited bandwidth and IT competency I'm often appalled at the size and unnecessary complexity of some of the spreadsheets I have to fix. I'm glad you average user can only use a limited amount of functions, some of the power users in the office should have the number of functions they use limited too.
I like excel. Never used it as much as I did on my A level geography course though.
Posted 7 months ago # -
Welcome to the inaugural meeting of the Datedif Is Common Knowledge Society. Hereafter to be referred to as D.I.C.K.S
Posted 7 months ago # -
You should download asap utilities, all the functions excel should do but doesn't! I think we use office 2000 at work though, more recent versions may have some of the more useful features
Posted 7 months ago #
Reply
You must log in to post.
