Announcements

Optimizing Accounting & Finance with Advanced Excel

This seminar will show you how to harness the full power of Excel to become a more effective and efficient user. The seminar covers advanced material taught by an instructor with extensive accounting and finance experience.  All examples are therefore tailored to accounting and finance. Up to 2 Accounting credits can be earned by attending this seminar.

COURSE PREREQUISITES:

  • A laptop with Excel 2010 or above is required. Some features of Pivot Tables have really improved in Excel 2016. Therefore, we will be using Excel 2016 in the seminar.
  • A strong working knowledge of Excel, including commonly used keyboard shortcuts and functions, is required. Knowledge of Excel VBA is not necessary.
  • Please note that we will not be covering Excel VBA or Excel charting features.
Date/Location:
5/15/2018 New York
CPE Credit:
8
Tuition:
$1,295 **

Venue and Hotel Details

Agenda

  • Build common accounting and finance schedules efficiently using transpose and shift aspects of Excel
  • Automate and condense schedules using SUMPRODUCT and ARRAY functions
  • Make schedules flexible to incorporate multiple scenarios using LOOKUP and OFFSET functions
  • Collect and select user data through use of formatting, Data Validation, Spinners, List Boxes, Sliders, INDEX, MATCH, OFFSET, and INDIRECT functions
  • Perform what if analysis using DATA TABLES and PIVOT TABLES
  • Design more efficient spreadsheets using effective planning and various Excel features
  • Stress testing the future cash flows using SOLVER and GOAL SEEK

Program Details

Prerequisite:  A strong working knowledge of Excel, including commonly used keyboard shortcuts and functions, is required. Knowledge of Excel VBA is not necessary.
Preparation:   None
Level of Knowledge:   Intermediate
Field of Study:   Accounting, Computer Software & Applications
Delivery Method:   Group Live, Instructor-Led Course

Course Leaders

Dan Gode, Co-founder, Almaris E-Learning Systems.


  • Register Early and Save!*
    Reserve your seat in any session before midnight on May 1, 2018 and apply coupon code SPRG18WEBSITE at checkout to receive $100 off the purchase price.
  • Attend Any 2 Executive Education Courses Per Person and Save!*
    Apply coupon code COMBO300 at checkout to receive $300 off the combined purchase price.



    See other courses offered in the same week

  • Discounts Available for Groups of 3 or More!*
    For more information, call 201-505-6062 or email us-kpmglearning@kpmg.com.

* Discounts cannot be combined and must be applied at time of initial registration.

** Tuition price includes daily breakfast, lunch, and morning and afternoon refreshments.

If you have previously attended this course, you may not be eligible for CPE credits. Please contact KPMG Executive Education to confirm your eligibility.