MYCPE ONE

Intermediate Excel Skills Training Program

Build Practical Intermediate Excel Expertise

certificate
5460

Enrollments

5/5(4.8K+ Reviews)
  • rating
  • rating
  • rating
  • rating
  • rating
Published on July, 2026
img
Multiple

Qualifications 

28

Credits

28 Hours

Learning Duration

$299

Training Program Access

Overview

What You’ll learn

Have you mastered Excel basics but want to use more advanced features to improve productivity, accuracy, and business reporting? 

Many professionals rely on Excel every day, yet often use only a fraction of its capabilities. Features such as pivot tables, structured tables, audit trails, spreadsheet auditing, financial reporting techniques, waterfall calculations, depreciation templates, Copilot integration, and error management can significantly improve efficiency while reducing spreadsheet risks. 

The training program, "Intermediate Excel Skills Training Program," focuses on practical Excel techniques that bridge the gap between foundational skills and advanced analytics. It covers data management, spreadsheet auditing, date and time functions, structured tables, pivot tables, financial reporting, Excel automation concepts, AI-assisted productivity with Microsoft Copilot, spreadsheet controls, error prevention, and operational analysis using Excel tools. 

By focusing on real-world business scenarios, this training helps professionals build stronger Excel capabilities, improve spreadsheet accuracy, streamline reporting processes, and work more efficiently with business and financial data.

Get Deeper Understanding of:
  • Advanced data management using Excel tables
  • Spreadsheet auditing and error prevention techniques
  • Pivot tables for business data analysis
  • Financial reporting and waterfall calculations
  • AI-powered productivity with Microsoft Copilot
  • Operational analysis using practical Excel tools
Recommended For:
  • This program is designed for accountants, finance professionals, business analysts, CPAs, office professionals, and individuals looking to strengthen their intermediate Microsoft Excel skills.
  • It is particularly relevant for professionals working with financial reporting, spreadsheet management, operational analysis, data validation, business reporting, budgeting, and workbook auditing. Those who regularly use Excel for business decision-making and want to improve efficiency beyond basic spreadsheet functions will find this training directly aligned with their responsibilities.
  • It is also suitable for professionals looking to enhance spreadsheet accuracy, reduce manual effort, and build greater confidence using intermediate Excel features in everyday work.
Resources included
  • Handout PDFs for every Module.
  • Glossary/Key Terms for every module.
  • Q&A directly with instructors.

Courses

Spreadsheet Skyscrapers vs. Spreadsheet SprawlMastering Tables in Excel: Enhance Your Data Management SkillsExcel Accountant: NuancesExcel Accountant: Error PromptsExcel Accountant: Creating Error-Free Excel SpreadsheetsExcel Accountant: Auditing Excel WorkbooksCreating Audit Trails in Microsoft ExcelDisaster Proof SpreadsheetExcel Date and Time TechniquesExcel Accountant: Pivot Tables for Data AnalysisFrom Data to Decision: Powerful Excel Techniques for Financial ReportingMaking a Splash: Excel Waterfall CalculationsDepreciation Made Easy: Excel Templates for SuccessOperations Optimization Using Excel ToolsExcel Meets AI - How Microsoft Copilot Can Save You Time
Course Title Time Credits Learning Format
2 Hours
License details Credits Status
Computer Software and Applications for Certified Public Accountants (CPA-US) 2 CPE Approved
Computer Software and Applications for Chartered Professional Accountant in Canada 2 CPD Eligible
Information Technology for Certified Government Financial Manager (CGFM) 2 CPE Eligible
Computer Software and Applications for Delaware Licensed Public Accountant (DE-LPA) 2 CPE Approved
Association of Chartered Certified Accountants (ACCA) 2 CPD Eligible
Chartered Accountant - ICAEW 2 CPD Eligible
Information Technology (inc. Excel) for Certified FP&A Professional (FP&A) 2 CE Eligible
Computer Software and Applications for Iowa Licensed Public Accountant (IA-LPA) 2 CPE Approved
Computer Software and Applications for Maine Licensed Public Accountant (ME-LPA) 2 CPE Approved
Chartered Accountants - Scotland 2 CPD Eligible
Chartered Accountants - Ireland (CAI) 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 Chartered Professional Accountant in Canada 2 CPD Eligible
Information Technology for Certified Government Financial Manager (CGFM) 2 CPE Eligible
Computer Software and Applications for Delaware Licensed Public Accountant (DE-LPA) 2 CPE Approved
Association of Chartered Certified Accountants (ACCA) 2 CPD Eligible
Chartered Accountant - ICAEW 2 CPD Eligible
Information Technology (inc. Excel) for Certified FP&A Professional (FP&A) 2 CE Eligible
Computer Software and Applications for Iowa Licensed Public Accountant (IA-LPA) 2 CPE Approved
Computer Software and Applications for Maine Licensed Public Accountant (ME-LPA) 2 CPE Approved
Chartered Accountants - Scotland 2 CPD Eligible
Chartered Accountants - Ireland (CAI) 2 CPD Eligible
CPA - Ireland 2 CPD Eligible
On Demand (video)
  • Learn to append data from multiple worksheets into a self-updating consolidated list with Power Query and configure efficient automatic updates.
  • Compare the benefits of transposing wide reports versus unpivoting data and eliminate total rows after unpivoting in Power Query.
  • Create a self-updating list of worksheets in any workbook with Power Query and explore the Queries & Connections task pane for managing data connections.
