Webucator's Free Intermediate Microsoft Excel 2013 Tutorial

# Lesson: Microsoft Excel 2013 New Features

Welcome to our free Intermediate Microsoft Excel 2013 tutorial. This tutorial is based on Webucator's Intermediate Microsoft Excel 2013 Training course.

Excel 2013 provides a number of new functions and tools to help make working with worksheets easier and more efficient.

Lesson Goals

• Learn about the new functions available in Excel 2013.
• Learn how to use the new chart tools in Excel 2013.
• Learn how to use the Quick Analysis tool.
• Learn how to use the Chart Recommendation feature.

## New Functions in Excel 2013

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.

1. `DECIMAL` function: Available on the Math & Trig tab. This function converts the text of a number in a given base into a decimal number.
2. `ACOT` function: Available on the Math & Trig tab. This function returns the arccotangent of a number.
3. `ENCODEURL` function: Available on the More Functions tab in the Web section. This function returns a URL-encoded string.
4. `DAYS` function: Available on the Date & Time tab. This function shows the number of days between two dates.

## Using the New Excel Functions

Duration: 5 to 10 minutes.

In this exercise, you will use one of the new functions available in Excel 2013.

1. Open New Functions.xlsx from your Excel2013.2/Exercises folder.
2. Use the new DAYS function to determine the amount of time between the two dates that are listed in Column A.

## Solution:

1. Select Cell B2
2. Select the FORMULAS tab and in the Function Library group, select the Date & Time tab.
3. Select DAYS.
4. In the Function Arguments dialog box, enter "A3" as the End_date and "A2" as the Start_date and click OK.
5. Notice that 56 days are between these two dates.

## Using New Chart Tools

Charts in Excel 2013 are easy to format and work with using three chart buttons that appear when you select the chart.

To use the new chart tools:

1. Click the chart you want to work with.
2. Notice the three buttons that appear next to the chart.
3. Use the Chart Elements button to quickly work with the legend, data labels, axis titles, and more.
4. Use the Chart Styles button to change the style and color of your chart.
5. Use the Chart Filters button to change which data points and names appear in your chart.

## Using the New Excel 2013 Chart Tools

Duration: 10 to 15 minutes.

In this exercise, you will use the new chart tools available in Excel 2013.

1. Open New Chart Tools.xlsx from your Excel2013.2/Exercises folder.
2. Use the Chart Elements button to add a Primary Horizontal style title to the x-axis named "Sales (in \$)" to the Quarterly Sales chart.

## Solution:

1. Click the chart to select it.
2. Click the Chart Elements button.
3. Click Axis Titles and then select Primary Horizontal.
4. Select the newly displayed Axis Title text box and type "Sales (in \$)".

## Using the Quick Analysis Tool

The Quick Analysis tool in Excel 2013 is a new feature that allows you to convert your data quickly and easily into a chart or table.

To use the Quick Analysis tool:

1. Select the cells of data that you want to analyze.
2. Notice the Quick Analysis Tool icon that is displayed at the bottom of the data. Click it.
3. Roll over each option in the Quick Analysis gallery to see a preview.
4. To select an option, click it.

## Using the Quick Analysis Tool

Duration: 10 to 15 minutes.

In this exercise, you will use the new Quick Analysis tool.

1. Open Using Quick Analysis Tool.xlsx from your Excel2013.2/Exercises folder.
2. For the January, February, and March data, use the Quick Analysis tool to add the formatting Icon Set feature.

## Solution:

1. Select cells B4:D8.
2. Click the Quick Analysis Tool icon.
3. Click the Icon Set icon of the FORMATTING tab to select this type of formatting.
4. The data now appears with icon set formatting.

## Using the Chart Recommendation Feature

The Excel 2013 Chart Recommendation feature can assist you by providing charts that suit your data.

To use the Chart Recommendation feature:

1. Select the cells of data for which you want to create the chart.
2. Select the INSERT tab, and in the Charts group, click Recommended Charts.
3. Excel 2013 displays the Insert Chart dialog box, displaying the Recommended Charts tab (as well as the All Charts tab.
4. To select a chart, select it and click OK.