My Shopping Cart
 
There are no items in your shopping cart.


Excel Know-How: Building Budget Spreadsheets (IME183K)

Presented by: David Ringstrom, CPA
 
(*) Single User Price. For multiple users please call 1-800-223-8720
Live Webinar
90 minutes
Event Description
1.0 CPE

Learn How to Create Easy-To-Use Budget Spreadsheets Using Excel

In this valuable session from Excel expert David H. Ringstrom, CPA, you’ll learn how to create resilient and easy-to-use budget spreadsheets. David will present helpful techniques, such as how to streamline formula writing, preserve key formulas, separate inputs from calculations, and create both operating and cash flow budgets.

David will also share the benefits associated with a variety of Excel functions and features to implement when building and updating budget spreadsheets. You will get a demonstration of every technique at least twice: first, on a PowerPoint slide with numbered steps, and second, in Excel 2016 and upon request, demonstration of techniques in a specific version of Excel. David will provide detailed handouts, with numbered steps, to serve as reference tools that you can fall back on, as well as an Excel workbook that will include a majority of the examples that will be used during the session.

Session Highlights

  • Preserve key formulas using hide and protect features
  • Improve the integrity of spreadsheets with Excel’s VLOOKUP function
  • Learn how the Table feature allows you to transform filtering tasks
  • Compare and contrast IFNA, IFERROR, and ISERROR functions and learn which versions of Excel support these worksheet functions
  • Streamline formula writing by using the Use in Formula command
  • Avoid the complexity of nested IF statements with Excel’s CHOOSE function
  • Go beyond simple rounding with the ROUNDUP and ROUNDDOWN worksheet functions
  • Use range names to streamline formulas and bookmark key inputs within a workbook
  • Use the SUMIF function to summarize data based on a single criterion

Who Should Attend

  • Accountants
  • CPAs
  • CFOs
  • Controllers
  • Excel users
  • Income tax preparers
  • Enrolled agents
  • Financial consultants
  • IT professionals
  • Auditors
  • Human resource personnel
  • Bookkeepers
  • Marketers
  • Government personnel

At the Q&A session following the live event, ask a question and get a direct response from our expert speaker.

About Our Speaker(s)

David Ringstrom | Microsoft Excel Courses  SpeakerDavid Ringstrom CPA
David H. Ringstrom, CPA, is an author and nationally recognized instructor who teaches scores of webinars each year. His Excel courses are based on over 25 years of consulting and teaching experience. David’s mantra is “Either you work Excel, or it works you,” so he focuses on what he sees users don’t, but shou... More info

 
Recommend this event to a colleague
  • Your Name:
  • Your E-mail:
  • Colleague's Name:
  • Colleague's E-mail:
  •  
    Subject: You might be interested in this event from AudioSolutionz
    Event Title: Excel Know-How: Building Budget Spreadsheets
    Presenter(s): David Ringstrom, CPA

 
DMCA.com Protection Status