Lesson 1: Getting Started (4m 51s)

In this lesson we will talk about what Excel is, and what it is used for. We’ll also begin to explore the interface and how to use it.

Lesson 2: The Ribbon (3m 1s)

The Ribbon is where we will find all of our commands in Excel. We’ll examine the Ribbon and briefly take a look at each tab, and also how to hide or display it.

Lesson 3: Ribbon Tabs: Home (2m 30s)

The Home Tab of The Ribbon is where we will find the most commonly used commands in Excel and we will briefly explore it in this lesson.

Lesson 4: Ribbon Tabs: Insert (1m 59s)

The Insert Tab contains options for adding things like charts, tables and PivotTables, in this lesson we will look at the different sections and see what some of those options are.

Lesson 5: Ribbon Tabs: Page Layout (1m 38s)

The options on the Page Layout Tab help you to arrange, visualize and prepare to print worksheets and we will view some of those options in this lesson.

Lesson 6: Ribbon Tabs: Formulas (1m 50s)

The Formula Tab is where we go to find all of the functions available in Excel. We will take a look at where to find them and some additional features to help you troubleshoot errors in your formulas.

Lesson 7: Ribbon Tabs: Data (1m 56s)

The Data Tab will assist you in connecting and importing data from external sources into Excel, it also contains many other tools that help you work with and analyze data.

Lesson 8: Ribbon Tabs: Review (1m 46s)

The Review Tab is where you will find tools to help you review, comment on, protect, translate and spell check your Excel worksheets. We’ll see how to access these and other options in this lesson.

Lesson 9: Ribbon Tabs: View (1m 31s)

The options on the View Tab will help you to view your worksheets in different ways, and in this lesson, we will see what those options are.

Lesson 10: Ribbon Tabs: Help (0m 55s)

The Help Tab gives us resources to help with Excel, and we will see what those are in this lesson.

Lesson 11: The Quick Access Toolbar (2m 29s)

The Quick Access Toolbar gives us a place to add shortcuts to the features that we use most often. In this clip we will explore how to add and remove those shortcuts.

Lesson 12: Backstage View (1m 38s)

Like The Ribbon, the Backstage View is a place to find options, features and other functions like printing and exporting. This clip will take a look at how to access those options.

Lesson 13: Backstage View: Info Option (1m 28s)

The Info Option gives us information about the open workbook, and tools for managing it. We’ll see this and other options in this clip.

Lesson 14: Backstage View: New Option (1m 34s)

The New Option is where we go to create new workbooks and access workbook templates. We’ll explore these things in this video.

Lesson 15: Backstage View: Open Option (2m 0s)

The Open Option is a place where you can open existing Excel workbooks and this clip will show us how to do that.

Lesson 16: Backstage View: Save and Save As Options (1m 53s)

Save and Save As can be confusing, in this lesson we will talk about the differences, and using those Backstage options.

Lesson 17: Backstage View: Print Option (1m 29s)

In this lesson we explore the different options available on the Print Option of the Backstage View.

Lesson 18: Backstage View: Share Option (1m 25s)

The Share Option gives us ways to share Excel Workbooks with other people in your organization and externally, we will look at these in this clip.

Lesson 19: Backstage View: Export Option (1m 2s)

In this lesson we will look at how we can export an Excel workbook as different file formats such as a .PDF using the tools on the Export Options Backstage view.

Lesson 20: Backstage View: Publish Option (0m 40s)

The Publish Option page gives us options for publishing Excel data to Power BI, in this lesson we will take a brief look at those.

Lesson 21: Backstage View: Close Option (0m 50s)

The Close Option allows us to close an Excel Workbook while leaving Excel open, we will see how this is done in this lesson.

Lesson 22: Backstage View: Account Option (1m 31s)

This area of the Backstage View gives us information about which, if any, Microsoft services we are connected to and about our version of Office. We explore these options in this lesson.

Lesson 23: Backstage View: Options Option (3m 19s)

The Options Option provides you with opportunities to change many of the settings having to do with the way Excel works. We will get a quick overview of the type of things you will find here in this lesson.

Lesson 24: Backstage View: Feedback Option (0m 39s)

In this lesson we will look at the Feedback Option where we can give input about our experiences with Excel.

