Customer Service: 800-778-7436     

    Log In to Your Surgent Account

    Forgot?
    Forgot?

    Register for an Account

Sign In to Your Surgent Account

Forgot Username or Password | Register for an Account

Choose CPE Format:

Live Webinar SELECT STARTING AT $89

Credits: 2

Qualifies For:

$89

Upcoming webinars

December 14, 2016
10:00 am - 12:00 pm (EST)

Instructor(s): Jeff Lenning

February 21, 2017
10:00 am - 12:00 pm (EST)

Instructor(s): Jeff Lenning

March 01, 2017
01:00 pm - 03:00 pm (EST)

Instructor(s): Jeff Lenning

See More Upcoming Webinar Dates >

NO HASSLE REFUNDS & TRANSFERS
EASY CANCELLATIONS
Self-StudySELECT

This course is not currently available. Please fill out this short form to be notified when self-study options are available.

FIRST NAME
LAST NAME
EMAIL ADDRESS
COMMENTS (OPTIONAL)
Get this course FREE with an Unlimited Package! Learn More
  • Very good & helpful presentation - thanks

    - Surgent customer

Interested in bringing this course into your firm?

PRIVATE WEBINARS AND LIVE ON-SITE COURSES ARE AVAILABLE. LEARN MORE.

Excel Budgeting Ideas (EXBI)

  • Customer Rating
    Not Yet Rated
  • Field of Study
    Spec. Knowledge
  • Level
    Basic
  • Credits
    2
  • Qualifies for

    CPE

Overview

Budget methods are the key to allowing department managers to efficiently prepare their budget in Excel. For example, a budget method may be to spread prior year actuals or match prior year actuals, or match prior year actuals less 10%. In this webinar, we will explore how to allow users to pick a budget method from a drop-down list for each account and then have Excel perform different calculations depending on the budget method selected. We use several features and functions at the same time to pull this off. Even if you are not involved in the budgeting process, the underlying features and functions discussed have a wide range of uses.

Major Topics:

  • Major Topics: * Set up an in-cell drop-down list of budget methods * Change the calculations in the cells based on the selected budget method * Use names in worksheets

Learning Objectives

  • Be able to set up an in-cell drop down
  • Discover the function that enables us to change formulas depending on the budget method
  • Name cells and ranges

Who should take this course:

Designed for:

Accounting professionals using Excel 2007, Excel 2010, or Excel 2013 for Windows

Prerequisite:

Basic knowledge of Excel for Windows

Advanced Preparation:

None

Loading...

Loading...

Thank You!

YOU HAVE ADDED THE FOLLOWING TO YOUR CART:


Loading...

Thank You!

Thank You! Your request has been submitted.



Get More with a Surgent CPE package

Self-Study Library Package

  • Unlimited 24/7 access to 200+ downloadable self-study courses

  • Courses range from 2-20 credits

  • Provides online grading & CPE certificates by email

$499

Learn More

Unlimited Webinar Package

  • Unlimited access to all non-premium live CPE webinars

  • Includes 1-, 2-, 3-, 4-, and 8-hour webinars, including Saturday and evening options

  • Access through 12/31/16

$649

Learn More

Unlimited Plus Package

  • Unlimited access to ALL live CPE webinars

  • Includes all premium courses and virtual conferences

  • Unlimited 24/7 access to all self-study courses

  • Includes all on-demand webcasts Access for a year from purchase date

  • Unlimited 24/7 access to all self-study courses

$849

Learn More
  • CPE Continuing Professional Education for CPAs

  • IRS Continuing Education for EAs and the AFSP program

  • CFP Accepted by the CFP® Board

  • YB YellowBook Continuing Education

Explore Additional Courses by Topic

SURGENT IS APPROVED AS A PROVIDER OF CONTINUING EDUCATION BY:

Thank You!

Thank You! Your subscription has been submitted.