Skip Navigation or Skip to Content
Print Course information
Email me when offered
Continue Shopping

SUNY Broome Continuing Education Course Catalog Registration for our summer classes is now open! > Professional Development > Professional Skills

Excel Spreadsheets: Tables, Pivots & Data Management   

Expand your understanding of data analytics using Excel. The Excel Spreadsheets: Tables, Pivots, and Data Management course covers the intermediate level concepts and applications of spreadsheets in business, health sciences, and service industries. Students will use Excel to learn to generate reports from multiple worksheets and workbooks, manage data with data tools including tables and filters, create interactive dashboards, and summarize data with PivotTables and PivotCharts.

Students who complete this course with satisfactory scores on assessments will be eligible for the Spreadsheets: Tables, Pivots, and Data Management badge. Students must have a basic background in Excel before taking this course. Excel Spreadsheets: Fundamentals is highly recommended as a prerequisite.

Software: Windows version of Excel 365/Excel 2019/Excel 2021
Textbook: New Perspectives Excel 2021 ebook and homework platform (MindTap) (ISBN is  9780357671993) $49.99 for 5-weeks of access. If you are planning to take all three courses, you can get a full 4-months for $124.99

Learning Outcomes:

  • Demonstrate proficiency with pivot tables and pivot charts
  • Manage data by creating dashboards with data tools including tables, filters, subtotal functions, and slicers
  • Apply formulas across multiple worksheets and workbooks and manage links across documents
  • Use templates to facilitate management of data across multiple workbooks

This is an on-demand, online course. Students should plan on 6 hours of material each week. Students will have access to the course for 5 weeks after their initial start date.

Prerequisite: CP200

Registration Deadline: April 19



To be notified when this class will be offered in the future, please email Call (607) 778-5012 with any questions.

Continue searching for courses.

Some Title