myCPE

Certified Intermediate Excel Professional Course (CIEPC)

Intermediate Techniques for Data Mastery in Excel.

certificate
3900+

Enrollments

4.5/5(2.1K+ Reviews)
  • rating
  • rating
  • rating
  • rating
  • rating
Last Updated

March, 2025

Multiple
35
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

Explore your potential with the Certified Intermediate Excel Professional Course (CIEPC). This course bridges the gap between basic and advanced Excel knowledge, focusing on intermediate-level techniques for efficient data analysis, reporting, and automation. Gain proficiency in tools like PivotTables, logic functions, and dashboards to make your data-driven decision-making more effective and streamlined.

Get Deeper Understanding of:

  • Using PivotTables for effective grouping and summarization of data.
  • Mastering Excel's logic functions for precise and accurate calculations.
  • Designing interactive and visually appealing Excel dashboards for reporting.
  • Automating repetitive tasks with LET and LAMBDA functions.
  • Performing What-If Analysis to evaluate different scenarios and outcomes.

Recommended For:

  • CPAs and financial analysts who seek to advance their Excel skills beyond basic functions and gain expertise in data analysis, reporting, and automation.
  • Business Professionals like operations managers, marketing analysts, and project managers who need to enhance their ability to analyze and present data more effectively using intermediate Excel tools.
  • Individuals looking to strengthen their Excel capabilities for career growth, improve efficiency in data handling, and better support decision-making processes in various business settings.

Why take the Certified Intermediate Excel Professional Course (CIEPC) Course with MYCPE ONE?

Resources included

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

Career Opportunities

  • Data Analyst
  • Business Intelligence Analyst
  • Marketing Analyst
  • Operations Manager
  • Reporting Specialist

Value Addition to your skills

  • Enhanced Data Analysis and Reporting
  • Streamlined Automation with Excel Functions
  • Improved Decision-Making with What-If Analysis
  • Increased Proficiency in Excel Dashboards
  • Time-Saving Data Management Skills
  • Strong Problem-Solving and Analytical Capabilities

Courses

Course Title Time Credits Learning Format
1. Introduction To Excel PivotTables
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 Certified Fraud Examiner (CFE) 1 CPE 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
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 Certified Fraud Examiner (CFE) 1 CPE 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
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)
  • Identify how to expand and collapse data groups in pivot tables.
  • Recognize the best approach for formatting numbers in pivot tables.
  • Identify the default location for pivot table data when selecting a field checkbox.
2. Simplifying Excel Reporting – Learn Pivot Tables from Scratch
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 Chartered Global Management Accountants (CGMA) 1.5 CPE Eligible
Computer Software and Applications for Certified Fraud Examiner (CFE) 1.5 CPE 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
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 Chartered Global Management Accountants (CGMA) 1.5 CPE Eligible
Computer Software and Applications for Certified Fraud Examiner (CFE) 1.5 CPE 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
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)
  • Harness Pivot Tables to transform raw data into insightful reports and summaries.
  • Review optimal data structuring techniques to enhance Pivot Table effectiveness.
  • Master designing, formatting, and summarizing Pivot Table reports for clarity, including conversions into charts.
3. Excel Accountant: Advanced Pivot Tables
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 Certified Fraud Examiner (CFE) 2 CPE 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
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 Certified Fraud Examiner (CFE) 2 CPE 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
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)
  • Summarize PivotTable data by grouping based on dates or custom arrangements.
  • Automate data refreshing in PivotTables and apply Slicer features for better interactivity.
  • Clean up PivotTables efficiently and explore custom list creation for enhanced reporting.
4. Excel Accountant: Logic 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 Certified Fraud Examiner (CFE) 2 CPE 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
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 Certified Fraud Examiner (CFE) 2 CPE 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
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 basics of the IF function and explore advanced uses.
  • Identify VLOOKUP as an alternative to the IF function and understand the IFERROR function's purpose.
  • Discuss IS functions and how to use them, along with the behavior of SUMIF when no match is found.
5. Excel Accountant: Beyond VLOOKUP
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
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
Information Technology for Certified Government Financial Manager (CGFM) 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)
  • Identify alternatives to the word TRUE in VLOOKUP for approximate matches.
  • Recall the maximum number of criteria pairs allowed in the SUMIFS function.
  • Explore the purpose and use of the IFERROR function.
6. LET & LAMBDA Functions
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 Certified Fraud Examiner (CFE) 1 CPE 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
Association of Chartered Certified Accountants (ACCA) 1 CPD Eligible
Chartered Accountant - ICAEW 1 CPD Eligible
Computer technology for Maryland Tax Preparer (MRTP) (Approval No. GEHNZ-T-01262-22-S) 1 CE Approved
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 Certified Fraud Examiner (CFE) 1 CPE 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
Association of Chartered Certified Accountants (ACCA) 1 CPD Eligible
Chartered Accountant - ICAEW 1 CPD Eligible
Computer technology for Maryland Tax Preparer (MRTP) (Approval No. GEHNZ-T-01262-22-S) 1 CE Approved
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)
  • Define and apply the LET function to simplify formulas and improve readability.
  • Create and manage range names in Excel for better data organization and navigation.
  • Use the LAMBDA function to build custom worksheet functions and automate tasks.
7. Excel Accountant: Breaking Down Formulas
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 technology for Maryland Tax Preparer (MRTP) (Approval No. GEHNZ-T-01329-22-S) 2 CE Approved
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
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 technology for Maryland Tax Preparer (MRTP) (Approval No. GEHNZ-T-01329-22-S) 2 CE Approved
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
On Demand (video)
  • Apply Excel's IFERROR function to handle formula errors and ensure smooth calculations.
  • Utilize range names and the Show Formulas feature for better formula management and ease of use.
  • Explore key formula management techniques, including copying formulas, tracing precedents, and handling common formula errors.
8. Budgeting using Excel
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 Certified Fraud Examiner (CFE) 1 CPE 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 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 Certified Fraud Examiner (CFE) 1 CPE 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 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)
  • Isolate user entries on an inputs worksheet while protecting calculations and budgets.
  • Use range names and the Table feature for resilient spreadsheets.
  • Recall the SUMIF function’s return value when no match is found.
9. Excel Accountant: Payroll Analysis
2 Hours
License details Credits Status
Accounting for Certified Public Accountants (CPA-US) 2 CPE Approved
Accounting for CPA in Canada 2 CPD Eligible
Business Acumen for SHRM Professionals (Approval No. 26-SWF3V) (Valid upto : Dec 31, 2026) 2 PDC Approved
HR (General) for Human Resource Certification Institute (HRCI) (Approval No. 688309) (Valid upto : Nov 30, 2025) 2 RCH Approved
Accounting 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
Core Payroll Concepts for Payroll Compliance Practitioner (PCP) 2 CPE Eligible
Core Payroll Concepts for Payroll Leadership Professional (PLP) 2 CPE Eligible
Accounting for Iowa Licensed Public Accountant (IA-LPA) 2 CPE Eligible
Accounting 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
Accounting for Certified Public Accountants (CPA-US) 2 CPE Approved
Accounting for CPA in Canada 2 CPD Eligible
Business Acumen for SHRM Professionals (Approval No. 26-SWF3V) (Valid upto : Dec 31, 2026) 2 PDC Approved
HR (General) for Human Resource Certification Institute (HRCI) (Approval No. 688309) (Valid upto : Nov 30, 2025) 2 RCH Approved
Accounting 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
Core Payroll Concepts for Payroll Compliance Practitioner (PCP) 2 CPE Eligible
Core Payroll Concepts for Payroll Leadership Professional (PLP) 2 CPE Eligible
Accounting for Iowa Licensed Public Accountant (IA-LPA) 2 CPE Eligible
Accounting 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)
  • Recall how to reformat Social Security Numbers using Excel’s Flash Fill feature.
  • Discuss how to assign random numbers to a data set in Excel.
  • Apply password-protection techniques for sensitive payroll files, worksheets, and spreadsheet columns.
10. Excel Accountant: Database Techniques
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 Certified Fraud Examiner (CFE) 2 CPE 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
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 Certified Fraud Examiner (CFE) 2 CPE 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
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)
  • Sum values based on a single criterion and multiple criteria in Excel.
  • Use Microsoft Query to import data from one workbook to another and explore it as a Workbook Link alternative.
  • Duplicate columns, rows, or cells within a worksheet and discuss data security prompts in Excel.
11. Excel Accountant: Dealing with Duplicates
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 Certified Fraud Examiner (CFE) 2 CPE 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
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 Certified Fraud Examiner (CFE) 2 CPE 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
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 how to duplicate Excel worksheets and use mouse tricks for the same task.
  • Apply the Advanced Filter and Remove Duplicates features, and explore the UNIQUE function available in Office 365.
  • Use pivot tables to identify duplicate entries, and explore data validation techniques to prevent duplicates and unlock validation cells.
12. Excel Accountant: Custom Views
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 Certified Fraud Examiner (CFE) 2 CPE 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
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-01330-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
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 Certified Fraud Examiner (CFE) 2 CPE 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
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-01330-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
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 apply the Custom Views feature for multiple uses of a single data set.
  • Recognize the Zoom feature in worksheets and recall how to make the same edits across multiple worksheets simultaneously.
  • Use Custom Views to manage the visibility of columns, rows, worksheets, and print settings.
13. Excel Accountant: Dashboards 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 Certified Fraud Examiner (CFE) 4 CPE 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
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 Certified Fraud Examiner (CFE) 4 CPE 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
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)
  • Use Quick Analysis for data visualization and create dashboard-like reports.
  • Leverage Microsoft Query for persistent, self-updating data connections.
  • Select nonadjacent rows/columns and identify slicer compatibility in Excel versions.
14. Excel Accountant: Interactive 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 Certified Fraud Examiner (CFE) 2 CPE 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
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 Certified Fraud Examiner (CFE) 2 CPE 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
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)
  • Discuss the Go To Special option allows you to select all form controls on a worksheet at once.
  • Analyze what the linked cell for a checkbox displays when a user clicks the checkbox on.
  • Identify the feature that offers the most efficient means of storing a paragraph or more of text in a worksheet.
15. Excel Accountant: What-If Analysis
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 Certified Fraud Examiner (CFE) 2 CPE 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 Certified Fraud Examiner (CFE) 2 CPE 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)
  • Identify when to use Excel’s Goal Seek feature versus Solver.
  • Discuss how to use the Data Table feature in Excel to compare calculation results based on varying inputs.
  • Analyze how to make one worksheet serve multiple purposes by way of Excel’s Scenario Manager.
16. Take Control of Excel: Smart Solutions for Real Work Challenges- Part 1
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 Certified Fraud Examiner (CFE) 1 CPE 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
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 Certified Fraud Examiner (CFE) 1 CPE 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
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 critical components of Excel, including formulas, data management, and charting techniques, to enhance your workflow.
  • Master different ways to initiate commands in Excel, such as using the ribbon, right-click menu, etc.
  • Apply dynamic features through formulas, cell formatting, and proper page layout to optimize data presentation and functionality.
17. Take Control of Excel: Smart Solutions for Real Work Challenges- Part 2
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 Certified Fraud Examiner (CFE) 1.5 CPE 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
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 Certified Fraud Examiner (CFE) 1.5 CPE 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
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)
  • Identify key Excel components, including TEXT functions, file, and sheet names.
  • Explore basic VBA creation with Macro Recorder and batch processing techniques.
  • Discover methods for synchronizing charts in dashboard reporting for cohesive data analysis.
