myCPE
myCPE

Certified Basic Excel Professional Course (CBEPC)

Streamline your work with Excel basics.

Ratings

  • rating
  • rating
  • rating
  • rating
  • rating

Last Updated

February, 2025

Multiple
44
On Demand
Included with Subscription

Why Professionals Trust Our Advance Certification Programs

  • Access to cutting-edge industry knowledge and practices.
  • Comprehensive training designed to meet professional needs.
  • Fulfill compliance requirements while acquiring valuable skills.
  • Ongoing updates to course content for relevant industry trends.
certificate
certificate
certificate

What You’ll learn

Are you ready to become proficient in Excel? The Certified Basic Excel Professional Course (CBEPC) is designed for professionals looking to build solid Excel skills for everyday tasks. From data management to error-free spreadsheets, this course will boost your confidence in handling Excel’s basic functions. By the end, you’ll master essential Excel features and improve workflow efficiency.

Get Deeper Understanding of:

  • Excel’s sorting and filtering tools for precise data management.
  • The role of conditional formatting in data visualization.
  • Data entry shortcuts and techniques to improve accuracy.
  • Creating simple yet effective charts for data presentation.
  • Leveraging cell references for dynamic and scalable formulas.

Recommended For:

  • CPAs and finance professionals aiming to strengthen their foundational Excel skills for efficient data analysis, reporting, and auditing.
  • Individuals in roles requiring proficiency in managing datasets, creating dynamic reports, or optimizing workflows through Excel automation.
  • Anyone looking to boost their productivity and problem-solving capabilities by mastering essential Excel tools and techniques.

Why take the Certified Basic Excel Professional Course (CBEPC) Course with MYCPE ONE?

Resources included

  • Handout PDFs for every Module
  • Glossary/Key Terms for every module
  • Q&A directly with instructors

Career Opportunities

  • Excel Data Analyst
  • Financial Analyst
  • Operations Analyst
  • Spreadsheet Management Specialist
  • Data Entry Supervisor

Value Addition to your skills

  • Excel Function Proficiency
  • Efficient Data Management
  • Error-Free Spreadsheet Creation
  • Formatting and Automation Techniques
  • Enhanced Reporting and Presentation Skills

Courses

Course Title Time Credits Learning Format
1. 11 Timesaving Worksheet Functions
1.5 Hours
License details Credits Status
Computer Software and Applications for Certified Public Accountants (CPA-US) 1.5 CPE Approved
Computer Software and Applications for CPA in Canada 1.5 CPD Eligible
Computer Software and Applications for Delaware Licensed Public Accountant (DE-LPA) 1.5 CPE Eligible
Information Technology for Certified Government Financial Manager (CGFM) 1.5 CPE Eligible
Computer Software and Applications for Certified Fraud Examiner (CFE) 1.5 CPE Eligible
Association of Chartered Certified Accountants (ACCA) 1.5 CPD Eligible
Chartered Accountant - ICAEW 1.5 CPD Eligible
Computer Software and Applications for Iowa Licensed Public Accountant (IA-LPA) 1.5 CPE Eligible
Computer Software and Applications for Maine Licensed Public Accountant (ME-LPA) 1.5 CPE Eligible
Chartered Accountants - Ireland (CAI) 1.5 CPD Eligible
Chartered Accountants - Scotland 1.5 CPD Eligible
CPA - Ireland 1.5 CPD Eligible
Information Technology (inc. Excel) for Certified FP&A Professional (FP&A) 1.5 CE Eligible
License details Credits Status
Computer Software and Applications for Certified Public Accountants (CPA-US) 1.5 CPE Approved
Computer Software and Applications for CPA in Canada 1.5 CPD Eligible
Computer Software and Applications for Delaware Licensed Public Accountant (DE-LPA) 1.5 CPE Eligible
Information Technology for Certified Government Financial Manager (CGFM) 1.5 CPE Eligible
Computer Software and Applications for Certified Fraud Examiner (CFE) 1.5 CPE Eligible
Association of Chartered Certified Accountants (ACCA) 1.5 CPD Eligible
Chartered Accountant - ICAEW 1.5 CPD Eligible
Computer Software and Applications for Iowa Licensed Public Accountant (IA-LPA) 1.5 CPE Eligible
Computer Software and Applications for Maine Licensed Public Accountant (ME-LPA) 1.5 CPE Eligible
Chartered Accountants - Ireland (CAI) 1.5 CPD Eligible
Chartered Accountants - Scotland 1.5 CPD Eligible
CPA - Ireland 1.5 CPD Eligible
Information Technology (inc. Excel) for Certified FP&A Professional (FP&A) 1.5 CE Eligible
On Demand (video)
  • Define and understand the key arguments of Excel’s VLOOKUP function.
  • Identify the character used in SUMPRODUCT to separate criteria arguments for summing or counting values.
  • Explain how the SUMIFS function behaves when no match is found.
2. 14 Ways To Minimize Data Entry In Excel
1.5 Hours
License details Credits Status
Accounting for Certified Public Accountants (CPA-US) 1.5 CPE Approved
Accounting for CPA in Canada 1.5 CPD Eligible
Accounting for Delaware Licensed Public Accountant (DE-LPA) 1.5 CPE Eligible
Accounting for Certified Government Financial Manager (CGFM) 1.5 CPE Eligible
Accounting for Certified Fraud Examiner (CFE) 1.5 CPE Eligible
Association of Chartered Certified Accountants (ACCA) 1.5 CPD Eligible
Chartered Accountant - ICAEW 1.5 CPD Eligible
Accounting for Iowa Licensed Public Accountant (IA-LPA) 1.5 CPE Eligible
Federal tax-related matters for Maryland Tax Preparer (MRTP) (Approval No. GEHNZ-T-00755-21-S) (Valid upto : Dec 31, 2024) 1 CE Approved
Accounting for Maine Licensed Public Accountant (ME-LPA) 1.5 CPE Eligible
Chartered Accountants - Ireland (CAI) 1.5 CPD Eligible
CPA - Ireland 1.5 CPD Eligible
Chartered Accountants - Scotland 1.5 CPD Eligible
Information Technology (inc. Excel) for Certified FP&A Professional (FP&A) 1.5 CE Eligible
License details Credits Status
Accounting for Certified Public Accountants (CPA-US) 1.5 CPE Approved
Accounting for CPA in Canada 1.5 CPD Eligible
Accounting for Delaware Licensed Public Accountant (DE-LPA) 1.5 CPE Eligible
Accounting for Certified Government Financial Manager (CGFM) 1.5 CPE Eligible
Accounting for Certified Fraud Examiner (CFE) 1.5 CPE Eligible
Association of Chartered Certified Accountants (ACCA) 1.5 CPD Eligible
Chartered Accountant - ICAEW 1.5 CPD Eligible
Accounting for Iowa Licensed Public Accountant (IA-LPA) 1.5 CPE Eligible
Federal tax-related matters for Maryland Tax Preparer (MRTP) (Approval No. GEHNZ-T-00755-21-S) (Valid upto : Dec 31, 2024) 1 CE Approved
Accounting for Maine Licensed Public Accountant (ME-LPA) 1.5 CPE Eligible
Chartered Accountants - Ireland (CAI) 1.5 CPD Eligible
CPA - Ireland 1.5 CPD Eligible
Chartered Accountants - Scotland 1.5 CPD Eligible
Information Technology (inc. Excel) for Certified FP&A Professional (FP&A) 1.5 CE Eligible
On Demand (video)
  • Analyze the character that you can use in lieu of the CONCATENATE worksheet function.
  • Identify the Office applications that offer the ability to open and edit PDF files.
  • Explain the functionality that the Flash Fill feature offers.
3. Basic Excel Skills for Professionals
1 Hour
License details Credits Status
Computer Software and Applications for Certified Public Accountants (CPA-US) 1 CPE Approved
Computer Software and Applications for CPA in Canada 1 CPD Eligible
Computer Software and Applications for Delaware Licensed Public Accountant (DE-LPA) 1 CPE Eligible
Information Technology for Certified Government Financial Manager (CGFM) 1 CPE Eligible
Computer Software and Applications for Certified Fraud Examiner (CFE) 1 CPE Eligible
Association of Chartered Certified Accountants (ACCA) 1 CPD Eligible
Chartered Accountant - ICAEW 1 CPD Eligible
Computer Software and Applications for Iowa Licensed Public Accountant (IA-LPA) 1 CPE Eligible
Computer Software and Applications for Maine Licensed Public Accountant (ME-LPA) 1 CPE Eligible
Chartered Accountants - Ireland (CAI) 1 CPD Eligible
CPA - Ireland 1 CPD Eligible
Chartered Accountants - Scotland 1 CPD Eligible
Information Technology (inc. Excel) for Certified FP&A Professional (FP&A) 1 CE Eligible
License details Credits Status
Computer Software and Applications for Certified Public Accountants (CPA-US) 1 CPE Approved
Computer Software and Applications for CPA in Canada 1 CPD Eligible
Computer Software and Applications for Delaware Licensed Public Accountant (DE-LPA) 1 CPE Eligible
Information Technology for Certified Government Financial Manager (CGFM) 1 CPE Eligible
Computer Software and Applications for Certified Fraud Examiner (CFE) 1 CPE Eligible
Association of Chartered Certified Accountants (ACCA) 1 CPD Eligible
Chartered Accountant - ICAEW 1 CPD Eligible
Computer Software and Applications for Iowa Licensed Public Accountant (IA-LPA) 1 CPE Eligible
Computer Software and Applications for Maine Licensed Public Accountant (ME-LPA) 1 CPE Eligible
Chartered Accountants - Ireland (CAI) 1 CPD Eligible
CPA - Ireland 1 CPD Eligible
Chartered Accountants - Scotland 1 CPD Eligible
Information Technology (inc. Excel) for Certified FP&A Professional (FP&A) 1 CE Eligible
On Demand (video)
  • Define the correct argument in Excel's SUBTOTAL function for summing data.
  • Identify Excel versions supporting slicers for tables and pivot tables.
  • Demonstrate the use of the Open and Repair command in Excel.