1 Hour
License details Credits Status
Computer Software and Applications for Certified Public Accountants (CPA-US) 1 CPE Approved
Computer Software and Applications for Chartered Professional Accountant in Canada 1 CPD Eligible
Computer Software and Applications for Certified Fraud Examiner (CFE) 1 CPE Eligible
Computer Software and Applications for Chartered Global Management Accountants (CGMA) 1 CPE Eligible
Information Technology for Certified Government Financial Manager (CGFM) 1 CPE Eligible
Computer Software and Applications for Delaware Licensed Public Accountant (DE-LPA) 1 CPE Approved
Association of Chartered Certified Accountants (ACCA) 1 CPD Eligible
Chartered Accountant - ICAEW 1 CPD Eligible
Certified FP&A Professional (FP&A) 1 CE Eligible
Computer Software and Applications for Iowa Licensed Public Accountant (IA-LPA) 1 CPE Approved
Computer Software and Applications for Maine Licensed Public Accountant (ME-LPA) 1 CPE Approved
Data & Analytics for Associate Professional in Talent Development (APTD) 1 CEU Approved
Data & Analytics for Certified Professional in Talent Development (CPTD) 1 CEU Approved
Chartered Accountants - Scotland 1 CPD 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 Chartered Professional Accountant in Canada 1 CPD Eligible
Computer Software and Applications for Certified Fraud Examiner (CFE) 1 CPE Eligible
Computer Software and Applications for Chartered Global Management Accountants (CGMA) 1 CPE Eligible
Information Technology for Certified Government Financial Manager (CGFM) 1 CPE Eligible
Computer Software and Applications for Delaware Licensed Public Accountant (DE-LPA) 1 CPE Approved
Association of Chartered Certified Accountants (ACCA) 1 CPD Eligible
Chartered Accountant - ICAEW 1 CPD Eligible
Certified FP&A Professional (FP&A) 1 CE Eligible
Computer Software and Applications for Iowa Licensed Public Accountant (IA-LPA) 1 CPE Approved
Computer Software and Applications for Maine Licensed Public Accountant (ME-LPA) 1 CPE Approved
Data & Analytics for Associate Professional in Talent Development (APTD) 1 CEU Approved
Data & Analytics for Certified Professional in Talent Development (CPTD) 1 CEU Approved
Chartered Accountants - Scotland 1 CPD Eligible
Chartered Accountants - Ireland (CAI) 1 CPD Eligible
CPA - Ireland 1 CPD Eligible
On Demand (video)
  • Grasp the Basics of Excel Tables.
  • Explore how to create and format tables in Excel for better data organization.
  • Master Sorting and Filtering: Attain proficiency in sorting data alphabetically, numerically, and custom sorting, as well as applying multiple filters to streamline your data view.
2 Hours
License details Credits Status
Computer Software and Applications for Certified Public Accountants (CPA-US) 2 CPE Approved
Computer Software and Applications for Chartered Professional Accountant in Canada 2 CPD Eligible
Information Technology for Certified Government Financial Manager (CGFM) 2 CPE Eligible
Computer Software and Applications for Delaware Licensed Public Accountant (DE-LPA) 2 CPE Approved
Association of Chartered Certified Accountants (ACCA) 2 CPD Eligible
Chartered Accountant - ICAEW 2 CPD Eligible
Information Technology (inc. Excel) for Certified FP&A Professional (FP&A) 2 CE Eligible
Computer Software and Applications for Iowa Licensed Public Accountant (IA-LPA) 2 CPE Approved
Computer Software and Applications for Maine Licensed Public Accountant (ME-LPA) 2 CPE Approved
Chartered Accountants - Scotland 2 CPD Eligible
Chartered Accountants - Ireland (CAI) 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 Chartered Professional Accountant in Canada 2 CPD Eligible
Information Technology for Certified Government Financial Manager (CGFM) 2 CPE Eligible
Computer Software and Applications for Delaware Licensed Public Accountant (DE-LPA) 2 CPE Approved
Association of Chartered Certified Accountants (ACCA) 2 CPD Eligible
Chartered Accountant - ICAEW 2 CPD Eligible
Information Technology (inc. Excel) for Certified FP&A Professional (FP&A) 2 CE Eligible
Computer Software and Applications for Iowa Licensed Public Accountant (IA-LPA) 2 CPE Approved
Computer Software and Applications for Maine Licensed Public Accountant (ME-LPA) 2 CPE Approved
Chartered Accountants - Scotland 2 CPD Eligible
Chartered Accountants - Ireland (CAI) 2 CPD Eligible
CPA - Ireland 2 CPD Eligible
On Demand (video)
  • Discuss key differences between Excel versions and license types. 
  • Identify features restricted by Excel table formatting. 
  • Analyze worksheet navigation techniques to boost efficiency. 
