CPE Catalog & Events
Mastering the Excel Lookup Functions
-
Webinar
2.00 Credits
Member Price: $89
The major topics that will be covered in this class include:A review of the various lookup functions, beyond VLOOKUPLearn which lookup works best for your situationHow to apply the many lookup functionsDiscover advanced lookup techniques like nested lookups, approximate matching, and handling errors effectivelyAn in-depth review of the following functions:VLOOKUP / HLOOKUPXLOOKUPMATCH / INDEXXMATCHINDIRECTFILTERSORT / SORTBYUNIQUEAn overview of some newer functions
ACPEN: Triple Your Memory, Prevent Dementia and Halve Your Stress - Part 1
-
Webinar
4.00 Credits
Member Price: $149
Why the brain can remember some things a hundred times better than others Why we typically forget names and faces, and what can be done about it How our emotions follow the motion of our body, and how that can be used to instill instant confidence How to tap into a completely relaxed and/or confident state of mind in 10 seconds or less using advanced hypnotic conditioning and Neuro-Linguistic Programming techniques How to prevent dementia and brain “fog” using specific supplements and exercise How to stay motivated to use the methods outlined in this course to advance your career and achieve a higher quality of life How to use the concept of constant learning to help you maintain a balanced and fulfilling
ACPEN: Federal Tax Update for Individuals with Doug Van Der Aa
-
Webinar
4.00 Credits
Member Price: $149
"Tax-mageddon" - the all-important impending expiration/extension/renewal of the TCJA Recent legislative, judicial, and IRS developments impacting individual taxpayers 2025 Tax rates and inflation-adjusted figures Cryptocurrency reporting and new Form 1099-DA Form 1099-K and previously unreported income Review of significant changes in individual tax forms Recent federal tax legislation, cases and rulings affecting income of individual taxpayers
ACPEN: Preparing and Reviewing Workpapers for Higher Quality Audits
-
Webinar
4.00 Credits
Member Price: $149
The primary purpose of workpaper documentation, and minimum documentation requirements for workpaper preparers Best practices for documenting complex and subjective procedures and conclusions, such as estimates, substantive analytic procedures, etc. that impact the nature and extent of audit documentation needed to support audit conclusions Discussing the financial statement audit risk concept, including how proper application better ensures a higher quality audit Tips for an efficient workpaper review process that complies with relevant standards
ChatGPT for Accountants: 50+ Use Cases
-
Webinar
2.00 Credits
Member Price: $89
Major topics covered in this course include:Introduction to ChatGPT and artificial intelligence chatbot technologiesAutomating frequently asked questions and the onboarding processVerifying and reviewing financial recordsProviding real-time support to clientsGenerating financial reportsAutomating tax return preparation and financial planningProviding guidance on financial decision making
ACPEN: Wired Differently - An Introduction to Neurodivergence
-
Webinar
1.00 Credits
Member Price: $39
Neurodivergence Diversity Inclusion
ACPEN: Stand Out - How to Create a Unique Employer Brand
-
Webinar
1.00 Credits
Member Price: $39
Employer Brand Talent Management Future of Work Onboarding New Hires
CPA to CFO: Essential Competencies for Finance Leaders
-
Webinar
1.00 Credits
Member Price: $55
To purchase the report referenced in this presentation, or any of the research papers published by CPA Crossings, visit https://www.cpacrossings.com/research. The major topics that will be covered in this course include: Top competencies hiring executives seek in CFO candidates based on survey of 320+ CEOs and recruiters Critical thinking frameworks and strategy creation techniques for financial leadership Forward-looking financial skills including capital management, forecasting, and funding strategies Industry-specific requirements for high-growth companies and nonprofit organizations Practical career development strategies to build CFO-ready competencies
ACPEN: Unleashing Creativity in the Workplace
-
Webinar
1.00 Credits
Member Price: $39
The Power of Creativity in the Workplace The Three Types of Creativity: Imagination, Creativity, Innovation Benefits of Creativity: Purpose, Productivity, Performance Applications of Creativity: Individual, Team, Organizational Culture Creative Problem-Solving Techniques (Mind Mapping, Visual Thinking) Whole Brain Thinking: Integrating Left & Right Brain Functions Creating a Culture of Innovation Measuring and Implementing Creativity for Growth
ACPEN: Emerging Risks and Resilience - How Accountants and Finance Professionals are Leading the Way - Part 1 Building Organizational Resilie
-
Webinar
1.40 Credits
Member Price: $39
Risks Accounting Finance Economy Information Technology Data Governance
Risk Assessment Under SAS No. 145
-
Webinar
2.00 Credits
Member Price: $89
Risk assessment under SAS No. 145 Overview of the steps to perform during risk assessment Testing the design, implementation, and operating effectiveness of controls New concepts due to the issuance of SAS No. 145
Surgent's Workplace Harassment: How to Prevent Harassment and Reduce Liability Risks in Today’s Changing Environment
-
Webinar
2.00 Credits
Member Price: $99
An overview of workplace harassment and discrimination laws, including the intangible benefits that come with compliance An overview of sexual harassment and workplace retaliation The supervisor’s (or manager’s) role in preventing harassment and in reducing the company’s potential liability through good faith efforts at compliance Review a compliant procedure for handling harassment concerns
ACPEN: Guide to Preparing Form 1041 for Estates and Trusts
-
Webinar
4.00 Credits
Member Price: $149
Current rates and brackets Calculating a trust's AGI Filing requirements, deadlines and penalties 3.8% Medicare surtax on net investment income (NII) Simple vs. complex trusts Grantor Trusts: Four options to report activity Section 643 (g) Election Taxable income of trusts, estate and beneficiaries
ACPEN: Shorten Month-End - Closing Best Practices
-
Webinar
4.00 Credits
Member Price: $149
Trends in financial statement closings including the Quick Close, Soft Close and Virtual Close Review and discuss information systems headaches that slow you down Work through examples of close cycle "time killers" and how to resolve them Get inventory and cost of sales under control Identify the improvement projects that will yield the biggest benefit
Create Measures in Power BI that Define Your Metrics
-
Webinar
4.00 Credits
Member Price: $149
The major topics that will be covered in this class include:Introduction to DAX: Understanding the fundamentals of DAX and its role in Power BI.Advanced DAX Formulas: Delving into complex DAX functions and formulas for creating sophisticated measures.Time Intelligence in DAX: Exploring time-based functions to analyze data over different periods.Validating Measures with DAX: Techniques for ensuring accuracy and reliability in your DAX measures.Using PivotTables for Measure Validation: Employing PivotTables in Power BI to test and confirm the effectiveness of DAX measures.
Fraud & Embezzlement: Case Studies from the Trenches
-
Webinar
2.00 Credits
Member Price: $89
The major topics that will be covered in this class include:How organizations can find themselves defrauded due to lax oversight and weak internal controls.How the existence of the "trusted advisor" creates situations where CPAs can drop their professional skepticism.Illustrations of the issues companies should look for in preventing fraud and embezzlement.
Operations Level Internal Control
-
Webinar
4.00 Credits
Member Price: $149
The major topics covered in this course include:An overview of controls that drive proceduresConsiderations for procedural control developmentUnderstanding and controlling risk that arises when organizations change
ACPEN: Supervised AI Agents as Public CPA Audit Team Members
-
Webinar
1.00 Credits
Member Price: $39
Independent execution: AI agents can perform control testing and analyze evidence across multiple formats. Audit-ready outputs: Deliver high-quality results with speed, accuracy, and consistency. Workflow integration: See how agents fit seamlessly into existing audit engagement processes. Guardrails and governance: Learn the safeguards and governance needed to ensure reliability. Human supervision: Explore the critical role of training data and oversight in producing trustworthy results. Practical applications: Real-world examples of firms already deploying supervised AI agents in audits. Augmentation, not replacement: Understand how AI can support, rather than substitute, on audit teams.
ACPEN: A New Productivity for the New World. Goal Achievement for the 21st Century, A Whole Brain Approach
-
Webinar
1.00 Credits
Member Price: $39
Mindfulness Creative Thinking Productivity Performance Neuroscience Leadership
ACPEN: Emerging Risks and Resilience - How Accountants and Finance are Leading the Way - Part 2 Technology Disruption, Artificial Intelligence an
-
Webinar
1.60 Credits
Member Price: $79
Artificial Intelligence Emerging Risks for Acccountants and Finance Cybersecurity Risks