4. Conditional Formatting
1 Hour
License details Credits Status
Computer Software and Applications for Certified Public Accountants (CPA-US) 1 CPE Approved
Computer Software and Applications for CPA in Canada 1 CPD Eligible
Computer Software and Applications for Delaware Licensed Public Accountant (DE-LPA) 1 CPE Eligible
Information Technology for Certified Government Financial Manager (CGFM) 1 CPE Eligible
Computer Software and Applications for Certified Fraud Examiner (CFE) 1 CPE Eligible
Association of Chartered Certified Accountants (ACCA) 1 CPD Eligible
Chartered Accountant - ICAEW 1 CPD Eligible
Computer Software and Applications for Iowa Licensed Public Accountant (IA-LPA) 1 CPE Eligible
Computer technology for Maryland Tax Preparer (MRTP) (Approval No. GEHNZ-T-01258-22-S) 1 CE Approved
Computer Software and Applications for Maine Licensed Public Accountant (ME-LPA) 1 CPE Eligible
Chartered Accountants - Ireland (CAI) 1 CPD Eligible
Chartered Accountants - Scotland 1 CPD Eligible
CPA - Ireland 1 CPD Eligible
Information Technology (inc. Excel) for Certified FP&A Professional (FP&A) 1 CE Eligible
License details Credits Status
Computer Software and Applications for Certified Public Accountants (CPA-US) 1 CPE Approved
Computer Software and Applications for CPA in Canada 1 CPD Eligible
Computer Software and Applications for Delaware Licensed Public Accountant (DE-LPA) 1 CPE Eligible
Information Technology for Certified Government Financial Manager (CGFM) 1 CPE Eligible
Computer Software and Applications for Certified Fraud Examiner (CFE) 1 CPE Eligible
Association of Chartered Certified Accountants (ACCA) 1 CPD Eligible
Chartered Accountant - ICAEW 1 CPD Eligible
Computer Software and Applications for Iowa Licensed Public Accountant (IA-LPA) 1 CPE Eligible
Computer technology for Maryland Tax Preparer (MRTP) (Approval No. GEHNZ-T-01258-22-S) 1 CE Approved
Computer Software and Applications for Maine Licensed Public Accountant (ME-LPA) 1 CPE Eligible
Chartered Accountants - Ireland (CAI) 1 CPD Eligible
Chartered Accountants - Scotland 1 CPD Eligible
CPA - Ireland 1 CPD Eligible
Information Technology (inc. Excel) for Certified FP&A Professional (FP&A) 1 CE Eligible
On Demand (video)
  • Apply various Conditional Formatting options, including Top/Bottom Rules, Highlight Cells, Data Bars, Color Scales, and Icon Sets.
  • Format cells dynamically using Excel formulas in Conditional Formatting.
  • Highlight key data points effectively with advanced Conditional Formatting techniques.
5. Excel Accountant : Error Prompts
2 Hours
License details Credits Status
Computer Software and Applications for Certified Public Accountants (CPA-US) 2 CPE Approved
Computer Software and Applications for CPA in Canada 2 CPD Eligible
Computer Software and Applications for Delaware Licensed Public Accountant (DE-LPA) 2 CPE Eligible
Information Technology for Certified Government Financial Manager (CGFM) 2 CPE Eligible
Computer Software and Applications for Certified Fraud Examiner (CFE) 2 CPE Eligible
Association of Chartered Certified Accountants (ACCA) 2 CPD Eligible
Chartered Accountant - ICAEW 2 CPD Eligible
Computer Software and Applications for Iowa Licensed Public Accountant (IA-LPA) 2 CPE Eligible
Computer Software and Applications for Maine Licensed Public Accountant (ME-LPA) 2 CPE Eligible
Chartered Accountants - Ireland (CAI) 2 CPD Eligible
Chartered Accountants - Scotland 2 CPD Eligible
CPA - Ireland 2 CPD Eligible
Information Technology (inc. Excel) for Certified FP&A Professional (FP&A) 2 CE Eligible
License details Credits Status
Computer Software and Applications for Certified Public Accountants (CPA-US) 2 CPE Approved
Computer Software and Applications for CPA in Canada 2 CPD Eligible
Computer Software and Applications for Delaware Licensed Public Accountant (DE-LPA) 2 CPE Eligible
Information Technology for Certified Government Financial Manager (CGFM) 2 CPE Eligible
Computer Software and Applications for Certified Fraud Examiner (CFE) 2 CPE Eligible
Association of Chartered Certified Accountants (ACCA) 2 CPD Eligible
Chartered Accountant - ICAEW 2 CPD Eligible
Computer Software and Applications for Iowa Licensed Public Accountant (IA-LPA) 2 CPE Eligible
Computer Software and Applications for Maine Licensed Public Accountant (ME-LPA) 2 CPE Eligible
Chartered Accountants - Ireland (CAI) 2 CPD Eligible
Chartered Accountants - Scotland 2 CPD Eligible
CPA - Ireland 2 CPD Eligible
Information Technology (inc. Excel) for Certified FP&A Professional (FP&A) 2 CE Eligible
On Demand (video)
  • Identify common errors in Excel worksheets and use error-checking prompts and commands to manage them.
  • Apply Excel’s Filter feature to detect specific errors and improve error-tracing accuracy.
  • Recall how to enable backup creation and adjust settings for Protected View to enhance data recovery and security.
6. Excel Accountant Member Exclusive: Printing & Page Layout
1 Hour
License details Credits Status
Computer Software and Applications for Certified Public Accountants (CPA-US) 1 CPE Approved
Computer Software and Applications for CPA in Canada 1 CPD Eligible
Computer Software and Applications for Delaware Licensed Public Accountant (DE-LPA) 1 CPE Eligible
Information Technology for Certified Government Financial Manager (CGFM) 1 CPE Eligible
Computer Software and Applications for Certified Fraud Examiner (CFE) 1 CPE Eligible
Association of Chartered Certified Accountants (ACCA) 1 CPD Eligible
Chartered Accountant - ICAEW 1 CPD Eligible
Computer Software and Applications for Iowa Licensed Public Accountant (IA-LPA) 1 CPE Eligible
Computer Software and Applications for Maine Licensed Public Accountant (ME-LPA) 1 CPE Eligible
Chartered Accountants - Ireland (CAI) 1 CPD Eligible
Chartered Accountants - Scotland 1 CPD Eligible
CPA - Ireland 1 CPD Eligible
Information Technology (inc. Excel) for Certified FP&A Professional (FP&A) 1 CE Eligible
License details Credits Status
Computer Software and Applications for Certified Public Accountants (CPA-US) 1 CPE Approved
Computer Software and Applications for CPA in Canada 1 CPD Eligible
Computer Software and Applications for Delaware Licensed Public Accountant (DE-LPA) 1 CPE Eligible
Information Technology for Certified Government Financial Manager (CGFM) 1 CPE Eligible
Computer Software and Applications for Certified Fraud Examiner (CFE) 1 CPE Eligible
Association of Chartered Certified Accountants (ACCA) 1 CPD Eligible
Chartered Accountant - ICAEW 1 CPD Eligible
Computer Software and Applications for Iowa Licensed Public Accountant (IA-LPA) 1 CPE Eligible
Computer Software and Applications for Maine Licensed Public Accountant (ME-LPA) 1 CPE Eligible
Chartered Accountants - Ireland (CAI) 1 CPD Eligible
Chartered Accountants - Scotland 1 CPD Eligible
CPA - Ireland 1 CPD Eligible
Information Technology (inc. Excel) for Certified FP&A Professional (FP&A) 1 CE Eligible
On Demand (video)
  • Demonstrate printing a chart and using the Print Titles command.
  • Identify the command to add to the Quick Access Toolbar for Print Preview.
  • Answer all attendee questions thoroughly on Excel printing options.