2 Hours
License details Credits Status
Computer Software and Applications for Certified Public Accountants (CPA-US) 2 CPE Approved
Computer Software and Applications for Chartered Professional Accountant in Canada 2 CPD Eligible
Information Technology for Certified Government Financial Manager (CGFM) 2 CPE Eligible
Computer Software and Applications for Delaware Licensed Public Accountant (DE-LPA) 2 CPE Approved
Association of Chartered Certified Accountants (ACCA) 2 CPD Eligible
Chartered Accountant - ICAEW 2 CPD Eligible
Information Technology (inc. Excel) for Certified FP&A Professional (FP&A) 2 CE Eligible
Computer Software and Applications for Iowa Licensed Public Accountant (IA-LPA) 2 CPE Approved
Computer Software and Applications for Maine Licensed Public Accountant (ME-LPA) 2 CPE Approved
Chartered Accountants - Scotland 2 CPD Eligible
Chartered Accountants - Ireland (CAI) 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 Chartered Professional Accountant in Canada 2 CPD Eligible
Information Technology for Certified Government Financial Manager (CGFM) 2 CPE Eligible
Computer Software and Applications for Delaware Licensed Public Accountant (DE-LPA) 2 CPE Approved
Association of Chartered Certified Accountants (ACCA) 2 CPD Eligible
Chartered Accountant - ICAEW 2 CPD Eligible
Information Technology (inc. Excel) for Certified FP&A Professional (FP&A) 2 CE Eligible
Computer Software and Applications for Iowa Licensed Public Accountant (IA-LPA) 2 CPE Approved
Computer Software and Applications for Maine Licensed Public Accountant (ME-LPA) 2 CPE Approved
Chartered Accountants - Scotland 2 CPD Eligible
Chartered Accountants - Ireland (CAI) 2 CPD Eligible
CPA - Ireland 2 CPD Eligible
On Demand (video)
  • State what FORMULATEXT returns when no formula exists.
  • Recognize which Excel versions support FILTER function.
  • Identify required arguments for IFERROR function.
2 Hours
License details Credits Status
Computer Software and Applications for Certified Public Accountants (CPA-US) 2 CPE Approved
Computer Software and Applications for Chartered Professional Accountant in Canada 2 CPD Eligible
Information Technology for Certified Government Financial Manager (CGFM) 2 CPE Eligible
Computer Software and Applications for Delaware Licensed Public Accountant (DE-LPA) 2 CPE Approved
Association of Chartered Certified Accountants (ACCA) 2 CPD Eligible
Chartered Accountant - ICAEW 2 CPD Eligible
Information Technology (inc. Excel) for Certified FP&A Professional (FP&A) 2 CE Eligible
Computer Software and Applications for Iowa Licensed Public Accountant (IA-LPA) 2 CPE Approved
Computer Software and Applications for Maine Licensed Public Accountant (ME-LPA) 2 CPE Approved
Chartered Accountants - Scotland 2 CPD Eligible
Chartered Accountants - Ireland (CAI) 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 Chartered Professional Accountant in Canada 2 CPD Eligible
Information Technology for Certified Government Financial Manager (CGFM) 2 CPE Eligible
Computer Software and Applications for Delaware Licensed Public Accountant (DE-LPA) 2 CPE Approved
Association of Chartered Certified Accountants (ACCA) 2 CPD Eligible
Chartered Accountant - ICAEW 2 CPD Eligible
Information Technology (inc. Excel) for Certified FP&A Professional (FP&A) 2 CE Eligible
Computer Software and Applications for Iowa Licensed Public Accountant (IA-LPA) 2 CPE Approved
Computer Software and Applications for Maine Licensed Public Accountant (ME-LPA) 2 CPE Approved
Chartered Accountants - Scotland 2 CPD Eligible
Chartered Accountants - Ireland (CAI) 2 CPD Eligible
CPA - Ireland 2 CPD Eligible
On Demand (video)
  • Define the INDEX function's required input arguments.
  • Identify the File menu’s document trust settings location.
  • Recall how to enable Solver in Excel Options.
2 Hours
License details Credits Status
Computer Software and Applications for Certified Public Accountants (CPA-US) 2 CPE Approved
Computer Software and Applications for Chartered Professional Accountant in Canada 2 CPD Eligible
Computer Software and Applications for Certified Fraud Examiner (CFE) 2 CPE Eligible
Information Technology for Certified Government Financial Manager (CGFM) 2 CPE Eligible
Computer technology for Maryland Tax Preparer (MRTP) (Approval No. GEHNZ-T-00966-22-S) 2 CE Approved
Computer Software and Applications for Delaware Licensed Public Accountant (DE-LPA) 2 CPE Approved
Association of Chartered Certified Accountants (ACCA) 2 CPD Eligible
Chartered Accountant - ICAEW 2 CPD Eligible
Information Technology (inc. Excel) for Certified FP&A Professional (FP&A) 2 CE Eligible
Computer Software and Applications for Iowa Licensed Public Accountant (IA-LPA) 2 CPE Approved
Computer Software and Applications for Maine Licensed Public Accountant (ME-LPA) 2 CPE Approved
Chartered Accountants - Scotland 2 CPD Eligible
Chartered Accountants - Ireland (CAI) 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 Chartered Professional Accountant in Canada 2 CPD Eligible
Computer Software and Applications for Certified Fraud Examiner (CFE) 2 CPE Eligible
Information Technology for Certified Government Financial Manager (CGFM) 2 CPE Eligible
Computer technology for Maryland Tax Preparer (MRTP) (Approval No. GEHNZ-T-00966-22-S) 2 CE Approved
Computer Software and Applications for Delaware Licensed Public Accountant (DE-LPA) 2 CPE Approved
Association of Chartered Certified Accountants (ACCA) 2 CPD Eligible
Chartered Accountant - ICAEW 2 CPD Eligible
Information Technology (inc. Excel) for Certified FP&A Professional (FP&A) 2 CE Eligible
Computer Software and Applications for Iowa Licensed Public Accountant (IA-LPA) 2 CPE Approved
Computer Software and Applications for Maine Licensed Public Accountant (ME-LPA) 2 CPE Approved
Chartered Accountants - Scotland 2 CPD Eligible
Chartered Accountants - Ireland (CAI) 2 CPD Eligible
CPA - Ireland 2 CPD Eligible
On Demand (video)
  • To recall the location of the menu command that allows you to determine categorically if a workbook contains links or not.
  • To define how to transform cell references into range names. State the location of the Enable Iterative Calculations setting within the Excel Options dialog box.
  • To implement the Watch Window to monitor the ramifications of even minor changes to your workbooks.
