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

formulas

ResolvedVersion 2003

Greggory has attended:
Excel Intermediate course

Formulas

Is there a specific section in the online manual that will help me to understand and use formulas and pivots?

RE: Formulas

Hello Greggory

Thank you for your question and welcome to the forum.

With regard to the topic of formulas, the online manual will contain information on creating 3D formulas and linking spreadsheets, as these are the areas relating to formulas covered on the intermediate level course.

See links in your delegate account for you to download reference material for the Introduction and Advanced level courses. We cover an introduction to the use of formulas in the Introduction level course; and pivot tables in the Advanced level.

Kind regards
Amanda

Wed 3 Jun 2009: Automatically marked as resolved.

Excel tip:

Status Bar Functions

When using the SUM, MIN, MAX, AVERAGE and COUNT functions, the result of such calculations are displayed in the worksheet.

However, if a range of cells, containing numbers, is highlighted, and then a right-mouse click is performed at the bottom right side of the status bar, then the result of those functions will be displayed.

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.1 secs.