Create a Workbook from a Template in Microsoft Excel 2013

Edited by Colette Cole, Crystal, Eng

Hi there and welcome to VisiHow. In this tutorial, we're going to show you how to easily create a workbook from an existing template in Microsoft Excel 2013.

How to Create a Workbook from a Template in MS Excel 2013.mp4-canvas0.jpg

Ad

Steps

  1. 1
    The first thing that we want to do is open the application
    .
    We'll see the normal landing page. On the right side of the screen, we can see the different templates available. This should be done if we have an idea of what we want and want to find something good available to save time.
    How to Create a Workbook from a Template in MS Excel 2013.mp4-canvas27 20199.jpg
    Advertisement
    Was this step helpful? Yes | No
  2. 2
    If we don't see anything that we'd like to use, we can also search by clicking on a suggested search at the top
    .
    We can also type in what we want and click on the magnifying glass.
    How to Create a Workbook from a Template in MS Excel 2013.mp4-canvas52 191687.jpg
    Advertisement
    Was this step helpful? Yes | No
  3. 3
    Click on the chosen template
    .
    For this purpose, we're going to click on a random one. It will show us a description and some images.
    How to Create a Workbook from a Template in MS Excel 2013.mp4-canvas64 527685.jpg
    Was this step helpful? Yes | No
  4. 4
    If we decide that this is the template we want to use, we can click on "Create"
    .
    It will download and then open the template.
    How to Create a Workbook from a Template in MS Excel 2013.mp4-canvas74 063089.jpg
    Was this step helpful? Yes | No
  5. 5
    We will then see the workbook that we can use by changing the information
    .
    This workbook already has formulas available, so if we change the values according to our own company values, we don't have to come up with the sum, for example, we just simply leave it the way it is and it will calculate according to the formula. In this particular case, we're looking at hours & expense tracking.
    How to Create a Workbook from a Template in MS Excel 2013.mp4-canvas86 328992.jpg
    Was this step helpful? Yes | No
  6. 6
    For example, we'll change the rate
    .
    It was $50, but we want to change it to $80, so we can type that in.
    How to Create a Workbook from a Template in MS Excel 2013.mp4-canvas122 229405.jpg
    Was this step helpful? Yes | No
  7. 7
    We can see that the numbers have changed accordingly
    .
    We can just go through and change all of the information and treat it like any other workbook. We can also add sheets, just like we were working with a blank workbook. We can add images, clipart, and that sort of thing. Don't forget that this is a new document even though it's a template. It's not actually our workbook until we save the document.
    How to Create a Workbook from a Template in MS Excel 2013.mp4-canvas127 107453.jpg
    Was this step helpful? Yes | No
  8. 8
    We're going to click the save icon in the top left-hand corner
    .
    It looks like a floppy disk.
    How to Create a Workbook from a Template in MS Excel 2013.mp4-canvas161 622641.jpg
    Was this step helpful? Yes | No
  9. 9
    Alternatively, click on "FILE"
    .
    How to Create a Workbook from a Template in MS Excel 2013.mp4-canvas162 113227.jpg
    Was this step helpful? Yes | No
  10. 10
    Click on "Save As"
    .
    An easier way is to press "Ctrl" + "S" on the keyboard simultaneously.
    How to Create a Workbook from a Template in MS Excel 2013.mp4-canvas163 975133.jpg
    Was this step helpful? Yes | No
  11. 11
    Choose the location to save the document to
    .
    We'll click on "Browse".
    How to Create a Workbook from a Template in MS Excel 2013.mp4-canvas166 208014.jpg
    Was this step helpful? Yes | No
  12. 12
    Name the document, then click "Save"
    .
    We can also hit "Enter" on the keyboard. We're going to name it "colette's tracker".
    How to Create a Workbook from a Template in MS Excel 2013.mp4-canvas177 478949.jpg
    Was this step helpful? Yes | No
  13. 13
    After it has been named and saved, if we make any changes, we can just quickly save after so that we don't lose any data
    .
    Sometimes people forget and lose all the changes they've made.
    How to Create a Workbook from a Template in MS Excel 2013.mp4-canvas196 162769.jpg
    Was this step helpful? Yes | No
  14. 14
    That is how you create a workbook using a template in Microsoft Excel 2013
    .
    Thank you for watching VisiHow. If you have any questions or comments about this video, please feel free to leave them in the comment section below. Take care.
    Was this step helpful? Yes | No
    Advertisement

Video: Create a Workbook from a Template in Microsoft Excel 2013

If you have problems with any of the steps in this article, please post in the comments section below.

Comments

VisiHow welcomes all comments. If you do not want to be anonymous, register or log in. It is free.

Article Info

Categories : Microsoft Suites

Recent edits by: Crystal, Colette Cole

Share this Article:

Thanks to all authors for creating a page that has been read 223 times.