Excel 101: Establishing Structure and the Five Key Questions Every Spreadsheet Should Answer

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 (IES8 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-IES8 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.
Instructor for this course
Course Syllabus
INTRODUCTION AND OVERVIEW
Excel – Why Structure Matters
  Goals and how to achieve them4:44
  Illustrative example 17:30
Structuring Excel workbooks
  Excel User Groups: What They Need and How to Give It to Them5:41
  Illustrative example 25:49
Structuring Excel Calculations
  How best to approach calculations3:26
  Illustrative example 315:59
Excel Rules and Tips
  Ways to make your life a whole lot easier8:04
Conclusion
  Tips Demonstration and Course Conclusion1:10
Continuous Play
  Excel 101: Establishing Structure and the Five Key Questions Every Spreadsheet Should Answer 54:54
SUPPORTING MATERIALS
  Slides: Excel 101: Establishing Structure and the Five Key Questions Every Spreadsheet Should AnswerPDF
  Excel 101: Establishing Structure and the Five Key Questions Every Spreadsheet Should Answer Glossary/IndexPDF
  Calculation Examplexlsx
  Sales Incentive Calculationxlsx
  Template Base Filexlsx
REVIEW & TEST
  REVIEW QUESTIONSquiz
 FINAL EXAMexam