myCPE
myCPE

Certified Advanced Excel Professional Course (CAEPC)

Automate and Streamline with Advanced Excel Features.

Last Updated

December, 2024

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

Ready to elevate your Excel skills? The Certified Advanced Excel Professional Course (CAEPC) is designed for professionals eager to master Excel’s advanced capabilities. You’ll learn to automate reports, create sophisticated financial models, and design interactive dashboards. With an emphasis on Power Pivot, Power Query, and data integration, this course will transform your ability to manage and analyze complex data.

Get Deeper Understanding of:

  • Automating financial models with advanced Excel features.
  • Designing interactive dashboards to visualize key data insights.
  • Creating dynamic reports using Excel formulas and advanced functions.
  • Building budgeting models and financial projections in Excel.
  • Enhancing data analysis with advanced Excel charting techniques.

Recommended For:

  • CPAs and financial professionals seeking to advance their Excel expertise, focusing on complex data analysis, automation, and financial modeling beyond basic Excel skills.
  • Professionals in finance, business intelligence, or data analytics aiming to optimize reporting, create advanced financial models, and extract insights using Excel’s most powerful features.
  • Individuals wanting to master advanced Excel tools to enhance productivity, automate tasks, and develop sophisticated reports and dashboards for strategic decision-making.

Why take the Certified Advanced Excel Professional Course (CAEPC) Course with MYCPE ONE?

Resources included

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

Career Opportunities

  • Senior Data Analyst
  • Financial Modeler
  • Excel Specialist
  • Business Intelligence Analyst
  • Financial Reporting Manager

Value Addition to your skills

  • Advanced Data Analysis
  • Excel Automation Techniques
  • Financial Modeling Expertise
  • Dashboard and Reporting Skills
  • Data Integration Proficiency
  • Problem-solving with Excel Functions
  • Streamlined Workflow Management

Courses

Course Title Time Credits
1. Excel Pivot Tables: How to Tame the Excel Beast!
1 Hour

On Demand Credits for Listed Qualifications

Nano Credits for Listed Qualifications

On Demand Credits for Listed Qualifications

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
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
  • Recognize the differences between formulas and Pivot Tables and identify the pros and cons of using Pivot Tables.
  • Discover essential skills and intermediate techniques for effective Pivot Table construction and advanced data handling.
  • Implement best practices for constructing Pivot Tables to enhance data analysis and reporting.
2. Intermediate Pivot Tables: Because Basic is So Last Years
1 Hour

On Demand Credits for Listed Qualifications

Nano Credits for Listed Qualifications

On Demand Credits for Listed Qualifications

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
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
  • Resolve formula errors and apply intermediate skills for calculations in Pivot Tables.
  • Customize Pivot Table layouts and displays for improved data presentation.
  • Master advanced data management techniques and enhance productivity with keyboard shortcuts in Excel.
3. Advanced Pivot Tables: The Ticket to Self-service Dashboards
1 Hour

On Demand Credits for Listed Qualifications

Nano Credits for Listed Qualifications

On Demand Credits for Listed Qualifications

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
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
  • Analyze Pivot Table data to uncover insights and address reporting needs.
  • Customize calculations and layouts to improve data clarity and presentation.
  • Apply advanced techniques and utilize shortcuts to streamline workflow and solve complex data challenges.
4. Excel - Power Pivot - Take Your Pivot Tables to the Next Level
1 Hour

On Demand Credits for Listed Qualifications

Nano Credits for Listed Qualifications

On Demand Credits for Listed Qualifications

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
Computer technology for Maryland Tax Preparer (MRTP) (Approval No. GEHNZ-T-01350-22-S) 1 CE Approved
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
Computer Software and Applications for Licensed Public Accountant (LPA) 1 CPE 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
Computer technology for Maryland Tax Preparer (MRTP) (Approval No. GEHNZ-T-01350-22-S) 1 CE Approved
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
Computer Software and Applications for Licensed Public Accountant (LPA) 1 CPE 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
Computer technology for Maryland Tax Preparer (MRTP) (Approval No. GEHNZ-T-01350-22-S) 1 CE Approved
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
Computer Software and Applications for Licensed Public Accountant (LPA) 1 CPE Eligible
  • Utilize Power Pivot to enhance Business Intelligence and reporting within Excel.
  • Create Pivot Tables from related data sources, including external and Excel tables.
  • Manage relationships using the Data Model and implement powerful calculated fields in Pivot Tables.
5. Excel Accountant: Pivot Tables for Data Analysis
4 Hours

On Demand Credits for Listed Qualifications

Nano Credits for Listed Qualifications

On Demand Credits for Listed Qualifications

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
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-01023-22-S) 4 CE Approved
Chartered Accountants - Ireland (CAI) 4 CPD Eligible
Chartered Accountants - Scotland 4 CPD Eligible
CPA - Ireland 4 CPD 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
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-01023-22-S) 4 CE Approved
Chartered Accountants - Ireland (CAI) 4 CPD Eligible
Chartered Accountants - Scotland 4 CPD Eligible
CPA - Ireland 4 CPD 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
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-01023-22-S) 4 CE Approved
Chartered Accountants - Ireland (CAI) 4 CPD Eligible
Chartered Accountants - Scotland 4 CPD Eligible
CPA - Ireland 4 CPD Eligible
  • Identify key Pivot Table commands such as Subtotals and Field List within Excel’s ribbon interface.
  • Recognize Pivot Table indicators for filtering and the menus that appear or disappear during interactions.
  • Utilize mouse actions to reconstruct data and manage the GETPIVOTTABLE feature in Excel.
6. Excel Magic 1: Elevate Your Skills with Dynamic Formulas
1 Hour

On Demand Credits for Listed Qualifications

Nano Credits for Listed Qualifications

On Demand Credits for Listed Qualifications

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
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
  • Differentiate between simple and dynamic formulas and identify key elements that make a formula dynamic.
  • Explore top dynamic formulas and advanced techniques that simplify Excel modeling.
  • Discover new dynamic array formula features introduced in Excel 365.
7. Excel Magic 2: Ditch Manual Reports— Bot is Ready to Work Overtime!
1 Hour

On Demand Credits for Listed Qualifications

Nano Credits for Listed Qualifications

On Demand Credits for Listed Qualifications

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
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
  • Understand VBA macros as the 4th generation of Excel modeling and identify key elements of a VBA macro.
  • Recognize when to use VBA macros and explore best practices for building effective macros.
  • Discover the steps to create a reporting-generating Bot and key elements of the VBA environment.
8. Excel Magic 3: Automating Data Entry with Data Feeds
1 Hour

On Demand Credits for Listed Qualifications

Nano Credits for Listed Qualifications

On Demand Credits for Listed Qualifications

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
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
  • Automate data entries and convert PDF data to Excel.
  • Use Excel functions to connect and refresh online tables.
  • Master text formulas for formatting and integrate accounting system data into Excel.
9. Excel Magic 4: Say Goodbye to Boring Reports—Hello, API Power!
0.5 Hour

On Demand Credits for Listed Qualifications

Nano Credits for Listed Qualifications

On Demand Credits for Listed Qualifications

License details Credits Status
Computer Software and Applications for Certified Public Accountants (CPA-US) 0.5 CPE Approved
Computer Software and Applications for CPA in Canada 0.5 CPD Eligible
Computer Software and Applications for Delaware Licensed Public Accountant (DE-LPA) 0.5 CPE Eligible
Information Technology for Certified Government Financial Manager (CGFM) 0.5 CPE Eligible
Computer Software and Applications for Certified Fraud Examiner (CFE) 0.5 CPE Eligible
Association of Chartered Certified Accountants (ACCA) 0.5 CPD Eligible
Chartered Accountant - ICAEW 0.5 CPD Eligible
Computer Software and Applications for Iowa Licensed Public Accountant (IA-LPA) 0.5 CPE Eligible
Computer Software and Applications for Maine Licensed Public Accountant (ME-LPA) 0.5 CPE Eligible
Information Technology (inc. Excel) for Certified FP&A Professional (FP&A) 0.5 CE Eligible
Chartered Accountants - Ireland (CAI) 0.5 CPD Eligible
Chartered Accountants - Scotland 0.5 CPD Eligible
CPA - Ireland 0.5 CPD Eligible
License details Credits Status
Computer Software and Applications for Certified Public Accountants (CPA-US) 0.5 CPE Approved
Computer Software and Applications for CPA in Canada 0.5 CPD Eligible
Computer Software and Applications for Delaware Licensed Public Accountant (DE-LPA) 0.5 CPE Eligible
Information Technology for Certified Government Financial Manager (CGFM) 0.5 CPE Eligible
Computer Software and Applications for Certified Fraud Examiner (CFE) 0.5 CPE Eligible
Association of Chartered Certified Accountants (ACCA) 0.5 CPD Eligible
Chartered Accountant - ICAEW 0.5 CPD Eligible
Computer Software and Applications for Iowa Licensed Public Accountant (IA-LPA) 0.5 CPE Eligible
Computer Software and Applications for Maine Licensed Public Accountant (ME-LPA) 0.5 CPE Eligible
Information Technology (inc. Excel) for Certified FP&A Professional (FP&A) 0.5 CE Eligible
Chartered Accountants - Ireland (CAI) 0.5 CPD Eligible
Chartered Accountants - Scotland 0.5 CPD Eligible
CPA - Ireland 0.5 CPD Eligible
License details Credits Status
Computer Software and Applications for Certified Public Accountants (CPA-US) 0.5 CPE Approved
Computer Software and Applications for CPA in Canada 0.5 CPD Eligible
Computer Software and Applications for Delaware Licensed Public Accountant (DE-LPA) 0.5 CPE Eligible
Information Technology for Certified Government Financial Manager (CGFM) 0.5 CPE Eligible
Computer Software and Applications for Certified Fraud Examiner (CFE) 0.5 CPE Eligible
Association of Chartered Certified Accountants (ACCA) 0.5 CPD Eligible
Chartered Accountant - ICAEW 0.5 CPD Eligible
Computer Software and Applications for Iowa Licensed Public Accountant (IA-LPA) 0.5 CPE Eligible
Computer Software and Applications for Maine Licensed Public Accountant (ME-LPA) 0.5 CPE Eligible
Information Technology (inc. Excel) for Certified FP&A Professional (FP&A) 0.5 CE Eligible
Chartered Accountants - Ireland (CAI) 0.5 CPD Eligible
Chartered Accountants - Scotland 0.5 CPD Eligible
CPA - Ireland 0.5 CPD Eligible
  • Identify key features of API reporting and methods for reporting from financial systems.
  • Differentiate between extracted and attached Excel reports for better reporting clarity.
  • Explore technology for writing back data and unique features of Office Connect in dynamic API reporting.
10. Excel Magic 5: Building Interactive Budgeting Model in Excel
1 Hour

On Demand Credits for Listed Qualifications

Nano Credits for Listed Qualifications

On Demand Credits for Listed Qualifications

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
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
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
CPA - Ireland 1 CPD Eligible
  • Build interactive Excel budgeting models and create editable PivotTables for efficient reporting.
  • Use Power Query to consolidate and integrate data from multiple sources.
  • Generate integrated reports that combine actuals, budgets, and forecasts for streamlined analysis.
11. Excel Magic 6: "Speaking" the 7 Languages in Excel
1.5 Hours

On Demand Credits for Listed Qualifications

Nano Credits for Listed Qualifications

On Demand Credits for Listed Qualifications

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
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
  • Explore formulas and methods for efficient data management, including custom cell formatting and dynamic named ranges.
  • Analyze formulas in PivotTables to enhance data analysis and streamline decision-making.
  • Understand the basics of VBA, M language, and DAX functions for advanced data manipulation and reporting.
12. Excel Magic 7: Creating Excel Charts Like a PRO
1.5 Hours

On Demand Credits for Listed Qualifications

Nano Credits for Listed Qualifications

On Demand Credits for Listed Qualifications

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
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
  • Discuss popular Excel charts and discover essential charting techniques for clarity.
  • Analyze key formatting techniques and explore rarely used charts for enhanced visualization.
  • Implement best practices to create impactful and effective charts in Excel.
13. Excel Magic 8: Building a Project Tracking “Gantt” Chart
1.5 Hours

On Demand Credits for Listed Qualifications

Nano Credits for Listed Qualifications

On Demand Credits for Listed Qualifications

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
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
  • Identify and construct Gantt Charts, from basic to advanced with overlapping tasks.
  • Apply conditional formatting techniques in Excel to improve data visualization.
  • Enhance data entry efficiency using Excel apps for streamlined workflows.
14. Data Visualization using Excel
1.5 Hours

On Demand Credits for Listed Qualifications

Nano Credits for Listed Qualifications

On Demand Credits for Listed Qualifications

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
Computer technology for Maryland Tax Preparer (MRTP) (Approval No. GEHNZ-T-01044-22-S) 1 CE Approved
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
Computer technology for Maryland Tax Preparer (MRTP) (Approval No. GEHNZ-T-01044-22-S) 1 CE Approved
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
Computer technology for Maryland Tax Preparer (MRTP) (Approval No. GEHNZ-T-01044-22-S) 1 CE Approved
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
  • Discuss principles of data analysis and the most commonly used charts, Power Pivots, and queries.
  • Create custom charts in Excel and manage data connections and models.
  • Generate interactive dashboards and explore the process for creating data-driven interactivity.
15. Building an Excel Dashboard - Transforming Raw Data into Visual Insights
1 Hour

On Demand Credits for Listed Qualifications

Nano Credits for Listed Qualifications

On Demand Credits for Listed Qualifications

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
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
  • Analyze dashboard design principles and create interactive, visually engaging dashboards in Excel.
  • Apply best practices in data visualization to enhance clarity and impact.
  • Leverage dashboards to inform and guide strategic business decisions.
16. Financial Modeling Using Excel
1.5 Hours

On Demand Credits for Listed Qualifications

Nano Credits for Listed Qualifications

On Demand Credits for Listed Qualifications

License details Credits Status
Finance for Certified Public Accountants (CPA-US) 1.5 CPE Approved
Finance for CPA in Canada 1.5 CPD Eligible
Finance for Accredited in Business Valuation (ABV) 1.5 CPD Eligible
Finance for Delaware Licensed Public Accountant (DE-LPA) 1.5 CPE Eligible
Association of Chartered Certified Accountants (ACCA) 1.5 CPD Eligible
Financial Planning for Certified Wealth Strategist (CWS) 1.5 CE Eligible
Chartered Accountant - ICAEW 1.5 CPD Eligible
Financial Planning for Certified Fiduciary and Investment Risk Specialist (CFIRS) 1.5 CE Eligible
Master Analyst In Financial Forensics (MAFF) 1.5 CPE Eligible
Certified Financial Forensics (CFF) 1.5 CPD Eligible
Finance for Iowa Licensed Public Accountant (IA-LPA) 1.5 CPE Eligible
Finance 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
License details Credits Status
Finance for Certified Public Accountants (CPA-US) 1.5 CPE Approved
Finance for CPA in Canada 1.5 CPD Eligible
Finance for Accredited in Business Valuation (ABV) 1.5 CPD Eligible
Finance for Delaware Licensed Public Accountant (DE-LPA) 1.5 CPE Eligible
Association of Chartered Certified Accountants (ACCA) 1.5 CPD Eligible
Financial Planning for Certified Wealth Strategist (CWS) 1.5 CE Eligible
Chartered Accountant - ICAEW 1.5 CPD Eligible
Financial Planning for Certified Fiduciary and Investment Risk Specialist (CFIRS) 1.5 CE Eligible
Master Analyst In Financial Forensics (MAFF) 1.5 CPE Eligible
Certified Financial Forensics (CFF) 1.5 CPD Eligible
Finance for Iowa Licensed Public Accountant (IA-LPA) 1.5 CPE Eligible
Finance 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
License details Credits Status
Finance for Certified Public Accountants (CPA-US) 1.5 CPE Approved
Finance for CPA in Canada 1.5 CPD Eligible
Finance for Accredited in Business Valuation (ABV) 1.5 CPD Eligible
Finance for Delaware Licensed Public Accountant (DE-LPA) 1.5 CPE Eligible
Association of Chartered Certified Accountants (ACCA) 1.5 CPD Eligible
Financial Planning for Certified Wealth Strategist (CWS) 1.5 CE Eligible
Chartered Accountant - ICAEW 1.5 CPD Eligible
Financial Planning for Certified Fiduciary and Investment Risk Specialist (CFIRS) 1.5 CE Eligible
Master Analyst In Financial Forensics (MAFF) 1.5 CPE Eligible
Certified Financial Forensics (CFF) 1.5 CPD Eligible
Finance for Iowa Licensed Public Accountant (IA-LPA) 1.5 CPE Eligible
Finance 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
  • Use Excel for disciplined financial analysis and develop projections for income statements, balance sheets, and cash flows.
  • Analyze methods to maintain model integrity and credibility throughout the development process.
  • Prepare accurate financial projections that guide decision-making and strategic planning.
