Lesson 1: Format Cells and Ranges (3m 44s)

In this lesson we look at formatting text, including changing fonts and text color.

Lesson 2: Adding a Fill Color (1m 45s)

This lesson explores adding a fill color to a cell or row of cells.

Lesson 3: Adding Borders to Cells and Ranges (3m 6s)

Adding Borders to Cells and Ranges is not a hard thing to do! In this lesson we will show you how.

Lesson 4: Merge Cells (1m 20s)

Merging two or more cells together is a great way to emphasize text, and combine long text strings. In this lesson, we will show you how to use the Merge and Center option.

Lesson 5: Wrap Text Within Cells (1m 44s)

Wrapping text in a cell can also help with long text strings. In this you will see how to use the Warp Text option.

Lesson 6: Modify Cell Alignment (3m 7s)

The text in cells can be aligned left, center, and right in a cell and in this lesson, we will show you how.

Lesson 7: Changing the Orientation (1m 40s)

Believe it or not, you can change the orientation of text in a cell in Excel and in this lesson, we will explore those options.

Lesson 8: Format Cells by Using the Format Painter (4m 29s)

Sometimes you just can’t remember what formatting has been applied to cells. With the format painter, you can copy the format, and paste it where you need it. We’ll see how that is done in this lesson.

Lesson 9: Apply Cell Styles (4m 25s)

Excel comes with a collection of cell style that you use. In this lesson, I’ll show you how to apply cell styles.

Lesson 10: Create and Modify Cell Styles (5m 14s)

You can create your own cell styles, or modify existing ones. We’ll show you how, in this lesson.

Lesson 11: Change Workbook Themes (4m 2s)

Excel has several themes that you can apply to a workbook. We will explore those themes and how to apply them in this lesson.

Lesson 12: Create Custom Color Formats (5m 17s)

In this lesson we will explore Excel’s color formats, and see how to create our own custom color format.

Lesson 13: Create and Modify Custom Themes (2m 38s)

You can create your own custom workbook theme in Excel, or modify an existing one. Watch as we show you how, in this lesson.

Lesson 14: Insert Text Boxes (2m 38s)

You can add a text box to an Excel worksheet, for text that you don’t occupying a cell. In this lesson we will show you how to insert a text box.

Lesson 15: Insert Objects and Shapes (4m 34s)

In this lesson we will see how you can add objects like icons and shapes to a worksheet in Excel.

Lesson 16: Insert Images (2m 35s)

See how you can add images to an Excel worksheet in this lesson.

Lesson 17: Modify Object Properties (3m 47s)

In this lesson you will see how to modify object properties, and control how they move and resize within a worksheet.

Lesson 18: Add Alternative Text to Objects (4m 57s)

Whenever you add objects or images to an Excel worksheet, you have the ability to add alternative text to the object for the visually impaired. In this lesson we will show how.

Lesson 19: Hide or Unhide Worksheets (1m 16s)

Sometimes you may find it necessary to hide worksheets in an Excel workbook. In this lesson we will explore how to Hide or Unhide worksheets.

Lesson 20: Copy and Move a Worksheet (4m 45s)

If you ever need a copy of a worksheet, or want to move it into a new workbook, watch as we copy and move worksheets into new and existing workbooks, in this lesson.

Lesson 21: Change Worksheet Tab Color (1m 39s)

A great feature in Excel is the ability to color worksheet tabs. In this lesson you will discover how to change worksheet tab colors.

Lesson 22: Navigation Shortcuts (2m 49s)

Moving around, and selecting data in a large Excel worksheet can be difficult. In this lesson we will show you some great navigation shortcuts to help you get around.

Lesson 23: Change Magnification by Using Zoom Tools (3m 15s)

When you want to get a closer look at your data, you can use Excel’s Zoom tools to focus on the data you want. In this lesson we will see how to use those magnification tools.

Lesson 24: Change Workbook Views (4m 20s)

Watch this lesson and as we examine how to create and save workbook views, so that you can always view your workbooks your way.

Lesson 25: Change Window Views (5m 32s)

Window views are a great way to open, view and work with multiple worksheets in the same workbook. In this lesson we show you how to use window view options.

Lesson 26: Insert and Remove Hyperlinks (6m 29s)

You can add hyperlinks to an Excel worksheet that link to many different places including, other locations in the current workbook, and places on the internet. See how to insert and remove hyperlinks in this lesson.

Lesson 27: Save a Workbook as a Template (3m 31s)

Using templates are a great way to save time when you have to recreate similar worksheets. In this lesson we will show you how to save a workbook as a template.

Lesson 28: Import Data From a Delimited Text File (4m 54s)

There are many ways to import data into Excel, in this lesson you will see how to import data from a delimited text file.

Lesson 29: Using the Text to Columns Tool (3m 16s)

Separating text strings into columns is accomplished using the Text to Columns tool. Watch this lesson to observe how to use the Text to Columns tool.

Lesson 30: Working With Print Preview (2m 25s)

Print Preview can show you how your worksheets will look when you are ready to print them. In this lesson we will explore some of the available Print Preview features.

