Working with Excel Tables
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 tablemanipulate data in a tableuse table styles
-
configure a tableuse slicers in tablesformat slicers
IN THIS COURSE
-
1.Creating a table3m 22sUP NEXT
-
2.Manipulating data in a table3m 26s
-
3.Using table styles3m 12s
-
4.Configuring a table2m 31s
-
5.Using slicers in tables2m 34s
-
6.Formatting slicers3m 44s
EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE
Skillsoft is providing you the opportunity to earn a digital badge upon successful completion of this course, which can be shared on any social network or business platform
Digital badges are yours to keep, forever.