Back to All Events

Excel Workshop for HR Professionals

  • Washington Group Plaza 400 S. Broadway Avenue Boise, ID, 83702 United States (map)

FREE to SICBA Members | $20 Non-members | $5 Full-time Student Non-members

The Southern Idaho Compensation and Benefits Association is pleased to bring back Dr. Phillip Fry to present an interactive session on Excel. This is a fabulous opportunity to expand your Excel knowledge in a casual environment and at a very affordable price.

Topics include:

  • Excel functions for summarizing data

  • Advanced functions, including: Sumproduct, If, SumIf, Index, Match, Vlookup, and Intersection

  • Array functions, including: Transpose and Frequency

  • Overview of pivot tables

  • Graphical summaries

  • Conditional formatting

This program is valid for 3 PDCs for the SHRM-CP or SHRM-SCP

Dr. Phillip Fry specializes in utilizing Excel spreadsheet modeling to forecast growth and minimize the risk of business decision-making. Since 1988, he has taught MBA and undergraduate courses in the College of Business and Economics at Boise State University. Dr. Fry received his B.A. and M.B.A. degrees from the University of Arkansas, and his M.S. and Ph.D. degrees from Louisiana State University.

In addition to business decision-making, his research and teaching interests include operations management, business statistics, demand forecasting, supply chain inventory management, and supply chain transportation issues. Dr. Fry provides seminars and consulting for numerous companies, among them Boise Cascade Corporation, Hewlett-Packard, J. R. Simplot Company, United Water of Idaho, Woodgrain Millwork, Idaho Power, Boise City and Micron Electronics. He has co-authored university level text books and his research has appeared in the European Journal of Research, the Decision Science Journal of Innovative Education and the Production and Inventory Management Journal.