Dates: October 2, 16, 30, November 13, 2024
Time: 9:00am – 12:00 pm
Cost: $599 ($560 if registered by September 18)
Location: Corry Hi-ED
221 N. Center Street, Corry, PA 16407

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.

Attendee Information

Tickets

$560.00

Payment must be received, in full, prior to training/event start date. If the registered individual cannot attend, you may substitute another individual. At least a 2-day notice is appreciated.

If the registered individual cannot attend, or make a substitution, and wishes to cancel, a full refund will be issued with ten business days or more notice. Please note that no refund will be issued with less than a 10 business day notice.

A full refund will be given if NWIRC should cancel the training/event.

Registration Information

Booking Summary

1
x Standard Ticket
$560.00
Total Price
$560.00
Loading Map....

Location
Corry Higher Education Council