Excel 2013 Tables, Filters & Functions

53 CQ
17 Lessons
Course Info
Previous...
  • Playing
    3 CQ
    6. The Concatenate Function in Excel 2013
    A lesson with SONIC Performance Support
    View lesson

    To improve the readability of text in Excel, you'll have to combine multiple cells into one with concatenate. Learn how to use this function in this lesson.

    The Concatenate Function in Excel 2013
    with SONIC Performance Support

    To improve the readability of text in Excel, you'll have to combine multiple cells into one with concatenate. Learn how to use this function in this lesson.

  • Playing
    3 CQ
    7. VLOOKUP & HLOOKUP in Excel 2013
    A lesson with SONIC Performance Support
    View lesson

    Learn about Excel's VLOOKUP and HLOOKUP functions, and see how to use the powerful VLOOKUP function to find data based on very specific criteria.

    VLOOKUP & HLOOKUP in Excel 2013
    with SONIC Performance Support

    Learn about Excel's VLOOKUP and HLOOKUP functions, and see how to use the powerful VLOOKUP function to find data based on very specific criteria.

  • Playing
    3 CQ
    8. Creating Tables in Excel 2013
    A lesson with SONIC Performance Support
    View lesson

    This lesson demonstrates the steps of turning raw data into a table in Microsoft Excel, and how to modify and customize the table with different styles.

    Creating Tables in Excel 2013
    with SONIC Performance Support

    This lesson demonstrates the steps of turning raw data into a table in Microsoft Excel, and how to modify and customize the table with different styles.

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

    Want to view your data from lowest to highest, or vice versa? In this lesson, learn how to use Excel's sort feature to arrange data according to your needs.

    Sorting Data in Excel 2013
    with SONIC Performance Support

    Want to view your data from lowest to highest, or vice versa? In this lesson, learn how to use Excel's sort feature to arrange data according to your needs.

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

    By filtering data, you can remove from view any data that does not meet certain criteria. In this lesson, learn how to use Excel's powerful AutoFilter tool.

    The AutoFilter in Excel 2013
    with SONIC Performance Support

    By filtering data, you can remove from view any data that does not meet certain criteria. In this lesson, learn how to use Excel's powerful AutoFilter tool.

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