TRAINING & EVENTS

Dates: May 8, 22, June 5, 12, 2024
Time: 11:00 am – 2:00 pm
Cost: $599 ($560 if registered by 4/26)
Location: Community Education Center (CEC)
4 Erie Avenue, St Marys, PA 15857

(previously scheduled April 17 through May 29)

Lunch is provided

Many organizations utilize Microsoft Excel to track and organize data but rely on a few power users to manipulate data for easier analysis and presentation. This 4-week training series will teach participants Office 365 Excel from basics through advanced levels, including how to create any function and formulas and developing and modifying Pivot Tables, in classroom format, including examples, and provide for out of classroom exercises that will reinforce learning. Participants will learn how to manipulate data to better understand and present trends and summations.Become proficient in Microsoft Excel and take your data to new levels with this step by step, guided instruction by our best instructor who uses data analysis on a daily basis.

Materials Needed: All attendees will need to bring a laptop.

Week 1: Basic overview of Microsoft Excel including:

1. Basic terminology
2. MS Excel layout and tab overview
3. Creating a list
4. Formatting cells
5. Formatting a worksheet for printing
6. Managing and Edit worksheets and add new worksheets to a workbook, rename and rearrange sheets.
7. Inserting and Formatting Tables, Charts, and Graphs to graphically present numerical data
8. Formulas and functions overview

Week 2: Basic Formulas and Functions

1. 1. Enter text, numbers and formulas into a worksheet applying to business situations.
   2. Working with tables using Sort and Filter
   3. Basic Formulas and functions
   4. Use the Excel SUM, AVERAGE, MAX, MIN, IF, and NOW functions to display desired calculations.
   5. Create and copy formulas using relative and absolute cell references.

Week 3: Advanced Functions

1. 1. Advanced Functions – VLOOKUP, SUMIF(S), AVERAGEIF(S), COUNTIF(S)

Week 4: Pivot Tables and Pivot Charts

Presenter: Michael Griffith

Michael joined NWIRC in August 2013 following fifteen years fulfilling various manufacturing roles including product development, sales engineering, and sales and marketing management. Michael served five years in the US Marine Corps as a Korean Cryptologic Linguist and received both his bachelors in Chemical Engineering and Masters of Business Administration from The Pennsylvania State University.

During his tenure with NWIRC, Michael has directly assisted manufacturers as a Strategic Business Advisor, Manufacturing Technology Engineer, and Manager of Business Development/Operations. Michael draws upon his analytical, organizational, and project management skills and experience while working with NWIRC’s current Strategic Business Advisors and support staff to facilitate our regional manufacturers’ ability to accelerate their topline business growth.

Email rkeller@nwirc.org for additional information or questions.