Tools for Analyzing Data in Microsoft Excel

Narrow down your data to help analyze and answer complex questions using tools available in Microsoft Excel.

During this three-hour class, we will explore sorting and filtering and conditional formatting. We will also discover how to create and modify PivotTables and PivotCharts that take large data sets and narrow down the results to simple tables and charts. This class is offered at least once a quarter.

On this page:

Learning Outcomes

  • Use sorting and filtering to narrow down your data to help answer questions
  • Add visual cues to your data using conditional formatting
  • Quickly solve complex questions of your data using PivotTables and PivotCharts

Intended Audience

UB faculty and staff


Familiarity with Microsoft Excel and experience with creating, editing, formatting, saving and printing basic workbooks or, attended the Introduction to Microsoft Excel class



Class Schedule and Registration

Log in to UB EDGE to view class dates and register. (Don't have a UB EDGE account? Search for dates on the UB Calendar and email or call 716-645-4459 to register.)

May Also Interest You


Rosanne Steinmetz

Owner and Instructor

Quality PC Training

Contact for Questions

Kerry Lynch

Kerry Gangi

Program Coordinator & Communications Specialist

Organizational Development and Training

Phone: 716-645-4459


The University at Buffalo is committed to providing reasonable accommodations to individuals with any disabilities. If you require accommodations to participate in this session, please contact Organizational Development & Training (OD&T) at (716) 645-4459 or prior to attending the class. Please allow ample time for OD&T to work with the Office of Accessibility Resources to arrange accommodations.