Self-Paced Courses

Excel Skills Series
Pricing: Member: $295 | Non-member: $395

Credits: FP&A 4.8 | CTP 4.8 | CPE 4.8 | CPE Field of Study: Computer Software & Applications (CSA)
Dates: July 12, 13, 19 & 20 1:00 - 2:00 PM ET

Course Description: 

Want to get more comfortable with some of the advanced features of Excel and create a user-friendly template for your users? This is your chance!  In this course we dive into data validation, pivot tables, creating efficient models and explore how Solver can be incorporated into financial models. Plus, gain essential tips and tricks to help you step up your Excel game!

Learning Objectives:

  1. Learn how to slice and dice data very efficiency with Pivot Tables
  2. Create interactive user-friendly input forms to capture and deliver data
  3. Improve your modeling skills through the use of built in tools in Excel
  4. Learn to use solver within models and find the optimal solution even with multiple constraints 
Speaker Information Register Now

Sneak Peek

Session 1: Data Validation and Duplication Identification

Session 2: Pivot Tables

Session 3: Creating efficient models

Session 4: Using solver to optimize models