OK

Excel Series

Tuesday, November 09, 2021 • 5:30 PM - 7:30 PM EST

$75.00

2bb3470a c0ce 4497 ba60 6ef285ebc366

Event Details

This ticket is for all three excel workshops.

Below are the descriptions for each workshop.

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

These workshops are Online.


Excel Foundations and Introduction to Formulas

Tuesday, October 26, 2021 • 5:30 PM - 7:30 PM EDT

Excel allows a user to compile and store data in one central location while telling the story of their data in a meaningful way. Join us for the first of three courses that will take participants from the foundational basics of Excel to more advanced functionality. During this course participants will learn the foundational basics of Excel in order to become more efficient in producing meaningful spreadsheets and compiling data. Participants of this course will also receive documentation of the functionality discussed during the course which can be used as a reference later on.

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

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, November 02, 2021 • 5:30 PM - 7:30 PM EDT

Join us for the second of three courses that will take participants from the foundational basics of Excel to more advanced functionality. During this course 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. Participants of this course will also receive documentation of the functionality discussed during the course which can be used as a reference later on.

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


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 09, 2021 • 5:30 PM - 7:30 PM EDT

Join us for the final course in a series of three that will take participants from the foundational basics of Excel to more advanced functionality.

During this course 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. Participants of this course will also receive documentation of the functionality discussed during the course which can be used as a reference later on.

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

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

Venue Information

The Hannah Grimes Center
25 Roxbury Street
Keene, NH 03431
(603) 352-5063
Staticmap?center=42.9334218, 72.2770427&zoom=13&scale=2&size=936x250&markers=|42.9334218, 72

Organizer Information

Hannah Grimes Center


25 Roxbury Street
Keene , NH 03431
(603) 352-5063

More Events

Name:
Sara
Phone:
(603) 352-5063
Email:
[email protected]
Name:
Sara
Phone:
(603) 352-5063
Email:
[email protected]