|Author :||Lenny Wu, CPA, CGA, MBA|
|CPE Credits :||1.5|
|IRS Credits :||0|
|Passing Score :||70%|
|Course Type:||Video - NASBA QAS - NASBA Registry|
|Primary Subject-Field Of Study:||
Computer Software & Applications - Computer Software & Applications for Course Id 1784
The course is presented in four parts.
First, the course introduces a business case of a financial model that allegedly “did it all wrong”. The model requires over 30 steps and over 1 hour just to report on a simple 1-measure report. This becomes a great candidate for this Model Makeover course.
Next, the course lists what make a model great and how to achieve them:
Third, we illustrate the full skills of building the fully overhauled model that would only take 1 minute to generate the report with only 2 steps. The whole process includes:Data sourcing
Last, the course evaluating the newly built model to determine how well it meets the requirements of a great Excel model.
Please Note: This course’s author is working on the providing transcripts, PDFs, and slides where applicable. Unfortunately until then we will not be able to offer them with the course but felt the course was valuable enough as it is so have chosen to include it on our site. Our sincere apologies for any inconvenience and please let us know any question using the support bubble on the bottom right of all pages on our site.
|Usage Rank :||0|
|Experience Level :||Overview|
|Additional Contents :||Complete, no additional material needed.|
|Additional Links :|
|Advance Preparation :|
|Delivery Method :||QAS Self Study|
|Intended Participants :||Anyone needing Continuing Professional Education (CPE).|
|Revision Date :||28-Jan-2021|
|NASBA Course Declaration :||Participants must complete the final examination within one year of purchase and with a minimum passing grade of 70% or better to receive CPE credit unless otherwise noted on the Course History page (i.e. California Ethics must score 90% or better). After logging in click on the Course History links on your My Courses page for the Begin date and Expire date for the Final Exam.|
|Approved Audience :||
Video - NASBA QAS - NASBA Registry - 1784
|Keywords :||Computer Software & Applications, Excel, Model, Makeover, Reducing, Prep, Time, 1 hour, 1 minute, Video, cpe, cpa, online course|
|Learning Objectives :||
Course Learning ObjectivesAfter this course, you will be able to:
|Course Contents :||
Chapter 1 - Excel Model Makeover: Reducing Prep Time from 1 hour to 1 minute
Chapter 1 Review Questions