18. Excel Accountant: QuickBooks Detailed Analysis
4 Hours
License details Credits Status
Accounting for Certified Public Accountants (CPA-US) 4 CPE Approved
Accounting for CPA in Canada 4 CPD Eligible
Accounting for Certified Fraud Examiner (CFE) 4 CPE Eligible
Accounting for Delaware Licensed Public Accountant (DE-LPA) 4 CPE Eligible
Accounting for Certified Government Financial Manager (CGFM) 4 CPE Eligible
Accounting for Iowa Licensed Public Accountant (IA-LPA) 4 CPE Eligible
Accounting for Maine Licensed Public Accountant (ME-LPA) 4 CPE Eligible
Financial accounting concepts for Certified FP&A Professional (FP&A) 4 CE Eligible
License details Credits Status
Accounting for Certified Public Accountants (CPA-US) 4 CPE Approved
Accounting for CPA in Canada 4 CPD Eligible
Accounting for Certified Fraud Examiner (CFE) 4 CPE Eligible
Accounting for Delaware Licensed Public Accountant (DE-LPA) 4 CPE Eligible
Accounting for Certified Government Financial Manager (CGFM) 4 CPE Eligible
Accounting for Iowa Licensed Public Accountant (IA-LPA) 4 CPE Eligible
Accounting for Maine Licensed Public Accountant (ME-LPA) 4 CPE Eligible
Financial accounting concepts for Certified FP&A Professional (FP&A) 4 CE Eligible
On Demand (video)
  • Identify QuickBooks features for streamlining reports and using pivot tables in Excel for faster analysis.
  • Explore how to enable browser settings for launching Excel files exported from QuickBooks Online.
  • Define ideal data for pivot tables and recall key techniques, like Text to Columns and selecting non-adjacent items in a Slicer.
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
15,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.

card

$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

Next-Level Excel Skills

“Taking this course was a game-changer for me! The practical Excel skills I gained helped me streamline my daily tasks, and I feel way more confident tackling complex data now. The course is definitely more than just basic Excel. It is perfect for someone ready to level up! ”

Sara Patterson

Sara Patterson, ACCA

Finance Manager

  • rating
  • rating
  • rating
  • rating
  • rating

Enhancing Work Efficiency

“I have taken several Excel courses before, but this one was by far the most valuable. The focus on real-world applications made all the difference. I can now create dynamic dashboards and analyze data like a pro! Definitely recommend it to anyone looking to build on their Excel skills.”

James Clark

James Clark, ACCA

Entrepreneur

  • rating
  • rating
  • rating
  • rating
  • rating

Boosting Productivity with Excel

“After completing this certification, I have noticed a huge difference in my work productivity. The course covers everything from PivotTables to advanced functions, making it a perfect fit for someone like me who needs Excel skills beyond the basics. Plus, I loved how MYCPE ONE made the whole learning process so smooth and their platform is incredibly user-friendly.”

Olivia Thompson

Olivia Thompson, CA-Scotland

Tax Accountant

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 a wide range of intermediate Excel topics designed to enhance your data management and analytical skills. You'll learn how to use advanced PivotTables for efficient data analysis, apply powerful logic functions like IF, VLOOKUP, and SUMIF, and create interactive dashboards and dynamic spreadsheets. Additionally, the course introduces advanced problem-solving tools like LET, LAMBDA, and What-If Analysis to help streamline data processes and decision-making. By the end of the course, you'll be equipped with the Excel skills needed for more efficient data management and reporting.

