Watching:

How to Create New Files in Excel 2013


show more Creating new files provides you with in-depth training on Business. Taught by Dennis Taylor as part of the Excel 2013 Essential Training show less
please wait ...

Creating new files

If you like to create a brand-new workbook and you're simply thinking of a blank slate, you can press Ctrl+N--that's the letter N--and suddenly, we see on the screen a new workbook. Now, that's going to be called Book2, Book3--depending upon what other workbooks you might have open-- that's its temporary name, but you should not overlook the fact that Excel has a number of built-in templates that might get you started much, much faster. Suppose for example, you're interested in creating a Budget or a Personnel list or a Phone list, you can go to the File Tab in the Ribbon and choose "New", now it does give us the choice for a Blank workbook or possibly a Mortgage Refinance Calculator; Financial Portfolio.

Take a look at some of these that are built-in. What you get here in all cases is an attractively designed worksheet with built-in formulas that might just be enough of a kick-start to get you going pretty fast here. Maybe you're considering some Home Loan options. Choose "Home Loan Comparison" here, "Create" and here we are started; and we're going to have to explore this a little bit. Maybe for it to make sense to our situation--change the Bank name. A lot of formulas are built-in, we might be looking at different terms, different rates.

This is enough to get you started many, many times. Furthermore, it gives you some insight into how, perhaps, certain formulas work in Excel, how certain formatting capabilities exist. We also see some nice charts in this option, so don't overlook this possibility. Again, going to that File Tab, choose "New"; explore some of the many options that are here. Furthermore, at the bottom of this list, you will see reference here, to the fact that you can use the search box at the top to find more templates.

If the recipe template that you saw here wasn't quite what you wanted, you can, for example, go to "Lists" here, possibly find some other options here and here we see a huge category of possibilities. This is almost an endless list of, possible built-in, templates that you might want to use to get a workbook started very quickly in Excel.

Creating new files
Video duration: 2m 11s 6h 32m Appropriate for all

Viewers:

Creating new files provides you with in-depth training on Business. Taught by Dennis Taylor as part of the Excel 2013 Essential Training

Subjects:
Business Education + Elearning
Software:
Excel
Author:
please wait ...