Excel: How to EXCEL at Budgeting and Variance Analysis

Learning objectives

Using Excel's analytic capabilities you will learn how to:

  • Estimate fixed and variable costs with the High Low Method and Regression.
  • Using the Learning Curve to estimate manufacturing costs.
  • Create  a Master and  Cash Budget.
  • Compute price, quantity, market size, market share, sales mix, sales price, sales volume, and profit variances.
  • Use Control Charts and Simulation to Analyze variances.
National Registry of CPE Sponsors

A Becker Professional Education is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: www.nasbaregistry.org

Becker Professional Education Sponsor I.D. Numbers NASBA: 107294, New York: 002087, New Jersey: 20CE00226700, Texas: 009580, Ohio: CPE.186, Illinois 158.002405, Pennsylvania: PX177823

Now Leaving Becker.com

You are leaving the Becker.com website. Once you click “continue,” you will be brought to a third-party website. Please be aware, the privacy policy may differ on the third-party website. Adtalem Global Education is not responsible for the security, contents and accuracy of any information provided on the third-party website. Note that the website may still be a third-party website even the format is similar to the Becker.com website.

Continue