2 Hours
License details Credits Status
Computer Software and Applications for Certified Public Accountants (CPA-US) 2 CPE Approved
Computer Software and Applications for Chartered Professional Accountant in Canada 2 CPD Eligible
Information Technology for Certified Government Financial Manager (CGFM) 2 CPE Eligible
Computer Software and Applications for Delaware Licensed Public Accountant (DE-LPA) 2 CPE Approved
Association of Chartered Certified Accountants (ACCA) 2 CPD Eligible
Chartered Accountant - ICAEW 2 CPD Eligible
Information Technology (inc. Excel) for Certified FP&A Professional (FP&A) 2 CE Eligible
Computer Software and Applications for Iowa Licensed Public Accountant (IA-LPA) 2 CPE Approved
Computer Software and Applications for Maine Licensed Public Accountant (ME-LPA) 2 CPE Approved
Chartered Accountants - Scotland 2 CPD Eligible
Chartered Accountants - Ireland (CAI) 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 Chartered Professional Accountant in Canada 2 CPD Eligible
Information Technology for Certified Government Financial Manager (CGFM) 2 CPE Eligible
Computer Software and Applications for Delaware Licensed Public Accountant (DE-LPA) 2 CPE Approved
Association of Chartered Certified Accountants (ACCA) 2 CPD Eligible
Chartered Accountant - ICAEW 2 CPD Eligible
Information Technology (inc. Excel) for Certified FP&A Professional (FP&A) 2 CE Eligible
Computer Software and Applications for Iowa Licensed Public Accountant (IA-LPA) 2 CPE Approved
Computer Software and Applications for Maine Licensed Public Accountant (ME-LPA) 2 CPE Approved
Chartered Accountants - Scotland 2 CPD Eligible
Chartered Accountants - Ireland (CAI) 2 CPD Eligible
CPA - Ireland 2 CPD Eligible
On Demand (video)
  • Identify Excel versions offering the Inquire add-in effectively.
  • Apply legacy Track Changes for reviewing collaborative workbook edits.
  • Discuss the purpose and function of the Protect Sheet command.
1 Hour
License details Credits Status
Computer Software and Applications for Certified Public Accountants (CPA-US) 1 CPE Approved
Computer Software and Applications for Chartered Professional Accountant in Canada 1 CPD Eligible
Computer Software and Applications for Certified Fraud Examiner (CFE) 1 CPE Eligible
Information Technology for Certified Government Financial Manager (CGFM) 1 CPE Eligible
Computer technology for Maryland Tax Preparer (MRTP) (Approval No. GEHNZ-T-01259-22-S) 1 CE Approved
Computer Software and Applications for Delaware Licensed Public Accountant (DE-LPA) 1 CPE Approved
Association of Chartered Certified Accountants (ACCA) 1 CPD Eligible
Chartered Accountant - ICAEW 1 CPD Eligible
Information Technology (inc. Excel) for Certified FP&A Professional (FP&A) 1 CE Eligible
Computer Software and Applications for Iowa Licensed Public Accountant (IA-LPA) 1 CPE Approved
Computer Software and Applications for Maine Licensed Public Accountant (ME-LPA) 1 CPE Approved
Chartered Accountants - Scotland 1 CPD 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 Chartered Professional Accountant in Canada 1 CPD Eligible
Computer Software and Applications for Certified Fraud Examiner (CFE) 1 CPE Eligible
Information Technology for Certified Government Financial Manager (CGFM) 1 CPE Eligible
Computer technology for Maryland Tax Preparer (MRTP) (Approval No. GEHNZ-T-01259-22-S) 1 CE Approved
Computer Software and Applications for Delaware Licensed Public Accountant (DE-LPA) 1 CPE Approved
Association of Chartered Certified Accountants (ACCA) 1 CPD Eligible
Chartered Accountant - ICAEW 1 CPD Eligible
Information Technology (inc. Excel) for Certified FP&A Professional (FP&A) 1 CE Eligible
Computer Software and Applications for Iowa Licensed Public Accountant (IA-LPA) 1 CPE Approved
Computer Software and Applications for Maine Licensed Public Accountant (ME-LPA) 1 CPE Approved
Chartered Accountants - Scotland 1 CPD Eligible
Chartered Accountants - Ireland (CAI) 1 CPD Eligible
CPA - Ireland 1 CPD Eligible
On Demand (video)
  • To identify the button within the Scenario Manager dialog box that allows you to apply a given scenario.
  • To identify the command within the Tools menu within the Save As dialog box that enables you to password protect an Excel workbook from being opened or modified.
  • To Recall the section of the Excel Options dialog box where the AutoRecover setting resides that controls how often Excel creates a back-up copy of your workbooks.
