Course details

Excel 2019 for Windows: Working with Excel Tables

Excel 2019 for Windows: Working with Excel Tables


Overview/Description
Expected Duration
Lesson Objectives
Course Number
Expertise Level



Overview/Description

Excel tables are a useful tool for quickly managing, analyzing, and manipulating data in a range. Once configured as a table, you can easily sort, filter, and perform calculations on your data, as well as change its appearance and formatting. Key concepts covered in this 6-video course include how to convert a data range into an table and edit its contents, giving you greater control over the inserted information; and how to perform calculations and manipulate data in an table such as create calculated columns to perform automatic calculations on data, quickly clean up your data with a sweep, and transform your data range into a PivotTable. Learners continue by examining how tables are highly customizable, as you learn how to use formatting tools and styles to change the appearance of a table, then learn to customize the table settings and tools. Finally, you will learn how to use slicers which can be used to filter and manipulate data in a table; and how to resize and format a slicer.



Expected Duration (hours)
0.3

Lesson Objectives

Excel 2019 for Windows: Working with Excel Tables

  • convert a data range into an Excel table and edits its contents
  • perform calculations and manipulate data in an Excel table
  • use the formatting tools and styles to change the appearance of a table
  • customize the table settings and tools
  • use slicers to filter data in an Excel table
  • resize and format a slicer
  • Course Number:
    ds_msex2019_15_enus

    Expertise Level
    Intermediate