Function Wizard- why you should use it

Please purchase the course before starting the lesson.

The Function Wizard can be considered Excel’s cheat tool. It lists every function that can be used in Excel  and guides the user on how the function works.

We use it to:

  • Find the correct function to use to solve a particular problem
  • Understand what a function in a spreadsheet does if we are not familiar with it
  • Understand what Excel requires in each part of the formula
  • Test the results of the function before clicking enter.

Watch the video clip and/or read the text to understand how to use the Function Wizard

 

where-the-function-wizard-isfunction-wizard-category-selection

function-wizard-date-function

 

function-wizard-test-result

To see the full course contents click here.

Back to: Advanced Excel Course > Function and Formula Basics