Learn how to use the Watch Window dialog, which allows you to keep both cells and formulas visible for monitoring the effects of any worksheet changes.

When working with complex formulas, small errors can easily go undetected. In this lesson, learn how to use the Evaluate Formula feature to debug your formulas.

Looking for an easy way to visually represent data? In this lesson, see how to create and edit sparklines in Excel 2013 to illustrate data trends over time.

Merging Excel workbooks manually is both tedious and error prone. In this lesson, learn how to use Excel's automated process for flawless workbook merging.

In this lesson, Jillian shows you how to apply the data consolidation tool in Excel to combine several different data ranges into a single location.

Web queries allow you to add automatically updating web data in Excel. In this lesson, learn how to create a web query and how to set up its properties.

Need to know the basics of the VLOOKUP function in Microsoft Excel? In this lesson, learn how to use VLOOKUP exact match and approximate match.

In this Excel spreadsheets lesson, get an explanation of the match and index functions before learning practical, everyday examples for using both functions.

In this Excel spreadsheets lesson, learn how to combine the VLOOKUP function with the MATCH function to create a more dynamic and robust formula.

In this advanced Excel or Google Sheets lesson, learn how to perform a lookup that returns values from the left by combining INDEX and MATCH.