facebook google plus twitter
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.

New Functions

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. Date & Time Tab
  3. Select DAYS. DAYS Option
  4. In the Function Arguments dialog box, enter "A3" as the End_date and "A2" as the Start_date and click OK. End and Start Dates
  5. Notice that 56 days are between these two dates. Days Between 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. Buttons Next to Chart
  3. Use the Chart Elements button to quickly work with the legend, data labels, axis titles, and more. Chart Elements Button
  4. Use the Chart Styles button to change the style and color of your chart. Chart Styles Button
  5. Use the Chart Filters button to change which data points and names appear in your chart. Chart Filters Button

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. Selected Chart
  2. Click the Chart Elements button. Chart Elements Button
  3. Click Axis Titles and then select Primary Horizontal. Primary Horizontal Option
  4. Select the newly displayed Axis Title text box and type "Sales (in $)". Axis Title Text Box

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. Selected Data
  2. Notice the Quick Analysis Tool icon that is displayed at the bottom of the data. Click it. Quick Analysis Tool
  3. Roll over each option in the Quick Analysis gallery to see a preview. Previewed Options
  4. To select an option, click it. Selected Option

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.
  3. Save your changes.

Solution:

  1. Select cells B4:D8. Selected Cells
  2. Click the Quick Analysis Tool icon. Quick Analysis Tool Icon
  3. Click the Icon Set icon of the FORMATTING tab to select this type of formatting. Icon Set Icon
  4. The data now appears with icon set formatting. 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. Recommended Charts Option
  3. Excel 2013 displays the Insert Chart dialog box, displaying the Recommended Charts tab (as well as the All Charts tab. Recommended Charts Tab
  4. To select a chart, select it and click OK. Selected Chart