How to find and use all the functions and formula within Excel using the Excel Function Wizard
You can avoid having to remember the complex syntax for each function, and to find out more about functions you come across in spreadsheets. This can be achieved with the Excel Function Wizard.
FUNCTION WIZARD is Excel’s ways of helping developers and users understand and use functions.
I highly recommend you have a look at these every now and again, or look at our website and get some training material on some of the more useful functions.
How this helps as well is, if you have a spreadsheet with a function in it that you don’t fully understand, you can actually backtrack into the FUNCTION WIZARD to find out what is actually happening. So for example
Now lets say you understand the If function, but you don’t know what this ABS does.
So there’s the cells being used, but it tells you that ABS returns the absolute value of a number – that is a number without its sign. So you can quickly understand what is happening and look into it.
Now different versions of Excel handle that slightly differently. What you might find is that on your version the way it’ll do it is
But this allows you understand any function that is used in a spreadsheet, and so you don’t have to worry about running back to the developer to learn what functions they have actually used
Advanced Excel Course – June 2013 in South Africa Our next advanced excel course is running during June 2013 in Johannesburg. During the week of the 10th June we offer the following options. You can either attend the full 5 … Continue reading
A very popular chart is the waterfall chart which shows the impact of various items on a total e.g. the various components that explain the move from budgeted profit to actual profit. A common way to build this is using … Continue reading
AuditExcel (aka Miricle Solutions) provided the Sasol Chlor Vinyls financial team with professional excel training whilst fully understanding the accounting landscape which is highly recommend.– Sasol Polymers