excel-training-advanced courses - invoiving
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

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

excel-training-advanced courses - Invoiving

resolvedResolved · Low Priority · Version Standard

replyReply Fri 16 Nov 2007, 16:47Delegate Celina said...

Celina has attended:
Excel Intermediate course

Invoiving

how to set up a template

For upcoming training course dates see: Pricing & availability

replyReply Mon 19 Nov 2007, 09:19Trainer Pete said...

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:

Sum Up All the Values in A Column

If you want to quickly calculate the Summed values of all cells in a column in Excel 2003 normally you would use the SUM formula. (eg if you wanted to calculate the values in Column C rows 10 to 25) the formula would be:

=SUM(C10:C25)

However, if you keep adding values to column C you would keep having to modify the above SUM formula which can get quite annoying.

To get around this you can sum all the values in a column using the following formula:

=SUM(COLUMN:COLUMN)

Which, in our example, would be:

=SUM(C:C)

NOTE You cannot place this formula in column C, or else Excel 2003 will show a circular reference error.

The formula must be placed in any other column, EXCEPT the one being calculated.

View all Excel hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard