This ticket is for all three excel workshops.

**Registration is required prior to the first workshop in order to receive the Zoom link to join us.

These workshops are Online.

Participants of this course will receive documentation of the functionality discussed during the course which can be used as a reference later on.

Where possible, participants should use a Windows laptop with Excel 2007 or later. Mac laptops will run a version of Excel however there may be drastic differences.

Please review the descriptions for each workshop below.

Excel Level One: Excel Foundations and Introduction to Formulas

Tuesday, October 11, 2022 • 5:00 PM - 7:00 PM EDT

In this workshop we will learn how to navigate an Excel workbook effectively, start discussing the formatting of data contained within an Excel sheet and start the journey of Excel formulas.

Excel functionality you’ll learn:

• What pieces make up an Excel spreadsheet?
• Formatting & auto-sizing of cells, rows & columns
• Freezing cells
• Shortcuts
• Concatenating & text to columns
• Introduction to Formulas & Functions
• SUM, Average, Count, Min & Max
• How to print a spreadsheet effectively (Written documentation will be provided, will not be reviewed in this session)

Excel Formatting Data & Advanced Functions

Tuesday, October 25, 2022 • 5:00 PM - 7:00 PM EDT

This workshop will take participants from the foundational basics of Excel to more advanced functionality. During this workshop participants will learn various intermediate and advanced functions that allow a user to analyze data in an effective way, as well as put Excel to work for the user.

Excel functionality you’ll learn:

• Conditional Formatting
• Sparklines
• Vlookups
• IF Statements & Nested IF Statements
• Macros
• Hlookups (Written documentation will be provided, will not be reviewed in this session)

Pivot Tables and Pivot Charts

Tuesday, November 01, 2022 • 5:00 PM - 7:00 PM EDT

This is the final workshop in an Excel series that will take participants from the foundational basics of Excel to more advanced functionality.

During this workshop participants will learn about PivotTables & PivotCharts, why and how they can be useful, and how to create effective ones. A PivotTable is a dynamic tool that allows a user to analyze and summarize data very quickly. They can be used for tracking income, purchases, inventory, spending and more. A PivotChart takes this and makes it even more visually appealing.

Excel functionality you’ll learn:

• PivotTables & PivotCharts
• What are they?
• How can they be useful?
• How to create them

About the Instructor:

Melissa Binder graduated from Keene State College in 2012 with a degree in Sociology and currently works as Project Manager for New Hampshire Mutual Bancorp and affiliated banks: Savings Bank of Walpole, Meredith Village Savings Bank, and Merrimack County Savings Bank, as well as NH Trust. Previously Melissa held the role of Supervisor of the Learning & Development team at C&S Wholesale Grocers which focused on training new team members, and existing team members as well as helping everyone grow and develop in their professional careers. Outside of the office, Melissa enjoys painting, reading, and spending time with friends and family.