Excel Fundamentals Series

The Excel Fundamentals Series is a three-part professional development program designed to help participants build confidence and improve productivity using Microsoft Excel. Through hands-on instruction and practical business applications, participants will develop the skills needed to organize data, perform calculations, analyze information, and create professional spreadsheets. Whether you're new to Excel or looking to strengthen your existing skills, this series provides a structured, practical approach to using Excel more effectively in the workplace.

Participants who complete all three workshops will earn an Excel Foundation Badge from Saint Francis University, recognizing their successful completion of the series.

Workshop 3: Formulas, Functions, Lookups, & Introductory Analysis

Build confidence using Excel formulas, functions, and lookup tools to perform calculations and analyze data more effectively. Participants will learn practical techniques for working with formulas, applying common functions, and using advanced tools to improve productivity and support data-driven decision-making.

Topics Include:

• Creating formulas and using the formula bar
• Absolute and relative cell references
• Function library and function syntax
• Essential functions (SUM, AVERAGE, COUNT, MIN, MAX)
• IF statements
• Lookup functions (VLOOKUP, HLOOKUP, INDEX/MATCH, XLOOKUP)
• Grouping worksheets and using 3-D formulas
• Introduction to dynamic array functions (FILTER, SEQUENCE, CHOOSECOLS, CHOOSEROWS)

Target Audience

The Excel Fundamentals Series is designed for professionals who want to strengthen their Excel skills and improve productivity in the workplace. The series is ideal for beginners, occasional Excel users, and anyone looking to build a stronger foundation in Excel. No advanced Excel experience is required.