Working with tables in Excel 365
Excel Microsoft 365 (2021)
| Beginner
- 11 Videos | 36m 10s
- Includes Assessment
- Earns a Badge
- CPE
- PMI PDU
Tables are a useful tool for quickly managing, analyzing, and manipulating data as a range in Excel 365. In this course, you will discover how you can easily create tables from a data range; insert borders, and change the appearance and formatting of a table. You will start by learning how to insert a table, and convert a data range into a table. In addition, you'll learn how to transpose a data range, which means inverting the columns and rows. You will see that tables are highly customizable, as you learn how to use the formatting tools and styles to change the appearance of a table. Also, see how to use the Border tool to make the data in your table stand out more. You will learn how to use slicers to filter and manipulate data in a table; and how to resize and format a slicer tile. Finally, you will explore how to add subtotals to your data tables and how to manipulate the table date in other ways.
WHAT YOU WILL LEARN
-
discover the key concepts covered in this Microsoft 365: Working with tables in Excel 365 coursecreate a table in Excel 365create a table from a range in Excel 365transpose a data range in Excel 365apply table styles in Excel 365configure the table design in Excel 365
-
format tables in Excel 365use slicers in tables in Excel 365format slicers in Excel 365add subtotals to data tables in Excel 365manipulate table data in Excel 365
IN THIS COURSE
-
1.Course Overview: Working with tables in Excel 36545sUP NEXT
-
2.Creating a table2m 39s
-
3.Creating a table from a range3m 59s
-
4.Transposing a data range2m 42s
-
5.Applying table styles3m 3s
-
6.Configuring the table design3m 27s
-
7.Formatting your table4m 36s
-
8.Using slicers in tables3m 19s
-
9.Formatting slicers4m 8s
-
10.Adding subtotals to data tables4m 12s
-
11.Manipulating table data3m 21s
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.