7. Excel Accountant: Benefits/Risks of Office 365
2 Hours
License details Credits Status
Computer Software and Applications for Certified Public Accountants (CPA-US) 2 CPE Approved
Computer Software and Applications for CPA in Canada 2 CPD Eligible
Computer Software and Applications for Delaware Licensed Public Accountant (DE-LPA) 2 CPE Eligible
Computer Software and Applications for Certified Fraud Examiner (CFE) 2 CPE Eligible
Association of Chartered Certified Accountants (ACCA) 2 CPD Eligible
Chartered Accountant - ICAEW 2 CPD Eligible
Computer Software and Applications for Iowa Licensed Public Accountant (IA-LPA) 2 CPE Eligible
Computer Software and Applications for Maine Licensed Public Accountant (ME-LPA) 2 CPE Eligible
Chartered Accountants - Ireland (CAI) 2 CPD Eligible
Chartered Accountants - Scotland 2 CPD Eligible
CPA - Ireland 2 CPD Eligible
Information Technology (inc. Excel) for Certified FP&A Professional (FP&A) 2 CE Eligible
License details Credits Status
Computer Software and Applications for Certified Public Accountants (CPA-US) 2 CPE Approved
Computer Software and Applications for CPA in Canada 2 CPD Eligible
Computer Software and Applications for Delaware Licensed Public Accountant (DE-LPA) 2 CPE Eligible
Computer Software and Applications for Certified Fraud Examiner (CFE) 2 CPE Eligible
Association of Chartered Certified Accountants (ACCA) 2 CPD Eligible
Chartered Accountant - ICAEW 2 CPD Eligible
Computer Software and Applications for Iowa Licensed Public Accountant (IA-LPA) 2 CPE Eligible
Computer Software and Applications for Maine Licensed Public Accountant (ME-LPA) 2 CPE Eligible
Chartered Accountants - Ireland (CAI) 2 CPD Eligible
Chartered Accountants - Scotland 2 CPD Eligible
CPA - Ireland 2 CPD Eligible
Information Technology (inc. Excel) for Certified FP&A Professional (FP&A) 2 CE Eligible
On Demand (video)
  • Recall the benefits and risks of sharing workbooks via OneDrive in Office 365.
  • Explore the evolution of worksheet functions and the MAXIFS function in Excel 2016.
  • Identify the Recommended PivotTables feature and the missing folders link in Excel's Recent Menu.
8. Excel Accountant: Charts
2 Hours
License details Credits Status
Computer Software and Applications for Certified Public Accountants (CPA-US) 2 CPE Approved
Computer Software and Applications for CPA in Canada 2 CPD Eligible
Computer Software and Applications for Delaware Licensed Public Accountant (DE-LPA) 2 CPE Eligible
Computer Software and Applications for Certified Fraud Examiner (CFE) 2 CPE Eligible
Association of Chartered Certified Accountants (ACCA) 2 CPD Eligible
Chartered Accountant - ICAEW 2 CPD Eligible
Computer Software and Applications for Iowa Licensed Public Accountant (IA-LPA) 2 CPE Eligible
Computer Software and Applications for Maine Licensed Public Accountant (ME-LPA) 2 CPE Eligible
Chartered Accountants - Ireland (CAI) 2 CPD Eligible
Chartered Accountants - Scotland 2 CPD Eligible
CPA - Ireland 2 CPD Eligible
Information Technology (inc. Excel) for Certified FP&A Professional (FP&A) 2 CE Eligible
License details Credits Status
Computer Software and Applications for Certified Public Accountants (CPA-US) 2 CPE Approved
Computer Software and Applications for CPA in Canada 2 CPD Eligible
Computer Software and Applications for Delaware Licensed Public Accountant (DE-LPA) 2 CPE Eligible
Computer Software and Applications for Certified Fraud Examiner (CFE) 2 CPE Eligible
Association of Chartered Certified Accountants (ACCA) 2 CPD Eligible
Chartered Accountant - ICAEW 2 CPD Eligible
Computer Software and Applications for Iowa Licensed Public Accountant (IA-LPA) 2 CPE Eligible
Computer Software and Applications for Maine Licensed Public Accountant (ME-LPA) 2 CPE Eligible
Chartered Accountants - Ireland (CAI) 2 CPD Eligible
Chartered Accountants - Scotland 2 CPD Eligible
CPA - Ireland 2 CPD Eligible
Information Technology (inc. Excel) for Certified FP&A Professional (FP&A) 2 CE Eligible
On Demand (video)
  • Identify how to hide and unhide worksheets, and use the Custom Views feature to manage multiple data purposes and hidden/visible settings.
  • Recognize how to implement the Zoom feature to navigate worksheets and make edits across multiple sheets simultaneously.
  • Recall how to manage print settings and visibility for columns, rows, and worksheets using Custom Views.
9. Excel Accountant: Creating Error-Free Excel Spreadsheets
1 Hour
License details Credits Status
Computer Software and Applications for Certified Public Accountants (CPA-US) 1 CPE Approved
Computer Software and Applications for CPA in Canada 1 CPD Eligible
Computer Software and Applications for Delaware Licensed Public Accountant (DE-LPA) 1 CPE Eligible
Association of Chartered Certified Accountants (ACCA) 1 CPD Eligible
Chartered Accountant - ICAEW 1 CPD Eligible
Computer Software and Applications for Iowa Licensed Public Accountant (IA-LPA) 1 CPE Eligible
Computer technology for Maryland Tax Preparer (MRTP) (Approval No. GEHNZ-T-01214-22-S) 1 CE Approved
Computer Software and Applications for Maine Licensed Public Accountant (ME-LPA) 1 CPE Eligible
Chartered Accountants - Ireland (CAI) 1 CPD Eligible
Chartered Accountants - Scotland 1 CPD Eligible
CPA - Ireland 1 CPD Eligible
License details Credits Status
Computer Software and Applications for Certified Public Accountants (CPA-US) 1 CPE Approved
Computer Software and Applications for CPA in Canada 1 CPD Eligible
Computer Software and Applications for Delaware Licensed Public Accountant (DE-LPA) 1 CPE Eligible
Association of Chartered Certified Accountants (ACCA) 1 CPD Eligible
Chartered Accountant - ICAEW 1 CPD Eligible
Computer Software and Applications for Iowa Licensed Public Accountant (IA-LPA) 1 CPE Eligible
Computer technology for Maryland Tax Preparer (MRTP) (Approval No. GEHNZ-T-01214-22-S) 1 CE Approved
Computer Software and Applications for Maine Licensed Public Accountant (ME-LPA) 1 CPE Eligible
Chartered Accountants - Ireland (CAI) 1 CPD Eligible
Chartered Accountants - Scotland 1 CPD Eligible
CPA - Ireland 1 CPD Eligible
On Demand (video)
  • Identify the required arguments for Excel's IFERROR function.
  • Define the argument in the SUBTOTAL function used to sum columns or rows.
  • Recall how to apply Conditional Formatting to highlight unlocked cells for data entry.
10. Excel Accountant: Dynamic Arrays
2 Hours
License details Credits Status
Computer Software and Applications for Certified Public Accountants (CPA-US) 2 CPE Approved
Computer Software and Applications for CPA in Canada 2 CPD Eligible
Computer Software and Applications for Delaware Licensed Public Accountant (DE-LPA) 2 CPE Eligible
Computer Software and Applications for Certified Fraud Examiner (CFE) 2 CPE Eligible
Association of Chartered Certified Accountants (ACCA) 2 CPD Eligible
Chartered Accountant - ICAEW 2 CPD Eligible
Computer Software and Applications for Iowa Licensed Public Accountant (IA-LPA) 2 CPE Eligible
Computer Software and Applications for Maine Licensed Public Accountant (ME-LPA) 2 CPE Eligible
Computer technology for Maryland Tax Preparer (MRTP) (Approval No. GEHNZ-T-00978-22-S) 2 CE Approved
Chartered Accountants - Ireland (CAI) 2 CPD Eligible
Chartered Accountants - Scotland 2 CPD Eligible
CPA - Ireland 2 CPD Eligible
Information Technology (inc. Excel) for Certified FP&A Professional (FP&A) 2 CE Eligible
License details Credits Status
Computer Software and Applications for Certified Public Accountants (CPA-US) 2 CPE Approved
Computer Software and Applications for CPA in Canada 2 CPD Eligible
Computer Software and Applications for Delaware Licensed Public Accountant (DE-LPA) 2 CPE Eligible
Computer Software and Applications for Certified Fraud Examiner (CFE) 2 CPE Eligible
Association of Chartered Certified Accountants (ACCA) 2 CPD Eligible
Chartered Accountant - ICAEW 2 CPD Eligible
Computer Software and Applications for Iowa Licensed Public Accountant (IA-LPA) 2 CPE Eligible
Computer Software and Applications for Maine Licensed Public Accountant (ME-LPA) 2 CPE Eligible
Computer technology for Maryland Tax Preparer (MRTP) (Approval No. GEHNZ-T-00978-22-S) 2 CE Approved
Chartered Accountants - Ireland (CAI) 2 CPD Eligible
Chartered Accountants - Scotland 2 CPD Eligible
CPA - Ireland 2 CPD Eligible
Information Technology (inc. Excel) for Certified FP&A Professional (FP&A) 2 CE Eligible
On Demand (video)
  • Recognize dynamic array functions and the Spilled Range Operator in Excel.
  • Identify the function for calculating the principal portion of a loan payment.
  • Explore data validation and filtering functions in Excel.
