Join us for an upcoming CPE webinar that will provide you with the skills and knowledge to create waterfall calculations in Excel. In this CPE course, Excel expert David H.Ringstrom, CPA, will walk you through assembling a waterfall calculation from scratch. David brings his prior commercial real estate experience to the forefront, ensuring that you'll learn practical skills that you can apply to your work right away.
Throughout the webinar, David covers important concepts such as range names, IRR vs. XIRR worksheet functions, and worksheet functions like MIN, ROUND, DATE, and SUMIF. David provides detailed handouts and uses check figures extensively throughout the model to ensure data integrity. You'll be able to easily follow the calculations through the tiers and understand every step of the process.
David will demonstrate every technique twice - first on a PowerPoint slide with numbered steps, and then in the subscription-based Microsoft 365 version of Excel. He will also draw attention to any differences in older versions of Excel (2019, 2016, 2013, and earlier) during the presentation. Plus, you'll receive an Excel workbook that includes most of the examples David uses during the webcast. Don't miss this opportunity to learn essential Excel skills for creating waterfall calculations. Register now for our upcoming CPE webinar.
Major topics covered in this CPE course on Excel:
Excel users, don't miss this chance to enhance your skills and learn from an expert. Whether you're a beginner or an experienced user, this webinar will provide you with valuable insights that you can apply to your work right away. Register now and get ready to take your Excel skills to the next level!
President, EXCEL Accountant
I own an Atlanta-based training and consulting firm that helps businesses nationwide streamline accounting challenges. Our specialties include:
Our services include training, technical support, accounting automation, and problem solving. I have spoken at conferences or meetings for these organizations:
I teach over 200 live webinars annually on Microsoft Excel across roughly two-dozen training providers. I am available for in-house training or select conference engagements as well.
I am the co-author of Idiot's Guide to Introductory Accounting. I've published hundreds of freelance articles on various topics, including Lotus 1-2-3, Quattro Pro, Microsoft Excel, Microsoft Office Accounting, QuickBooks, Peachtree Accounting, and more.
I serve as the technical editor for several books in Wiley's Dummies series, including QuickBooks for Dummies, Quicken for Dummies, Peachtree for Dummies, and more.
Specialties: Microsoft Excel, Visual Basic for Applications, Sage 50, Peachtree Accounting, QuickBooks, Microsoft Office Accounting, freelance writing, training, business consulting
Course Level
Credits
Instructional Method
Pre-requisites
Advance Preparation
MY-CPE LLC, 1600 Highway 6 south, suite 250, sugar land, TX, 77478
MY-CPE LLC (Sponsor Id#: 143597) is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors.
LD
This is the second course I have taken with this instructor and he did not disappoint. He is very effective at presenting the material. I was expecting something a little more advanced, but I still picked up a few things.
LL
This was a very informative CPE course. As an added bonus, it was very interesting and not hard to stay focused at all!
KB
David Ringstrom's courses are the best. I love the consistency of his course materials and his style of teaching.
EA
I leart a lot of new functions and good tips which will speed up my spreadsheet calculations a lot.
SR
I love David's Excel classes. I always learn something new!
Access to 13000+ Hours of Continuing Education Approved Content Know More
Subscribe To Access
