MS Excel - Ranges, Structured Tables, Charts

Class Sessions: Three, 2-hour classes

Course Prerequisites:

The student must have basic Windows skills, including the use of files and folders, as well as a basic proficiency in Excel.  

Course Description:

Even a relatively small set of data in an Excel spreadsheet can be overwhelming and not very useful until it is properly organized and summarized.  We often want to look at data, such as our investment portfolio or our golf scores, in many different ways.  In this class we will examine two Excel features for organizing data in a worksheet: ranges and structured tables.  Students will get hands-on experience in building and using these tools to analyze data.

Organizing data using ranges and tables is important, but one of the best ways to find the story that lies behind the numbers is to use Excel’s charting tools.  Charts depict data visually, so you can quickly spot trends, patterns, associations and hidden meanings in the data.  This class will illustrate the wide variety of charts which can be created in Excel and provide hands-on experience in creating and formatting charts from data in Excel ranges and structured tables.

This class also provides the prerequisite training required for the successor class in Excel Pivot Tables and Pivot Charts.  

Course Objectives:

By the end of this course, you will be able to:

  • Organize data in an Excel worksheet by sorting, filtering, and subtotaling ranges of data. 
  • Convert ranges into structured tables where you can use the versatile subtotal function to quickly analyze your data.
  • Insert formulas within a table and reference data using table and column names. 
  • Create a data-analysis table using Excel’s logic functions. 
  • Create an Excel data table.
  • Create a wide variety of charts from data in ranges and structured tables.

Modified: 10/28/2017