Login to your Account
Select the topics of your interest to receive Webinars/Virtual Events/E-Books/Podcasts of your interest.
Waterfall calculations are used to allocate cash flow among two or more partners based upon agreed-upon return parameters. In this hands-on workshop join Excel expert David H. Ringstrom, CPA as he brings his prior commercial real estate experience to the foreground by walking you through assembling a waterfall calculation from scratch.
David's effective "show-twice" process first walks you through a procedure by way of detailed PowerPoint slides and then demonstrates the techniques firsthand in the Office 365 version of Excel. David draws your attention to any differences in the older versions of Excel (2019, 2016, 2013, and earlier) during the presentation as well as in his detailed handouts. David also provides an Excel workbook that includes most of the examples he uses during the webcast.
Microsoft 365 is a subscription-based product that provides new feature updates as often as monthly. Conversely, the perpetual licensed versions of Excel have feature sets that don’t change. Perpetual licensed versions have year numbers, such as Excel 2019, Excel 2016, and so on.
The sessions of the conference qualifies for
CPA (US)
Date
Time
If you use Excel quite often, you know firsthand about the benefits of charts. Graphical representation of your data turns to be very helpful when you want to make a comparison or pinpoint a trend at a glance.
Microsoft Excel has lots of predefined chart types, including column, line, pie, bar, radar, etc. In this online CPE session, we will go above and beyond creating basic graphs and have a closer look at a special chart type - the Waterfall chart in Excel. You will find out what a waterfall chart is and how helpful it can be. You will know the secret of creating a waterfall chart in Excel 2010 - 2016 and learn about different utilities that can do it for you in a minute
Major topics covered in this online CPE session:
Subject Area:
Computer Software and Applications
Course Level:
Advance
Instuctional Method:
Group Internet Based
Pre-requisites:
Advance Preparation:
CPA (US)
Date
Time
In this CPE session work side-by-side with David by starting with a blank worksheet and detailing every input and formula. Concepts covered include using range names, although David also provides cell address references to use in lieu of range names if desired. David contrasts the IRR versus XIRR worksheet functions for computing investment returns, and incorporates other worksheet functions including MIN, ROUND, DATE, SUMIF, and more. Extensive check figures are also incorporated into the model to ensure data integrity and ease of use in following the calculations through the tiers.
Major Topics covered:
Subject Area:
Computer Software and Applications
Course Level:
Advance
Instuctional Method:
Group Internet Based
Pre-requisites:
Advance Preparation:
President
Excel Accountan...
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
myCPE is seamlessly integrated with ZOOM for conducting continuing education events. Please ensure that you check the system requirements before the event starts. The system requirements are :
There is an official break scheduled for this workshop/events. Other than the scheduled break, the in-session breaks shall be available at discretion of the speaker.
A live virtual event enables remote participants to access live, interactive networking opportunities and content through their computers/other digital devices, no matter where they are located. These events can be conducted in multiple formats;
Conference: A virtual conference is an activity, organized in a way that participants can meet and discuss themes of common interest through the use of communication tools at a central location on the Internet
Workshop: A workshop is not very different from a conference. The key point that makes a workshop unique is that it is a brief intensive educational program for a relatively small group of people that focuses especially on techniques and skills in a particular field.
The myCPE virtual events are designed to impart education around a specific theme or subject from a basic to an advanced level, which is why we do not recommend you to leave the event in between. However, if you had to leave the event because of some unforeseen circumstances, you would be granted the credits for the sessions that you attended completely and wherein you answered all the polling questions.
The recording of the event can be made available to you, on request. You can reach out to us at support@my-cpe.com or can also let us know through live chat support if you need a recording for this event. However, the recording shall not be available for Continuing Education Credits.
You can cancel your registration for a premium conference/workshop at any time before the start of the event. Upon successful cancellation the entire amount shall be credited to your myCPE wallet within 24-48 working hours. The balance in your myCPE wallet can be used to register for premium live webinars, premium self-study webinars, myCPE package courses or any other future virtual conference/workshop.
All the upcoming virtual events can be seen listed under the ‘Virtual Events’ tab on the homepage of myCPE (www.my-cpe.com).
A unique joining link will be shared with you on your registered email ID once you have registered for a conference. You can join in using the unique link at the scheduled time of the event. Also, the events that you have registered for are visible in your myCPE account under ‘My Virtual Events’ section >> under the ‘Upcoming Virtual Events’ tab. CLICK HERE to login to your account.
myCPE recommends that you verify if your digital device is compatible with the ZOOM software prior to attending the live events on myCPE (www.my-cpe.com)
For every Session you attend in a Virtual Event, you need to remain logged into the session till the end and answer the polling questions asked during the event. Once you have fulfilled these two criteria, you shall receive an evaluation form in the next 24 hours. You will receive an email with the link to complete the evaluation form and it will also be available in your myCPE account under the 'My Virtual Events’ section, under the 'Evaluation' tab. Once you complete the evaluation form, you will receive an email with your credit certificates and the same shall also be available in your myCPE account under the 'My Certificates' tab. The link in the certificate email is for downloading the certificates. If the event qualifies for multiple certificates, each certificate will be available for download.
Once you complete the evaluation form, you will receive an email with your credit certificates and the same shall also be available in your myCPE account under the 'My Certificates' tab. The link in the certificate email is for downloading the certificates. If the event qualifies for multiple certificates, each certificate will be available for download
During every conference the chat panel shall always be open. You can mention the issue faced by you in the chat panel and our moderator will take it up for resolution shortly. You can also reach out to our support team in the live chat support or at support@my-cpe.com
Yes, each live virtual conference/workshop shall be recorded and the recording of the same can be made available to on request. However, the recording shall not be eligible for continuing education credits.
If you’re a new user, you will have to sign-up at www.my-cpe.com to register for a virtual event. Click Here for a free sign up to myCPE. If you’re an existing user, you need to log in to your myCPE account.
Once you’re logged into your myCPE account, you can click on the ‘Virtual Event’ tab, scroll down to view the upcoming Virtual Events. There is a Register Button on each event detail page. Once you click on REGISTER, you will receive a prompt pop up that you have registered for the event. If it is a premium event then you will first be redirected to the payment page and after paying the amount you will receive a prompt pop up that you have registered for the event.
You can cancel your registration to any event from your myCPE account. Look under My Virtual Events >Upcoming Events. Simply click “Cancel Event” against the event that you do not wish to attend. If you cancel your registration for any paid event, the amount shall be credited in your myCPE wallet within 24-48 hours.
Your webinar schedule at sep 10,2021 | 02:00PM EST
Something Just Gone Wrong.
We use cookies to improve your experience on our website. Cookies store information about how a user interacts with Website. By clicking "Accept Cookies", you agree that MY-CPE LLC can store cookies on your device. All your data is anonymised and cannot be used to identify you.