• Speak to an IT Buddy: 484-845-1600

Excel 2013 Training Center

Microsoft Excel 2013 Training Center

The following contains links to downloadable tip sheets and online training videos created and provided by the Microsoft Training Team

Excel 2013 Tip Sheets & Reference Guides

Excel 2013 training

Getting Started
Commmon Formulas
Sorting Data
Charts & Graphs
Filtering Data
Formatting Cells
Page Layout
Quick Reference Guide

Excel 2013 Training Videos

Basic Math in Excel

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

Watch the video

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.

Watch the video

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. Good news – the command is easy to get to. Click View > Freeze Panes > Freeze Top Row.

Watch the video

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. For example, a cell in column D and row 5 is cell D5. When you use cell references in a formula, Excel calculates the answer automatically using the numbers in the referenced cells.

Watch the video

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.

Watch the video

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.

Watch the video

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.

Watch the video

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.

Watch the video

[gradient_button size=”x-large” bg_color=”#00ccff” color=”#fff” text=”Return to the Business Learning Center” title=”Return to the Business Learning Center” url=”http://it-buddy.com/index.php/training/”]