Excel 2013 Advanced Data Techniques

14 CQ
6 Lessons
Previous...
  • Playing
    2 CQ
    1. The Evaluate Feature in Excel 2013
    A lesson with SONIC Performance Support
    View lesson

    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.

    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.

  • Playing
    2 CQ
    2. The Watch Window in Excel 2013
    A lesson with SONIC Performance Support
    View lesson

    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.

    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.

  • Playing
    3 CQ
    3. Sparklines in Excel 2013
    A lesson with SONIC Performance Support
    View lesson

    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.

    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.

  • Playing
    2 CQ
    4. Data Consolidation in Excel 2013
    A lesson with SONIC Performance Support
    View lesson

    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.

    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.

  • Playing
    2 CQ
    5. Merging Workbooks in Excel 2013
    A lesson with SONIC Performance Support
    View lesson

    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.

    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.

More...
  • 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!

Comments
500 characters max