Compare courses
Register
KPMG Executive Education

Optimizing Accounting & Finance With Advanced Excel

Nov 20, 2019
New York, New York, United States
USD 1295
USD 1295 per day

How it works

Disclaimer

Coursalytics is an independent platform to find, compare, and book executive courses. Coursalytics is not endorsed by, sponsored by, or otherwise affiliated with KPMG Executive Education.

Full disclaimer.

Description

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.

COURSE PREREQUISITES:

  • Expected Incoming Knowledge: Participants should have a strong working knowledge of Excel including commonly used keyboard shortcuts and functions.
  • A laptop with Excel 2010 or above is required. Note that we will be using Excel 2016 in the course due to improved features of Pivot Tables.
  • Please note that we will not be covering Excel VBA or Excel charting features except the building of charts whose scales adjust automatically as the input data changes.

COURSE MATERIALS:

The seminar materials will include over 50 detailed spreadsheets illustrating the concepts coupled with documents and videos explaining various aspects of Excel.

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

Experts

Dan is the founder of Almaris Consulting and Training. He brings in 25 years of extensive experience in consulting and training in accounting, financial statement analysis, business drivers, modeling. valuation, and credit risk analysis. He has worked with over numerous corporations, investment b...

Files

Detailed Description
Detailed Description

Next dates

Nov 20, 2019
New York, New York, United States
USD 1295
USD 1295 per day

How it works

Show more

Course reviews

Reviews for this course are not publicly available