Welcome to our free Upgrading to Microsoft Office 2013 tutorial. This tutorial is based on Webucator's Upgrading to Microsoft Office 2013 course.
Microsoft Excel 2010 and 2013 provide a number of new features. In this lesson, you will review how to perform basic tasks in Excel 2013, as well as what features are new or have changed.
Lesson Goals
To start Microsoft Excel (see screen shot below):
When you open Microsoft Excel, a workbook is automatically opened as well. As you can see in the screens hot 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:
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 ().
To delete a worksheet, simply rightclick on the worksheet name and select Delete:
To change the name of a worksheet, doubleclick the current name and begin typing:
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.
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:
In Excel 2013, formulas now reside on the FORMULAS tab of the Ribbon.
On this tab, you can create and work with formulas in your workbook.
However, there are other places within Excel 2013 where you can use formulas.
When on the HOME tab, in the Editing group, you can use the AutoSum button to quickly add your data.
Also, when working in Excel 2013, you can work with formulas regardless of what tab you are on in the Ribbon. Simply do the following:
Microsoft Excel is a powerful program which is used to analyze and present data, perform calculations, and much more. Microsoft Excel has hundreds of commands for working with different scenarios. To make it easier for users to find the specific commands they are looking for, commands are organized onto eight main tabs:
Note that the FILE menu is not the same as a tab. The FILE menu takes you to the Backstage view, where you manage, rather than make changes to, your workbook.
To further organize the many commands available in Microsoft Excel, commands are organized in groups on each tab. Each group contains three or more related commands. The following table lists the groups found on each tab:
Tab  Group 

HOME 

INSERT 

PAGE LAYOUT 

FORMULAS 

Data 

REVIEW 

VIEW 

ADDINS 

Commands are controls that enable you to accomplish specific tasks, such as bolding a word, wrapping text, changing the format of a number to percent, or adding a column.
On the Excel 2013 HOME tab, you will find commands that you will use often when working in Excel. The Copy and Paste commands are found on the HOME tab in the Clipboard group.
The Font group contains commands to format text within your workbook.
In the Alignment group, you will find commands to center and align your text.
The Number group contains commands that you can use to format the numbers that appear in your worksheets.
In the Styles group, you will see options to apply conditional formatting, as well as table and cell styles, to help make your workbooks look polished and professionals.
Within the Cells group, you will find the options to insert, delete, and format cells within your worksheets.
And finally on the HOME tab is the Editing group, which contains the Sort & Filter and the Find & Select options, along with the AutoSum command and the Fill and Clear commands.
One of the new features in Excel 2010 and 2013, as discussed previously, are tools on the Ribbon that appear on demand, as you work. These tools will automatically appear as you work in your worksheet. They will be relevant to what you are doing at the time.
For example, if you are working with a PivotTable in your Excel worksheet, when you are working in your table, you will notice ANALYZE and DESIGN tabs, along with the PivotTable Tools, will appear on the Ribbon.
When you click away from the PivotTable, the ondemand tools will disappear, and the standard tabs will remain.
In Excel 2010 and 2013, keyboard shortcuts that begin with the CTRL key, such as CTRL+N to create a new, blank workbook and CTRL+F to display the Find and Replace dialog box, remain the same as in previous versions of Excel.
However, shortcuts that in previous Excel versions involved pressing ALT have changed; these are now called KeyTips.
To display KeyTips in your workbook:
For example, to add a comment in your workbook, you would
Excel 2010 and 2013 workbooks use the .xlsx file extension. Excel 2010 and 2013 are based on Office Open XML formats (but you do not need to know how to use XML to work in Excel 2010/2013).
The reasoning behind this change is because XML helps keep workbooks safer by:
You can open workbooks that were created in previous versions of Excel. When you open such a workbook, it will open in Compatibility Mode.
When you save a file that was created originally in a previous version of Excel, the Save As dialog box will open automatically, to save the file with an .xlsx file extension.
Also, when you save an Excel 2010/2013 file as a previous version, Compatibility Checker will identify any new features that will not work in that version.
In previous versions of Excel, when working with multiple workbooks, they would all open in the same window.
This would make it difficult to work with two workbooks at once. However, in Excel 2013, each workbook opens in its own window. This makes it easier to work with them, especially if you are using multiple monitors.
Flash Fill is similar to the AutoComplete feature, but it is new to Excel 2013. It looks for patterns in your data and shows a suggestion. As soon as it detects what you are attempting to do, it shows a recommended pattern.
In the following example, full names have been entered in Column A. In Column B, this is what happens when you begin entering just first names, pressing Enter after each:
In this exercise, you will use the new Flash Fill feature.
Excel 2013 contains a number of new functions that are available to work with that are available in the Function Library group of the FORMULAS tab.
Some of the new functions include the following. To view all of the functions, click each button in the Function Library.
DECIMAL
function: Available on the Math & Trig tab. This function converts the text of a number in a given base into a decimal number. ACOT
function: Available on the Math & Trig tab. This function returns the arccotangent of a number.ENCODEURL
function: Available on the More Functions tab in the Web section. This function returns a URLencoded string. DAYS
function: Available on the Date & Time tab. This function shows the number of days between two dates. Excel 2013 contains a number of new functions that are available to work with that are available in the Function Library group of the FORMULAS tab.
Some of the new functions include the following. To view all of the functions, click each button in the Function Library.
DECIMAL
function: Available on the Math & Trig tab. This function converts the text of a number in a given base into a decimal number. ACOT
function: Available on the Math & Trig tab. This function returns the arccotangent of a number.ENCODEURL
function: Available on the More Functions tab in the Web section. This function returns a URLencoded string. DAYS
function: Available on the Date & Time tab. This function shows the number of days between two dates. Excel 2013 contains a number of new functions that are available to work with that are available in the Function Library group of the FORMULAS tab.
Some of the new functions include the following. To view all of the functions, click each button in the Function Library.
DECIMAL
function: Available on the Math & Trig tab. This function converts the text of a number in a given base into a decimal number. ACOT
function: Available on the Math & Trig tab. This function returns the arccotangent of a number.ENCODEURL
function: Available on the More Functions tab in the Web section. This function returns a URLencoded string. DAYS
function: Available on the Date & Time tab. This function shows the number of days between two dates. Excel 2013 contains a number of new functions that are available to work with that are available in the Function Library group of the FORMULAS tab.
Some of the new functions include the following. To view all of the functions, click each button in the Function Library.
DECIMAL
function: Available on the Math & Trig tab. This function converts the text of a number in a given base into a decimal number. ACOT
function: Available on the Math & Trig tab. This function returns the arccotangent of a number.ENCODEURL
function: Available on the More Functions tab in the Web section. This function returns a URLencoded string. DAYS
function: Available on the Date & Time tab. This function shows the number of days between two dates. Slicers was a new feature added to Excel 2010, which allows users to filter PivotTable data. In Excel 2013, you can now use slicers to filter table data.
To filter data using slicers:
In this exercise, you will use slicers to filter data in Excel 2013.
You can now use the PivotTable Timeline feature to filter your data by time.
To create a PivotTable Timeline:
In this exercise, you will create a PivotTable timeline.
In previous versions of Excel, a PivotChart needed to be associated with a PivotTable; however, in Excel 2013 you can now create a standalone PivotChart.
To create a standalone PivotChart: