Formulas

Resolved · Low Priority · Version Standard

Formulas

Rachel has attended:
Excel Introduction course
Excel Intermediate course

by - delegate Rachel [2 posts] (2008 Feb 27 Wed, 15:12) Reply

How do your create formulas?

Version	Date	Location	Places available	Book	Next place rate:
Excel VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Dec 11 Thu + 12 Fri	Bayswater	3	book now	£525	£545
2007	2009 Jan 8 Thu + 9 Fri	Bloomsbury	7	book now	£450	£475
2003	2009 Jan 22 Thu + 23 Fri	Southwark	4	book now	£475	£485
2003	2009 Jan 29 Thu + 30 Fri	Bayswater	5	book now	£450	£485
2007	2009 Feb 5 Thu + 6 Fri	Bloomsbury	7	book now	£450	£475
2003	2009 Feb 19 Thu + 20 Fri	Southwark	8	book now	£275	£399
Full Schedule: See all 33 Excel VBA course dates. Bookings currently available until 26th November 2009.

RE: Formulas

by - trainer Rich platinum contributer [744 posts] (2008 Mar 1 Sat, 10:23) Reply

You can either type it directly in a cell and you can click on particular cells you want to include in the formula and they will automatically be added. For example, type =SUM( into a cell and then click on a number field. You will end up with something as follows:
=SUM(F17,E20)

You can also go to View and select formula bar to show the formula bar. Click on the little = sign next to the white box and you can get help with formulas. There are lots of different kinds of formulas so best to decide what you want to do and ask us.

· What's Better Than the Help Function in Excel? Microsoft Training
· MS Excel: Excel At Making The Most Of Your Christmas
· Microsoft Excel Training - Discover A Hidden Power At Your Fingertips
· Microsoft Excel Features and Functions for Accountants
· Microsoft Excel Training - Numerical excellence for all

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

Excel tip:

Freeze Rows and Columns to keep lables displayed

You can freeze rows and columns in your worksheet so they don't move.

This allows you to keep row and column labels displayed on your screen as you move through a large worksheet.

Click below and/or to the right of the cell(s) you want to freeze. (NB. Excel freezes ALL the rows above and ALL the columns to left of the selected cell)

Click on the 'Windows' menu and selct 'Freeze Panes'.

Lines appear in your worksheet. The required rows and columns are frozen and remain on your screen as you move through your worksheet.

To unfreeze rows and columns, click on 'Window' menu and select 'Unfreeze Panes'.

View all Excel hints and tips

Rate this page: