Keyword Search:
OR
Register for an Account
To access your product click the Log In link at the top right of the screen. Once inside your account, you will be able to access your Packages, Self-Study Product, and Webinar Registrations.
Forgot Username or Password | Register for an Account
Credits: 2
Qualifies For: CPE
Instructor(s): Jeff Lenning
(All Times Eastern)
Please choose a Webinar date
CPE
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.
Accounting professionals using Excel for Windows
Basic knowledge of Excel for Windows
None
Unlimited access to ALL live CPE webinars, including premium courses
Unlimited 24/7 access to on-demand webcasts and self-study PDF courses
Includes select gamified CPE courses from Surgent Interactive
Access for a year from date of purchase
Auto-renew locks in your price for next year (can cancel any time)
$899
Unlimited access to all non-premium live CPE webinars
Includes 1, 2, 3, 4 and 8 CPE sessions
Access for a year from purchase date
Provides online grading & CPE certificates by email
Does NOT include Premium courses and select* courses
$749
Unlimited 24/7 access to 250+ downloadable PDF courses
Courses range from 1-20 credits
Does NOT include Premium courses and select^ courses
$549
+Excludes: ETDE, AFTR, ETTX, Certification Courses, and select Surgent Interactive games (MTT2, MTT4, MTT5, MTT6, MTT7, SAU1, SAU2, SAU4, SAU5, SAU6, BDV1, and RPA1)
*Excludes Premium Webinars & Ethics for Delaware (ETDE)
^Excludes: ETDE, ETTX, AFTR, Certificate Courses, and Interactive Games
Subscribe to Surgent CPE emails for course information, promotions and industry insights