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

Solutions Through Learning

Excellent

Request Callback We will call you back

0207 987 3777 Call for assistance

Your Basket Basket is empty

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel word powerpoint courses london - Formula

excel word powerpoint courses london - Formula

ResolvedVersion Standard

Tue 27 Nov 2007, 17:07 Delegate Katherine said...

Katherine has attended:
Excel Intermediate course

Formula

how do I know what function does what - ie 'sum; is obvious but if I wanted to divide I would not know what to type or how to find out this?

Wed 28 Nov 2007, 09:07 Delegate Paul said...

RE: formula

Hi Katherine.

The best way to find out what a function does and, indeed, what functions there are, click the little 'Fx' button to the left of the formula bar. This will give a list of all the different formulas and they are sorted into different categories

the divide formula is like this: =A2/A3

Good Luck

Paul

Excel tip:

Using Alt in Save Dialog Box

When you are saving (or opening) a file, try these;
(Note the numbers are on the keyboard not the numeric keypad)
1. Go to previous folder Alt+1
2. Go up one folder level Alt+2
3. Search the Web Alt+3
4. Delete selected file Alt+4 or Delete
5. Create a new folder Alt+5
6. Cycle through all views Alt+6 repeatedly
7. Display the Tools menu Alt+7

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

excel word powerpoint courses london - Formula

Formula

RE: formula

Excel articles

Excel tip:

Using Alt in Save Dialog Box