11. Excel Accountant: Filtering Data
2 Hours
License details Credits Status
Computer Software and Applications for Certified Public Accountants (CPA-US) 2 CPE Approved
Computer Software and Applications for CPA in Canada 2 CPD Eligible
Computer Software and Applications for Delaware Licensed Public Accountant (DE-LPA) 2 CPE Eligible
Information Technology for Certified Government Financial Manager (CGFM) 2 CPE Eligible
Computer Software and Applications for Certified Fraud Examiner (CFE) 2 CPE Eligible
Association of Chartered Certified Accountants (ACCA) 2 CPD Eligible
Chartered Accountant - ICAEW 2 CPD Eligible
Computer Software and Applications for Iowa Licensed Public Accountant (IA-LPA) 2 CPE Eligible
Computer Software and Applications for Maine Licensed Public Accountant (ME-LPA) 2 CPE Eligible
Chartered Accountants - Ireland (CAI) 2 CPD Eligible
Chartered Accountants - Scotland 2 CPD Eligible
CPA - Ireland 2 CPD Eligible
Information Technology (inc. Excel) for Certified FP&A Professional (FP&A) 2 CE Eligible
License details Credits Status
Computer Software and Applications for Certified Public Accountants (CPA-US) 2 CPE Approved
Computer Software and Applications for CPA in Canada 2 CPD Eligible
Computer Software and Applications for Delaware Licensed Public Accountant (DE-LPA) 2 CPE Eligible
Information Technology for Certified Government Financial Manager (CGFM) 2 CPE Eligible
Computer Software and Applications for Certified Fraud Examiner (CFE) 2 CPE Eligible
Association of Chartered Certified Accountants (ACCA) 2 CPD Eligible
Chartered Accountant - ICAEW 2 CPD Eligible
Computer Software and Applications for Iowa Licensed Public Accountant (IA-LPA) 2 CPE Eligible
Computer Software and Applications for Maine Licensed Public Accountant (ME-LPA) 2 CPE Eligible
Chartered Accountants - Ireland (CAI) 2 CPD Eligible
Chartered Accountants - Scotland 2 CPD Eligible
CPA - Ireland 2 CPD Eligible
Information Technology (inc. Excel) for Certified FP&A Professional (FP&A) 2 CE Eligible
On Demand (video)
  • Identify how actions like row deletions or formatting impact data during worksheet filtering.
  • Recognize valid filtering options available in Excel.
  • Describe the keyboard shortcut for deleting selected rows or columns efficiently.
12. Excel Accountant: Intro to Lookup Functions
2 Hours
License details Credits Status
Computer Software and Applications for Certified Public Accountants (CPA-US) 2 CPE Approved
Computer Software and Applications for CPA in Canada 2 CPD Eligible
Computer Software and Applications for Delaware Licensed Public Accountant (DE-LPA) 2 CPE Eligible
Association of Chartered Certified Accountants (ACCA) 2 CPD Eligible
Chartered Accountant - ICAEW 2 CPD Eligible
Computer Software and Applications for Iowa Licensed Public Accountant (IA-LPA) 2 CPE Eligible
Computer Software and Applications for Maine Licensed Public Accountant (ME-LPA) 2 CPE Eligible
Information Technology (inc. Excel) for Certified FP&A Professional (FP&A) 2 CE Eligible
Chartered Accountants - Ireland (CAI) 2 CPD Eligible
Chartered Accountants - Scotland 2 CPD Eligible
CPA - Ireland 2 CPD Eligible
License details Credits Status
Computer Software and Applications for Certified Public Accountants (CPA-US) 2 CPE Approved
Computer Software and Applications for CPA in Canada 2 CPD Eligible
Computer Software and Applications for Delaware Licensed Public Accountant (DE-LPA) 2 CPE Eligible
Association of Chartered Certified Accountants (ACCA) 2 CPD Eligible
Chartered Accountant - ICAEW 2 CPD Eligible
Computer Software and Applications for Iowa Licensed Public Accountant (IA-LPA) 2 CPE Eligible
Computer Software and Applications for Maine Licensed Public Accountant (ME-LPA) 2 CPE Eligible
Information Technology (inc. Excel) for Certified FP&A Professional (FP&A) 2 CE Eligible
Chartered Accountants - Ireland (CAI) 2 CPD Eligible
Chartered Accountants - Scotland 2 CPD Eligible
CPA - Ireland 2 CPD Eligible
On Demand (video)
  • Explain and analyze key arguments in functions like VLOOKUP and SUMIF to enhance data accuracy and efficiency.
  • Leverage Excel features such as Tables and comparative functions like MIN, MAX, SMALL, and LARGE for improved data analysis.
  • Identify and troubleshoot common Excel errors, including #REF!, #NAME!, and #VALUE!, to ensure data integrity.
13. Excel Accountant: Intro to Spreadsheets In-Depth
4 Hours
License details Credits Status
Computer Software and Applications for Certified Public Accountants (CPA-US) 4 CPE Approved
Computer Software and Applications for CPA in Canada 4 CPD Eligible
Computer Software and Applications for Delaware Licensed Public Accountant (DE-LPA) 4 CPE Eligible
Information Technology for Certified Government Financial Manager (CGFM) 4 CPE Eligible
Computer Software and Applications for Certified Fraud Examiner (CFE) 4 CPE Eligible
Association of Chartered Certified Accountants (ACCA) 4 CPD Eligible
Chartered Accountant - ICAEW 4 CPD Eligible
Computer Software and Applications for Iowa Licensed Public Accountant (IA-LPA) 4 CPE Eligible
Computer Software and Applications for Maine Licensed Public Accountant (ME-LPA) 4 CPE Eligible
Computer technology for Maryland Tax Preparer (MRTP) (Approval No. GEHNZ-T-01133-22-S) 4 CE Approved
Chartered Accountants - Ireland (CAI) 4 CPD Eligible
Chartered Accountants - Scotland 4 CPD Eligible
CPA - Ireland 4 CPD Eligible
Information Technology (inc. Excel) for Certified FP&A Professional (FP&A) 4 CE Eligible
License details Credits Status
Computer Software and Applications for Certified Public Accountants (CPA-US) 4 CPE Approved
Computer Software and Applications for CPA in Canada 4 CPD Eligible
Computer Software and Applications for Delaware Licensed Public Accountant (DE-LPA) 4 CPE Eligible
Information Technology for Certified Government Financial Manager (CGFM) 4 CPE Eligible
Computer Software and Applications for Certified Fraud Examiner (CFE) 4 CPE Eligible
Association of Chartered Certified Accountants (ACCA) 4 CPD Eligible
Chartered Accountant - ICAEW 4 CPD Eligible
Computer Software and Applications for Iowa Licensed Public Accountant (IA-LPA) 4 CPE Eligible
Computer Software and Applications for Maine Licensed Public Accountant (ME-LPA) 4 CPE Eligible
Computer technology for Maryland Tax Preparer (MRTP) (Approval No. GEHNZ-T-01133-22-S) 4 CE Approved
Chartered Accountants - Ireland (CAI) 4 CPD Eligible
Chartered Accountants - Scotland 4 CPD Eligible
CPA - Ireland 4 CPD Eligible
Information Technology (inc. Excel) for Certified FP&A Professional (FP&A) 4 CE Eligible
On Demand (video)
  • Utilize mouse tricks, keyboard shortcuts, and Excel’s Freeze Panes feature to streamline navigation and data viewing.
  • Apply data analysis techniques and tools such as Text to Columns, Trace Dependents, and Trace Precedents for efficient data management.
  • Identify ideal data for creating pivot table reports and optimize workflow with Excel's built-in features.
14. Excel Accountant: Linked Workbooks
2 Hours
License details Credits Status
Computer Software and Applications for Certified Public Accountants (CPA-US) 2 CPE Approved
Computer Software and Applications for CPA in Canada 2 CPD Eligible
Computer Software and Applications for Delaware Licensed Public Accountant (DE-LPA) 2 CPE Eligible
Data management and analysis for Certified Government Financial Manager (CGFM) 2 CPE Eligible
Computer Software and Applications for Certified Fraud Examiner (CFE) 2 CPE Eligible
Association of Chartered Certified Accountants (ACCA) 2 CPD Eligible
Chartered Accountant - ICAEW 2 CPD Eligible
Computer Software and Applications for Iowa Licensed Public Accountant (IA-LPA) 2 CPE Eligible
Computer Software and Applications for Maine Licensed Public Accountant (ME-LPA) 2 CPE Eligible
Computer technology for Maryland Tax Preparer (MRTP) (Approval No. GEHNZ-T-01136-22-S) 2 CE Approved
Chartered Accountants - Ireland (CAI) 2 CPD Eligible
Chartered Accountants - Scotland 2 CPD Eligible
CPA - Ireland 2 CPD Eligible
Information Technology (inc. Excel) for Certified FP&A Professional (FP&A) 2 CE Eligible
License details Credits Status
Computer Software and Applications for Certified Public Accountants (CPA-US) 2 CPE Approved
Computer Software and Applications for CPA in Canada 2 CPD Eligible
Computer Software and Applications for Delaware Licensed Public Accountant (DE-LPA) 2 CPE Eligible
Data management and analysis for Certified Government Financial Manager (CGFM) 2 CPE Eligible
Computer Software and Applications for Certified Fraud Examiner (CFE) 2 CPE Eligible
Association of Chartered Certified Accountants (ACCA) 2 CPD Eligible
Chartered Accountant - ICAEW 2 CPD Eligible
Computer Software and Applications for Iowa Licensed Public Accountant (IA-LPA) 2 CPE Eligible
Computer Software and Applications for Maine Licensed Public Accountant (ME-LPA) 2 CPE Eligible
Computer technology for Maryland Tax Preparer (MRTP) (Approval No. GEHNZ-T-01136-22-S) 2 CE Approved
Chartered Accountants - Ireland (CAI) 2 CPD Eligible
Chartered Accountants - Scotland 2 CPD Eligible
CPA - Ireland 2 CPD Eligible
Information Technology (inc. Excel) for Certified FP&A Professional (FP&A) 2 CE Eligible
On Demand (video)
  • Identify how to create links that can be copied down columns or across rows.
  • Recall how to link Excel workbooks to other sources.
  • Analyze how to apply security prompts and settings related to linked workbooks.
