Function Wizard V2

By: AuditExcel Advanced Excel and Financial Model Training and Consulting

In this section you’ll learn how to activate the FUNCTION WIZARD, use the FUNCTION WIZARD to find Excel’s inbuilt functions, and how they can help you. You can avoid having to remember the complex syntax for each function, and to find out more about functions you come across in spreadsheets. FUNCTION WIZARD is Excel’s ways of helping developers and users understand and use functions. To activate you can either click on this fx button or you can say Insert Function, when you click on that a menu similar to this will appear, depending on the version of Excel you have, now what you’ll have here is a couple of categories, and all the functions that sit in there. So for example if you click on Look up &Reference all the functions that exist in that section will pop up and you can look through this and actually by looking at the description see if it meets what you need, 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 if we click on this cell, we’ll see the function is a simple IF function, if you click on the FUNCTION WIZARD in there, up pops up the IF function arguments and it explains that that is the logical tests happening, if its true that’s what’s happening and if it false that’s what’s happens and it’ll explain what the If function does, Now lets say you understand the If function, but you don’t know what this ABS does. Click in the ABS itself click on the FUNCTION WIZARD and up will pop that function argument. 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 once you’ve clicked in it you’ll be able to click over there and there’ll be a little fx next door to it ,and you can click it again, all depends on the version 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.

Function Wizard V2

Views: 147 Likes: 1 Dislikes: 0
100% Likes
0% Dislikes
Getting Started with EndNote: Inserting Citations into MS Word

This tutorial can be used for EndNote x4, x5, and x6. This tutorial will demonstrate how easy it is to insert citations into your manuscript using the EndNote Cite While You Write feature.…

Views: 18 353 By: Duke University Medical Center Library & Archives
CppCon 2017: Steve Carroll & Daniel Moth “Latest & Greatest in Visual Studio…

- Hello everyone, and welcome to this Visual Studio for C Plus Plus; developers' session. Thank you for choosing to spend your time with us. My name is Daniel Moth, and Steve Carrol…

Views: 6 526 By: CppCon
Using track changes - Hindi

Hello Everybody. Welcome to the tutorial on LibreOffice Writer - 'Track changes while Editing a document'. In this tutorial I will explain how peer review of documents can be…

Views: 264 By: Spoken-Tutorial IIT Bombay
Word 2013 for Beginners Part 11: Entering and Editing Text in a Word 2013…

Welcome back to our course on Word 2013. We’re now going to spend some time looking at basic entry and editing of text in Word. So from now on we’re going to be making Word documents…

Views: 19 148 By: Simon Sez IT