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 2: Data Management, Tables, and Presentation Tools

Learn how to organize, manage, and present data more effectively using Excel's most valuable productivity tools. Participants will build practical skills in sorting, filtering, conditional formatting, tables, and charts to improve efficiency, accuracy, and data presentation in the workplace.

Topics Include:

Sorting and filtering dataCustom sorting and advanced filteringConditional formattingCreating basic chartsWorking with Excel tablesStructured data and table namingRemoving duplicate dataPage layout, setup, and printing options

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.

View on site | Email this event

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 barAbsolute and relative cell referencesFunction library and function syntaxEssential functions (SUM, AVERAGE, COUNT, MIN, MAX)IF statementsLookup functions (VLOOKUP, HLOOKUP, INDEX/MATCH, XLOOKUP)Grouping worksheets and using 3-D formulasIntroduction 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.

View on site | Email this event