Formulas

The UK's most regular instructor-led training courses.
Training information: excel computer course london · Excel course · Microsoft Excel Training
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version Standard

Formulas

Sue has attended:
Excel Introduction course

by - delegate Sue [4 posts] (2008 Feb 13 Wed, 16:29) Reply

Where can I get more information on formulas?

Version	Date	Location	Places available	Book	Next place rate:
Excel Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Jul 9 Wed	Bloomsbury	0	FULL
2003/XP	2008 Jul 9 Wed	Bayswater	2	book now	£195	£205
2003/XP	2008 Jul 16 Wed	Tooting	0	FULL
2003/XP	2008 Jul 16 Wed	Bloomsbury	1	book now	£235	£240
2003/XP	2008 Jul 18 Fri	Southwark	4	book now	£224	£235
2003/XP	2008 Jul 23 Wed	Southwark	0	FULL
Full Schedule: See all 143 Excel Advanced course dates. Bookings currently available until 24th November 2009.

RE: Formulas

by - trainer Mark gold contributer [151 posts] (2008 Feb 18 Mon, 15:57) Reply

Hi Sue

Hope you are OK

there are couple of ways to get more info on formulas the first way is to go to the function wizard and that can be found in the Insert menu and you could go through the different type in there and read the discribtions

The other way is to search the file files by going to the help menu and choosing Excel help then searching for formulas

Hope this helps

Mark East

· Features of Microsoft Excel that assist in Analysis of Financial Data
· Do You Really Need Excel VBA Training?
· An Introduction to Microsoft Excel: Top Features for the Excel Novice
· Excel Advanced Courses Ease the Frustration of Learning Complex Tasks
· Advanced level training: Microsoft Excel and the Web

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

Excel tip:

Changing Excel file and worksheet defaults

The appearance of any new Excel files or any new worksheets that are inserted into a file are controlled by two template files, Book.xlt and Sheet.xlt.

By opening, modifying and saving these templates you can change the default settings for all new files and/or all newly inserted sheets.

Use Book.xlt to make change to defaults for new workbooks; and Sheet.xlt to change defaults for sheets.

If you can't find either of these files on your computer, you can create and save them yourself.

You can do this simply by creating a new workbook with the setting you want to use as your defaults; then saving them with the appropriate name in the XLStart folder. If you are using Office 2003, this is usually found in C:\Program Files\Microsoft Office\Office11\XLStart.

View all Excel hints and tips