Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Formulas

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Formulas

Resolved · Low Priority · Version 2003

Reply Wed 28 May 2008, 16:42Delegate Donna said...

Donna has attended:
Excel Introduction course
Excel Intermediate course
Project Intro Intermediate course
Powerpoint Introduction course

Formulas

Is there a summary which shows all the relevant formula options

For upcoming training course dates see: Pricing & availability

Reply Fri 30 May 2008, 16:00Trainer Amanda said...

RE: Formulas

Hi Donna

Thank you for your question; and welcome to the forum.

If you go into Help in Excel and type in operators, then click on the link 'About calculation operators' that appears, you will then be able to get a complete list of operators that can be used as part of formulas in Excel.

There is also an explanation of the order in which Excel will perform calculations under this topic.

I hope this helps.
Amanda

Excel articles

· How To Add A Second Axis To An Excel Line Chart
· Excel 2010 Can Make Your Reports Better And More Detailed Than Ever
· Coping With Compatibility In Excel 2007
· Making The Most Of Filtering In Excel
· Do Bright Sparks Use Sparklines?

Please browse our web site to find out more about
excel course and other Microsoft training courses.

Excel tip:

Repeating headings on spreadsheets that print on more than one page

By default when you print a spreadsheet out and it prints on more than one page, the headings at the top and the side of the spreadsheet don't appear on all the pages following page 1.

To get Excel to repeat headings on all pages when printing, go to File - Page Setup - Sheet, then select the rows to repeat at the top of pages, and the columns to repeat at the side of pages by clicking on the red arrows at the right side of the two boxes under the 'Print titles' area. Then click OK.

If you view your spreadsheet in Print Preview, you should see the headings being repeated on each page.

View all Excel hints and tips