excel word powerpoint courses london - formula

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

TrustPilot

starstarstarstarstar Excellent

  • Home
  • Courses
  • Promotions
  • Schedule
  • Formats
  • Our Clients

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

excel word powerpoint courses london - Formula

resolvedResolved · Low Priority · Version Standard

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?

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:

Quickly insert a function

In Excel 97 and 2000 it was known as the Paste Function dialog box, these days it's known as the Insert Function dialog box. Regardless, one has to choose Insert|Function. or the fx button to open it up. There is, however, a non-mousey way to get hold of the Insert Function dialog box: press Shift+F3 in a blank cell to open the Insert Function dialog.

Press Shift+F3 after a function name and open bracket to open the Function Arguments dialog. For example, type =VLOOKUP( into a cell and press Shift+F3 to obtain a detailed description of VLOOKUP's arguments.

View all Excel hints and tips


Server loaded in 0.1 secs.