Welcome to our free Introduction to Microsoft Excel 2013 tutorial. This tutorial is based on Webucator's Introduction to Microsoft Excel 2013 Training course.
In this first lesson, you will learn how to get started creating Microsoft Excel workbooks.
Lesson Goals
To start Microsoft Excel (see screenshot below):
When you open Microsoft Excel, in Excel 2013, you will have an option to open a template or a blank document; to create a new spreadsheet open a blank document. As you can see in the screenshot below, the default workbook is named "Book1".
Cell A1 is automatically selected when Excel opens. To enter a number or text in cell A1, simply begin typing:
The first time you save a Microsoft Excel workbook, you need to give it a name and location. To do this:
The Status Bar, located at the bottom of Excel, shows basic information about your workbook and enables you to change your viewing settings. Specific items on the Status Bar include:
Depending on your settings, Excel workbooks typically open with one to three worksheets, named Sheet1, Sheet2, etc:
To add additional worksheets, simply click on the Insert worksheet icon (which looks like a worksheet with a plus sign in Excel 2007 and 2010) ().
To delete a worksheet, simply right-click on the worksheet name and select Delete:
To change the name of a worksheet, double-click the current name and begin typing:
Changing the order of worksheets in Excel involves moving or copying worksheets; you can move or copy worksheets within a workbook.
To move a worksheet:
To copy a worksheet:
The copy now appears with the same title and (2).
When working in Excel, it can sometimes be helpful to split the worksheet into two separate, so that you can compare data in the sheet.
To split the window:
You can easily change the order of worksheets in a workbook.
To change the order of worksheets by clicking and dragging the sheet tab to a new location.
The two most common ways to close a Microsoft Excel workbook are:
When you close your workbook, you will be prompted to save if you have made any changes since the last time you saved.
In this exercise, you will create, save and close a Microsoft Excel workbook. You will also name a worksheet. If you currently have Microsoft Excel open, please close it before starting the exercise.