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 » Templates

	98.1 % recommend us
	More live stats...

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

Training information:

Templates

Resolved · Low Priority · Version 2007

Reply Thu 5 Mar 2009, 13:12Delegate Hayley said...

Hayley has attended:
Excel Intermediate course

Templates

How to create a template in excel?

For upcoming training course dates see: Pricing & availability

Reply Thu 5 Mar 2009, 15:53Trainer Cress said...

RE: Templates

Hello Hayley
Thank you for your question

To create a worksheet template:

Create a new Excel workbook containing one worksheet
One the worksheet specify all required settings
Go to File>Save As
In the Save as type box, select Template
In the Save in box, select the folder you wish to store your template in.

This link provides details on what the template is with a sample template containing details on how it was created:

http://office.microsoft.com/en-us/excel/HA010548141033.aspx

If this resolves your question, please mark it as resolved. If not, please reply with more information.

Kind regards
Cress

Thu 12 Mar 2009: Automatically marked as resolved.

Excel articles

· Improve Performance Of Your Excel Macros
· A Blinking Good Excel Tip
· Should I Use Data Bars, Colour Scales Or Icon Sets In Excel?
· What's In A Number? Make Figures Mean More Via Excel
· MS Excel: Excel At Making The Most Of Your Christmas

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

Excel tip:

Checking formulas with multiple operators

When dealing with formulas containing more than one operator (+, -, /, *), Excel follow standard BEDMAS order of operation rules. These rules specify the order that calculations will be performed in, regardless of how the formula reads left to right:

B = brackets
E = exponents
D = division
M = multiplication
A = addition
S = subtraction

It should be noted that multiplication and division are considered equal; as are addition and subtraction.

If you would like to check the order in which Excel is performing calculations in a formula, simply click on the cell containing the formula. Then go to Tools - Formula Auditing and select Evaluate Formula.

In the Evaluate Formula dialogue box that appears on your screen, click the Evaluate button to see how Excel calculates the formula result.

View all Excel hints and tips