15. Excel Accountant: Nuances
2 Hours
License details Credits Status
Computer Software and Applications for Certified Public Accountants (CPA-US) 2 CPE Approved
Computer Software and Applications for CPA in Canada 2 CPD Eligible
Computer Software and Applications for Delaware Licensed Public Accountant (DE-LPA) 2 CPE Eligible
Association of Chartered Certified Accountants (ACCA) 2 CPD Eligible
Chartered Accountant - ICAEW 2 CPD Eligible
Computer Software and Applications for Iowa Licensed Public Accountant (IA-LPA) 2 CPE Eligible
Computer technology for Maryland Tax Preparer (MRTP) (Approval No. GEHNZ-T-01328-22-S) 2 CE Approved
Computer Software and Applications for Maine Licensed Public Accountant (ME-LPA) 2 CPE Eligible
Chartered Accountants - Ireland (CAI) 2 CPD Eligible
CPA - Ireland 2 CPD Eligible
Chartered Accountants - Scotland 2 CPD Eligible
License details Credits Status
Computer Software and Applications for Certified Public Accountants (CPA-US) 2 CPE Approved
Computer Software and Applications for CPA in Canada 2 CPD Eligible
Computer Software and Applications for Delaware Licensed Public Accountant (DE-LPA) 2 CPE Eligible
Association of Chartered Certified Accountants (ACCA) 2 CPD Eligible
Chartered Accountant - ICAEW 2 CPD Eligible
Computer Software and Applications for Iowa Licensed Public Accountant (IA-LPA) 2 CPE Eligible
Computer technology for Maryland Tax Preparer (MRTP) (Approval No. GEHNZ-T-01328-22-S) 2 CE Approved
Computer Software and Applications for Maine Licensed Public Accountant (ME-LPA) 2 CPE Eligible
Chartered Accountants - Ireland (CAI) 2 CPD Eligible
CPA - Ireland 2 CPD Eligible
Chartered Accountants - Scotland 2 CPD Eligible
On Demand (video)
  • Recognize features that work only in the latest version of Excel.
  • Apply keyboard shortcuts and mouse actions to override default behaviors.
  • Use Excel's features for locking rows, toggling between Enter/Edit modes, and building Pivot Tables.
16. Excel Accountant: Six Ways to Sum
2 Hours
License details Credits Status
Computer Software and Applications for Certified Public Accountants (CPA-US) 2 CPE Approved
Computer Software and Applications for CPA in Canada 2 CPD Eligible
Computer Software and Applications for Delaware Licensed Public Accountant (DE-LPA) 2 CPE Eligible
Computer Software and Applications for Certified Fraud Examiner (CFE) 2 CPE Eligible
Association of Chartered Certified Accountants (ACCA) 2 CPD Eligible
Chartered Accountant - ICAEW 2 CPD Eligible
Computer Software and Applications for Iowa Licensed Public Accountant (IA-LPA) 2 CPE Eligible
Computer Software and Applications for Maine Licensed Public Accountant (ME-LPA) 2 CPE Eligible
Chartered Accountants - Ireland (CAI) 2 CPD Eligible
Chartered Accountants - Scotland 2 CPD Eligible
CPA - Ireland 2 CPD Eligible
Information Technology (inc. Excel) for Certified FP&A Professional (FP&A) 2 CE Eligible
License details Credits Status
Computer Software and Applications for Certified Public Accountants (CPA-US) 2 CPE Approved
Computer Software and Applications for CPA in Canada 2 CPD Eligible
Computer Software and Applications for Delaware Licensed Public Accountant (DE-LPA) 2 CPE Eligible
Computer Software and Applications for Certified Fraud Examiner (CFE) 2 CPE Eligible
Association of Chartered Certified Accountants (ACCA) 2 CPD Eligible
Chartered Accountant - ICAEW 2 CPD Eligible
Computer Software and Applications for Iowa Licensed Public Accountant (IA-LPA) 2 CPE Eligible
Computer Software and Applications for Maine Licensed Public Accountant (ME-LPA) 2 CPE Eligible
Chartered Accountants - Ireland (CAI) 2 CPD Eligible
Chartered Accountants - Scotland 2 CPD Eligible
CPA - Ireland 2 CPD Eligible
Information Technology (inc. Excel) for Certified FP&A Professional (FP&A) 2 CE Eligible
On Demand (video)
  • Identify SUMIFS behavior when referencing closed workbooks for data analysis.
  • Recognize and apply wildcard characters in functions like SUMIF, VLOOKUP, and MATCH for flexible lookups.
  • Determine Excel versions that support the AGGREGATE function for advanced calculations.
17. Excel Accountant: Speed Tips in Depth
4 Hours
License details Credits Status
Computer Software and Applications for Certified Public Accountants (CPA-US) 4 CPE Approved
Computer Software and Applications for CPA in Canada 4 CPD Eligible
Computer Software and Applications for Delaware Licensed Public Accountant (DE-LPA) 4 CPE Eligible
Certified Government Financial Manager (CGFM) 4 CPE Eligible
Computer Software and Applications for Certified Fraud Examiner (CFE) 4 CPE Eligible
Association of Chartered Certified Accountants (ACCA) 4 CPD Eligible
Chartered Accountant - ICAEW 4 CPD Eligible
Computer Software and Applications for Iowa Licensed Public Accountant (IA-LPA) 4 CPE Eligible
Computer Software and Applications for Maine Licensed Public Accountant (ME-LPA) 4 CPE Eligible
Chartered Accountants - Ireland (CAI) 4 CPD Eligible
Chartered Accountants - Scotland 4 CPD Eligible
CPA - Ireland 4 CPD Eligible
Information Technology (inc. Excel) for Certified FP&A Professional (FP&A) 4 CE Eligible
License details Credits Status
Computer Software and Applications for Certified Public Accountants (CPA-US) 4 CPE Approved
Computer Software and Applications for CPA in Canada 4 CPD Eligible
Computer Software and Applications for Delaware Licensed Public Accountant (DE-LPA) 4 CPE Eligible
Certified Government Financial Manager (CGFM) 4 CPE Eligible
Computer Software and Applications for Certified Fraud Examiner (CFE) 4 CPE Eligible
Association of Chartered Certified Accountants (ACCA) 4 CPD Eligible
Chartered Accountant - ICAEW 4 CPD Eligible
Computer Software and Applications for Iowa Licensed Public Accountant (IA-LPA) 4 CPE Eligible
Computer Software and Applications for Maine Licensed Public Accountant (ME-LPA) 4 CPE Eligible
Chartered Accountants - Ireland (CAI) 4 CPD Eligible
Chartered Accountants - Scotland 4 CPD Eligible
CPA - Ireland 4 CPD Eligible
Information Technology (inc. Excel) for Certified FP&A Professional (FP&A) 4 CE Eligible
On Demand (video)
  • Recall how to create custom keyboard shortcuts and unlock hidden functionality in Excel.
  • Identify how to efficiently compile large data lists using filtering and transform filtering tasks.
  • Recognize how to implement Excel’s Personal Macro Workbook and locate the Custom Lists feature in the Options dialog box.
18. Excel Accountant: Table Feature
2 Hours
License details Credits Status
Computer Software and Applications for Certified Public Accountants (CPA-US) 2 CPE Approved
Computer Software and Applications for CPA in Canada 2 CPD Eligible
Computer Software and Applications for Delaware Licensed Public Accountant (DE-LPA) 2 CPE Eligible
Information Technology for Certified Government Financial Manager (CGFM) 2 CPE Eligible
Computer Software and Applications for Certified Fraud Examiner (CFE) 2 CPE Eligible
Association of Chartered Certified Accountants (ACCA) 2 CPD Eligible
Chartered Accountant - ICAEW 2 CPD Eligible
Computer Software and Applications for Iowa Licensed Public Accountant (IA-LPA) 2 CPE Eligible
Computer Software and Applications for Maine Licensed Public Accountant (ME-LPA) 2 CPE Eligible
Chartered Accountants - Ireland (CAI) 2 CPD Eligible
Chartered Accountants - Scotland 2 CPD Eligible
CPA - Ireland 2 CPD Eligible
Information Technology (inc. Excel) for Certified FP&A Professional (FP&A) 2 CE Eligible
License details Credits Status
Computer Software and Applications for Certified Public Accountants (CPA-US) 2 CPE Approved
Computer Software and Applications for CPA in Canada 2 CPD Eligible
Computer Software and Applications for Delaware Licensed Public Accountant (DE-LPA) 2 CPE Eligible
Information Technology for Certified Government Financial Manager (CGFM) 2 CPE Eligible
Computer Software and Applications for Certified Fraud Examiner (CFE) 2 CPE Eligible
Association of Chartered Certified Accountants (ACCA) 2 CPD Eligible
Chartered Accountant - ICAEW 2 CPD Eligible
Computer Software and Applications for Iowa Licensed Public Accountant (IA-LPA) 2 CPE Eligible
Computer Software and Applications for Maine Licensed Public Accountant (ME-LPA) 2 CPE Eligible
Chartered Accountants - Ireland (CAI) 2 CPD Eligible
Chartered Accountants - Scotland 2 CPD Eligible
CPA - Ireland 2 CPD Eligible
Information Technology (inc. Excel) for Certified FP&A Professional (FP&A) 2 CE Eligible
On Demand (video)
  • Define the key arguments of Excel's VLOOKUP function for effective lookups.
  • Identify Excel versions that support slicers with tables and pivot tables.
  • Recognize the feature enabling automatic chart expansion with dynamic source data.
