Working with Excel Tables

Excel Microsoft 365 (Windows)    |    Intermediate
  • 6 Videos | 23m 58s
  • Includes Assessment
  • Earns a Badge
Likes 206 Likes 206
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 contents
    perform calculations and manipulate data in an Excel table
    use the formatting tools and styles to change the appearance of a table
  • customize the table settings and tools
    use slicers to filter data in an Excel table
    resize and format a slicer

IN THIS COURSE

  • Playable
    1. 
    Creating a table
    3m 45s
    UP NEXT
  • Playable
    2. 
    Manipulating data in a table
    3m 40s
  • Locked
    3. 
    Using table styles
    3m 50s
  • Locked
    4. 
    Configuring a table
    2m 44s
  • Locked
    5. 
    Using slicers in tables
    2m 54s
  • Locked
    6. 
    Formatting slicers
    4m 4s

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

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 238 Likes 238  
Likes 1408 Likes 1408  
Likes 229 Likes 229