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

excel-training-advanced courses - invoiving

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel-training-advanced courses - Invoiving

excel-training-advanced courses - Invoiving

ResolvedVersion Standard

Celina has attended:
Excel Intermediate course

Invoiving

how to set up a template

RE: invoiving

Hi Celina, thank you for the post, I hope you enjoyed your Excel course, in answer to your question, the easiest way to set up a template is to prepare your worksheet in the normal way with all formulas and functions in place, ensure that any cells that you wish to enter data into are left blank and then save your worksheet as a template, choose the template option from the type of file in the Save dialog box, if you now save your template it will be available from the File New, Templates on my computer command, however you can in the Save As dialog box indicate a different place to save your template, ie on a server so that others can access it. If you wish to stop changes to your basic format you should lock the cells that you do not wish to have changed before saving as a template. Dont forget to open a template you can Right click on its icon and choose Open from the shortcut menu. I hope that helps, regards Pete.

Excel tip:

Bracketed negative numbers

Often Excel users wish to display negative numbers in colour red and bracketed

Intstructions
Step1. Select Format > Cells menu options. Within Numbers tabsheet, select Category = Custom.
Step 2. Select a type such as #,##0;[Red]-#,##0;; that specifies a colour in square brackets.
Step 3. Amend as follows; #,##0;[Red](#,##0;;

Notes: Excel formatting featues are of the form
"Positive; Negative;Zero;Text" separated by semicolon.

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.