GROWING CONNECTIONS IN THE TOTAL REWARDS COMMUNITY.

Virtual Excel Workshop Series

  • 07/23/2024
  • 09/17/2024
  • 3 sessions
  • 07/23/2024, 11:30 AM 12:30 PM (MDT)
  • 08/20/2024, 11:30 AM 12:30 PM (MDT)
  • 09/17/2024, 11:30 AM 12:30 PM (MDT)
  • Zoom Meeting

Registration


Register


Master Excel with Emily Milligan: Join Our Exclusive Workshop Series!

Emily is a Director with Alvarez & Marsal in its Compensation & Benefits group. She assists with both qualified retirement plan and compensation-related issues, including pay equity analyses and complex nondiscrimination testing. With an MS in Applied Mathematics and Statistics, Emily is an expert in data analysis and specializes in designing customized models for her clients.

• Basic/Intro to Excel: Tuesday July 23, 2024; 11:30am – 12:30pm Mountain Time

• Intermediate Excel: Tuesday August 20, 2024: 11:30am – 12:30pm Mountain Time

• Advanced Excel: Tuesday September 17, 2024; 11:30am – 12:30pm Mountain Time

Basic/Intro to Excel

o Setting up spreadsheets for optimal performance

o Intro to the ribbon and more commonly used features (e.g., cell formatting, filters, freeze panes)

o Keyboard shortcuts

o Basic formulas

Intermediate Course

o Intermediate formulas/nested formulas

o Data cleanup and consolidation

o Other features of Excel (print screen, customizing spellcheck, etc.)

o Data Validation

Advanced Class:

o Advanced formulas

o Charts/graphs

o Pivot tables

o More advanced customization options

• Examples of some possible case studies:

o Consolidating and cleaning up data

o Mail merge/other automated processes

o Simple performance calculator

You won't want to miss out. Register today!

Follow us on LinkedIn to stay up to date on upcoming events.


©2022 Rocky Mountain Total Rewards Association

Powered by Wild Apricot Membership Software