CPE Catalog & Events
Mastering the Excel Lookup Functions
-
TBD
0.0 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
Finance and Innovation: Reinvent Your Department and Company 26-27
-
TBD
8.0 Credits
Member Price: $329
How innovation happens Innovation metrics and how to report on innovation efforts How the use of technology and other simple techniques can foster and sustain innovation
Preparation, Compilations and Reviews—A Practical Workshop 26-27
-
TBD
8.0 Credits
Member Price: $329
Preparation Compilations Reviews
Strategy, Risk and Finance: Why We Do What We Do 26-27
-
TBD
8.0 Credits
Member Price: $329
Why do most strategic plans fail" Why so many formerly strong organizations have failed Why most organizations have a poor strategic plan and how to correct this The many risks that must be addressed: Financial risk, execution risk, commercial, business, and strategic risks as well as commonly overlooked risks How Behavioral Economics will help address the risk
Introduction to Ethics & Professional Skepticism
-
TBD
2.0 Credits
Member Price: $89
The major topics that will be covered in this course include:The Code of Ethics for Professional Accountants.The pressures, opportunities, and rationalizations that lead to instances of fraud. Interactive examples to illustrate various scenarios of noncompliance during engagements.
ACPEN: Preparing to be a Forensic Accountant - Focus on Computer Forensics - Part 2 (Cryptology)
-
TBD
1.0 Credits
Member Price: $39
Forensic Accounting Accounting Finance Auditing
Ethics, AI, and Music: What Every CPA Must Know
-
TBD
1.0 Credits
Member Price: $55
The major topics that will be covered in this course include: Four key aspects of artificial intelligence that are relevant to CPAs: machine learning, generative AI, large language models, and GPT.The role that five powerful principles—the principles of ethical intelligence—play in using AI the right way. Short, focused writing exercises (30 seconds each) designed to deepen understanding of the topic. Real-world case studies about the use of AI in music as well as accountingAnswers to several crucial questions about how to use artificial intelligence with ethical intelligence.
ACPEN: Relationship Networking: The Art Of Conversation
-
TBD
1.0 Credits
Member Price: $39
Networking Replatinship Management
ACPEN: It Is Legal, But Is It Really Ethical?, featuring Rob Berry and Bob Mims
-
TBD
1.0 Credits
Member Price: $39
Is ‘legal’ the same as ‘ethical’? Why or why not? The value of using the Code of Professional Conduct properly. Resolving situations where the two are divergent.
ACPEN: Maintaining a Harmonious Working Environment
-
TBD
1.0 Credits
Member Price: $39
Disassociating yourself and your employer from discriminatory comments Scripts for addressing potential and actual sexual harassment situations Consensual relationships between leaders and their subordinates Effective violence prevention measure Survival tactics in active violence situations
ACPEN: Coaching Leaders to Handle Sensitive Employee Relations Situations
-
TBD
1.2 Credits
Member Price: $39
Employee complaints Personality & attitude problems Performance counseling Personal hygiene problems Disability-related performance issues Misconduct due to mental conditions
ACPEN: The Controllership Series: The Controllers Role in Internal Controls
-
TBD
1.5 Credits
Member Price: $79
Accounting Finance Internal Controls
ACPEN: The Controllership Series: The Controller's Role in Debt Management
-
TBD
1.5 Credits
Member Price: $79
Accounting Treasury Finance
ACPEN: Yellow Book Ethics
-
TBD
2.0 Credits
Member Price: $89
Ethics Accounting & Auditing Yellowbook
ACPEN: IFRS vs. US GAAP - Major Accounting Differences
-
TBD
2.0 Credits
Member Price: $89
Explore major differences in the design and structure of IFRS vs. U.S. GAAP Discover significant differences in financial statement presentation and disclosure principles, including: Periods required to be reported Interim financial reporting Debt classification, and more Recognize significant differences in initial recognition and subsequent measurement standards, including: Consolidation Equity method investments
ACPEN: K2’s Eight Awesome PivotTable Features
-
TBD
2.0 Credits
Member Price: $89
Adding user-defined calculations to PivotTables Enhancing PivotTables with Key Performance Indicators Using PivotTables to consolidate "standard" Excel reports Creative ways to filter PivotTables Linking accounting software data into PivotTables
ACPEN: Failure to Detect Fraud and the Reasons Why
-
TBD
2.0 Credits
Member Price: $89
Fraud Detection Challenges Fraud Characteristics Fraud Indicators Audit Responsibilities Fraud Risk Recognition Responding to Suspected Fraud
ACPEN: Real World Business Ethics Scenarios
-
TBD
2.0 Credits
Member Price: $85
The Angry Boss Financial Close Dilemma Petty Cash Fund Management Incentives I Need My Job
Google Gemini AI for Accountants
-
TBD
0.0 Credits
Member Price: $89
The major topics that will be covered in this course include:Google Gemini Quick StartGemini Standalone ChatbotMobile AppGemini integration with:WorkspaceGmailDocsSheetsSlidesUser Tips
ACPEN: Fiduciary Accounting for Estates and Trusts
-
TBD
4.0 Credits
Member Price: $149
10 Principles of Tax Accounting for Trust Income Entity accounting income and Form 1041 Uniform Principal and Income Act Discretionary Power to Adjust Allocations between principal and income Trust accounting issues