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

formula

ResolvedVersion 2007

sara has attended:
Excel Intermediate course

Formula

What is a good course/resource for using formuala

RE: Formula

Hello Sara

Thank you for your question and welcome to the forum.

It depends what specifically you are interested in learning with regard to formulas.

On Excel Introduction, we look at being able to create formulas to add, subtract, multiply, divide, and some functions (AVERAGE, MIN, MAX, COUNT, SUM).

On Advanced level, we look at logical functions (nested IF, OR, AND), some lookup functions (VLOOKUP, HLOOKUP), and database functions.

Otherwise looking up a particular function in Excel Help can be of assistance; you can ask us questions here through the forum; or the Microsoft web site has tutorials on various aspects of Excel.

I hope this helps.

Kind regards
Amanda

Excel tip:

Copying Formulae Quickly

There is a quicker way of copying a formula down a column.

Just point and double click on the black autofill handle in the right hand corner of a cell.

This will work providing you have some data in the column to the left of the column.

Sandy

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.43 secs.