Cost Modeling & Analysis Using Excel

The start date for this course has passed. Registration is no longer available.

This course is 8.00 credits
Field of Study
Accounting
Course Level
Intermediate
Vendor
California Society of CPAs

Registration Fees

MSCPA-AICPA Member
$245.00
MSCPA Member
$245.00
AICPA Member
$375.00
Non-Member
$375.00
Return to Webinars List

Tuesday, Feb 13, 2018
11:30am – 7:00pm

Excel is one of the most popular tools in business, yet many CPAs have never explored more than its most rudimentary features. This hands-on course goes beyond the basics and explores various Excel features that will allow you to confidently and effectively build cost models. Combine the latest trends in cost analysis with Excel model-building techniques through the use of clear and concise examples that will enable participants to practice what they learn.

Materials are provided as an ebook for this course.

Excel is one of the most popular tools in business, yet many CPAs have never explored more than its most rudimentary features. This hands-on course goes beyond the basics and explores various Excel features that will allow you to confidently and effectively build cost models. Combine the latest trends in cost analysis with Excel model-building techniques through the use of clear and concise examples that will enable participants to practice what they learn.

Materials are provided as an ebook for this course.

Designed For

CPAs, CFOs, controllers and finance professionals, as well as department heads, auditors, project managers and those responsible for ensuring the effective use of business resources.

Course Objectives

  • Identify the basics of cost modeling with Excel using step-by-step examples.
  • Recognize ways to boost your analytical potential with clear and well-designed Excel models.
  • Outline the wide array of formatting capabilities available with Excel.
  • Determine the uses Excel’s built-in functions, wizards and tools as they relate to cost modeling.
  • Identify how to use Excel for trend analysis, cost-decomposition analysis, multidriver cost analysis and capital budgeting.
  • Identify hidden profits and make business decisions more confidently.

Major Subjects

  • Forecast costs using Excel's linear and exponential Trendline feature.
  • Analyze costs using Chart Tools and advanced tools such as Regression.
  • Read Regression outputs for single and multi-driver models.
  • What-if tools such as Goal Seek, Scenario Manager and Data Tables.
  • Read Solver outputs and use the integer and binary constraint features.

Prerequisites

Basic knowledge of Excel.

The start date for this course has passed. Registration is no longer available.