If it’s been a while since you’ve used Excel or if you just learned the fundamentals, this lesson gives you a short review of the basics.

Add and subtract numbers on a simple worksheet. Learn how to save time with the AutoFill feature.

Excel has over 400 built-in functions. This lesson shows you the starting point for how they all work.

Usually, you want Excel to rewrite your formulas when you copy and paste and move data around. Learn how to prevent that from happening when the need arises.

These are Excel's basic, core functions. You should know these.

It's often a good idea to assign friendly names to ranges of data. This makes it easier to write and modify formulas and to select large ranges of cells.

Calculating averages manually can lead to incorrect results. Learn how to use a function that gets it right.

In a range of cells, find the highest and lowest numbers, and count how many there are.

Learn the functions and formulas to calculate and manipulate dates and time.

Undocumented unofficial function that finds the difference between two dates.

We'll show you how to write formulas that can span multiple worksheets and even multiple workbooks.

These functions are not linear. The values they return depend on conditions elsewhere.

Use the IF function when you want the value of one cell to depend on the value of another cell.

Combine the SUM and AVERAGE functions with the decision making ability of the IF function.

Evaluate several criteria at once without complicated formula nesting.

Find the highest or lowest number in a range based on a value that you specify.

Like the name sounds, Sumproduct will add and multiply in one step. This can reduce the number of columns in a large worksheet.

Use functions that calculate exponents, square roots, common, natural and any-base logarithms.

Learn how to calculate four common statistical functions.

Plug in the amount you're borrowing, the interest rate and payback period to find out how much the payments will be.

Is an investment worth the money? Use a net present value calculation to help you decide.

Use a function to make the worksheet display helpful messages instead of errors.

Excel has a lot of powerful features that let you use it like a database.

Not all worksheets are tables. Tables are objects you create that have data handling features.

You can sort one category inside another, as many levels as you want.

Have filtered data extracted to another location.

Use the Filter function to filter data dynamically.

Sort data by any field using the Sort function. Sort by a non-displaying field using the Sortby function.

Xlookup lets you query a data set like it's a database. This function replaces the Vlookup and Hlookup functions in older versions of Excel.

Excel has a bunch of functions specifically to run on small databases. They kind of work like Lookup and If functions, but they have one small advantage over them.

The VLOOKUP and HLOOKUP functions have been replaced by the superior XLOOKUP function in the previous video. This video is here in case you need to edit an existing VLOOKUP.

You will learn methods of gaining insight into data, comparing data, and examining how data might be different.

Look at multiple possibilities of formula results.

Excel can automatically change cell formatting when values change. This feature is called Conditional Formatting, and you can use it to highlight cells when the value goes above or below or between certain values, or Excel can automatically compare cells with each other.

Create a list of unique values in a dataset.

See where the results are that data feed into and which data contribute to results.

Analyze and summarize large amounts of transactional data.

Create a Pivot Table that uses several tables as the source data.

If you're making or receiving regular payments like an auto loan or rental income, you can figure out what today's value is of all those payments into the future. That's called Present Value.

Excel has many ways of identifying, adding, removing and modifying content. In this section, we look at several powerful techniques.

Learn techniques of moving data in and out of Excel.

Connect to data tables on websites that can update worksheets automatically.

How to remove duplicate data from a worksheet.

Make changes to data based on content or character position.

Rotate columns into rows and rows into columns.

Create comma separated values (CSV) inside Excel, rather than having to export to a file.

You might have a datasheet that isn’t arranged the way you want. Maybe you want to push rows or columns around or stack data that’s spread out. There are 6 functions that will do that for you. But you only have to learn 3 of them because they come in pairs — one for columns and one for rows.

Use some of Excel's powerful functions for manipulating text… and learn how to cheat!

These functions make it easier to separate text. They replace long, complicated formulas.

When you have a lot of data and want to keep most of it but just eliminate some, or keep just some and eliminate the rest, these functions do it simply. They replace old, complicated formulas.

This is a method of extracting several rows at the top or at the bottom of a list.

Learn how to add special objects to worksheets to make them shine.

Use a function to insert links. It's a dynamic alternative to using the Insert Hyperlink command on the ribbon bar and especially useful if you have a lot of them to insert.

Insert images from web links dynamically. Useful if you have a lot of images to place. (No class file for this video. Use an empty sheet.)

At last! You don't need complicated Visual Basic programming to insert simple checkboxes on a sheet. And you can format them.

Excel has great charting features, and much of the controls and formatting work the same in each one, making them faster to learn.

Column charts are useful for comparing multiple component data over time or with each other.

Pie charts are the most common way of displaying parts of a whole. They have pretty nice featues in Excel.

A bubble chart lets you sneak a third dimension into a two-dimentional chart. You get X and Y axes plus bubble size.

Combination charts let you create two charts, one overlaying the other. This lets you show a comparison between data that wouldn't be easy to compare otherwise.

Use map charts when you have data with geographic information, like sales by state or country.

Sparklines are tiny, little charts that go inside cells. They're great for showing individual trends for rows of data.