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

  • 45s
    This video outlines the key content covered in the Microsoft 365: Working with tables in Excel 365 course, including how to create a table from a data range, configure the tables styles and design, and how to manipulate the table data. FREE ACCESS
  • 2m 39s
    Organizing your data into tables allows you to easily format, sort, or apply filters to data. In this video, you will explore how to create a table in Excel 365. FREE ACCESS
  • Locked
    3.  Creating a table from a range
    3m 59s
    Excel 365 tables give you greater control over the information that has been inserted and provide additional tools for working with data. In this video, you will discover how to create a table from a data range. This video aligns with MOS MO-200 / Excel Associate Certification exam objectives: 3.1.1 Create Excel tables from cell ranges, 2.3.2 Name a table, and 3.1.3 Convert tables to cell ranges. FREE ACCESS
  • Locked
    4.  Transposing a data range
    2m 42s
    Transposing data allows you to invert columns and rows. In this video, explore Excel 365's transpose paste operation. FREE ACCESS
  • Locked
    5.  Applying table styles
    3m 3s
    Excel 365 has a wide array of table styles to quickly change the appearance of your table. In this video, you will discover how to apply table styles. This video aligns with MOS MO-200 / Excel Associate Certification exam objective: 3.1.2 Apply table styles. FREE ACCESS
  • Locked
    6.  Configuring the table design
    3m 27s
    In Excel 365, tables can be configured in a variety of ways, such as using banded columns to make data more legible or adding total row calculations. In this video, you will explore how to configure the table design. This video aligns with MOS MO-200 / Excel Associate Certification exam objective: 3.2.2 Configure table style options. As well as MOS MO-200 / Excel Associate Certification exam objective: 3.2.3 Insert and configure total rows.  FREE ACCESS
  • Locked
    7.  Formatting your table
    4m 36s
    Adding shading and adjusting the borders of your cells, can make your data values and ranges stand out. In this video, discover how to format tables in Excel 365. FREE ACCESS
  • Locked
    8.  Using slicers in tables
    3m 19s
    If you want to filter and manipulate data stored in an Excel 365 table, slicers are a handy tool. They provide a clear visual guide to the content and the qualifying criteria. In this video, you will explore how to use slicers. FREE ACCESS
  • Locked
    9.  Formatting slicers
    4m 8s
    Slicers are highly visual and are a great way of showing how the data in an Excel 365 table is being manipulated and filtered. In this video, you will discover how to format slicers using Slicer Styles, button controls, and the resize tool. FREE ACCESS
  • Locked
    10.  Adding subtotals to data tables
    4m 12s
    Subtotals help you to summarize data, especially when data tables become rather long. In this video, you will learn how to add subtotals to data tables in Excel 365. This video aligns with MOS MO-201 / Excel Expert Certification exam objective: 2.2.4 Calculate data by inserting subtotals and totals. FREE ACCESS
  • Locked
    11.  Manipulating table data
    3m 21s
    Once a table has been inserted in Excel 365, you can work with data more efficiently. In this video, you will explore how to manipulate data in a table. 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 on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Course Complete Guide to Excel 365: Pivot, PowerPivot, & Financial Modeling
Likes 60 Likes 60  
Course Adding & arranging data in Excel 365
Likes 13 Likes 13  
Course Using charts in PowerPoint 365

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Finding and grouping data in Excel 365
Course Getting started in Excel 365
Likes 1300 Likes 1300  
Course Formatting cells and ranges in Excel 365
Likes 5 Likes 5