Optimizing Accounting & Finance with Advanced Excel: NYC
Optimizing Accounting & Finance with Advanced Excel: NYC
EVENT

Nov 20, 2019

Optimizing Accounting & Finance with Advanced Excel: NYC

KPMG New York Office | New York, NY

Register today

CPE Credits: 8.0

Overview:

CPE Credits: 8.0

KPMG hosts a one-day seminar on excel for accountants and finance professionals. The seminar covers advanced excel material with all examples tailored to accounting and finance.

Applicability

  • All companies

Date Nov 20, 2019

Location  New York, NY

Contents

  • 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

 

 

KPMG Handbooks

KPMG experts and professionals continually research, update and produce many publications including in-depth handbooks.



Subscribe to our newsletter

Receive timely updates on accounting and financial reporting topics from KPMG.


ARO

Use our Accounting Research Online website for financial reporting resources.