K2's Budgeting And Forecasting Tools And Techniques WEBCAST
Overview
Most budgeting and forecasting processes are in dire need of an overhaul. Join us in this session to learn better budgeting and forecasting methods, including using various technologies to get better results quickly.
Highlights
Budget-centric features in Excel. Capital budgeting techniques. Working with Solver and Scenario Manager in budgeting and forecasting environments. Collaboration issues, version control, and audit history.
Prerequisites
Fundamental knowledge of Microsoft Office Excel 2019 or newer.
Designed For
Business professionals involved in budgeting and forecasting activities.
Objectives
Utilize processes for obtaining budget data and collaborating with others when using Excel, including Shared and Merged Workbooks. Excel’s Audit Trail, controlling and validating data input, and collaborating with others. Apply various Excel techniques for interacting with the accounting system, such as Office Data Connections, Open Database Connectivity, importing text files, and linking Internet-based data into budgeting and forecasting models. Identify situations in which various Excel techniques are appropriately implemented, such as using Data Tables for sensitivity analysis, working with Excel’s Goal Seek feature, using Solver to maximize scarce resources, working with Scenario Manager, forecasting with Regression Analysis, and analyzing risk with Monte Carlo simulations. Implement various Excel functions - including NPV, IRR, XNPV, and XIRR - in capital budgeting situations and identify different methods by which Excel computes depreciation. Compare and contrast Excel with other applications used for budgeting and forecasting activities and describe conditions in which you should use other solutions to reduce the dependency on Excel as a budgeting and forecasting solution.
Preparation
None.
Notice
None.
Leader(s):
Leader Bios
Brian Tankersley, CPA, K2 Enterprises, LLC
Brian Tankersley is a consultant who advises US firms and companies on accounting technology issues. Mr. Tankersley is a frequent speaker at continuing education courses for K2 Enterprises, and publishes a nationally recognized blog on accounting and technology (www.cpatechblog.com). He has also served as the technology editor for a major accounting industry publication. Mr. Tankersley has over 20 years of professional experience, including accounting, auditing, technology, and education, and has been with K2 Enterprises since 2005. Tankersley has been recognized annually as one of the “Top 25 Thought Leaders in Public Accounting Technology” for 2011-2014 by Cygnus Business Media. Tankersley is also one of the principal authors of the 2015 Accounting Firm Operations and Technology Survey, which included over 500 US accounting firms. Brian has made presentations in 46 of the 50 US states and has served as a guest speaker for many professional accounting organizations across Canada. He received the Outstanding Discussion Leader Award from the Tennessee Society of CPAs in 2009 and 2013, and was recognized for writing the Article of the Year for the Tennessee CPA Journal in 2011. Brian has presented sessions at many national conferences, including AICPA TECH+/Practitioners Conference, The Sleeter Group’s Solutions Conference, Sage Insights, CCH Connections, and Thomson Reuters Synergy User Conference. Brian is both a Certified Public Accountant and Certified Information Technology Professional, and has bachelor’s degrees in both Accounting and Finance, cum laude, from the University of Tennessee. He is a certified public accountant (Tennessee), a certified information technology professional (CITP), and a Chartered Global Management Accountant (CGMA). Tankersley also holds numerous vendor software certifications, and is a member of the Tennessee Society of CPAs and the American Institute of CPAs. Brian and his family make their home in Farragut, Tennessee.
Non-Member Price $320.00
Member Price $270.00