Microsoft Excel: Quick Start

A quick preview of the parts of the Excel interface.

Learn about the components of the Excel title bar.

See how to use Microsoft Excel's File command and Backstage View to perform tasks, including opening, saving, and printing Excel files.

Find out what Microsoft Excel's command ribbon is and how to use it.

Review the various types of Excel command icons and learn how to use them.

Learn about what the Microsoft Excel Name Box tells you about a selected cell or range. Also, get your first glimpse at the Excel Formula Bar.

Get details about the Excel file, known as a workbook, and the worksheets within an Excel workbook.

Find out what the Excel status bar has to offer, including information about the workbook's state, calculation results from the data in selected cells, and view options.

Learn about entering numbers and text into an Excel worksheet. You'll also learn about how to handle some special data and how to cancel an entry.

Find out how to make changes to the data in a Microsoft Excel worksheet.

Learn how to move data in a Microsoft Excel worksheet. Also, learn about what happens when you attempt to move data to an area where there is already some data.

Learn how to copy data in a Microsoft Excel worksheet.

Learn how to clear out unwanted data from your worksheet.

Learn how to delete data from a Microsoft Excel worksheet and how deleting data differs from clearing data.

Learn how to use Microsoft Excel's Paste Special command to make copies of data, formulas, formats, and more.

Learn how to expand data in your worksheet with the Excel AutoFill feature.

In this exercise, you will practice what you have learned in the Entering and Changing Data section of the course.

In this video, I'll review the Practice Exercise for Entering and Changing Data. You'll get to see how I completed the exercise. And I'll show you some different ways of doing things and some shortcuts.

Learn how to use Microsoft Excel formatting features to change the font type, font size, text color, and fill color within a worksheet.

Learn how to use Microsoft Excel's border styles and colors to make your worksheets easier to read and more appealing.

Find out what Microsoft Excel's Format Painter is and how to use it to quickly apply formats from one cell to another.

Learn all about Excel's cell alignment options including horizontal and vertical alignment, indentation, and text orientation.

Learn about Microsoft Excel's various number formats and take a look at the Number tab within the Format Cells dialog box.

Find out what happens when text is too wide for a cell in Excel and how to use Microsoft Excel's Wrap Text feature to improve the appearance of your text.

Learn how to use Microsoft Excel's Merge features to improve the readability of text in your worksheets.

Learn how to use Microsoft Excel's Freeze Panes features to keep portions of your worksheet's content visible at all times, even when you scroll down or across your worksheets.

In this exercise, you will practice what you have learned in the Formatting section of the course.

In this video, I'll review the Practice Exercise for Formatting Data. You'll get to see how I completed the exercise. And I'll show you some different ways of doing things and some shortcuts.

Learn what Microsoft Excel formulas are and the basic format of formulas.

Learn about Microsoft Excel cell references and how to use them within a formula.

Learn about the arithmetic and comparison operators you can use in Excel. Also, learn how to combine multiple pieces of text with the Excel concatenation operator.

Learn how to move Excel formulas around in a worksheet and understand what happens to formulas when they are moved.

Learn about the three types of Microsoft Excel cell references: relative, static (absolute), and mixed.

Learn how to copy Microsoft Excel formulas within a worksheet and how the different cell reference types impact the copied formulas.

See more examples of how to copy relative and static Excel formulas.

In this exercise, you will practice what you have learned in the Creating Formulas section of the course.

In this video, I'll review the Practice Exercise for Creating Formulas. You'll get to see how I completed the exercise. And I'll show you some different ways of doing things and some shortcuts.

Get an introduction to Microsoft Excel's built-in functions. Learn about what Excel functions are, how to use them, the parts of a function, and how to pass data to functions.

Learn how to use Microsoft Excel's SUM function to add numeric values together.

Learn how to use Microsoft Excel's Insert Function and Function Arguments dialog boxes to get help with adding and updating Excel functions within your worksheet.

Learn how to use Microsoft Excel's AutoSum feature to quickly add SUM, AVERAGE, COUNT, MIN, and MAX functions to your Excel worksheets.

Learn how to use Microsoft Excel's COUNT, COUNTA, and COUNTBLANK functions and understand their differences.

Learn about some of Microsoft Excel's text functions, including LEFT, RIGHT, MID, LOWER, and UPPER.

Learn how to extend the power of Microsoft Excel's functions by using more than one function in a formula.

See some of Excel's functions you've learned about in action when we use them in a Product List worksheet.

In this exercise, you will practice what you have learned in the Working with Functions section of the course.

In this video, I'll review the Practice Exercise for Working with Functions. You'll get to see how I completed the exercise. And I'll show you some different ways of doing things and some shortcuts.

Find out what Microsoft Excel Tables are and some of the advantages of using them.

Learn how to convert an existing range of cells into an Excel Table.

Learn how to apply Excel table styles to an existing table.

Learn about the Microsoft Excel Table Style Options and what each one does.

Learn how to add totals to an Excel table and learn about the different functions that you can use within a table's total cells.

Learn how to add formulas to Excel tables and the advantages table formulas give you over formulas in normal cells.

Learn how to expand an Excel table by adding more rows or columns to it.

Learn how to remove unwanted rows or columns from an Excel table.

Learn some shortcuts for adding rows and columns to an Excel table.

In this exercise, you will practice what you have learned in the Designing Tables section of the course.

In this video, I'll review the Practice Exercise for Designing Tables. You'll get to see how I completed the exercise. And I'll show you some different ways of doing things and some shortcuts.

Get an introduction to sorting data in Microsoft Excel.

Learn how to use Microsoft Excel's quick sorting commands: Sort Ascending and Sort Descending.

Learn how to use Excel's Sort command to get more control over how Excel sorts your data.

Learn how to sort on multiple columns in Excel. Also, learn how to change the Sort Order and remove columns from the sorting criteria of your Excel worksheets.

In this exercise, you will practice what you have learned in the Sorting Data section of the course.

In this video, I'll review the Practice Exercise for Sorting Data. You'll get to see how I completed the exercise. And I'll show you some different ways of doing things and some shortcuts.

Learn about Excel's filtering capabilities and how they can help you limit the data you see in your worksheets.

Learn about how to apply filters in Excel by using the list of unique values in a column.

Learn how to use Microsoft Excel's number filtering capabilities.

Learn how to use Microsoft Excel's text filtering capabilities.

Learn how to filter Excel data on multiple columns within your worksheet.

Learn how to use Microsoft Excel's Reapply Filter command to update a filtered view after new data has been added to a worksheet.

In this exercise, you will practice what you have learned in the Filtering Data section of the course.

In this video, I'll review the Practice Exercise for Filtering Data. You'll get to see how I completed the exercise. And I'll show you some different ways of doing things and some shortcuts.

Introduction to using multiple worksheets in Microsoft Excel.

Learn how to add, move, and rename worksheets in an Excel workbook.

Learn how to group Microsoft Excel worksheets so that you can update them all simultaneously. Also, learn how to ungroup worksheets.

Learn how to add the same data to multiple Excel worksheets at one time.

Learn how to format multiple Excel worksheets at once to keep formatting consistent between them.

Learn how to select multiple Excel worksheets and update them all at once with the same formulas to save time and cut down on errors.

Learn how to create Microsoft Excel formulas in a worksheet that references cells in another worksheets.

In this exercise, you will practice what you have learned in the Using Multiple Worksheets section of the course.

In this video, I'll review the Practice Exercise for Using Multiple Worksheets. You'll get to see how I completed the exercise. And I'll show you some different ways of doing things and some shortcuts.