2 Hours
License details Credits Status
Computer Software and Applications for Certified Public Accountants (CPA-US) 2 CPE Approved
Computer Software and Applications for Chartered Professional Accountant in Canada 2 CPD Eligible
Information Technology for Certified Government Financial Manager (CGFM) 2 CPE Eligible
Computer Software and Applications for Delaware Licensed Public Accountant (DE-LPA) 2 CPE Approved
Association of Chartered Certified Accountants (ACCA) 2 CPD Eligible
Chartered Accountant - ICAEW 2 CPD Eligible
Information Technology (inc. Excel) for Certified FP&A Professional (FP&A) 2 CE Eligible
Computer Software and Applications for Iowa Licensed Public Accountant (IA-LPA) 2 CPE Approved
Computer Software and Applications for Maine Licensed Public Accountant (ME-LPA) 2 CPE Approved
Chartered Accountants - Scotland 2 CPD Eligible
Chartered Accountants - Ireland (CAI) 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 Chartered Professional Accountant in Canada 2 CPD Eligible
Information Technology for Certified Government Financial Manager (CGFM) 2 CPE Eligible
Computer Software and Applications for Delaware Licensed Public Accountant (DE-LPA) 2 CPE Approved
Association of Chartered Certified Accountants (ACCA) 2 CPD Eligible
Chartered Accountant - ICAEW 2 CPD Eligible
Information Technology (inc. Excel) for Certified FP&A Professional (FP&A) 2 CE Eligible
Computer Software and Applications for Iowa Licensed Public Accountant (IA-LPA) 2 CPE Approved
Computer Software and Applications for Maine Licensed Public Accountant (ME-LPA) 2 CPE Approved
Chartered Accountants - Scotland 2 CPD Eligible
Chartered Accountants - Ireland (CAI) 2 CPD Eligible
CPA - Ireland 2 CPD Eligible
On Demand (video)
  • Analyze Excel tools used to create and manage date sequences efficiently.
  • Apply functions that convert text-based dates into usable Excel values.
  • Identify formulas used to calculate date differences and working days.
4 Hours
License details Credits Status
Computer Software and Applications for Certified Public Accountants (CPA-US) 4 CPE Approved
Computer Software and Applications for Chartered Professional Accountant in Canada 4 CPD Eligible
Computer technology for Maryland Tax Preparer (MRTP) (Approval No. GEHNZ-T-01023-22-S) 4 CE Approved
Computer Software and Applications for Delaware Licensed Public Accountant (DE-LPA) 4 CPE Approved
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 Approved
Computer Software and Applications for Maine Licensed Public Accountant (ME-LPA) 4 CPE Approved
Chartered Accountants - Scotland 4 CPD Eligible
Chartered Accountants - Ireland (CAI) 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 Chartered Professional Accountant in Canada 4 CPD Eligible
Computer technology for Maryland Tax Preparer (MRTP) (Approval No. GEHNZ-T-01023-22-S) 4 CE Approved
Computer Software and Applications for Delaware Licensed Public Accountant (DE-LPA) 4 CPE Approved
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 Approved
Computer Software and Applications for Maine Licensed Public Accountant (ME-LPA) 4 CPE Approved
Chartered Accountants - Scotland 4 CPD Eligible
Chartered Accountants - Ireland (CAI) 4 CPD Eligible
CPA - Ireland 4 CPD Eligible
On Demand (video)
  • To identify the location of the pivot table-related Subtotals command within Excel's ribbon menu interface.
  • To describe the indicator that signifies whether the columns or rows of a pivot table have been filtered.
  • To identify the location of the Field List command within Excel's ribbon menu interface.
2 Hours
License details Credits Status
Computer Software and Applications for Certified Public Accountants (CPA-US) 2 CPE Approved
Computer Software and Applications for Chartered Professional Accountant in Canada 2 CPD Eligible
Computer Software and Applications for Chartered Global Management Accountants (CGMA) 2 CPE Eligible
Information Technology for Certified Government Financial Manager (CGFM) 2 CPE Eligible
Computer Software and Applications for Delaware Licensed Public Accountant (DE-LPA) 2 CPE Approved
Association of Chartered Certified Accountants (ACCA) 2 CPD Eligible
Chartered Accountant - ICAEW 2 CPD Eligible
Information Technology (inc. Excel) for Certified FP&A Professional (FP&A) 2 CE Eligible
Computer Software and Applications for Iowa Licensed Public Accountant (IA-LPA) 2 CPE Approved
Computer Software and Applications for Maine Licensed Public Accountant (ME-LPA) 2 CPE Approved
Chartered Accountants - Scotland 2 CPD Eligible
Chartered Accountants - Ireland (CAI) 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 Chartered Professional Accountant in Canada 2 CPD Eligible
Computer Software and Applications for Chartered Global Management Accountants (CGMA) 2 CPE Eligible
Information Technology for Certified Government Financial Manager (CGFM) 2 CPE Eligible
Computer Software and Applications for Delaware Licensed Public Accountant (DE-LPA) 2 CPE Approved
Association of Chartered Certified Accountants (ACCA) 2 CPD Eligible
Chartered Accountant - ICAEW 2 CPD Eligible
Information Technology (inc. Excel) for Certified FP&A Professional (FP&A) 2 CE Eligible
Computer Software and Applications for Iowa Licensed Public Accountant (IA-LPA) 2 CPE Approved
Computer Software and Applications for Maine Licensed Public Accountant (ME-LPA) 2 CPE Approved
Chartered Accountants - Scotland 2 CPD Eligible
Chartered Accountants - Ireland (CAI) 2 CPD Eligible
CPA - Ireland 2 CPD Eligible
On Demand (video)
  • Discuss the benefits of creating reusable Excel templates. 
  • Identify steps to build a custom waterfall chart. 
  • Analyze data visually using conditional formatting features. 
