0:00 / 4:54
 
 
 

Excel 2013 Tables, Filters & Functions

53 CQ
17 Lessons
Course Info
  • Playing
    Free
    4 CQ
    1. Descriptive Range Names in Excel 2013
    A lesson with SONIC Performance Support
    View lesson

    Learn how to create concise and descriptive range names for improving the readability and maintainability of formulas and functions in Excel 2013.

    Descriptive Range Names in Excel 2013
    with SONIC Performance Support

    Learn how to create concise and descriptive range names for improving the readability and maintainability of formulas and functions in Excel 2013.

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

    Range names are key to keeping your data organized and readable in Excel. In this lesson, learn how to use the Name Manager to edit cell range names.

    The Name Manager in Excel 2013
    with SONIC Performance Support

    Range names are key to keeping your data organized and readable in Excel. In this lesson, learn how to use the Name Manager to edit cell range names.

  • Playing
    4 CQ
    3. Range Names in Formulas in Excel 2013
    A lesson with SONIC Performance Support
    View lesson

    In this lesson, learn how to improve your Excel workbook readability by performing calculations with range names instead of using cryptic cell addresses.

    Range Names in Formulas in Excel 2013
    with SONIC Performance Support

    In this lesson, learn how to improve your Excel workbook readability by performing calculations with range names instead of using cryptic cell addresses.

  • Playing
    3 CQ
    4. Adding Comments in Excel 2013
    A lesson with SONIC Performance Support
    View lesson

    Adding notes to worksheets can help prevent confusion when working as a team. In this lesson, learn how to create, modify, and delete comments in Excel.

    Adding Comments in Excel 2013
    with SONIC Performance Support

    Adding notes to worksheets can help prevent confusion when working as a team. In this lesson, learn how to create, modify, and delete comments in Excel.

  • Playing
    4 CQ
    5. Count Functions in Excel 2013
    A lesson with SONIC Performance Support
    View lesson

    Counting can be surprisingly tricky in Excel if you don't know which function to use. In this lesson, learn about the COUNT, COUNTA, and COUNTIF functions.

    Count Functions in Excel 2013
    with SONIC Performance Support

    Counting can be surprisingly tricky in Excel if you don't know which function to use. In this lesson, learn about the COUNT, COUNTA, and COUNTIF functions.

More...