Working with tables in Excel 365

Excel Microsoft 365 (2021)    |    Beginner
  • 11 Videos | 36m 10s
  • Includes Assessment
  • Earns a Badge
  • Certification CPE
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. In order to practice what you have learned, you will find practice exercises and samples in the Resources section.

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 Ten common tools in Excel 365
Likes 1 Likes 1  
COURSE Adding & arranging data in Excel 365
Likes 13 Likes 13  
COURSE Complete Guide to Excel 365: Pivot, PowerPivot, & Financial Modeling
Likes 60 Likes 60  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

COURSE Adding & arranging data in Excel 365
Likes 13 Likes 13  
COURSE New Project Manager Essentials
Likes 1086 Likes 1086  
COURSE Analyzing Data with Tables & Charts in Google Sheets 2020
Likes 7 Likes 7