Excel 2016: Creating and Using Excel Tables

Date(s) - 09/28/2017
9:00 am - 11:00 am

IML (Eggers Hall, room 062)


Excel 2016 logo

To make managing and analyzing data easier, you can turn a range of cells into a Microsoft Office Excel Table. A table is a simple structure where each row corresponds to a single “item” (such as a student or a course). Each column denotes a specific piece of information that is shared by all rows (such as the last names of students, or the titles of courses).

The following topics will be covered in this training session:

  • Creating tables
  • Sorting
  • Filtering
  • Removal of duplicate data
  • Working with Subtotals (Subtotals are a way of grouping data and performing calculations on those groups. You can then use outline symbols to summarize the calculations, or expand and collapse portions of your data.)

In this training session, you will learn how to create and use tables, as well as perform calculations on grouped data using the subtotal command. Please join us!

Register For ICT Training