Working with tables in Excel 365

Excel Microsoft 365 (2021)    |    Beginner
  • 11 Videos | 1h 1m 6s
  • Includes Assessment
  • Earns a Badge
  • Certification CPE
  • Certification PMI PDU
Likes 11 Likes 11
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 course
    create a table in Excel 365
    create a table from a range in Excel 365
    transpose a data range in Excel 365
    apply table styles in Excel 365
    configure the table design in Excel 365
  • format tables in Excel 365
    use slicers in tables in Excel 365
    format slicers in Excel 365
    add subtotals to data tables in Excel 365
    manipulate table data in Excel 365

IN THIS COURSE

  • Playable
    1. 
    Course Overview: Working with tables in Excel 365
    52s
    UP NEXT
  • Playable
    2. 
    Creating a table
    3m 27s
  • Locked
    3. 
    Creating a table from a range
    5m 8s
    FREE ACCESS
  • Locked
    4. 
    Transposing a data range
    3m 32s
    FREE ACCESS
  • Locked
    5. 
    Applying table styles
    4m 3s
    FREE ACCESS
  • Locked
    6. 
    Configuring the table design
    4m 33s
    FREE ACCESS
  • Locked
    7. 
    Formatting your table
    5m 52s
    FREE ACCESS
  • Locked
    8. 
    Using slicers in tables
    4m 8s
    FREE ACCESS
  • Locked
    9. 
    Formatting slicers
    5m 20s
    FREE ACCESS
  • Locked
    10. 
    Adding subtotals to data tables
    5m 12s
    FREE ACCESS
  • Locked
    11. 
    Manipulating table data
    4m
    FREE ACCESS

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

COURSE Tableau for Data Visualization: Introduction
Likes 16 Likes 16  
COURSE Enhancing Data Visualizations in Tableau Desktop
Likes 44 Likes 44  
COURSE Inserting PivotTables
Likes 238 Likes 238