17. Introduction to Power Query in Excel
4 Hours

On Demand Credits for Listed Qualifications

Nano Credits for Listed Qualifications

On Demand Credits for Listed Qualifications

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
Information Technology (inc. Excel) for Certified FP&A Professional (FP&A) 4 CE Eligible
Chartered Accountants - Ireland (CAI) 4 CPD Eligible
Chartered Accountants - Scotland 4 CPD Eligible
CPA - Ireland 4 CPD 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
Information Technology (inc. Excel) for Certified FP&A Professional (FP&A) 4 CE Eligible
Chartered Accountants - Ireland (CAI) 4 CPD Eligible
Chartered Accountants - Scotland 4 CPD Eligible
CPA - Ireland 4 CPD 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
Information Technology (inc. Excel) for Certified FP&A Professional (FP&A) 4 CE Eligible
Chartered Accountants - Ireland (CAI) 4 CPD Eligible
Chartered Accountants - Scotland 4 CPD Eligible
CPA - Ireland 4 CPD Eligible
  • Explain how to use Power Query to extract text from cells, unpivot reports, and import data.
  • Identify key Power Query commands for appending queries and sending data to PivotTables.
  • Navigate the Power Query interface to locate essential commands and improve data analysis workflows.
18. Excel- Power Query - No Code Automation Every User Needs to Know About - Part 1
1 Hour

On Demand Credits for Listed Qualifications

Nano Credits for Listed Qualifications

On Demand Credits for Listed Qualifications

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
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
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
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
  • Analyze how Power Query/Get and Transform saves time and enhances data processing efficiency.
  • Identify the differences between Excel functionality and Power Query/Get and Transform.
  • Discuss the benefits and speed advantages of using Power Query/Get and Transform for data work.
19. Excel- Power Query - No Code Automation Every User Needs to Know About - Part 2
1 Hour

On Demand Credits for Listed Qualifications

Nano Credits for Listed Qualifications

On Demand Credits for Listed Qualifications

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
Computer technology for Maryland Tax Preparer (MRTP) (Approval No. GEHNZ-T-01348-22-S) 1 CE Approved
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
Computer technology for Maryland Tax Preparer (MRTP) (Approval No. GEHNZ-T-01348-22-S) 1 CE Approved
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
Computer technology for Maryland Tax Preparer (MRTP) (Approval No. GEHNZ-T-01348-22-S) 1 CE Approved
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
  • Analyze how to create additional columns without complex formulas.
  • Explain how to combine, merge, and unpivot unusable data to make it report-ready.
  • Discuss the advanced features of the Power Query Editor.
20. Power BI Class
4 Hours

On Demand Credits for Listed Qualifications

Nano Credits for Listed Qualifications

On Demand Credits for Listed Qualifications

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-01056-22-S) 4 CE Approved
Information Technology (inc. Excel) for Certified FP&A Professional (FP&A) 4 CE Eligible
Chartered Accountants - Ireland (CAI) 4 CPD Eligible
Chartered Accountants - Scotland 4 CPD Eligible
CPA - Ireland 4 CPD 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-01056-22-S) 4 CE Approved
Information Technology (inc. Excel) for Certified FP&A Professional (FP&A) 4 CE Eligible
Chartered Accountants - Ireland (CAI) 4 CPD Eligible
Chartered Accountants - Scotland 4 CPD Eligible
CPA - Ireland 4 CPD 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-01056-22-S) 4 CE Approved
Information Technology (inc. Excel) for Certified FP&A Professional (FP&A) 4 CE Eligible
Chartered Accountants - Ireland (CAI) 4 CPD Eligible
Chartered Accountants - Scotland 4 CPD Eligible
CPA - Ireland 4 CPD Eligible
  • Analyze concepts like data visualization, integration, and the use of Power Pivot, Power Map, and Power Excel.
  • Explore DAX, measurements, and how to perform data binding and formatting.
  • Master Power BI Embedded and Workspace Collection for advanced data analysis and reporting.
21. Getting Started with DAX in Excel and Power BI
1.5 Hours

On Demand Credits for Listed Qualifications

Nano Credits for Listed Qualifications

On Demand Credits for Listed Qualifications

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
Computer technology for Maryland Tax Preparer (MRTP) (Approval No. GEHNZ-T-01367-22-S) 1 CE Approved
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
Computer technology for Maryland Tax Preparer (MRTP) (Approval No. GEHNZ-T-01367-22-S) 1 CE Approved
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
Computer technology for Maryland Tax Preparer (MRTP) (Approval No. GEHNZ-T-01367-22-S) 1 CE Approved
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
  • Explain DAX and how to leverage its functionality for advanced data analysis.
  • Explore Measures and the CALCULATE function to enhance data modeling.
  • Discuss how Power Pivot provides Business Intelligence and reporting capabilities within Excel.
