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 » advanced excel training - Formulas

advanced excel training - Formulas

ResolvedVersion Standard

Mon 21 May 2007, 09:51 Delegate Suzanne said...

Suzanne has attended:
Word Advanced course
PowerPoint Intermediate Advanced course
Excel Introduction course

Formulas

What is a formula and how do I calculate it?

Thu 24 May 2007, 14:25 Trainer Richard said...

RE: Formulas

Hi Suzanne

A formula is a specific set of characters that include mathematical expressions to calculate answers.

An example is:

=1+2

or

=A1+B2

Whenever you start a formula, you must use an "=" sign. This tells Excel that you are about to enter a mathematical formula.

Regards

Richard

Excel tip:

Pivot table grouping

If you want to group items in a pivot table together, simply highlight the labels for the fields either with the shift key (if adjacent)or with the contral key if they are not next to each other.
Right click and choose group. Give the cell a name.

When you double click on this cell it will either expamd or collapse your grouped area

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

advanced excel training - Formulas

Formulas

RE: Formulas

Excel articles

Excel tip:

Pivot table grouping