5910 Breckenridge Pkwy Suite B, Tampa, FL. 33610
(800) 272-0707

SkillSoft Explore Course

Productivity & Collaboration Tools     Microsoft Office 365     Excel 365

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.



Objectives

Excel 365: Working with tables

  • 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
  • Knowledge Check: Working with tables in Excel 365