22. Mastering Calculated Columns Excel & Power BI Query Editor Techniques
1 Hour

On Demand Credits for Listed Qualifications

Nano Credits for Listed Qualifications

On Demand Credits for Listed Qualifications

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
Data & Analytics for Associate Professional in Talent Development (APTD) 1 Points Eligible
Data & Analytics for Certified Professional in Talent Development (CPTD) 1 Points 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
Data & Analytics for Associate Professional in Talent Development (APTD) 1 Points Eligible
Data & Analytics for Certified Professional in Talent Development (CPTD) 1 Points 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
Data & Analytics for Associate Professional in Talent Development (APTD) 1 Points Eligible
Data & Analytics for Certified Professional in Talent Development (CPTD) 1 Points 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
  • Discuss the functionalities of the Query Editor tools in Excel and Power BI for creating calculated columns.
  • Create and manipulate calculated columns using DAX functions to summarize data and uncover insights.
  • Troubleshoot common issues encountered when working with calculated columns in Excel and Power BI.
23. Automating Financial Reporting in EXCEL (Part 1)
1.5 Hours

On Demand Credits for Listed Qualifications

Nano Credits for Listed Qualifications

On Demand Credits for Listed Qualifications

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
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
  • Build reports using Excel formulas such as VLOOKUP, MATCH, and INDEX, and create Pivot Tables.
  • Review model reports with GETPIVOTDATA to streamline data extraction.
  • Identify essential VBA macros to automate reporting processes for "one-click reporting."
24. Automating Financial Reporting in EXCEL (Part 2)
1 Hour

On Demand Credits for Listed Qualifications

Nano Credits for Listed Qualifications

On Demand Credits for Listed Qualifications

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
Information Technology for Chartered Global Management Accountants (CGMA) 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
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
Information Technology for Chartered Global Management Accountants (CGMA) 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
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
Information Technology for Chartered Global Management Accountants (CGMA) 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
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
  • Analyze how to synchronize financials from EXCEL to WORD and PowerPoint.
  • Explain how to set up Parameters and Proofs in financial report modeling.
  • Discuss building an interactive dashboard with clickable buttons for detail drill-down, and identify three essential elements in financial modeling.
25. Automating Financial Reporting in EXCEL (Part 3)
1 Hour

On Demand Credits for Listed Qualifications

Nano Credits for Listed Qualifications

On Demand Credits for Listed Qualifications

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
Information Technology for Chartered Global Management Accountants (CGMA) 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
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
Information Technology for Chartered Global Management Accountants (CGMA) 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
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
Information Technology for Chartered Global Management Accountants (CGMA) 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
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
  • Identify critical components for building integrated financial documents and presentations in Excel, Word, and PowerPoint.
  • List essential formulas for designing automated narratives and synchronizing financial data between Word, PowerPoint, and Excel.
  • Analyze methods to customize charts for reports and ensure effective data presentation.
26. Advanced Excel Skills For Accountants
1 Hour

On Demand Credits for Listed Qualifications

Nano Credits for Listed Qualifications

On Demand Credits for Listed Qualifications

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
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
  • Analyze the VLOOKUP function for looking up data, performing approximate matches, and handling potential #N/A errors.
  • Compare INDEX and MATCH with VLOOKUP/HLOOKUP, and evaluate the use of the SUMIFS function for summing values based on multiple criteria.
  • Explore the new XLOOKUP function in Office 365 and identify the ideal data for analysis with Excel's PivotTable feature.
27. Excel Accountant: XLOOKUP
2 Hours

On Demand Credits for Listed Qualifications

Nano Credits for Listed Qualifications

On Demand Credits for Listed Qualifications

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
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
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
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
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
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
  • Identify the purpose of Excel’s XLOOKUP function and the column_index_num argument within VLOOKUP.
  • Explore the MAXIFS function and the number of criteria pairs you can specify.
  • Understand the MATCH function’s return value and explore Excel for Mac’s Function ScreenTips for enhanced functionality.
28. Excel Accountant: Time-Saving Data Analysis Techniques
2 Hours

On Demand Credits for Listed Qualifications

Nano Credits for Listed Qualifications

On Demand Credits for Listed Qualifications

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
Data analytics for Certified Management Accountants (CMA) 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
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
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
Data analytics for Certified Management Accountants (CMA) 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
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
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
Data analytics for Certified Management Accountants (CMA) 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
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
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
  • Explain the menu in Excel where the Table feature resides.
  • Analyze dynamic array function from a list of worksheet functions.
  • Discuss how to use Power Query to automate repetitive analysis.
29. Excel Accountant: Internal Control
2 Hours

On Demand Credits for Listed Qualifications

Nano Credits for Listed Qualifications

On Demand Credits for Listed Qualifications

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-01206-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-01206-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-01206-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
  • Recall which ribbon tab contains the Data Validation feature.
  • Identify which input is valid for a data validation rule limiting inputs to whole numbers between 0 and 100.
  • Explain the ribbon tab the Table feature appears within.
30. Excel Accountant: Auditing Excel Workbooks
2 Hours

On Demand Credits for Listed Qualifications

Nano Credits for Listed Qualifications

