Instructor for this course
more
Enrolled:
413
Duration: 1.5 Hours
Level: Intermediate
Access This Course: Instant Access to Course Library

Financial Modeling Using Excel

Continuing Education Credits
Click or touch a Credit for more information

Certified Public Accountant

Continuing Education Credit:
1.5 CPE Credit
Field of Study:
Finance
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

Continuing Professional Development

Continuing Education Credit:
1.5 Hour
Field of Study:
Accounting
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 credit.

Certified Management Accountant

Continuing Education Credit:
1.5 CPE Credit
Field of Study:
Finance
Program Location:
Online
Program Level:
Basic
Prerequisites:
No advanced preparation or prerequisites are required for this course.

Certified Fraud Examiner

Continuing Education Credit:
1.5 CPE Credit
Field of Study:
Financial Transactions and Fraud Schemes
CPE Delivery Method:
Self-Study
Program Location:
Online
Program Level:
Basic
Prerequisites:
No advanced preparation or prerequisites are required for this course.

Certified Government Financial Manager

Continuing Education Credit:
1.5 CPE Credit
Field of Study:
Financial Planning Or Analysis
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.5 CPE Credit
Field of Study:
Specific business topics such as finance and others
CPE Delivery Method:
Self-Study
Program Location:
Online
Program Level:
Basic
Prerequisites:
No advanced preparation or prerequisites are required for this course.
IIA CPE Provider 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.5 CPE Credit
Field of Study:
Specific business topics such as finance and others
CPE Delivery Method:
Self-Study
Program Location:
Online
Program Level:
Basic
Prerequisites:
No advanced preparation or prerequisites are required for this course.
IIA CPE Provider Seal


Recognized CPE provider, authorized by the Institute of Internal Auditors for use in the Certified Risk Management Assurance (CRMA) CPE program.

Society for Human Resource Management Certified Professional℠

Continuing Education Credit:
1.5 PDC Credit
Program Location:
Online
Program Level:
Basic
Prerequisites:
No advanced preparation or prerequisites are required for this course.
approved by SHRM



Illumeo is recognized by SHRM to offer Professional Development Credits (PDCs) for the SHRM-CP℠. This program is valid for 1.5 PDCs for the SHRM-CP℠. For more information about certification or recertification, please visit www.shrmcertification.org.

Society for Human Resource Management Senior Certified Professional℠

Continuing Education Credit:
1.5 PDC Credit
Program Location:
Online
Program Level:
Basic
Prerequisites:
No advanced preparation or prerequisites are required for this course.
approved by SHRM



Illumeo is recognized by SHRM to offer Professional Development Credits (PDCs) for the SHRM-SCP℠. This program is valid for 1.5 PDCs for the SHRM-SCP℠. For more information about certification or recertification, please visit www.shrmcertification.org.
Course Syllabus
INTRODUCTION AND OVERVIEW
Financial Modeling Using Excel
  9:19Planning your Financial Model
  12:29Building a Model Template
  13:13Projecting the Income Statement
  16:37Projecting the Balance Sheet
  14:22Projecting Cash Flows
  13:58Advanced Financial Modeling
Conclusion/Bonus Lesson
  7:49BONUS LESSON: Top 5 Excel Features for Financial Modellers
Continuous Play
  1:31:50Financial Modeling Using Excel
Lesson and Solutions
  XLSXStart and Solution 2
  XLSXStart and Solution 3
  XLSXStart and Solution 4
  XLSXStart and Solution 5
  XLSXStart and Solution 6
SUPPORTING MATERIALS
  PDFSlides: Financial Modeling Using Excel
  PDFFinancial Modeling Using Excel Glossary/Index
REVIEW & TEST
  quizREVIEW QUESTIONS
 examFINAL EXAM