This certification will significantly enhance your Excel proficiency by teaching you essential tools and techniques to streamline tasks, improve data analysis, and make data-driven decisions. You'll gain practical skills in automating processes, creating dynamic reports, and solving complex problems, which can be immediately applied to real-world scenarios. The knowledge gained will not only boost your productivity but also make you more efficient in handling data, reporting, and decision-making tasks in your professional role.

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
Adam purchased a subscription.
Subscribed
Erin purchased a subscription.
Subscribed
Patricia purchased a subscription.
Subscribed
Colin purchased a subscription.
Subscribed
Loran purchased a subscription.
Subscribed
phillip purchased a subscription.
Subscribed
Mary purchased a subscription.
Subscribed
Chris purchased a subscription.
Subscribed
Rishita purchased a subscription.
Subscribed
Richard purchased a subscription.
Subscribed
TOMOHIKO purchased a subscription.
Subscribed
Garth purchased a subscription.
Subscribed
Adrianna purchased a subscription.
Subscribed
Merylou purchased a subscription.
Subscribed
Sophia purchased a subscription.
Subscribed
Richard purchased a subscription.
Subscribed
JOHN purchased a subscription.
Subscribed
Phil purchased a subscription.
Subscribed
Andrew purchased a subscription.
Subscribed
William purchased a subscription.
Subscribed
Debra purchased a subscription.
Subscribed
Monica purchased a subscription.
Subscribed
Nicole purchased a subscription.
Subscribed
Roland purchased a subscription.
Subscribed
Laura purchased a subscription.
Subscribed
Pamela purchased a subscription.
Subscribed
Mitchell purchased a subscription.
Subscribed
Elizabeth purchased a subscription.
Subscribed
Rachel purchased a subscription.
Subscribed
Amy purchased a subscription.
Subscribed
Lance purchased a subscription.
Subscribed
Adrienne purchased a subscription.
Subscribed
Erendira purchased a subscription.
Subscribed
Jordan purchased a subscription.
Subscribed
Shawn purchased a subscription.
Subscribed
Robert purchased a subscription.
Subscribed
Ann Saputelli purchased a subscription.
Subscribed
Michael Febrey purchased a subscription.
Subscribed
Laura purchased a subscription.
Subscribed
Jhanet purchased a subscription.
Subscribed
Steven purchased a subscription.
Subscribed
Robert purchased a subscription.
Subscribed
Patricia purchased a subscription.
Subscribed
Johanna purchased a subscription.
Subscribed
Artur purchased a subscription.
Subscribed
Vanessa purchased a subscription.
Subscribed
Ami purchased a subscription.
Subscribed
Melissa purchased a subscription.
Subscribed
Morgan purchased a subscription.
Subscribed
Claire purchased a subscription.
Subscribed
JESSICA purchased a subscription.
Subscribed
Amy purchased a subscription.
Subscribed
Oladapo purchased a subscription.
Subscribed
Avani purchased a subscription.
Subscribed
Nicole purchased a subscription.
Subscribed
Angela purchased a subscription.
Subscribed
Jo Ann purchased a subscription.
Subscribed
Kristn purchased a subscription.
Subscribed
Brian purchased a subscription.
Subscribed
Barbara purchased a subscription.
Subscribed
Breal purchased a subscription.
Subscribed
Angela purchased a subscription.
Subscribed
Amro purchased a subscription.
Subscribed
Robert purchased a subscription.
Subscribed
John P VanderBloemen purchased a subscription.
Subscribed
Carol purchased a subscription.
Subscribed
Osbell purchased a subscription.
Subscribed
Kouri purchased a subscription.
Subscribed
Chelsea purchased a subscription.
Subscribed
Kristen purchased a subscription.
Subscribed
Genie purchased a subscription.
Subscribed
Christine purchased a subscription.
Subscribed
Michael purchased a subscription.
Subscribed
Stephen purchased a subscription.
Subscribed
Thomas purchased a subscription.
Subscribed
Matthew purchased a subscription.
Subscribed
Amy purchased a subscription.
Subscribed
Marianne purchased a subscription.
Subscribed
kellie purchased a subscription.
Subscribed
Donna purchased a subscription.
Subscribed
Mitch purchased a subscription.
Subscribed
Kimberly Anne purchased a subscription.
Subscribed
umadevi purchased a subscription.
Subscribed
Janell purchased a subscription.
Subscribed
HEIDI purchased a subscription.
Subscribed
Lynn purchased a subscription.
Subscribed
Bernard purchased a subscription.
Subscribed
Christian purchased a subscription.
Subscribed
Judy purchased a subscription.
Subscribed
Caroline purchased a subscription.
Subscribed
David purchased a subscription.
Subscribed
beth purchased a subscription.
Subscribed
Barry L purchased a subscription.
Subscribed
Edward purchased a subscription.
Subscribed
Jamie purchased a subscription.
Subscribed
Kevin purchased a subscription.
Subscribed
Elton purchased a subscription.
Subscribed
David purchased a subscription.
Subscribed
Mary-Jo purchased a subscription.
Subscribed
Michael purchased a subscription.