On Demand Credits for Listed Qualifications

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
Computer technology for Maryland Tax Preparer (MRTP) (Approval No. GEHNZ-T-00966-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
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
Computer technology for Maryland Tax Preparer (MRTP) (Approval No. GEHNZ-T-00966-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
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
Computer technology for Maryland Tax Preparer (MRTP) (Approval No. GEHNZ-T-00966-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
  • Recall the location of the menu command to determine if a workbook contains links and identify the setting for Enable Iterative Calculations.
  • Transform cell references into range names and implement the Watch Window to track changes in workbooks.
  • Explore automatic vs. manual calculation in Excel and learn how to trace dependents, precedents, and circular references.
31. Data Management in Excel- Combining, Merging and Modelling Data
1 Hour

On Demand Credits for Listed Qualifications

Nano Credits for Listed Qualifications

On Demand Credits for Listed Qualifications

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 Chartered Global Management Accountants (CGMA) 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
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
Data & Analytics for Associate Professional in Talent Development (APTD) 1 Points Eligible
Data & Analytics for Certified Professional in Talent Development (CPTD) 1 Points 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 Chartered Global Management Accountants (CGMA) 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
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
Data & Analytics for Associate Professional in Talent Development (APTD) 1 Points Eligible
Data & Analytics for Certified Professional in Talent Development (CPTD) 1 Points 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 Chartered Global Management Accountants (CGMA) 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
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
Data & Analytics for Associate Professional in Talent Development (APTD) 1 Points Eligible
Data & Analytics for Certified Professional in Talent Development (CPTD) 1 Points 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
  • Discuss utilizing VLOOKUP and XLOOKUP to search for specific data across multiple sheets and compile information effectively.
  • Apply the VSTACK function to combine arrays vertically and use Power Query for advanced merging and appending data from various formats.
  • Analyze data models to enhance data analysis, ensuring accuracy and efficiency in decision-making processes.
32. Mastering Tables in Excel: Enhance Your Data Management Skills
1 Hour

On Demand Credits for Listed Qualifications

Nano Credits for Listed Qualifications

On Demand Credits for Listed Qualifications

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 Chartered Global Management Accountants (CGMA) 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
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
Data & Analytics for Associate Professional in Talent Development (APTD) 1 Points Eligible
Data & Analytics for Certified Professional in Talent Development (CPTD) 1 Points Eligible
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 Chartered Global Management Accountants (CGMA) 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
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
Data & Analytics for Associate Professional in Talent Development (APTD) 1 Points Eligible
Data & Analytics for Certified Professional in Talent Development (CPTD) 1 Points Eligible
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 Chartered Global Management Accountants (CGMA) 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
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
Data & Analytics for Associate Professional in Talent Development (APTD) 1 Points Eligible
Data & Analytics for Certified Professional in Talent Development (CPTD) 1 Points Eligible
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
  • Grasp the basics of Excel Tables, including creation, formatting, and organizing data efficiently.
  • Master sorting and filtering techniques, including custom sorting and applying multiple filters, while utilizing slicers for interactive filtering.
  • Utilize table-specific formulas and structured references to enhance data analysis within tables.
33. Depreciation Made Easy: Excel Templates for Success
1 Hour

On Demand Credits for Listed Qualifications

Nano Credits for Listed Qualifications

On Demand Credits for Listed Qualifications

License details Credits Status
Accounting for Certified Public Accountants (CPA-US) 1 CPE Approved
Accounting for CPA in Canada 1 CPD Eligible
Accounting 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
Accounting for Iowa Licensed Public Accountant (IA-LPA) 1 CPE Eligible
Accounting 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
Accounting for Certified Public Accountants (CPA-US) 1 CPE Approved
Accounting for CPA in Canada 1 CPD Eligible
Accounting 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
Accounting for Iowa Licensed Public Accountant (IA-LPA) 1 CPE Eligible
Accounting 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
Accounting for Certified Public Accountants (CPA-US) 1 CPE Approved
Accounting for CPA in Canada 1 CPD Eligible
Accounting 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
Accounting for Iowa Licensed Public Accountant (IA-LPA) 1 CPE Eligible
Accounting 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
  • Identify and differentiate between the four main depreciation methods and understand their applications.
  • Apply procedures to calculate depreciation using each method and utilize Excel templates for efficient implementation.
  • Gain practical insights into managing depreciation for long-lived assets in accounting practices.
34. Zombie Excel
1 Hour

On Demand Credits for Listed Qualifications

Nano Credits for Listed Qualifications

On Demand Credits for Listed Qualifications

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
Compliance with laws and regulations 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
Computer technology for Maryland Tax Preparer (MRTP) (Approval No. GEHNZ-T-01264-22-S) 1 CE Approved
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
Compliance with laws and regulations 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
Computer technology for Maryland Tax Preparer (MRTP) (Approval No. GEHNZ-T-01264-22-S) 1 CE Approved
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
Compliance with laws and regulations 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
Computer technology for Maryland Tax Preparer (MRTP) (Approval No. GEHNZ-T-01264-22-S) 1 CE Approved
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
  • Analyze solutions for handling changes to Print Preview in Word 2010 and later versions.
  • Recover and explore the From Text command in Excel 2019 and Microsoft 365, and examine the Threaded Comments feature in Microsoft 365.
  • Analyze and apply the new XLOOKUP worksheet function in Microsoft 365 for more efficient data lookups.
35. Spreadsheet Skyscrapers vs. Spreadsheet Sprawl
2 Hours

On Demand Credits for Listed Qualifications

Nano Credits for Listed Qualifications

On Demand Credits for Listed Qualifications

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
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
  • Append data from multiple worksheets into a self-updating list with Power Query.
  • Optimize data by transposing or unpivoting reports and removing total rows.
  • Automate extraction using INDIRECT and simplify navigation with the Navigation task pane.
36. Making a Splash: Excel Waterfall Calculations
2 Hours

On Demand Credits for Listed Qualifications

Nano Credits for Listed Qualifications

On Demand Credits for Listed Qualifications

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
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
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
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
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
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
  • Analyze the concept of waterfall calculations in Excel.
  • Recall keyboard shortcuts to transfer cell contents and toggle bold settings.
  • Identify the location of the Format Painter command within Excel's menu structure.
37. Macro Magic: Advanced Techniques and Tips
5 Hours

On Demand Credits for Listed Qualifications

Nano Credits for Listed Qualifications

On Demand Credits for Listed Qualifications

License details Credits Status
Computer Software and Applications for Certified Public Accountants (CPA-US) 5 CPE Approved
Computer Software and Applications for CPA in Canada 5 CPD Eligible
Computer Software and Applications for Delaware Licensed Public Accountant (DE-LPA) 5 CPE Eligible
Information Technology for Certified Government Financial Manager (CGFM) 5 CPE Eligible
Computer Software and Applications for Certified Fraud Examiner (CFE) 5 CPE Eligible
Association of Chartered Certified Accountants (ACCA) 5 CPD Eligible
Chartered Accountant - ICAEW 5 CPD Eligible
Computer Software and Applications for Iowa Licensed Public Accountant (IA-LPA) 5 CPE Eligible
Computer Software and Applications for Maine Licensed Public Accountant (ME-LPA) 5 CPE Eligible
Information Technology (inc. Excel) for Certified FP&A Professional (FP&A) 5 CE Eligible
Chartered Accountants - Ireland (CAI) 5 CPD Eligible
Chartered Accountants - Scotland 5 CPD Eligible
CPA - Ireland 5 CPD Eligible
License details Credits Status
Computer Software and Applications for Certified Public Accountants (CPA-US) 5 CPE Approved
Computer Software and Applications for CPA in Canada 5 CPD Eligible
Computer Software and Applications for Delaware Licensed Public Accountant (DE-LPA) 5 CPE Eligible
Information Technology for Certified Government Financial Manager (CGFM) 5 CPE Eligible
Computer Software and Applications for Certified Fraud Examiner (CFE) 5 CPE Eligible
Association of Chartered Certified Accountants (ACCA) 5 CPD Eligible
Chartered Accountant - ICAEW 5 CPD Eligible
Computer Software and Applications for Iowa Licensed Public Accountant (IA-LPA) 5 CPE Eligible
Computer Software and Applications for Maine Licensed Public Accountant (ME-LPA) 5 CPE Eligible
Information Technology (inc. Excel) for Certified FP&A Professional (FP&A) 5 CE Eligible
Chartered Accountants - Ireland (CAI) 5 CPD Eligible
Chartered Accountants - Scotland 5 CPD Eligible
CPA - Ireland 5 CPD Eligible
License details Credits Status
Computer Software and Applications for Certified Public Accountants (CPA-US) 5 CPE Approved
Computer Software and Applications for CPA in Canada 5 CPD Eligible
Computer Software and Applications for Delaware Licensed Public Accountant (DE-LPA) 5 CPE Eligible
Information Technology for Certified Government Financial Manager (CGFM) 5 CPE Eligible
Computer Software and Applications for Certified Fraud Examiner (CFE) 5 CPE Eligible
Association of Chartered Certified Accountants (ACCA) 5 CPD Eligible
Chartered Accountant - ICAEW 5 CPD Eligible
Computer Software and Applications for Iowa Licensed Public Accountant (IA-LPA) 5 CPE Eligible
Computer Software and Applications for Maine Licensed Public Accountant (ME-LPA) 5 CPE Eligible
Information Technology (inc. Excel) for Certified FP&A Professional (FP&A) 5 CE Eligible
Chartered Accountants - Ireland (CAI) 5 CPD Eligible
Chartered Accountants - Scotland 5 CPD Eligible
CPA - Ireland 5 CPD Eligible
  • Explain keyboard shortcuts for navigating to the last used cell and counting rows in Excel.
  • Discuss the use of "With" in Excel macros and methods for displaying a UserForm in VBA.
  • Identify how to modify the Properties Window and manage items within a ListBox in VBA.
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

Excel Mastery Achieved

“I have taken a lot of Excel courses, but this one truly transformed my skills! The advanced techniques and practical tips I learned have helped me automate tasks and create powerful reports in no time. Definitely a game-changer for my career! ”

James Martinez
James Martinez, ACCA

Accountant

  • rating
  • rating
  • rating
  • rating
  • rating

Unlocking Excel Potential

“I am a financial analyst, and this course has taken my Excel abilities to a whole new level. The advanced formulas and automation skills I have gained are already making a big difference in my work. Go for it if you are serious about mastering Excel! ”

John Harrison
John Harrison, CPA US

Financial Analyst

  • rating
  • rating
  • rating
  • rating
  • rating

Powerful Excel Techniques

“As a CPA, I have always considered myself proficient with Excel, but this course pushed me to become truly advanced. The Power Pivot and financial modeling lessons were especially valuable, and the ability to automate reports has saved me countless hours. Plus, MYCPE ONE made the process easy with clear, organized materials. If you are looking to level up your Excel skills, this is the course for you! ”

Emily Rodgers
Emily Rodgers, CPA US

Financial Analyst

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 certification dives deep into advanced Excel skills, focusing on powerful features such as PivotTables, Power Pivot, and dynamic formulas. You'll master data automation techniques, streamline financial modeling, and learn how to build interactive dashboards. The course also covers Excel's role in financial reporting, automating data entry, creating detailed reports, and integrating Excel with external data sources using Power Query and Power BI. By the end, you’ll be equipped to handle complex data analysis and reporting tasks with ease.

This certification will enhance your ability to leverage Excel for advanced data management and reporting. You'll gain expertise in automating manual tasks, creating insightful financial models, and building interactive dashboards that are critical for data-driven decision-making. Additionally, mastering Power Query and Power BI will allow you to integrate and analyze data from multiple sources seamlessly. Whether you’re in finance, accounting, or data analysis, these skills will increase your productivity, improve your ability to manage large datasets, and position you as a leader in using Excel to drive business insights and efficiencies.

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
Jining purchased a subscription.
Subscribed
Audrey purchased a subscription.
Subscribed
Moath purchased a subscription.
Subscribed
Frank purchased a subscription.
Subscribed
Pedro purchased a subscription.
Subscribed
Roger purchased a subscription.
Subscribed
Aston O purchased a subscription.
Subscribed
Scot purchased a subscription.
Subscribed
Kenneth purchased a subscription.
Subscribed
Ignacio purchased a subscription.
Subscribed
MOHAMMED purchased a subscription.
Subscribed
Vaughn purchased a subscription.
Subscribed
hifan purchased a subscription.
Subscribed
Kim purchased a subscription.
Subscribed
Cody purchased a subscription.
Subscribed
Ahmed purchased a subscription.
Subscribed
Timothy purchased a subscription.
Subscribed
Rebecca purchased a subscription.
Subscribed
sandra purchased a subscription.
Subscribed
Krystal purchased a subscription.
Subscribed
Anastasia purchased a subscription.
Subscribed
carla purchased a subscription.
Subscribed
Margaret purchased a subscription.
Subscribed
Nadin purchased a subscription.
Subscribed
Marwan purchased a subscription.
Subscribed
Alexis purchased a subscription.
Subscribed
Cassandra purchased a subscription.
Subscribed
Bernard purchased a subscription.
Subscribed
Cordilia purchased a subscription.
Subscribed
Greg purchased a subscription.
Subscribed
Kenneth purchased a subscription.
Subscribed
Zihui purchased a subscription.
Subscribed
Janelle purchased a subscription.
Subscribed
WILLIAM purchased a subscription.
Subscribed
Michael purchased a subscription.
Subscribed
Abigail purchased a subscription.
Subscribed
Maria purchased a subscription.
Subscribed
Jason purchased a subscription.
Subscribed
Susan purchased a subscription.
Subscribed
Thomas purchased a subscription.
Subscribed
Michael purchased a subscription.
Subscribed
Saken purchased a subscription.
Subscribed
Julie purchased a subscription.
Subscribed
Carmen purchased a subscription.
Subscribed
Linda purchased a subscription.
Subscribed
Camille purchased a subscription.
Subscribed
Wigberto purchased a subscription.
Subscribed
Cesar purchased a subscription.
Subscribed
Craig purchased a subscription.
Subscribed
Russell purchased a subscription.
Subscribed
Emily purchased a subscription.
Subscribed
Lokesh purchased a subscription.
Subscribed
Angelina purchased a subscription.
Subscribed
Lynne purchased a subscription.
Subscribed
Raghuvir purchased a subscription.
Subscribed
Angela purchased a subscription.
Subscribed
Mary purchased a subscription.
Subscribed
Huei-Jyun purchased a subscription.
Subscribed
Luka purchased a subscription.
Subscribed
Dean purchased a subscription.
Subscribed
Andrew purchased a subscription.
Subscribed
Jeremy purchased a subscription.
Subscribed
Joanie purchased a subscription.
Subscribed
Ryan purchased a subscription.
Subscribed
Larry purchased a subscription.
Subscribed
Amy purchased a subscription.
Subscribed
Teri purchased a subscription.
Subscribed
Peter purchased a subscription.
Subscribed
Megan purchased a subscription.
Subscribed
Bryan purchased a subscription.
Subscribed
William purchased a subscription.
Subscribed
Frank purchased a subscription.
Subscribed
james purchased a subscription.
Subscribed
Jane purchased a subscription.
Subscribed
jack purchased a subscription.
Subscribed
Maureen purchased a subscription.
Subscribed
Lindsay purchased a subscription.
Subscribed
Philip purchased a subscription.
Subscribed
Zane purchased a subscription.
Subscribed
Crosby purchased a subscription.
Subscribed
Monique purchased a subscription.
Subscribed
Yun purchased a subscription.
Subscribed
George purchased a subscription.
Subscribed
Dianne M purchased a subscription.
Subscribed
Evan purchased a subscription.
Subscribed
Inna purchased a subscription.
Subscribed
SUPRIYA purchased a subscription.
Subscribed
Orit purchased a subscription.
Subscribed
Sergio purchased a subscription.
Subscribed
Harvinder purchased a subscription.
Subscribed
David purchased a subscription.
Subscribed
Bart purchased a subscription.
Subscribed
Mary purchased a subscription.
Subscribed
Julie purchased a subscription.
Subscribed
Alamanda purchased a subscription.
Subscribed
Lisa purchased a subscription.
Subscribed
Craig purchased a subscription.
Subscribed
Sevag purchased a subscription.
Subscribed
Dennis purchased a subscription.
Subscribed
Francisco purchased a subscription.