Excel 2013 Training

Make the Switch to Excel 2013

Watch these videos to make the switch to Excel 2013. Get started with the new version to see how to do everyday tasks.

Download this Course

Beginner: Create your first Workbook

Learn how to use Excel 2013. Get started with the new version to see how to do everyday tasks.

Download this Course

Beginner: Basic Math in Excel 2013

Let Excel be your Calculator. Take this course to learn how to add, subtract, multiply, and divide using formulas and functions.

Download this Course

Beginner: Add Numbers in Excel 2013

See how Excel 2013 makes it easy to add numbers using formulas, buttons, and functions (such as the SUM and SUMIF functions).

Download this Course

Beginner: Create a Chart

Charts provide a visual representation of your data, making it easier to analyze. Each type of chart highlights data differently. And some charts can’t be used with some types of data.

Download this Course

Beginner: Freeze or Lock Panes

You want to scroll down and see your rows of data, but when you get to the bottom of the screen, your column names in the top row have disappeared. To fix this, you freeze the top row so that it’s always visible.

Download this Course

Beginner: Top Tips for Working in Excel Online

Use Excel Online to change the formatting of numbers and text to help make your information stand out. And see 3 ways to quickly add numbers, too.

Download this Course

Beginner: Understand and Use Cell References

One of the key things you’ll calculate in Excel are values in cells, the boxes you see in the grid of an Excel worksheet. Each cell is identified by its reference—the column letter and row number that intersect at the cell’s location. When you use cell references in a formula, Excel calculates the answer automatically using the numbers in the referenced cells.

Download this Course

Beginner: Use Autofill and Flash Fill

Sometimes you need to enter a lot of repetitive information in Excel, such as dates, and it can be really tedious. But the AutoFill feature can help.  AutoFill and Flash Fill are tremendous time savers, and in this course, we’ll cover them in more detail.

Download this Course

Intermediate: Add or Subtract Time

You can add and subtract time in Excel almost like you subtract other types of numbers. For example, you might do this if you want to know how long it took to complete a project’s tasks. The one exception is that Excel doesn’t support a negative number formatted as time.

Download this Course

Intermediate: Average a Group of Numbers

When you need to find an average, you can click a button, or use a function in a formula. The AutoSum button lets you find the average in a column or row of numbers where there are no blank cells. Use the AVERAGE or the AVERAGEIF functions to find the average of numbers that aren’t in a contiguous row or column. And use the SUMPRODUCT and the SUM functions to find a weighted average, which depends on the weight that’s applied to the values.

Download this Course

Intermediate: Insert Headers and Footers

You can add headers to the top and footers to the bottom of a worksheet. When you print the worksheet, the headers and footers also print. For example, you might create a header with the file path and a footer with page numbers. Headers and footers display only in Page Layout view and on printed pages. Take this quick course to learn more.

Download this Course

Intermediate: Sort and Filter Data

Excel is an amazing tool for analyzing data. And Sort and Filter are some of the most commonly used features to help you. To change the order of your data, you’ll want to sort it. To focus on a specific set of your data, you can filter a range of cells or a table. Take this course to learn more.

Download this Course

Intermediate: Use Conditional Formatting

It can be hard to get a lot of meaning out of numbers in a worksheet. But Excel provides a bunch of ways to quickly analyze your data using conditional formatting. For example, you can use a color scale to differentiate high, medium, and low temperature values.

Download this Course

Intermediate: Take Conditional Formatting to the Next Level

In the course Use conditional formatting, we covered the basics of conditional formatting. Here, we’ll go a few steps further and see how to apply conditional formatting to cells, tables, PivotTables, and worksheets. For example, to quickly conditionally format cells, you can use a Quick Analysis option or an option on the Conditional Formatting button in the ribbon. We’ll also use formulas to apply conditional formatting, and learn how to edit and delete rules using the Conditional Formatting Rules Manager.

Download this Course

Intermediate: VLOOKUP – When and How to use it

Learn how to use the VLOOKUP function to find data in a large spreadsheet, and on other worksheets in a large workbook. These videos explain each of the VLOOKUP arguments, and mistakes to avoid.

Download this Course

Advanced: Advanced IF Functions

Take this course to learn complex examples and variations of the IF function in Excel, including nested IF functions, IF with AND and OR, COUNTIFS and SUMIFS, and AVERAGEIFS and IFERROR.

Download this Course

Advanced: Create and Manage Drop-Down Lists

You can make a worksheet more efficient by providing drop-down lists. Someone using your worksheet clicks an arrow, and then clicks an entry in the list. Take this course to learn more about how best to use and manage them.

Download this Course

Advanced: PivotTables

Learn what a PivotTable and PivotCharts are and how you can use them to summarize and analyze data in Excel 2013.

Download this Course

Advanced: Password Protect Workbooks and Worksheets

Your Excel workbook or worksheets contain sensitive strategic data, so you want to require others to enter a password to open them. Or you can share the data freely with anyone without requiring a password, but require a password to make changes. Take this short course to find out more.

Download this Course

Advanced: Print Worksheets and Workbooks

Print Excel worksheets and workbooks one at a time, or several at one time. You can also print a partial worksheet, such as an Excel table.

Download this Course

Advanced: Work with Macros

You want to automate a repetitive task in Excel so that you can do the task again with a single click. The best way to do that? Record a macro. And the macro recorder is the easiest way to create a new macro in Excel. Take this course to learn more.

Download this Course