Course details

Excel Office 365 (Windows): Working with Excel Tables

Excel Office 365 (Windows): Working with Excel Tables


Overview/Description
Expected Duration
Lesson Objectives
Course Number
Expertise Level



Overview/Description

Explore how to use tables in Excel for Office 365 to manage, analyze, and manipulate data in a range, in this 6-video course, which demonstrates how to convert data ranges into a table, giving you greater control over data, and provides more tools for manipulating the data. You will learn how to create calculated columns to perform automated calculations, quickly clean up your data with a sweep, and transform your data into a PivotTable. Next, learn how to use the Table Design tab to change the appearance of your data. This course demonstrates how to use Excel's standard styles, how to create a custom style, and set it as the default. You will also learn how to use the Table Design tab to improve legibility with banded columns and rows, add total row calculations to add summaries to your data, and show or hide the filter buttons. Finally, this course demonstrates how to use slicers to filter and manipulate data.



Expected Duration (hours)
0.3

Lesson Objectives

Excel Office 365 (Windows): Working with Excel Tables

  • convert a data range into an Excel table and edits its contents
  • perform calculations and manipulate data in an Excel table
  • use the formatting tools and styles to change the appearance of a table
  • customize the table settings and tools
  • use slicers to filter data in an Excel table
  • resize and format a slicer
  • Course Number:
    ds_msex365_15_enus

    Expertise Level
    Intermediate