Learn multiple methods for creating new blank documents in Excel 2013, with emphasis on the methods most likely to appear in the Excel 2013 MOS exam. Author Jen McBee shows how to create a new blank document using menu options and keyboard shortcut. Explo
- [Voiceover] Excel is a great tool for analyzing large amounts of data, but it's also perfect for doing simple calculations in tracking almost any type of information. Since you will probably be asked to do so on your Excel 2013 MOS Exam, we're gonna look at two ways to create a Workbook in Excel 2013. First we'll look at using templates, which are predesigned workbooks with custom formatting, and then we'll look at creating a new blank workbook. So, let's go ahead and get started. I have Excel open.
To access the templates in Excel, we'll first click on our File tab, which will take us to the backstage area. I'll then click on the New tab, and here are all of our wonderful templates. Now, there may be times when you are faced with the daunting task of creating a brand new workbook, and it might be something such as project management that you need to track. Using the templates in Excel 2013 will make your job so much easier, and I'll show you how right now. Notice this search field at the top of this window.
This is a great tool that you can use to quickly search for a document that will fit your needs. I'll go ahead and click in the search field, type in project management, and then hit my enter key to begin the search. Here you see we have dozens of templates to choose from, everything from Project Budget, which is what I have highlighted on the screen now, to Project cost tracker. Did you notice that when I clicked on the thumbnail of the Project cost tracker, it's now showing me a preview of what that document will look like.
This looks pretty good. I'm gonna go ahead and click the Create button over on the right-hand side to open this template. That quickly I now have a beautiful document that's just waiting for me to start entering information in. Notice that all the formatting is done. All the formulas have been created. All I need to do is customize it with my company name and my data. Now let's look at how we can create a new workbook using the blank workbook template. Once again, I'll go to my File tab, and by clicking the New tab, I can access all of the templates.
The very first template is a blank workbook. I'll go ahead and click on it to create our new document, and here's our blank workbook. Now, that was a couple of clicks. First we had to go to File, and then to New, and then click on the icon. Let me show you a great shortcut that you can use to quickly open a new blank workbook. We'll use a keyboard stroke, Control N for New on your keyboard, and that quickly we now have a new workbook created. We're off to a great start. You now know how easy it is to conquer that huge project by using one of the great templates that are available in Excel 2013.
You also learned a new keyboard shortcut to create a blank workbook. During your MOS Exam, you may be asked to create a new workbook, based on a template. Please make sure you familiarize yourself with the different templates available in Excel, and don't forget about that great search field. Knowing how to quickly perform these tasks on your MOS Exam is key to passing. Anytime you can save time by quickly performing a task, that gives you additional time on those harder tasks.
Disclaimer: Microsoft does not produce, provide, or endorse this video training course.
The course first explores the MOS certification program, its cost, and its format. Jennifer then walks through all of the Excel certification objectives in detail. She includes free practice files so you can follow along as she demonstrates each skill. There are challenges to test your skills at the end of almost every chapter, and the full-length, 50-minute practice exam at the end of the course will ensure you're ready for the real exam.
- Preparing for the exam
- Understanding the registration process
- Creating new Excel workbooks and worksheets
- Formatting data
- Inserting columns and rows
- Moving data
- Applying conditional formatting
- Creating tables
- Applying formulas and functions
- Summarizing data
- Creating charts
- Taking a full-length practice exam