The ECEC’s Assessment and Data Analytics Team will be offering a series of seminars during the Fall 2025 semester. This series covers beginner to intermediate uses of Excel. Register to attend a session using this form. By registering, you will receive email reminders for the events and updates about session locations. You must register in order to attend via Zoom. 

Recordings from previous N2Data seminars are available here.

 

Title

Date/Location

Summary

Getting Started with Excel

Sept 29, 10:00-11:00

KH A549/Zoom

In this session, we will review the basics of Excel, including using features within Excel's menus, inserting data into a sheet, using keyboard shortcuts, and customizing your experience with Options that can reduce headaches. 

Getting Started with Formulas

Oct 13, 10:00-11:00

KH A549/Zoom

In this session, we will review the basics of using formulas within Excel, including using relative cell references, commonly used formulas, features of the Forumlas tab, and accessing and interpreting formula "help" documentation. 

Features and Formulas for Working with Your Data

Oct 27, 10:00-11:00

KH A549/Zoom

In this session, we will continue working with formulas as we explore absolute cell references and nesting formulas, and we will review other features within Excel that can help you make use of your data. 

Working Across Sheets

Nov 10, 10:00-11:00

KH A549/Zoom

In this session, we will tackle approaches for working across multiple spreadsheets and Workbooks as we explore advanced formulas (like lookups), cross-sheet cell references, approaches to combining datasets, and tools for viewing multiple sheets.

Strategies for Quality Checking your Data

Nov 24, 10:00-11:00

KH A549/Zoom

In this session we will explore strategies for quality checking and cleaning data.

Pivot Tables!

Dec 8, 10:00-11:00

KH A549/Zoom

In this session, we will learn how to use pivot tables! We will cover using pivot tables for summary and subgroup statistics.