2 Hours
License details Credits Status
Computer Software and Applications for Certified Public Accountants (CPA-US) 2 CPE Approved
Computer Software and Applications for Chartered Professional Accountant in Canada 2 CPD Eligible
Computer Software and Applications for Certified Fraud Examiner (CFE) 2 CPE Eligible
Information Technology for Certified Government Financial Manager (CGFM) 2 CPE Eligible
Computer Software and Applications for Delaware Licensed Public Accountant (DE-LPA) 2 CPE Approved
Association of Chartered Certified Accountants (ACCA) 2 CPD Eligible
Chartered Accountant - ICAEW 2 CPD Eligible
Information Technology (inc. Excel) for Certified FP&A Professional (FP&A) 2 CE Eligible
Computer Software and Applications for Iowa Licensed Public Accountant (IA-LPA) 2 CPE Approved
Computer Software and Applications for Maine Licensed Public Accountant (ME-LPA) 2 CPE Approved
Chartered Accountants - Scotland 2 CPD Eligible
Chartered Accountants - Ireland (CAI) 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 Chartered Professional Accountant in Canada 2 CPD Eligible
Computer Software and Applications for Certified Fraud Examiner (CFE) 2 CPE Eligible
Information Technology for Certified Government Financial Manager (CGFM) 2 CPE Eligible
Computer Software and Applications for Delaware Licensed Public Accountant (DE-LPA) 2 CPE Approved
Association of Chartered Certified Accountants (ACCA) 2 CPD Eligible
Chartered Accountant - ICAEW 2 CPD Eligible
Information Technology (inc. Excel) for Certified FP&A Professional (FP&A) 2 CE Eligible
Computer Software and Applications for Iowa Licensed Public Accountant (IA-LPA) 2 CPE Approved
Computer Software and Applications for Maine Licensed Public Accountant (ME-LPA) 2 CPE Approved
Chartered Accountants - Scotland 2 CPD Eligible
Chartered Accountants - Ireland (CAI) 2 CPD Eligible
CPA - Ireland 2 CPD Eligible
On Demand (video)
  • To analyze the concept of waterfall calculations.
  • To recall the keyboard shortcut that enables you to transfer the contents of a cell across a row of adjacent cells that you’ve selected.
  • To explain which keyboard shortcut allows you to toggle the Bold settings for a cell or selection of text on or off.
1 Hour
License details Credits Status
Accounting for Certified Public Accountants (CPA-US) 1 CPE Approved
Chartered Professional Accountant in Canada 1 CPD Eligible
Accounting for Delaware Licensed Public Accountant (DE-LPA) 1 CPE Approved
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 Approved
Accounting for Maine Licensed Public Accountant (ME-LPA) 1 CPE Approved
Chartered Accountants - Scotland 1 CPD Eligible
Chartered Accountants - Ireland (CAI) 1 CPD Eligible
CPA - Ireland 1 CPD Eligible
License details Credits Status
Accounting for Certified Public Accountants (CPA-US) 1 CPE Approved
Chartered Professional Accountant in Canada 1 CPD Eligible
Accounting for Delaware Licensed Public Accountant (DE-LPA) 1 CPE Approved
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 Approved
Accounting for Maine Licensed Public Accountant (ME-LPA) 1 CPE Approved
Chartered Accountants - Scotland 1 CPD Eligible
Chartered Accountants - Ireland (CAI) 1 CPD Eligible
CPA - Ireland 1 CPD Eligible
On Demand (video)
  • Identify and differentiate between the four main depreciation methods.
  • Apply proper procedures to calculate depreciation using each method.
  • Utilize Excel templates effectively for implementing depreciation calculations.
2 Hours
License details Credits Status
Computer Software and Applications for Certified Public Accountants (CPA-US) 2 CPE Approved
Computer Software and Applications for Chartered Professional Accountant in Canada 2 CPD Eligible
Information Technology for Certified Government Financial Manager (CGFM) 2 CPE Eligible
Computer Software and Applications for Delaware Licensed Public Accountant (DE-LPA) 2 CPE Approved
Association of Chartered Certified Accountants (ACCA) 2 CPD Eligible
Chartered Accountant - ICAEW 2 CPD Eligible
Information Technology (inc. Excel) for Certified FP&A Professional (FP&A) 2 CE Eligible
Computer Software and Applications for Iowa Licensed Public Accountant (IA-LPA) 2 CPE Approved
Computer Software and Applications for Maine Licensed Public Accountant (ME-LPA) 2 CPE Approved
Chartered Accountants - Scotland 2 CPD Eligible
Chartered Accountants - Ireland (CAI) 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 Chartered Professional Accountant in Canada 2 CPD Eligible
Information Technology for Certified Government Financial Manager (CGFM) 2 CPE Eligible
Computer Software and Applications for Delaware Licensed Public Accountant (DE-LPA) 2 CPE Approved
Association of Chartered Certified Accountants (ACCA) 2 CPD Eligible
Chartered Accountant - ICAEW 2 CPD Eligible
Information Technology (inc. Excel) for Certified FP&A Professional (FP&A) 2 CE Eligible
Computer Software and Applications for Iowa Licensed Public Accountant (IA-LPA) 2 CPE Approved
Computer Software and Applications for Maine Licensed Public Accountant (ME-LPA) 2 CPE Approved
Chartered Accountants - Scotland 2 CPD Eligible
Chartered Accountants - Ireland (CAI) 2 CPD Eligible
CPA - Ireland 2 CPD Eligible
On Demand (video)
  • Analyze how Power Query extracts and structures external data efficiently.
  • Apply lookup and decision tools to streamline operational spreadsheet analysis.
  • Evaluate trends using PivotTables, PivotCharts, Slicers, and forecasting tools.
