Spend more time using data – and less time preparing it in Excel. In two short hours, you will boost your efficiency and decision-making acumen by learning tested techniques for streamlining data formatting and calculations.
What You’ll Learn
- Using pivot tables and charts to analyze data and create interactive dashboards.
- Writing macros to automate frequent tasks.
- Using interactive tools to generate robust analyses.
- Calculating the cost of stock granted as a percentage of base pay and shares granted as a percentage of shares outstanding.
Who Will Benefit from This Course?
This course is ideal for anyone seeking to create interactive pivot tables quickly and easily, and who wishes to use macros to automate repetitive tasks.
Course Requirements
The course requires an intermediate to advanced knowledge of Excel. Participants also should have access to a computer with Excel 2013 or newer.
Related Courses
This learning experience is part of WorldatWork’s suite of Excel mastery courses, which include:
- Advanced Excel Skills for Compensation Professionals
- Creating a Dynamic Incentive Modeling Tool
- Designing Powerful HR Dashboards
- Dynamic Arrays: Excel Turbo Charged
- Excel Skills for Compensation Professionals
- Hello Excel Power Query, My New BFF
- Job Titles & Grades: Creating an Interactive Matrix in Excel
- Regression Analysis Made Easy with Excel
- Working Smarter & Faster with Excel Formulas
Recertification Credits
By successfully completing this course you will earn 2 WorldatWork recertification credits.
Based in India? Contact india@worldatwork.org for India-special course pricing.
Policies
View our Return/Cancellation policies and more here.
Members can register for this course at a special rate and gain exclusive access to research, publications and more!
Please consider a different learning method or contact our Customer Experience Team to learn about other classes and schedules.
Phone
877-951-9191 (United States and Canada)
+1 480-951-9191 (other countries)
Monday-Friday: 8:00 a.m. - 7:00 p.m. EST
Email
Email our Customer Experience Team: customerexperience@worldatwork.org