Inside Excel - Learn 23 Essential Excel Skills the Pros Know

The status bar is very underused. Many Excel users don't even know it exists. In this lecture you'll learn how to use the status bar to do lightening fast calculations on whatever data you have selected in your worksheet.

Inserting row after row while entering data can get really old. Here is a quick tip on how to insert multiple rows to save you time.

Sometimes you don't want to have to look at everything in your Excel workbook. Here's an easy way to hide rows, columns and even entire worksheets in Excel.

You want to be able to see your column headings even when you scroll down to row 1,542. In this lecture you'll learn how to do that quickly and easily using freeze pane.

Sorting and filtering is one of the simplest, yet most powerful ways to manipulate your data. This lecture will show you how the pros do it.

You don't have time to hand type monotonous data into every cell. If there is a pattern, use flash fill and auto fill to do the hard work for you. When you're finished with this lecture, you'll be able to fill out the days of the week, dates, or months with just a few clicks of the keyboard and mouse.

If you want to work faster, shortcut keystrokes are your answer. Learn the ones that you'll use the most and you can cut your work time by more than half in many cases.

The ALT key has it's own huge set of shortcuts. Learn how to use this simple and intuitive process and you can drastically increase your work speed.

Copying formulas to different cells can be a nightmare when your cell references keep changing, too. Understanding the difference between absolute and relative cell references can mean all the difference.

Paste is so much more than copying and pasting. By using paste special to it's fullest extent, you can manipulate formulas, formatting, even column widths with the click of a button.

Conditional formatting is like sorting and filtering on steroids. Add colors and graphics to make your sorts stand out. In this lecture you'll learn how to harness the power of conditional formatting.

Printing can be really frustrating when your Excel workbook is not set up right. You go to print one little spreadsheet and 10 pages come out of the printer. When you're finished with this lecture, you'll be able to avoid these kinds of little frustrations and print like a boss.

Empty, but active, cells in your worksheet can cause all kinds of mischief. When you're finished with this lecture, you'll be able to hunt them down and delete them, saving yourself potential headaches.

When is comes to money, there's nothing worse than doing a calculation and coming up with the "wrong" answer. But, if you don't pay attention to your decimals, this can happen. In this lecture, learn how to use rounding to prevent those money math errors.

INDEX and MATCH can be difficult to learn, but they are a powerful combination. Used together with an array, they can do everything that VLOOKUP can, plus you can put in additional variables to make more powerful calculations.

While it's technically a Microsoft Word tool, mail merge is something that almost every office worker should know how to do. In this lecture, you'll learn how to organize your data in Excel to make mail merge more effective. And you'll learn how to actually do a mail merge for letters and envelopes.

Download this file to follow along with the pivot table lectures below.

Before you create a pivot table, you have to be sure that your data is set up properly. In this lecture you'll learn basic rules for preparing your data before you turn it into a pivot table.

Now the fun begins. It seems like a lot of people are intimidated by pivot tables. The have lots of moving parts, it's true. But, by the time you're done with this lecture, you'll be able to create your own pivot tables for powerful calculations.

Now lets get into some real examples of how you can use a pivot table to do work in Excel.

Download this file to follow along with the Pivot Charts lecture below.

Pivot charts are the visual representation of pivot tables. In this lecture you'll learn how to create pivot charts from your data.