1 Hour
License details Credits Status
Computer Software and Applications for Certified Public Accountants (CPA-US) 1 CPE Approved
Computer Software and Applications for Chartered Professional Accountant in Canada 1 CPD Eligible
Computer Software and Applications for Certified Fraud Examiner (CFE) 1 CPE Eligible
Information Technology for Certified Government Financial Manager (CGFM) 1 CPE Eligible
Software and other process controls for Certified Information Technology Professionals (CITP) 1 CPD Eligible
Computer Software and Applications for Delaware Licensed Public Accountant (DE-LPA) 1 CPE Approved
Association of Chartered Certified Accountants (ACCA) 1 CPD Eligible
Chartered Accountant - ICAEW 1 CPD Eligible
Information Technology (inc. Excel) for Certified FP&A Professional (FP&A) 1 CE Eligible
Computer Software and Applications for Iowa Licensed Public Accountant (IA-LPA) 1 CPE Approved
Computer Software and Applications for Maine Licensed Public Accountant (ME-LPA) 1 CPE Approved
Chartered Accountants - Scotland 1 CPD 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 Chartered Professional Accountant in Canada 1 CPD Eligible
Computer Software and Applications for Certified Fraud Examiner (CFE) 1 CPE Eligible
Information Technology for Certified Government Financial Manager (CGFM) 1 CPE Eligible
Software and other process controls for Certified Information Technology Professionals (CITP) 1 CPD Eligible
Computer Software and Applications for Delaware Licensed Public Accountant (DE-LPA) 1 CPE Approved
Association of Chartered Certified Accountants (ACCA) 1 CPD Eligible
Chartered Accountant - ICAEW 1 CPD Eligible
Information Technology (inc. Excel) for Certified FP&A Professional (FP&A) 1 CE Eligible
Computer Software and Applications for Iowa Licensed Public Accountant (IA-LPA) 1 CPE Approved
Computer Software and Applications for Maine Licensed Public Accountant (ME-LPA) 1 CPE Approved
Chartered Accountants - Scotland 1 CPD Eligible
Chartered Accountants - Ireland (CAI) 1 CPD Eligible
CPA - Ireland 1 CPD Eligible
On Demand (video)
  • Analyze how Copilot integrates with Excel and ensure system compatibility.
  • Review how Copilot automates routine tasks to improve efficiency and save time.
  • Apply AI-powered Copilot features to enhance data accuracy and reliability.

* 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

David Ringstrom -CE/CPE Courses for Accountant, CPAs & more

David Ringstrom

President, EXCEL Accountant

David H. Ringstrom, CPA, is a nationally recognized Microsoft Excel expert and founder of Accounting Advisors, Inc., established in 1991 in Atlanta, Georgia. With over 30 years of experience, he specializes in spreadsheet consulting and training for accounting professionals, empowering users to master Excel and streamline workflows. David has delivered more than 2,500 live webinars and authored popular books such as Microsoft 365 Excel for Dummies, Exploring Microsoft Excel’s Hidden Treasures, QuickBooks Online for Dummies, and Idiot's Guide to Introductory Accounting. His mantra is, "Either you work Excel, or it works you."


He also serves as Lead Instructor at Students Excel, developing video-based Excel training for college students that bridges academic concepts with practical applications. David holds a Bachelor of Business Administration in Accounting from Georgia State University and certifications as a CPA and Microsoft Office Specialist in Excel. His expertise extends to advanced Excel functions, PivotTables, macros, accounting software, financial analysis, public speaking, and technical writing. His mission is to provide practical, real-world solutions to enhance efficiency and accuracy in financial tasks nationwide.

More...
Eric Knight

Eric Knight

Accounting Hound

Dr. Knight's journey in the world of numbers began with a Bachelor’s degree in Accounting from LSU, followed by a Master of Science in Accountancy from the University of North Texas. His career took off at Deloitte and Touche, LLP, one of the prestigious Big Four accounting firms, where he not only honed his skills but also completed the CPA requirements. 

With 15 years under his belt in the realms of accounting and financial analysis, Dr. Knight has mastered diverse areas including tax, financial reporting, financial analysis, and business management. His wealth of experience is matched by his passion for education. 

In 2015, he achieved a Doctorate of Business Administration (DBA) and transitioned into academia. Today, he inspires the next generation of accountants and business professionals through his engaging courses at various colleges and universities. 

