Working with Excel Tables

Excel 2019 (Windows)    |    Intermediate
  • 6 Videos | 18m 48s
  • Includes Assessment
  • Earns a Badge
  • Certification CPE
Likes 351 Likes 351
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

  • Playable
    1. 
    Creating a table
    3m 22s
    UP NEXT
  • Playable
    2. 
    Manipulating data in a table
    3m 26s
  • Locked
    3. 
    Using table styles
    3m 12s
  • Locked
    4. 
    Configuring a table
    2m 31s
  • Locked
    5. 
    Using slicers in tables
    2m 34s
  • Locked
    6. 
    Formatting slicers
    3m 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.

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 231 Likes 231  
Likes 40 Likes 40