TRAINING & EVENTS

Session Dates: October 2, 16, 30, November 13, 2024

Time: 9:00am – 12:00 pm
Cost: $599 ($560 if registered by September 18)

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

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

Week 2: Basic Formulas and Functions

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

Week 3: Advanced Functions

• Advanced Functions – VLOOKUP, SUMIF(S), AVERAGEIF(S), COUNTIF(S)

Week 4: Pivot Tables and Pivot Charts

About the Presenter: Michael Griffith, Chief Operating Officer, NWIRC

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 top-line business growth.

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