Excel 2013 Tables, Filters & Functions

53 CQ
17 Lessons
Previous...
  • Playing
    3 CQ
    11. The Advanced Filter in Excel 2013
    A lesson with SONIC Performance Support
    View lesson

    Learn how to use the Advanced Filter dialog in Excel, which allows you to create complex data filters with a variety of user-defined conditions.

    Learn how to use the Advanced Filter dialog in Excel, which allows you to create complex data filters with a variety of user-defined conditions.

  • Playing
    3 CQ
    12. Total Row Calculations in Excel 2013
    A lesson with SONIC Performance Support
    View lesson

    With the Total Row tool, you can indicate what type of summary calculation you’re looking for in your table. Learn how to add Total Rows in this lesson!

    With the Total Row tool, you can indicate what type of summary calculation you’re looking for in your table. Learn how to add Total Rows in this lesson!

  • Playing
    2 CQ
    13. Removing Duplicates in Excel 2013
    A lesson with SONIC Performance Support
    View lesson

    You don't have to remove duplicate data by hand! In this lesson, learn how to use Excel's duplicate identification and deletion function to clean your data.

    You don't have to remove duplicate data by hand! In this lesson, learn how to use Excel's duplicate identification and deletion function to clean your data.

  • Playing
    4 CQ
    14. Intro to Pivot Tables in Excel 2013
    A lesson with SONIC Performance Support
    View lesson

    A pivot table is a dynamic table that enables you to reposition columns and rows of raw data. Learn pivot table basics in Excel 2013 to get started!

    A pivot table is a dynamic table that enables you to reposition columns and rows of raw data. Learn pivot table basics in Excel 2013 to get started!

  • Playing
    4 CQ
    15. Pivot Table Sorting in Excel 2013
    A lesson with SONIC Performance Support
    View lesson

    In this lesson, learn how to adjust your field settings and apply sorting options to your Excel Pivot Table to help understand your data even better.

    In this lesson, learn how to adjust your field settings and apply sorting options to your Excel Pivot Table to help understand your data even better.

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