EXCEL Challenges (Part II): Real Cases from Work

Continuing Education Credits
Click or touch a Credit for more information

Certified Public Accountant

Continuing Education Credit:
2 CPE Credit
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 credits have been granted based on a 50-minute hour.

Chartered Accountant (IES8 CPD)

Continuing Education Credit:
2 Hour
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:
2 CPE Credit
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:
2 CPE Credit
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.

Yellow Book

Continuing Education Credit:
2 CPE Credit
Field of Study:
Other
CPE Delivery Method:
Self-Study
Program Location:
Online
The GAO's Yellow Book, Government Auditing Standards, establishes CPE requirements. Auditors performing work under GAGAS, including planning, directing, performing field work, or reporting on an audit or attestation engagement under GAGAS, need to maintain their professional competence through continuing professional education (CPE). Therefore, each auditor performing work under GAGAS should complete, every two years, at least 80 hours of CPE that directly enhance the auditor's professional proficiency to perform audits and/or attestation engagements. At least 24 of the 80 hours of CPE should be in subjects directly related to government auditing, the government environment, or the specific or unique environment in which the audited entity operates. At least 20 hours of the 80 should be completed in any one year of the two-year period. For details on the Yellow Book CPE requirements go to http://www.gao.gov/ and https://www.gao.gov/assets/700/693136.pdf.

Certified Internal Auditor

Continuing Education Credit:
2 CPE Credit
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:
2 CPE Credit
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
  Introduction to EXCEL Challenges (Part II): Real Cases from Work5:37
Basic
  Case 1 – Rename a sheet (Basic)1:38
  Case 2 – Summary and detail views(Basic)4:02
  Case 3 – Add a line in a cell (Basic)4:04
  Case 4 – Quickly Change words (Basic)4:38
  Case 5 – Delete non-adjacent rows (Basic)3:26
  Case 6 – Text functions (Basic)9:04
Intermediate
  Case 7 – Tab name and file name (Intermediate)7:44
  Case 8 – Macro and macro recorder (Intermediate)9:22
  Case 9 – Dropdown list (Intermediate)6:30
Advanced
  Case 10 – Synched charts (Advanced)8:31
  Case 10 – Synched charts (Advanced) Continued9:45
  Summary 3:59
Continuous Play
  EXCEL Challenges (Part II): Real Cases from Work 1:22:41
SUPPORTING MATERIALS
  Slides: (Part II) Real Cases from WorkPDF
  Real Cases from Work Glossary/IndexPDF
  Excel challenges - Part 2XLSM
REVIEW and TEST
  REVIEW QUESTIONSquiz
 FINAL EXAMexam