{"id":668,"date":"2012-10-02T10:48:43","date_gmt":"2012-10-02T10:48:43","guid":{"rendered":"http:\/\/www.microsofttraining.net\/b\/exceltraining\/?p=668"},"modified":"2023-12-30T23:12:17","modified_gmt":"2023-12-30T23:12:17","slug":"the-joy-of-excel-2010-templates","status":"publish","type":"post","link":"https:\/\/www.stl-training.co.uk\/b\/the-joy-of-excel-2010-templates\/","title":{"rendered":"The Joy of Excel 2010 Templates"},"content":{"rendered":"

I love time-saving tips and templates are a great way of setting up new worksheets without the hard work of formatting, setting up formulas and trying to make things look good. \u00a0What I really want to do, is on get on with “the important stuff” of entering the data quickly, so that I can analyse the results and get the positive work outcomes I need.<\/p>\n

Today’s mission, was to set up a basic time sheet for the different projects I am working on, and logging the time I spend on each one, so I can report back to each “client” on what I’ve done and how long it has taken. \u00a0I can then use this data to generate invoices, or project costings for example.<\/p>\n

In Excel 2010, I selected File, New – and I am given a smorgasbord of options…this is where I can look through suggested ready-made templates.<\/p>\n

\"Excel<\/a>
Screen shot of templates available in Excel 2010.<\/figcaption><\/figure>\n

I chose “Time Sheets”, which gave me four options – from which I chose “Daily Time Sheet”, and downloaded it to my computer. It looks like this:<\/p>\n

\"Template<\/a>
The template ready for editing to my requirements<\/figcaption><\/figure>\n

I then edited the sheet to show the titles and information I want to include and saved it. \u00a0Now I can easily add my client’s details, add a scheduled time for work and log what work was completed, for which client. \u00a0So now it looks like this:<\/p>\n

\"Excel<\/a>
My edited version of the timesheet so that the fields reflect what I need.<\/figcaption><\/figure>\n

No messing with formulas, formatting or fuss…Job done!<\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n","protected":false},"excerpt":{"rendered":"

I love time-saving tips and templates are a great way of setting up new worksheets without the hard work of formatting, setting up formulas and trying to make things look good. \u00a0What I really want to do, is on get on with “the important stuff” of entering the data quickly, so that I can analyse […]<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[4],"tags":[172,224,228],"class_list":["post-668","post","type-post","status-publish","format-standard","hentry","category-excel-training","tag-excel-how-to","tag-excel-training-london","tag-excel-training-using-templates"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts\/668","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/comments?post=668"}],"version-history":[{"count":1,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts\/668\/revisions"}],"predecessor-version":[{"id":6728,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts\/668\/revisions\/6728"}],"wp:attachment":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/media?parent=668"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/categories?post=668"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/tags?post=668"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}