Instructor for this course
more

Excel Model Makeover 3: Reducing Update Time from 3 Hours to 3 Minutes

Continuing Education Credits
Click or touch a Credit for more information

Certified Public Accountant

Continuing Education Credit:
1 CPE Credits
Field of Study:
Computer Software & Applications
CPE Delivery Method:
Self-Study
Program Location:
Online
Program Level:
Basic
Prerequisites:
No advanced preparation or prerequisites are required for this course.
cpe/qas logo
Illumeo 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 the final authority on the acceptance of individual course for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: www.nasbaregistry.org.

NASBA Sponsor Number: 109504
State of New York Sponsor Number: 002746
State of Texas Sponsor Number: 009890
In accordance with the standards of the National Registry of CPE Sponsors, CPE credit have been granted based on a 50-minute hour.

Chartered Accountant (IES7 CPD)

Continuing Education Credit:
1 Hours
Field of Study:
Computer Software & Applications
CPE Delivery Method:
Self-Study
Program Location:
Online
Your specific provider of Continuing Professional Development accreditation has final authority on the acceptance of individual courses for CPD-IES7 credit.

Certified Management Accountant

Continuing Education Credit:
1 CPE Credits
Field of Study:
Computer Software & Applications
CPE Delivery Method:
Self-Study
Program Location:
Online
Program Level:
Basic
Prerequisites:
No advanced preparation or prerequisites are required for this course.

Certified Fraud Examiner

Continuing Education Credit:
1 CPE Credits
Field of Study:
Computer Software & Applications
CPE Delivery Method:
Self-Study
Program Location:
Online
Program Level:
Basic
Prerequisites:
No advanced preparation or prerequisites are required for this course.

Certified Internal Auditor

Continuing Education Credit:
1 CPE Credits
Field of Study:
Computer science
CPE Delivery Method:
Self-Study
Program Location:
Online
Program Level:
Basic
Prerequisites:
No advanced preparation or prerequisites are required for this course.
Registry of CPE Providers Seal


Recognized CPE provider, authorized by the Institute of Internal Auditors for use in the Certified Internal Auditor (CIA) CPE program.

Certification in Risk Management Assurance

Continuing Education Credit:
1 CPE Credits
Field of Study:
Other activities contributing to professional competence
CPE Delivery Method:
Self-Study
Program Location:
Online
Program Level:
Basic
Prerequisites:
No advanced preparation or prerequisites are required for this course.
Registry of CPE Providers Seal

Recognized CPE provider, authorized by the Institute of Internal Auditors for use in the Certified Risk Management Assurance (CRMA) CPE program.
Course Syllabus
INTRODUCTION AND OVERVIEW
  0:37Introduction to Excel Model Makeover 3: Reducing Update Time from 3 Hours to 3 Minutes
  1:54Real Business Case: How to Report from the System?
  1:26Before and After of the Makeover
  1:12Instructor Introduction
  1:18Comparison with Other Similar Courses
  0:40What you will get from this course?
How to Report from a Financial System?
  1:34First 2 ways of Reporting from a Financial System
  6:23Extracted Report from the System
  6:51Extracted Data from the System
  0:22Reporting from Financial System Wrap-up
System Reporting: 4 Best Practices
  1:36Best Practice No. 1
  1:27Best Practice No. 2
  2:38Best Practice No. 3
  1:48Best Practice No. 4
PowerPoint update: 2 Best Practices
  6:19Best Practice No. 5
  2:53Best Practice No. 6
  2:29Before and After of the Makeover - A Revisit
BONUS VBA
  5:37VBA Macro
CONCLUSION
  1:32Takeaways
  0:29Next Course & Q&A
CONTINUOUS PLAY
  49:04Excel Model Makeover 3: Reducing Update Time from 3 Hours to 3 Minutes
SUPPORTING MATERIAL
  PDFSlides: Excel Model Makeover 3: Reducing Update Time from 3 Hours to 3 Minutes
  PDFExcel Model Makeover 3: Reducing Update Time from 3 Hours to 3 Minutes Glossary/ Index
  XLSMWorkbook: Excel Model Makeover 3: Reducing Update Time from 3 Hours to 3 Minutes
  CSVWorkbook: Detailed Statement Extract
REVIEW AND TEST
  quizREVIEW QUESTIONS
 examFINAL EXAM