Excel Function Wizard | Online Excel Help

MAIN PAGES

-Home Page
-Company Profile
-Free Tutorial Page
-Training Schedule
-Contact Us

BLOG

- Our BLOG

SOFTWARE

-Spreadsheet Auditing
-Spreadsheet Sensitivity
-Spreadsheet Security

NEW Videos

- IRR Calculator
- Count error checks
- Check import headers
- INDIRECT function
- IS number EVEN/ODD
- Is cell a number
- MATCH Function
- Identify missing categories
- Check that data within range
- TEXT Function
- Remove Spaces
- Use ADDRESS

Excel Basics

- Function Wizard
- Audit Toolbar
- Good Design
- Add In's

Tips and Tricks

- Identify missing categories
- Check that data within range
- Count error checks
- Check import headers
- CAGR
- Show all formula
- Fill in blanks
- Data Cleanup
- Multi sheet changes
- Automatic Sort

VLOOKUP tips

- VLOOKUP Use
- Large VLOOKUP's
- VLOOKUP Risk
- Automatic Sorting

Financial

- IRR Calculator
- Interest rate
- IRR
- NPV
- CAGR
- PMT
- Amortization table

Database

- Database

Lookups

- Use ADDRESS
- MATCH Function
- INDIRECT function
- VLOOKUP
- Transpose
- CHOOSE
- OFFSET
- SUMIF/ COUNTIF

Dates

- DATE
- EOMONTH
- EDATE

Statistics

- Rank
- MAX/ MIN

Logical

- IF
- AND/ OR

Text

- TEXT Function
- Remove Spaces
- FIND
- Length
- Join characters
- Change Case
- Extract Text

Information

- IS number EVEN/ODD
- Is cell a number
- ISERROR

Maths

- SUMIF/ COUNTIF

Other Tools

- Data Validation
- Group/Ungroup
- Autofilter
- Workbook protect
- External Links
- Goto Special
- Find/ Replace
- Conditional Format
- Pivot Tables
- Data Sort
- Data tables
- Multiple Windows
- Hyperlinks
- Protect cells
- Paste Special

How errors happen

- Copy/ Paste
- Delete Cells
- Insert rows
- Insert cells
- IF functions
- Linked Sheets
- Hidden Cells
- Lookup's
- MIN/MAX function
- Referencing

What If's

- Goalseek
- Data Tables
- Scenarios
- Watch Window

Download All Videos

- Download All

Excel Function Wizard

The Microsoft Excel Function Wizard is ideal for quickly generating valid functions. It is a menu-driven tool with which to access all Excel’s pre-defined data analysis functions.

The Function Wizard is accessed by clicking the Function Wizard button in the Formula Bar; it looks like an “fx” symbol. A description is provided for every selectable function and there is a space where you can enter the numbers or range so that you can preview the Formula Result.

If you click on the button with the red arrow on it next to the Value box, you can select a range from your worksheet, instead of having to type it in manually. The Function Wizard enables you to make custom functions according to your specific requirements and offers several built-in functions.

To use the Function Wizard, first highlight the cell where you want your formula to appear. Start the Function Wizard by pressing the aforementioned “fx” button, or by selecting Insert from the menu and selecting Function. The Function Wizard’s first dialog box appears, showing about a dozen main categories, like:

* AVEDEV (absolute deviation of a data set)
* AVERAGE (simple arithmetic mean for a data set)
* CORREL (correlation coefficient between two variables)
* COUNT (number of numeric values in a data set)
* RANK (sequence of a given value in a data set)

Select your function from the list and press Next.

The next dialog box will prompt you for the required parameters or data to enable you to complete the formula. You may click the Help button if you need assistance or instructions at this juncture. You may enter the values manually or you may point to the data locations with the mouse, selecting them from your worksheet. Pressing Finish will enable the Excel Function Wizard to complete the formula.