Working with Excel Tables in Excel 2019 for Windows

Excel 2019 (Windows)    |    Intermediate
  • 6 videos | 18m 48s
  • Includes Assessment
  • Earns a Badge
  • Certification CPE
Rating 4.4 of 1076 users Rating 4.4 of 1076 users (1076)
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. In order to practice what you have learned, you will find the Word document named Excel 2019 for Windows: Working with Excel Tables Exercise as well as the associated materials in the Resources section.


  • Convert a data range into a table
    Manipulate data in a table
    Use table styles
  • Configure a table
    Use slicers in tables
    Format slicers


  • 3m 22s
    Standard data ranges in Excel can be converted into Excel tables. Excel tables give you greater control over the information that has been inserted, and bring additional tools for working with data. FREE ACCESS
  • 3m 26s
    Once an Excel table has been inserted, you can begin working with the data more efficiently. You can use calculated columns to perform operations on data automatically, quickly perform a sweep of your data to remove duplicates, and transform your data into a PivotTable in a matter of clicks. FREE ACCESS
  • Locked
    3.  Using table styles in Excel 2019 for Windows
    3m 12s
    The formatting tools and table styles can be used to quickly change the appearance of your table. You have a wide range of standard table styles at your disposal, as well as the option to create your own custom style and set it as the default. FREE ACCESS
  • Locked
    4.  Configuring a table in Excel 2019 for Windows
    2m 31s
    Excel tables can be customized in a variety of different ways. You can use banded columns and rows to make your data more legible, add total row calculations to begin adding summaries to your data, and show and hide the filter buttons as and when you need them. FREE ACCESS
  • Locked
    5.  Using slicers in tables in Excel 2019 for Windows
    2m 34s
    Slicers can be used to filter and manipulate the data stored in an Excel table. They are a good alternative to filters as they give users a clear visual guide as to the contents being displayed in a table and their qualifying criteria. FREE ACCESS
  • Locked
    6.  Formatting slicers in Excel 2019 for Windows
    3m 44s
    Slicers are highly visual and a great way of communicating visually how data in a table is being manipulated or filtered. You can customize the appearance of your slicer, using Slicer Styles, button controls, and the resize tools. FREE ACCESS


Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.


Rating 4.9 of 7 users Rating 4.9 of 7 users (7)
Rating 4.5 of 2242 users Rating 4.5 of 2242 users (2242)
Rating 5.0 of 1 users Rating 5.0 of 1 users (1)


Rating 4.5 of 446 users Rating 4.5 of 446 users (446)
Rating 4.6 of 785 users Rating 4.6 of 785 users (785)
Rating 4.5 of 627 users Rating 4.5 of 627 users (627)