19. Excel Accountant: Taming Large Spreadsheets
2 Hours
License details Credits Status
Computer Software and Applications for Certified Public Accountants (CPA-US) 2 CPE Approved
Computer Software and Applications for CPA in Canada 2 CPD Eligible
Computer Software and Applications for Delaware Licensed Public Accountant (DE-LPA) 2 CPE Eligible
Information Technology for Certified Government Financial Manager (CGFM) 2 CPE Eligible
Computer Software and Applications for Certified Fraud Examiner (CFE) 2 CPE Eligible
Association of Chartered Certified Accountants (ACCA) 2 CPD Eligible
Chartered Accountant - ICAEW 2 CPD Eligible
Computer Software and Applications for Iowa Licensed Public Accountant (IA-LPA) 2 CPE Eligible
Computer Software and Applications for Maine Licensed Public Accountant (ME-LPA) 2 CPE Eligible
Chartered Accountants - Ireland (CAI) 2 CPD Eligible
Chartered Accountants - Scotland 2 CPD Eligible
CPA - Ireland 2 CPD Eligible
Information Technology (inc. Excel) for Certified FP&A Professional (FP&A) 2 CE Eligible
License details Credits Status
Computer Software and Applications for Certified Public Accountants (CPA-US) 2 CPE Approved
Computer Software and Applications for CPA in Canada 2 CPD Eligible
Computer Software and Applications for Delaware Licensed Public Accountant (DE-LPA) 2 CPE Eligible
Information Technology for Certified Government Financial Manager (CGFM) 2 CPE Eligible
Computer Software and Applications for Certified Fraud Examiner (CFE) 2 CPE Eligible
Association of Chartered Certified Accountants (ACCA) 2 CPD Eligible
Chartered Accountant - ICAEW 2 CPD Eligible
Computer Software and Applications for Iowa Licensed Public Accountant (IA-LPA) 2 CPE Eligible
Computer Software and Applications for Maine Licensed Public Accountant (ME-LPA) 2 CPE Eligible
Chartered Accountants - Ireland (CAI) 2 CPD Eligible
Chartered Accountants - Scotland 2 CPD Eligible
CPA - Ireland 2 CPD Eligible
Information Technology (inc. Excel) for Certified FP&A Professional (FP&A) 2 CE Eligible
On Demand (video)
  • Recognize the use of INDIRECT for creating summary worksheets and monitor key cells with the Watch Window.
  • Discuss volatile functions, improve calculation speed, and demonstrate Freeze Panes.
  • Explore freeze sheet pane shortcuts and streamline custom views with split worksheets.
20. Excel Detox: Escape 2-Hour Data Entry Habits in Just 2 Minutes!
1 Hour
License details Credits Status
Computer Software and Applications for Certified Public Accountants (CPA-US) 1 CPE Approved
Computer Software and Applications for CPA in Canada 1 CPD Eligible
Computer Software and Applications for Delaware Licensed Public Accountant (DE-LPA) 1 CPE Eligible
Information Technology for Certified Government Financial Manager (CGFM) 1 CPE Eligible
Computer Software and Applications for Certified Fraud Examiner (CFE) 1 CPE Eligible
Association of Chartered Certified Accountants (ACCA) 1 CPD Eligible
Chartered Accountant - ICAEW 1 CPD Eligible
Computer Software and Applications for Iowa Licensed Public Accountant (IA-LPA) 1 CPE Eligible
Computer Software and Applications for Maine Licensed Public Accountant (ME-LPA) 1 CPE Eligible
Information Technology (inc. Excel) for Certified FP&A Professional (FP&A) 1 CE Eligible
Chartered Accountants - Ireland (CAI) 1 CPD Eligible
Chartered Accountants - Scotland 1 CPD Eligible
CPA - Ireland 1 CPD Eligible
License details Credits Status
Computer Software and Applications for Certified Public Accountants (CPA-US) 1 CPE Approved
Computer Software and Applications for CPA in Canada 1 CPD Eligible
Computer Software and Applications for Delaware Licensed Public Accountant (DE-LPA) 1 CPE Eligible
Information Technology for Certified Government Financial Manager (CGFM) 1 CPE Eligible
Computer Software and Applications for Certified Fraud Examiner (CFE) 1 CPE Eligible
Association of Chartered Certified Accountants (ACCA) 1 CPD Eligible
Chartered Accountant - ICAEW 1 CPD Eligible
Computer Software and Applications for Iowa Licensed Public Accountant (IA-LPA) 1 CPE Eligible
Computer Software and Applications for Maine Licensed Public Accountant (ME-LPA) 1 CPE Eligible
Information Technology (inc. Excel) for Certified FP&A Professional (FP&A) 1 CE Eligible
Chartered Accountants - Ireland (CAI) 1 CPD Eligible
Chartered Accountants - Scotland 1 CPD Eligible
CPA - Ireland 1 CPD Eligible
On Demand (video)
  • Master best practices for designing, modeling, and validating accounting models.
  • Recognize when to use data entry versus automation in accounting models.
  • Identify key practices for efficient data entry and effective accounting summaries.
21. Excel Detox: Escape 3-Hour Update Time in Just 3 Minutes!
1 Hour
License details Credits Status
Computer Software and Applications for Certified Public Accountants (CPA-US) 1 CPE Approved
Computer Software and Applications for CPA in Canada 1 CPD Eligible
Computer Software and Applications for Delaware Licensed Public Accountant (DE-LPA) 1 CPE Eligible
Information Technology for Certified Government Financial Manager (CGFM) 1 CPE Eligible
Computer Software and Applications for Certified Fraud Examiner (CFE) 1 CPE Eligible
Association of Chartered Certified Accountants (ACCA) 1 CPD Eligible
Chartered Accountant - ICAEW 1 CPD Eligible
Computer Software and Applications for Iowa Licensed Public Accountant (IA-LPA) 1 CPE Eligible
Computer Software and Applications for Maine Licensed Public Accountant (ME-LPA) 1 CPE Eligible
Information Technology (inc. Excel) for Certified FP&A Professional (FP&A) 1 CE Eligible
Chartered Accountants - Ireland (CAI) 1 CPD Eligible
Chartered Accountants - Scotland 1 CPD Eligible
CPA - Ireland 1 CPD Eligible
License details Credits Status
Computer Software and Applications for Certified Public Accountants (CPA-US) 1 CPE Approved
Computer Software and Applications for CPA in Canada 1 CPD Eligible
Computer Software and Applications for Delaware Licensed Public Accountant (DE-LPA) 1 CPE Eligible
Information Technology for Certified Government Financial Manager (CGFM) 1 CPE Eligible
Computer Software and Applications for Certified Fraud Examiner (CFE) 1 CPE Eligible
Association of Chartered Certified Accountants (ACCA) 1 CPD Eligible
Chartered Accountant - ICAEW 1 CPD Eligible
Computer Software and Applications for Iowa Licensed Public Accountant (IA-LPA) 1 CPE Eligible
Computer Software and Applications for Maine Licensed Public Accountant (ME-LPA) 1 CPE Eligible
Information Technology (inc. Excel) for Certified FP&A Professional (FP&A) 1 CE Eligible
Chartered Accountants - Ireland (CAI) 1 CPD Eligible
Chartered Accountants - Scotland 1 CPD Eligible
CPA - Ireland 1 CPD Eligible
On Demand (video)
  • Identify methods for reporting from a financial system and best practices for updating models.
  • Review data cleansing techniques during data extraction and the pros and cons of extracting tables.
  • Master best practices for building dynamic “presentation” models from source Excel files.