Lesson 31: Adjusting Margins (2m 56s)

Adjusting the margins of a worksheet can help you to fit more data on a printed page. In this lesson you will see how to change the margins of an Excel worksheet.

Lesson 32: Changing Page Orientation (1m 26s)

In this lesson we show you how to change the orientation of your Excel worksheet when you are ready to print.

Lesson 33: Insert Headers and Footers (3m 10s)

Headers and footers can be added to your Excel worksheets to add useful information to them when you print them. In this lesson we explore the options for inserting headers and footers to a worksheet in Excel.

Lesson 34: Set a Print Area (2m 5s)

Setting a print area will allow you to print only a specific area of your worksheet. In this lesson you will see how to set a print area in an Excel worksheet.

Lesson 35: Set Print Scaling (3m 0s)

Using print scaling can help you to fit more data on a printed page by reducing the size of text and objects. The Fit to Page option can make all of your data fit on a single page. Watch this lesson as we explore options for print scaling.

Lesson 36: Display Repeating Row and Column Titles on Multipage Worksheets (1m 55s)

When printing a multi-page workbook, you can ensure that specific row and column titles appear on all of your printed pages. In this lesson we will explore the Print Titles options.

Lesson 37: Adding Page Breaks (5m 59s)

You can insert page breaks into your worksheets to determine what will print on each page. In this lesson we will explore how to work with page breaks.

Lesson 38: Print All or Part of a Workbook (4m 46s)

In a multi-page workbook you can choose to print only a single page, multiple pages, or the entire workbook. Watch this lesson to see how to print all, or part of a workbook.

Lesson 39: Filter Records (5m 14s)

In this lesson you will learn how to apply filters to a list, so you can filter out all of the data you don’t need to see, and only show the data you want.

Lesson 40: Change Sort Order (3m 56s)

In this lesson we will explore how to sort any list, either ascending or descending, to help you organize your list data in a way that works for you.

Lesson 41: Sort Data by Multiple Columns (4m 33s)

It’s possible to sort a list within already sorted groups by using multiple criteria. In this lesson we will explore how to use those options with a custom sort.

Lesson 42: Remove Duplicate Records (4m 17s)

Excel can search your data and remove any duplicate values. In the lesson we will see how to use the Remove Duplicates tool.

Lesson 43: Create a Table From a Cell Range (3m 29s)

Creating a table from a range of cells has many benefits. In this lesson we will explore how to create a table by using the Format as Table option.

Lesson 44: Add or Remove Table Rows and Columns (3m 43s)

Once a table has been created Excel makes it possible to quickly add additional rows and columns. In this lesson we will see how to add or remove table rows and columns.

Lesson 45: Insert Total Rows (1m 49s)

If you need to have a total row, Excel tables can do it for you just by checking a box. See how to add a total row to a table in this lesson.

Lesson 46: Apply Styles to Tables (2m 5s)

Excel provides us with many table formatting styles that can be applied quickly. In this lesson will explore applying styles to a table.

Lesson 47: Configure Table Style Options (2m 11s)

Excel has many pre-created table styles, but if you want to customize them, you have that option. In this lesson we will explore how to modify table styles.

Lesson 48: Convert a Table To a Cell Range (2m 13s)

Once a cell range has been formatted as a table, you might one day want to be able to convert the table back into a cell range. In this lesson we will see how to covert an Excel table, into a range.

Lesson 49: Name Cells (4m 1s)

If you name a cell in Excel, you then have the ability to use that name to refer to that cell in a formula. In this lesson we will observe, how to name a cell.

Lesson 50: Name Data Ranges (3m 2s)

If you name a range of a cells in Excel, you can then use that name to refer to that range in a formula. In this lesson we will observe, how to name data ranges.

Lesson 51: Name Tables (2m 23s)

When you convert a cell range into a table, Excel gives it a default name, you can rename the table to something that makes sense for you, and then use that name to refer to that range in a formula. In this lesson we will observe, how to name tables.

Lesson 52: Manage Named Ranges and Objects (6m 16s)

The Name Manager in Excel gives you options for naming, editing, and deleting named cells, objects, and ranges. In this lesson we will explore how manage named ranges and objects.

Lesson 53: Look Up Data by Using the VLOOKUP Function (9m 16s)

The VLOOKUP function can be used to find and return a value vertically in a range of data. In this lesson we will explore the VLOOKUP function, and how to use it.

Lesson 54: Look Up Data by Using the HLOOKUP Function (5m 31s)

The HLOOKUP function can be used to find and return a value horizontally in a range of data. In this lesson we will explore the HLOOKUP function, and how to use it.

Lesson 55: Look Up Data by Using the MATCH Function (5m 28s)

The MATCH function can be used to match and return a value a specified value in a range of data. In this lesson we will explore the MATCH function, and how to use it.

Lesson 56: Look Up Data by Using the INDEX Function (7m 22s)

The INDEX function can return a value based on location criteria that we specify. In this lesson we will explore the INDEX function, and how to use it.