Working with tables in Excel 365

Excel Microsoft 365 (2021)    |    Beginner
  • 11 Videos | 36m 10s
  • 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
    45s
    UP NEXT
  • Playable
    2. 
    Creating a table
    2m 39s
  • Locked
    3. 
    Creating a table from a range
    3m 59s
    FREE ACCESS
  • Locked
    4. 
    Transposing a data range
    2m 42s
    FREE ACCESS
  • Locked
    5. 
    Applying table styles
    3m 3s
    FREE ACCESS
  • Locked
    6. 
    Configuring the table design
    3m 27s
    FREE ACCESS
  • Locked
    7. 
    Formatting your table
    4m 36s
    FREE ACCESS
  • Locked
    8. 
    Using slicers in tables
    3m 19s
    FREE ACCESS
  • Locked
    9. 
    Formatting slicers
    4m 8s
    FREE ACCESS
  • Locked
    10. 
    Adding subtotals to data tables
    4m 12s
    FREE ACCESS
  • Locked
    11. 
    Manipulating table data
    3m 21s
    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 Creating Charts & Graphics
Likes 159 Likes 159  
COURSE Tableau for Data Visualization: Introduction
Likes 16 Likes 16  
COURSE Referencing data in Excel 365