Dr. Knight also conducts impactful training seminars and runs Accounting Hound, a website dedicated to accounting education. An accomplished author, he has published several journal articles and a book on basic accounting principles. Dr. Knight’s dynamic teaching style and extensive expertise make him a sought-after educator in the field of accounting and finance.

More...
Mike Thomas

Mike Thomas

Owner, The Excel Trainer

In a career spanning 30+ years, Mike Thomas, a UK-based IT Trainer, has delivered thousands of courses and produced hundreds of written and video-based tutorials. 

He is a subject matter expert in a range of technologies, his primary focus and passion being Microsoft Office (especially Excel) on both the Windows and Mac platforms and Power BI. 

Mike is a Fellow of The Learning and Performance Institute and has worked with and for many global and UK-based companies and organizations across a diverse range of industries including healthcare, pharmaceutical and public sector.

In addition to training, he also designs and develops Microsoft Office-based solutions that automate key business tasks and processes.

More...

Trusted by Professionals. Designed for Your Success

  • Learn from top thought leaders delivering real-world insights.
  • Programs designed to strengthen core skills.
  • Earn credits and meet regulatory requirements.
  • Stay ahead with continuously refreshed content.
All Practical Training Programs Available Only in Teams Premium Plan
certificate
certificate
certificate

Unlock Annual Access to News & CPE Subscription

Your All-in-One CPE Learning Platform

$199/Year

Silver
Select

$299/Year

Gold
Selected
All Features Included In Your Plan

15,000+ Hrs of Content

500+ Subject Areas

Mandatory Ethics Courses

250+ Compliance Packages

50+ Conferences and Events Access

Formats: Live, Audio, Video, E-Books

Audio Based Courses & Podcasts

Latest News and Articles (CPE Approved)

Monthly and Quarterly Updates

Add External Certificates with Al

Al Compliance Tracking and Report

Instant Certification and Fast Reporting

Mobile App Access (iOS and Android)

Dedicated Support System

Practical Triaining Programs

Al Academy Access

Get Started Today

card

Payment failed. Your card has expired, please update your card details

Your information is securely encrypted using SSL

Frequently Asked Questions

This program covers practical intermediate Microsoft Excel skills, including structured tables, pivot tables, spreadsheet auditing, audit trails, financial reporting, waterfall calculations, depreciation templates, date and time functions, Microsoft Copilot integration, spreadsheet controls, and operational analysis techniques.

This program helps professionals strengthen intermediate Excel skills, improve spreadsheet accuracy, streamline reporting processes, reduce manual work, and use Excel more effectively for business analysis and financial reporting. It provides practical techniques that can be applied immediately to everyday professional tasks.

The Practical Training Programs is created by qualified and experienced instructors. MYCPE ONE’s Practical Training Programs includes self-study courses, most of which are delivered as on-demand videos. These self-study video courses may be recordings of live presentations converted into on-demand format.

You can complete the Programs at your own pace. There is no limit on the number of exam attempts, so if you do not pass on the first attempt, you may retake the exam without any restrictions.

After completing each Programs within this Practical Training Programs , you can download a certificate showing the course title and number of hours completed. Certificates and study records are stored for life and can be accessed at any time. These certificates serve as valid proof of continuing education credits and may also be used as an additional designation.

Once registered, you will have full access to all courses included in the Practical Training Programs . The self-study format allows you to access materials online 24/7 and study at your own pace.

As per NASBA guidelines, you have one year from the date of purchase to complete each self-study course. After completing the course, you may take the final exam at any time and receive CPE credit instantly. The exam can be retaken multiple times at no additional cost.

Each Programs requires a minimum passing score of 70% on the final exam. Multiple attempts are allowed.

Our video player tracks and stores your watch time, which is displayed in the progress bar. Do not fast forward or manually move the progress bar, as the system will not capture your watch time if you do so. You may pause and resume the video at any time, and playback will continue from where you left off.
To complete a self-study course, you must:
1. Watch the entire video (100% completion).
2. Answer all review questions correctly. Review questions are located at the bottom of the same page as the video.
3. Once the video and review questions are completed, the Final Quiz will unlock. You must score at least 70% to earn CPE credit. Multiple attempts are allowed.
4. After completing the Review and Final Quiz, you can download your certificate from the “My Certificates” section. Ensure that multiple file downloads are enabled in your browser.
5. Certificates can be downloaded individually from your account or as a consolidated certificate from the package page.


A self-study course is a recorded video. If the course is a recording of a live session, polling questions may appear on the screen. You do not need to answer these polling questions. Do not fast forward the video, as doing so may prevent the system from tracking your watch time, requiring you to rewatch the video.
To unlock the final quiz, you must complete the entire video and answer all review questions correctly. Once unlocked, you must score at least 70% on the final quiz to qualify for credit. Multiple attempts are allowed for both review and final quiz questions.
If the issue persists, please email support@my-cpe.com or contact our support team via live chat.

The evaluation form is sent within 24 hours after you pass the final quiz with a minimum score of 70%. The evaluation form is available only to attendees who remained logged in until the end of the course and answered all polling questions.

MY-CPE LLC is PCI-compliant. MYCPE ONE uses Stripe, a secure payment gateway that meets PCI-DSS compliance standards, ensuring all payment details are protected through SSL encryption. Once you have registered for a package and completed payment, refunds are not provided unless you are unable to access the courses.