Next Live Training Date:

13- 17 May, 2013

Excel Function Wizard

Excel Function Wizard
Watch this video

How to find and use all the functions and formula within Excel using the Excel Function Wizard

  • 2:36
  • Skill Level:
  • What's my skill level
    Flying screens

    All of our videos are listed by user Excel Skill Level.

    To find out your personal skill level, download our quick assessment.

    Once you've completed the test, send it to us and we'll evaluate for you.

    Download Test

  • Watch this Video

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.

To activate

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

Handy Tips & Tricks

Advanced Excel Course

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

Creating a Waterfall Chart in Excel the easy way

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

We have used Audit Excel/Miracle Solutions for all our Excel training requirements for the past 18 months, the assessment is a good tool to determine that the trainee is allocated to the correct training.

– KRONES Lifecycle Service Center Africa

Video Library & Tutorials //

View Entire Video Gallery ››

Spreadsheet tests

Spreadsheet tests

Spreadsheet Change Control

Spreadsheet Change Control

Waterfall chart using stock charts

Waterfall chart using stock charts

Absolute and Relative cell references

Absolute and Relative cell references

Some of our Featured Clients