Working with Excel Tables
Excel Microsoft 365 (Windows)
6 Videos | 23m 58s
- Includes Assessment
- Earns a Badge
Explore how to use tables in Excel for Office 365 to manage, analyze, and manipulate data in a range, in this 6-video course, which demonstrates how to convert data ranges into a table, giving you greater control over data, and provides more tools for manipulating the data. You will learn how to create calculated columns to perform automated calculations, quickly clean up your data with a sweep, and transform your data into a PivotTable. Next, learn how to use the Table Design tab to change the appearance of your data. This course demonstrates how to use Excel's standard styles, how to create a custom style, and set it as the default. You will also learn how to use the Table Design tab to improve legibility with banded columns and rows, add total row calculations to add summaries to your data, and show or hide the filter buttons. Finally, this course demonstrates how to use slicers to filter and manipulate data.
WHAT YOU WILL LEARN
convert a data range into an Excel table and edits its contentsperform calculations and manipulate data in an Excel tableuse the formatting tools and styles to change the appearance of a table
customize the table settings and toolsuse slicers to filter data in an Excel tableresize and format a slicer
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 platformDigital badges are yours to keep, forever.
YOU MIGHT ALSO LIKE
COURSE Getting started in Excel 365