Lesson 25: The Mini Toolbar (1m 33s)

In this lesson we will work with the Mini Toolbar, a wonderful tool that gives us many of the most common formatting options with a simple with a simple right click.

Lesson 26: Navigating Worksheets (3m 12s)

In this lesson we review how to move around in an Excel worksheet.

Lesson 27: Navigating to Named Elements (3m 46s)

Excel makes it easy for us to find named elements like tables, ranges, charts and cells. We’ll see how to navigate to those in this clip.

Lesson 28: Adding and Deleting Worksheets (2m 55s)

In this lesson we see how to add and delete worksheets in Excel.

Lesson 29: Naming Worksheets (1m 29s)

We can name worksheets in Excel and we will see how that is accomplished in this lesson.

Lesson 30: Entering and Editing Data (3m 54s)

This lesson will show you how to manually enter data into Excel and how to edit it.

Lesson 31: Selecting Data (4m 0s)

In this lesson we see different methods to select groups of data in Excel.

Lesson 32: Selecting Multiple Ranges of Non-Adjacent Data (3m 0s)

It is sometimes necessary to select non-adjacent data In Excel and we will see how that is done in the lesson.

Lesson 33: Searching for Data (4m 55s)

In this lesson we will use the Find tool to search for data in our Excel workbook.

Lesson 34: Cut, Copy, Paste (4m 22s)

Being able to copy and move data in Excel is a great feature, and in this lesson, we will see how to do that.

Lesson 35: Undo, Redo (2m 48s)

Everybody makes mistakes, in this lesson we will see how Excel can help us undo, and if necessary, redo our previous actions in Excel.

Lesson 36: Paste Options (4m 37s)

When pasting data into Excel, you may want to change the properties of that data. Excel gives us options to change how that data gets pasted, we will explore those options in this lesson.

Lesson 37: Inserting Rows and Columns (2m 39s)

In this lesson we will see how to insert additional rows and columns into an Excel worksheet.

Lesson 38: Changing the Width of a Column (2m 32s)

Data comes in all kinds of widths and in this lesson, we see how to change the width of our columns in Excel to accommodate that data.

Lesson 39: Changing the Height of a Row (3m 1s)

In this video we watch how to change the height of a row in Excel.

Lesson 40: Hiding and Unhiding Columns or Rows (1m 50s)

This lesson examines how to hide and un-hide rows and columns.

Lesson 41: Number, Currency, and Accounting Formats (4m 36s)

We can format the data in Excel in many ways. In this lesson we will show how to use the number, currency and accounting formats.

Lesson 42: Percentage Formatting (2m 13s)

This lesson will show how to apply the percentage format to numbers in Excel.

Lesson 43: Date Formatting (2m 52s)

In this lesson we look at using different types of date formatting in Excel.

Lesson 44: Using Autofill and the Fill Handle (3m 2s)

Autofill is a wonderful tool in Excel and in this video, we will see what it does and how to use it.

Lesson 45: Auto Fill Options (2m 30s)

There are many ways to use Autofill and several different options. In this lesson we will explore those options.

Lesson 46: Using Flash Fill (2m 5s)

Flash Fill can detect patterns and predict the most likely way you want to use to fill in data. In this lesson we will see how to use Flash Fill.

Lesson 47: Working with AutoSum (5m 10s)

AutoSum makes totaling columns of numbers fast and easy and we will see how in this lesson.

Lesson 48: Using Auto Fill with Formulas (1m 53s)

Autofill can be used to copy and fill formulas in your worksheets. We will explore the many ways autofill can save you time and effort in this clip.

Lesson 49: Using Other Auto Options (2m 25s)

There are other auto options in Excel besides AutoSum like, AutoAverage and we will see these options in this lesson.

Lesson 50: Working with Auto Calculate (2m 33s)

The Auto calculate feature in Excel can total, average, and many other things without having to create formulas or add the results to your worksheet. See those options in this lesson.

Lesson 51: Using Save and Save As (2m 40s)

This lesson explores how to save workbook and use Save As to save a copy in a different place or with a different name.

Lesson 52: Working with File Formats (2m 57s)

We will look at the different file formats that an Excel workbook can be saved as in this lesson.