excel+training - templates
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 - Templates

excel+training - Templates

resolvedResolved · Low Priority · Version Standard

replyReply Thu 13 Dec 2007, 17:14Delegate John said...

John has attended:
Excel Intermediate course

Templates

how do I create a Template
from from an existing workbook?

For upcoming training course dates see: Pricing & availability

replyReply Fri 14 Dec 2007, 12:18Trainer Pete said...

RE: Templates

Hi John, Thank you for your post, I hope you enjoyed your course; in answer to your question; in your existing workbook, choose the menu command File, Save As, in the dialog box, name your Workbook, and from the Save As Type option choose Template, if you do not wish your new Template to be saved in the General Templates area, navigate to a folder of your choice and click the Save button. I hope that helps, best regards Pete

replyReply Fri 14 Dec 2007, 13:21Delegate John said...

RE: Templates

Thanks Pete, Yes that does help.
Regards
John

 

Excel tip:

Display Functions on Worksheets

Functions in Excel can be difficult to recall their format/syntax

For example, you want to use the =PMT function.

Enter =PMT, then select keystroke, CTRL+SHIFT+A.

This usful memory jog, will display the arguments of a function on a worksheet, allowing the user to proceed with the generation of the function



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