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. |