A workbook is a file that contains one or more worksheets, to help you organize your data. You can create a workbook from a blank workbook or a template.
Create a workbook
Select File > New.
Select Blank workbook.
Tip: Press CTRL+N to quickly create a new workbook.
Create a workbook using a template
Select File > New.
Do one of the following:
Select a template from the available list of templates, and then select Create.
From Suggested searches, select a category (such as Business, Personal, or Industry), select a template, and then select Create.
If you'd like to create a brand New workbook you can simple press Ctrl + N, think of N for New, the letter N.
Hold down Control, press the letter N.
And you're likely to see a workbook with a name like Book1, possibly Book2 depending upon which other workbooks might already be open.
But there's another way to start a workbook and this is going to give you a quick start on a lot of different kinds of workbooks that you might be considering.
The File tab in the ribbon, has an option called New.
There's that choice for blank workbook that we achieved with Ctrl +N.
But look at some of the other choices out here. Personal Budget, PayPal.
If you're looking at your screen right now you might be seeing a slightly different list or maybe in a different order.
But here are some frequently used, based on Microsoft analysis, kinds of worksheets, workbooks, that you might be interested in.
And lots of choices here.
And not only the ones we're initially seeing, but you'll notice up here, Suggested searches, Business, Personal, searching for online templates.
The beauty of these is that they look attractive for the most part, one or two of them here and there is going to catch your eye.
Maybe you've been trying to put together an expense report.
Here's one that's already started, let's click this. Sounds interesting, sounds worthwhile. Click Create.
Not only will this save you a ton of work, but it has formulas built in automatically so on a certain date, certain account description, maybe we'll just put in an amount here, maybe you spent $25 on a meal here.
It's got a total off to the right, you see what's happening over here.
Maybe you spent $15 on gas here.
We see how this is being totaled at the bottom and on the right hand side.
There are formulas off to the right, you may or may not understand how they're working but you may get some insight into that and as you look at this, you think one day I could probably do something like this on my own without needing this.
But not only do you get ideas, this may be pretty much what you need.
You've got your own choices here maybe you don't need this row here or this row, maybe you don't need this second row here.
Right click and Delete that. You might have seen that command.
So you do have control over this.
You can take advantage of the built in formulas, redesign it, maybe delete this column, that column.
Make it work for you. It's one of many, many choices here.
So remember, Ctrl + N to create a New Excel workbook or File tab in the ribbon, New and based on one of the templates here, start building your own workbook based on one of these.
Learning doesn't stop here. Discover more expert led tutorials at LinkedIn Learning. Start your free trial today, at linkedin.com/learning.
Learn from recognized industry experts, and get the business, tech, and creative skills that are most in demand.
Get unlimited access to over 4,000 video courses.
Receive personal recommendations based on your LinkedIn profile.
Stream courses from your computer or mobile device.
Take courses for every level – beginner to advanced.
Practice while you learn with quizzes, exercise files, and coding windows.
Choose a plan for yourself or your entire team.