excel function

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel Function

Excel Function

resolvedResolved · Low Priority · Version 2003

Alison has attended:
Excel Advanced course

Excel Function

How to create a user defined function

Edited on Thu 11 Sep 2008, 12:07

Create A Custom Excel Function

Hi Alison

To create a Custom function you need to first decide what calculation you require and what information you need the user to supply.

In my example, we are calculating the % increase in sales. In a table starting in row 2 we have the following headings; in Column B (


 

Excel tip:

Create your own custom list on Excel 2010!

If you know how to use the auto-fill option on Excel then why not create your own customs lists?

The auto fill feature saves you time by allowing you to enter one of the list entries into a cell and then use your mouse to automatically drag the rest of the list into the cells below, above or to either side of the initial cell. When using your mouse to perform this task you will see a thin black cross appear at the bottom right hand side of the cell. Click, hold and drag to make the list appear.

Default lists include weekdays and months. To create your own list in Excel 2010 do the following;

>File
>Options
>Advanced
>Scroll right to the bottom of the page and you will see a buttom "edit custom lists", click this button
>enter your list in the list entries
>click add

Now try it out. Good luck.
>

View all Excel hints and tips


Server loaded in 0.08 secs.