Attend upcoming webinar and earn continuing education credits. Creating Effective Excel Budget Spreadsheets | | | | | | | December | | 5 | 1 pm - 2:40 pm ET | | Presenter: David Ringstrom, CPA, author and nationally recognized Excel instructor | | Credits: CPE (Credit Details) | | Can't attend live? By registering, you will be able to view the course live, view a recording at any time after the live presentation, or both. | | Viewing Options: View on your computer, tablet, or smartphone | | Course Reviews: View Testimonials | | | | | | | | | | In this webinar, you'll learn how to build budget spreadsheets that can be updated effortlessly and contain easy-to-follow supporting calculations. You'll learn how to separate inputs from calculations, streamline formula writing, preserve key formulas, and create both operating and cash flow budgets. Upon completion of this course, you'll be able to: - Apply and isolate all user entries to an inputs worksheet and protect all calculations and budget schedules on additional worksheets
- Use range names and the Table feature to create resilient and easy-to-maintain spreadsheets
- Calculate borrowings from, and repayments toward, a working capital line of credit
- Apply several Excel functions, including:
- CHOOSE
- IFNA, IFERROR, and ISERROR
- ROUNDUP and ROUNDDOWN
- VLOOKUP
- SUM and SUMIF
Course Reviews from Past Attendees
92% of attendees recommend this webinar. "The webinar was very informative and I learned a few tricks I hadn't known about. I will definitely be using them in the future." "Excellent webinar – lots of great tips. Now I just need to figure out how to implement them!" "Loved the tips and tricks functions that he showed. Very useful!" "The explanation step by step was very helpful." | | | | | | | David H. Ringstrom, CPA, is an author and nationally recognized instructor who teaches scores of webinars each year. His Excel courses are based on 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 should, know about Microsoft Excel. His goal is to empower you to use Excel more effectively. | | | | | | | | | ● Earn continuing education credit for no additional fee ● Access courses on your computer, tablet, or smartphone ● More than 75 live webinars each month ● More than 1,300 on-demand courses | | | | | |
No comments:
Post a Comment