Live Virtual Courses

afp_learn_header_liveinstructor
Excel Skills Series
Member: $295 | Non-member: $395
Credits: FP&A 5.4 | CTP 5.4 | CPE 5.4 | CPE Field of Study: Computer Software & Applications (CSA)
Dates: July 13, 15 & 20 4:00 - 5:30 PM ET

Course Description: 

Want to get more comfortable with the guru tricks of Excel – namely Pivot Tables and Vlookup? We’ll also dig into how forecasting and regression can be incorporated into your models. Ever want to create a user-friendly template for your users, as well? This is your chance! We’ll be covering all of the above, plus some more tips and tricks to help you become a rock star in Excel!

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. Learn how to detect which economic variables are impacting your bottom line

 

Speaker Information Register Now

Sneak Peek

  1. Pivot Tables
    1. Creating
    2. Modifying
    3. Multiple
    4. Updating
    5. Slicers
    6. Pivot Charts
  2. Finding Data
    1. Vlookup, Hlookup, Xlookup
    2. Index, Match
  3. User Forms
    1. Drop Down Lists
      1. Error Alerts
      2. Messaging
    2. List Box
  4. Scenario Planning
    1. Scenario Toggles with Choose
    2. Goal Seek vs Solver
    3. Data Tables
    4. BreakEven Analysis
  5. Linear Regression
    1. Single Variable
    2. Sum of Least Squares; R2
    3. Forecasts
  6. Data Analysis Toolpak
    1. Descriptive Statistics
    2. Multi-variate Linear Regression