Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member
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.
Get unlimited access to all courses for just $25/month.Become a member
82 Video lessons · 80526 Viewers
80 Video lessons · 132799 Viewers
52 Video lessons · 66331 Viewers
59 Video lessons · 52095 Viewers
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.
Your file was successfully uploaded.