Optimizing Accounting & Finance With Advanced Excel

KPMG Executive Education

What are the topics?

KPMG Executive Education

Disclaimer

Coursalytics is an independent platform to find, compare, and book executive courses. Coursalytics is not endorsed by, sponsored by, or otherwise affiliated with any business school or university.

Full disclaimer.

About the course

This one-day course offers insights and tips intended to help you become an Excel power user and boost your productivity. During the course, we will apply advanced Excel techniques to accounting and finance problems. Our lead instructor's extensive accounting experience and programming background allows him to share guidance and tips that have significant impact for those working in accounting and finance functions. The course will cover not only the Excel functions but also how to organize your spreadsheets to optimize teamwork, scenario analysis, and ease of updating. You will learn to reduce errors by simplifying your spreadsheets and making them concise, compact, and understandable.

Agenda

  • Build accounting and finance schedules efficiently via transpose and shift
  • Automate and condense schedules using SUMPRODUCT and ARRAY functions
  • Build scenarios via LOOKUP, OFFSET, and INDIRECT
  • Give your spreadsheets a consistent look and feel that can be changed easily and separate inputs from outputs via Excel Styles and Add-ins
  • Build easy to update spreadsheets by avoiding complex functions, nested ifs, and iterations and integrating monthly, quarterly, and annual data
  • Make your spreadsheets responsive to user input via Custom Formatting, Data Validation, Spinners, List Boxes, Sliders, INDEX, MATCH, OFFSET, and INDIRECT
  • Perform what if analysis via DATA TABLES and PIVOT TABLES
  • Stress test future cash flows via SOLVER and GOAL SEEK
  • Eligibility: 2 Acccounting CPE credits

Experts

Dan Gode

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...

Videos and materials

Optimizing Accounting & Finance With Advanced Excel at KPMG Executive Education

This course has no confirmed dates in the future. Subscribe to be notified when it is offered.


Something went wrong. We're trying to fix this error.

Thank you

Someone from the Coursalytics team will be in touch with you soon.

Disclaimer

Coursalytics is an independent platform to find, compare, and book executive courses. Coursalytics is not endorsed by, sponsored by, or otherwise affiliated with any business school or university.

Full disclaimer.

Because of COVID-19, many providers are cancelling or postponing in-person programs or providing online participation options.

We are happy to help you find a suitable online alternative.