advanced+excel+course - 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 » advanced+excel+course - Templates

advanced+excel+course - Templates

resolvedResolved · Low Priority · Version Standard

replyReply Thu 18 Oct 2007, 17:17Delegate Victoria said...

Victoria has attended:
Excel Intermediate course

Templates

Can i create a template and then save a copy each month when the data changes?

For upcoming training course dates see: Pricing & availability

replyReply Fri 19 Oct 2007, 10:34Trainer Sandy said...

RE: Templates

Hi Victoria

It was great to meet you yesterday and thank you for your feedback comments :)

As you know we covered this topic last on our training yesterday, so you may have just made the question up just for the forum.

Just as a reminder -

1) Create your worksheet how you wish, then save it - changing the file type to: Template.
2) To create a new workbook based on the template, select File menu, New and choose Templates on My Computer to find your template.

Have a Great!! weekend
Kind regards
Sandy

 

Excel tip:

Create a unique items table from a duplicating table

1. Ensure that your list has column headings
2. Select the entire list
3. From the menu bar, select DATA, FILTER, ADVANCED FILTER
4. Select "Filter the list, in place", and tick the "Unique Records Only" box
5. Click OK, filtered list appears.

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