Working with Excel Tables in Excel 2019 for Windows
Excel 2019 (Windows)
| Intermediate
- 6 videos | 18m 48s
- Includes Assessment
- Earns a Badge
- CPE
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.
WHAT YOU WILL LEARN
-
Convert a data range into a table
Manipulate data in a table
Use table styles -
Configure a table
Use slicers in tables
Format slicers
IN THIS COURSE
-
3m 22sStandard 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 26sOnce 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
-
3. Using table styles in Excel 2019 for Windows3m 12sThe 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
-
4. Configuring a table in Excel 2019 for Windows2m 31sExcel 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
-
5. Using slicers in tables in Excel 2019 for Windows2m 34sSlicers 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
-
6. Formatting slicers in Excel 2019 for Windows3m 44sSlicers 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
EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE
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.
