facebook google plus twitter
Webucator's Free Introduction to Microsoft Excel 2013 Tutorial

Lesson: Microsoft Excel 2013 New Features

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

Excel 2013 provides some new features to make working with spreadsheets easier and more efficient.

Lesson Goals

  • Learn about the one workbook per window feature.
  • Learn how to use Flash Fill.

One Workbook Per Window Feature

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.

Two Workbooks in Separate Windows

Using Flash Fill

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:

Flash Fill

Using Flash Fill

Duration: 05 to 10 minutes.

In this exercise, you will use the new Flash Fill feature.

  1. Open a new, blank worksheet in Excel.
  2. In column A, enter the following:
    1. Angela Ang
    2. Bobbi Born
    3. Chris Carter
    4. Doris Day
    5. Edward Everly
  3. Use Flash Fill to enter just the first names in column B.

Solution:

  1. In a new, blank document, enter the data in column A. Flash Fill
  2. Click in cell B1, and type "Angela" and press Enter. Flash Fill
  3. Click in cell B2, and as you begin to type "Bobbi", Flash Fill fills in rest of the first names. Flash Fill
  4. To accept the rest of the data, press Enter. Flash Fill
  5. Close the worksheet without saving your changes.