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.
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.
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.
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.
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.
- Recommended Recommended
- History & In Progress History
- Browse Library
- Most Popular Library
Get Personalized Recommendations
Let us help you figure out what to learn! By taking a short interview you’ll be able to specify your learning interests and goals, so we can recommend the perfect courses and lessons to try next.Start Interview
You don't have any lessons in your history.
Just find something that looks interesting and start learning!