Working with Excel Tables

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

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.

YOU MIGHT ALSO LIKE

Likes 36 Likes 36  
Likes 84 Likes 84  
Likes 32 Likes 32  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 176 Likes 176  
Likes 146 Likes 146  
Likes 279 Likes 279