22. Excel Detox: Turn 1-Hour Reports into 60-Seconds of Magic!
1.5 Hours
License details Credits Status
Computer Software and Applications for Certified Public Accountants (CPA-US) 1.5 CPE Approved
Computer Software and Applications for CPA in Canada 1.5 CPD Eligible
Computer Software and Applications for Delaware Licensed Public Accountant (DE-LPA) 1.5 CPE Eligible
Information Technology for Certified Government Financial Manager (CGFM) 1.5 CPE Eligible
Computer Software and Applications for Certified Fraud Examiner (CFE) 1.5 CPE Eligible
Association of Chartered Certified Accountants (ACCA) 1.5 CPD Eligible
Chartered Accountant - ICAEW 1.5 CPD Eligible
Computer Software and Applications for Iowa Licensed Public Accountant (IA-LPA) 1.5 CPE Eligible
Computer Software and Applications for Maine Licensed Public Accountant (ME-LPA) 1.5 CPE Eligible
Information Technology (inc. Excel) for Certified FP&A Professional (FP&A) 1.5 CE Eligible
Chartered Accountants - Ireland (CAI) 1.5 CPD Eligible
Chartered Accountants - Scotland 1.5 CPD Eligible
CPA - Ireland 1.5 CPD Eligible
License details Credits Status
Computer Software and Applications for Certified Public Accountants (CPA-US) 1.5 CPE Approved
Computer Software and Applications for CPA in Canada 1.5 CPD Eligible
Computer Software and Applications for Delaware Licensed Public Accountant (DE-LPA) 1.5 CPE Eligible
Information Technology for Certified Government Financial Manager (CGFM) 1.5 CPE Eligible
Computer Software and Applications for Certified Fraud Examiner (CFE) 1.5 CPE Eligible
Association of Chartered Certified Accountants (ACCA) 1.5 CPD Eligible
Chartered Accountant - ICAEW 1.5 CPD Eligible
Computer Software and Applications for Iowa Licensed Public Accountant (IA-LPA) 1.5 CPE Eligible
Computer Software and Applications for Maine Licensed Public Accountant (ME-LPA) 1.5 CPE Eligible
Information Technology (inc. Excel) for Certified FP&A Professional (FP&A) 1.5 CE Eligible
Chartered Accountants - Ireland (CAI) 1.5 CPD Eligible
Chartered Accountants - Scotland 1.5 CPD Eligible
CPA - Ireland 1.5 CPD Eligible
On Demand (video)
  • Design, implement, and evaluate financial models.
  • Identify key elements of a great financial model.
  • Build dynamic data connections using Power Query and append tables in Excel.
23. Spreadsheet Accessibility Features
2 Hours
License details Credits Status
Computer Software and Applications for Certified Public Accountants (CPA-US) 2 CPE Approved
Computer Software and Applications for Delaware Licensed Public Accountant (DE-LPA) 2 CPE Eligible
Information Technology for Certified Government Financial Manager (CGFM) 2 CPE Eligible
Computer Software and Applications for Certified Fraud Examiner (CFE) 2 CPE Eligible
Computer Software and Applications for Iowa Licensed Public Accountant (IA-LPA) 2 CPE Eligible
Computer Software and Applications for Maine Licensed Public Accountant (ME-LPA) 2 CPE Eligible
Information Technology (inc. Excel) for Certified FP&A Professional (FP&A) 2 CE Eligible
License details Credits Status
Computer Software and Applications for Certified Public Accountants (CPA-US) 2 CPE Approved
Computer Software and Applications for Delaware Licensed Public Accountant (DE-LPA) 2 CPE Eligible
Information Technology for Certified Government Financial Manager (CGFM) 2 CPE Eligible
Computer Software and Applications for Certified Fraud Examiner (CFE) 2 CPE Eligible
Computer Software and Applications for Iowa Licensed Public Accountant (IA-LPA) 2 CPE Eligible
Computer Software and Applications for Maine Licensed Public Accountant (ME-LPA) 2 CPE Eligible
Information Technology (inc. Excel) for Certified FP&A Professional (FP&A) 2 CE Eligible
On Demand (video)
  • Explain which feature in Excel can read text aloud to users.
  • Discuss how to add alternate text to floating objects in Excel spreadsheets to improve accessibility.
  • Analyze the purpose of cell styles.
24. Spreadsheet Interactivity and Internal Control
1.5 Hours
License details Credits Status
Auditing for Certified Public Accountants (CPA-US) 1.5 CPE Approved
Auditing for CPA in Canada 1.5 CPD Eligible
Auditing for Delaware Licensed Public Accountant (DE-LPA) 1.5 CPE Eligible
Auditing for Certified Fraud Examiner (CFE) 1.5 CPE Eligible
Association of Chartered Certified Accountants (ACCA) 1.5 CPD Eligible
Chartered Accountant - ICAEW 1.5 CPD Eligible
Certified Internal Controls Auditor (CICA) 1.5 CPE Eligible
Auditing for Certified Financial Forensics (CFF) 1.5 CPD Eligible
Auditing for Iowa Licensed Public Accountant (IA-LPA) 1.5 CPE Eligible
Auditing for Maine Licensed Public Accountant (ME-LPA) 1.5 CPE Eligible
Certified Government Auditing Professional (CGAP) 1.5 CPE Eligible
Certified Controls Specialist (CCS) 1.5 CPE Eligible
Chartered Accountants - Ireland (CAI) 1.5 CPD Eligible
Chartered Accountants - Scotland 1.5 CPD Eligible
CPA - Ireland 1.5 CPD Eligible
Certified FP&A Professional (FP&A) 1.5 CE Eligible
License details Credits Status
Auditing for Certified Public Accountants (CPA-US) 1.5 CPE Approved
Auditing for CPA in Canada 1.5 CPD Eligible
Auditing for Delaware Licensed Public Accountant (DE-LPA) 1.5 CPE Eligible
Auditing for Certified Fraud Examiner (CFE) 1.5 CPE Eligible
Association of Chartered Certified Accountants (ACCA) 1.5 CPD Eligible
Chartered Accountant - ICAEW 1.5 CPD Eligible
Certified Internal Controls Auditor (CICA) 1.5 CPE Eligible
Auditing for Certified Financial Forensics (CFF) 1.5 CPD Eligible
Auditing for Iowa Licensed Public Accountant (IA-LPA) 1.5 CPE Eligible
Auditing for Maine Licensed Public Accountant (ME-LPA) 1.5 CPE Eligible
Certified Government Auditing Professional (CGAP) 1.5 CPE Eligible
Certified Controls Specialist (CCS) 1.5 CPE Eligible
Chartered Accountants - Ireland (CAI) 1.5 CPD Eligible
Chartered Accountants - Scotland 1.5 CPD Eligible
CPA - Ireland 1.5 CPD Eligible
Certified FP&A Professional (FP&A) 1.5 CE Eligible
On Demand (video)
  • Discuss the value that checkbox form controls return.
  • Explain uses for Excel's Data Validation feature.
  • Identify the ribbon tab in Excel where the Protect Sheet command appears.
Disclaimer : Before attending any course, please verify that the credit details align with your qualification requirements. This certificate is designed to help you acquire new skills and knowledge, which may or may not fulfill specific compliance criteria. While we have made every effort to ensure our courses adhere to compliance standards, we recommend reviewing the details to confirm applicability for your needs.

Instructors

All Advance Certification are included under the Individual Subscription

Get Started with Unlimited Learning

Select your plan, complete your payment, and access a world of knowledge.

Subscription Inclusions Silver Gold
13,000+ Hrs of CPE approved Content
tooltip

Largest content library covering all aspects of professional development.
500+ Emerging Subject Areas
tooltip

Wide range of subject areas tailored to meet diverse learning needs of all the department of the firm.
50+ State- Specific Ethics Courses
tooltip

Stay compliant with ethics requirements for every state.
50+ State Compliance Packages
tooltip

Pre-selected courses for quick compliance, saving time and effort.
100+ Advanced Certification Programs
tooltip

Expert-led programs to build advanced expertise and strengthen your career credentials.
AICPA Eligibility Programs (CFF, ABV, PFS)
tooltip

Pre-Packaged Eligibility Courses for AICPA designations such as PFS, ABV, and CFF, offering CPE credits upon completion.
Compliance Tracker and Credit Vault
tooltip

Store all your certificates in one place, stay compliance-ready with ease, and track your progress effortlessly using the built-in credit tracker.
Instant Certification and Fast Reporting
tooltip

Instant reporting to IRS, CFP Board, and other governing bodies.
Mobile App Access (iOS and Android)
tooltip

https://play.google.com/store/apps/details?id=com.my_cpe
Access to Communities
tooltip

Join communities tailored to your specific interests and areas of expertise.

Select Tenure

NEW YEAR
Sale Ends Soon!

00:00:00

Start Your Subscription 

Start your journey towards learning and compliance.

$299$199 For 12 Months

Start Your Subscription

$299$199/year

Secure unlimited access

Click Here

More Reasons to Subscribe

  • true true
    80% of Content Rated 4.5+ Stars
    High-quality content rated by professionals.
  • true true
    4X More Content at 1/3rd the Price
    Serious value compared to your regular provider!
  • true true
    Non-Sponsored Content
    Purely educational, unbiased content for your learning.
  • true true
    Monthly & Quarterly Updates
    Keeping you ahead of trends and changes.
  • true true
    Podcasts with Industry Leaders
    Learn and Earn CPE from experts on the go.

Discover Why We’re the Preferred Choice!

  • rating
  • rating
  • rating
  • rating
  • rating

Game-Changer for Busy Professionals

“MYCPE ONE has been a game-changer for my learning journey! The platform is user-friendly, and the course was structured perfectly for busy professionals like me. I feel more confident in my Excel skills now!”

Laura Bennett

Laura Bennett, CA-ICAEW

Accountant

  • rating
  • rating
  • rating
  • rating
  • rating

Practical Excel Applications

“This certification course was exactly what I needed! The practical examples and real-world applications made it so much easier to connect the dots. I can't recommend it enough!”

Mark Sullivan

Mark Sullivan, CPA US

Accountant

  • rating
  • rating
  • rating
  • rating
  • rating

Excel Made Simple

