0:00 / 4:54
 
 
 

Excel 2013 Tables, Filters & Functions

53 CQ
17 Lessons
  • 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.

    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.

    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.

    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 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.

    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...