“I have always been intimidated by Excel, but this course broke everything down into simple, manageable steps. The tips for automating tasks were especially helpful, and I'm already applying them at work. Plus, the instructors were approachable and super knowledgeable. Whether youre new to Excel or just need a refresher, this course is an absolute must!”

Alicia Parker

Alicia Parker, DE-LPA

Tax Practitioner

Team Subscription for CPAs & Accounting Firms

  • true true Comprehensive Content Library
  • true true CPE Compliance Automation
  • true true Advanced Training Solutions
  • true true Learning Management System
  • true true Event and Webinar Management

Frequently Asked Questions

This course covers essential Excel skills, including basic functions, cell referencing, data sorting, and conditional formatting. You'll master the use of formulas like SUMIFS, and IF statements, learn to manage data using tables, create professional reports with charts and graphs, and ensure accessibility and organization through keyboard shortcuts, data validation, and error handling. The course also dives into managing linked workbooks and using dynamic arrays to improve workflow.

This certification will enhance your ability to efficiently organize and analyze data, manage spreadsheets with accuracy, and create impactful reports using Excel's core functionalities. With the skills learned, you'll be able to perform tasks with greater speed and precision, solve problems related to data integrity, and present your findings clearly using charts and visual tools. Whether for administrative, analytical, or reporting tasks, these skills will make you an indispensable asset in any professional setting.

Certificate course is created by a qualified and experienced instructor(s). myCPE Certificate Courses includes Self-study Courses. Most of the courses are in the form of On-demand Videos. The Self-study Video courses in Certificate courses may be Live recorded presentations converted into Self Study (On-Demand Videos).

You can take your time and attend the course at your own pace. You can take exam unlimited time. So, don’t worry, if you are not able to pass an exam. You will be getting a chance to attend the exam again.

After completion of each course of this Certification Programs, you will be able to download a certificate with the course title and number of hours. Certificates, as well as your study records, are stored for life and you can access them anytime. Certificates are valid proof for your continuing education credits and you can also add it as an additional designation.

Once you register you will have complete access to all the courses of this Certification Programs. The self-study format allows you to access the material online 24x7 and study at your own pace.

As per NASBA guidelines, you have one year from date of purchase of your certificate to complete each program. After completion of each course, you can attend final exam any time and get CPE Credit instantly. You can retake the exam multiple times without any additional charges.

Course have minimum passing score of 70% in the final exam and you can take multiple attempts of the said exam.

Our video player tracks & stores the watch time and will show you in the progress bar. But you make sure that you don’t fast forward or manually try to move the progress bar. If you have fast forwarded the video or tried to manually move the progress bar of the video. System wouldn’t capture your watch time. So please, let the video go on its own. However, being on-demand video you can pause and play and whenever you want and you can watch it in pieces. It will pick up from where you left off. So, for a self study courses you will have to
1. Complete the entire video 100%.
2. Answer all the review questions correctly. The review questions are at the bottom of the same page where you are viewing the course video.
3. Once you have watched the whole video and answered all the review questions, the Final Quiz will open up. You need to score more than 70% in the Final Quiz to avail your CPE credit. Multiple attempts are allowed for submitting Review and Final Quiz questions.
4. Once you have completed the Review and Final quiz questions, you shall be able to download the credit certificate from the ‘My Certificates’ section. Kindly ensure you have allowed Multiple File download from your web browser to download all certificates.
5. You can download individual certificate from your "Account" as well as from this page once you complete a particular courses. Also, you can download "Consolidated Certificate" from the package page or from your account.

A Self-study course is a recorded video (If it’s a recording of a live course you may see polling questions appearing on the screen. You do not need to answer the polling questions and just let the video play). Do not fast forward. If you fast forward, we may not be able to capture your watch time and you may be required to watch it multiple times. In order to avail your credits for the self-study course, you need to answer the review questions correctly and complete the entire video. Once you have done that, the Final Quiz will open up in which you need to score a minimum 70% to qualify for the credit. You can attempt multiple times for answering the review questions and Final quiz questions. Once you have completed the Review and Final quiz questions, you shall be able to download the credit certificate from ‘My Certificates’ section.
If neither of the above cases works, please drop an email to support@my-cpe.com or contact our support team through live chat support.

The evaluation form will be sent to attendees in the next 24 hours after passing the final quiz with at least 70% marks. Kindly note that the evaluation form will only be available to attendees who remained logged in till the end of the course and answered all the polling questions.

MY-CPE LLC is PCI Compliant - Approved. myCPE uses a secure payment gateway (Stripe.com) to process your payment details. This payment gateway is in accordance with the PCI-DSS Compliance. Therefore, your payment details are secure through SSL encryption. CLICK HERE to view our PCI compliance certificate. Once you have register for the package and paid for it you shall not be granted any refund unless you are not able to access courses for any reason etc.
Subscribed
Uttam purchased a subscription.
Subscribed
Chris purchased a subscription.
Subscribed
Lachlan purchased a subscription.
Subscribed
Stephen purchased a subscription.
Subscribed
Denise purchased a subscription.
Subscribed
darryl purchased a subscription.
Subscribed
Jinella purchased a subscription.
Subscribed
Rebecca purchased a subscription.
Subscribed
xinxin purchased a subscription.
Subscribed
Victor purchased a subscription.
Subscribed
Rebecca purchased a subscription.
Subscribed
Steven purchased a subscription.
Subscribed
Katherine purchased a subscription.
Subscribed
Angela purchased a subscription.
Subscribed
Thomas purchased a subscription.
Subscribed
Victoria purchased a subscription.
Subscribed
David purchased a subscription.
Subscribed
Beth purchased a subscription.
Subscribed
Nirmala purchased a subscription.
Subscribed
Betsy purchased a subscription.
Subscribed
Anthony purchased a subscription.
Subscribed
Adam purchased a subscription.
Subscribed
Karen purchased a subscription.
Subscribed
Kandeh purchased a subscription.
Subscribed
Allison purchased a subscription.
Subscribed
Allison purchased a subscription.
Subscribed
ROBERT purchased a subscription.
Subscribed
Sally purchased a subscription.
Subscribed
Nakia purchased a subscription.
Subscribed
Angie purchased a subscription.
Subscribed
Pallavi purchased a subscription.
Subscribed
Sophia purchased a subscription.
Subscribed
Bird purchased a subscription.
Subscribed
Brad purchased a subscription.
Subscribed
James purchased a subscription.
Subscribed
Bryce purchased a subscription.
Subscribed
Brian purchased a subscription.
Subscribed
Teddie purchased a subscription.
Subscribed
Doris purchased a subscription.
Subscribed
Ken purchased a subscription.
Subscribed
Craig purchased a subscription.
Subscribed
Mohammed purchased a subscription.
Subscribed
Chuck purchased a subscription.
Subscribed
Paul purchased a subscription.
Subscribed
Yoshiya purchased a subscription.
Subscribed
Ehab purchased a subscription.
Subscribed
CATHY purchased a subscription.
Subscribed
Nicole purchased a subscription.
Subscribed
Christina purchased a subscription.
Subscribed
Lynden purchased a subscription.
Subscribed
Cassandra purchased a subscription.
Subscribed
Abdel monim purchased a subscription.
Subscribed
Ira purchased a subscription.
Subscribed
Taylor purchased a subscription.
Subscribed
Barbara purchased a subscription.
Subscribed
Yosefa purchased a subscription.
Subscribed
Kyle purchased a subscription.
Subscribed
Jennifer purchased a subscription.
Subscribed
Yuchu purchased a subscription.
Subscribed
Aman purchased a subscription.
Subscribed
Lisa purchased a subscription.
Subscribed
Brianna purchased a subscription.
Subscribed
Amanda purchased a subscription.
Subscribed
Ekaterina purchased a subscription.
Subscribed
James purchased a subscription.
Subscribed
Jaclyn purchased a subscription.
Subscribed
Kaylie purchased a subscription.
Subscribed
Joy purchased a subscription.
Subscribed
Terry purchased a subscription.
Subscribed
Kenneth purchased a subscription.
Subscribed
jason casper purchased a subscription.
Subscribed
Kristin purchased a subscription.
Subscribed
Shivangi purchased a subscription.
Subscribed
Mark purchased a subscription.
Subscribed
Jared purchased a subscription.
Subscribed
George purchased a subscription.
Subscribed
Valerian purchased a subscription.
Subscribed
Roeun purchased a subscription.
Subscribed
Klaudia purchased a subscription.
Subscribed
Jamie purchased a subscription.
Subscribed
Delores purchased a subscription.
Subscribed
Yuxin purchased a subscription.
Subscribed
Jackie purchased a subscription.
Subscribed
Vicki purchased a subscription.
Subscribed
Joseph purchased a subscription.
Subscribed
Colan purchased a subscription.
Subscribed
Lauren purchased a subscription.
Subscribed
Rebecca purchased a subscription.
Subscribed
Ashley purchased a subscription.
Subscribed
John purchased a subscription.
Subscribed
Selcuk purchased a subscription.
Subscribed
Wenxiu purchased a subscription.
Subscribed
Yagnesh purchased a subscription.
Subscribed
Ronald purchased a subscription.
Subscribed
Leonardo purchased a subscription.
Subscribed
Casey purchased a subscription.
Subscribed
Charise purchased a subscription.
Subscribed
YAMIL purchased a subscription.
Subscribed
Tony purchased a subscription.
Subscribed
Tim purchased a subscription.