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
ACPEN: Making Effective Decisions When You Can’t Get Everything You Want
-
TBD
2.0 Credits
Member Price: $89
Decision-making fundamentals Cost-volume-profit refresher Optimization analysis Constraint mitigation strategies Coping with incomplete information Solver and other Excel capabilities Qualitative considerations
Securing Your Data with a Password Management App - Updated
-
TBD
0.0 Credits
Member Price: $89
The major topics covered in this course include:Introduction to the world of password management apps and what makes them so secureReview and demonstration of top selling password management appsSoftware features that will be reviewedPassword generationEmergency user accessEntity vs. individual password managementDesktop vs. cloud basedMulti device synchronizationPII (personally identifiable information) forms fillerCredit card storageDigital data vault
ACPEN: Taxation of Business Entities
-
TBD
2.5 Credits
Member Price: $99
Types of business entities (Sole proprietorship, Partnership, Corporation, Limited Liability Company and Limited Liability Partnership) Considerations in choosing a business entity, including taxes, limited liability protection, management & control, funding options & opportunities, tax consequences for the owners and the business. Future tax considerations that will impact various business entities.
ACPEN: Leading for Well-Being: Building Resilient Teams & Thriving Workplaces
-
TBD
3.5 Credits
Member Price: $129
The Importance of Mental Wellness in Leadership Recognizing and Preventing Burnout Building and Sustaining Resilient Teams Leading by Example: Self-Care and Continuous Growth
Firm Ethics—A Practical Approach 26-27
-
TBD
4.0 Credits
Member Price: $175
AICPA Code of Professional Conduct Ethics requirements for CPA firms
ACPEN: Shorten Month-End - Closing Best Practices
-
TBD
4.0 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
Comprehensive Passive Activity Losses (PAL) 26-27
-
TBD
8.0 Credits
Member Price: $329
Overview of the four loss limitation rules and how the PAL rules interact with the other limitations Definition of a PAL including a detailed review of the 7 determining factors contained in the Treasury Regulations with a review of several recent court decisions that interpret this regulation Impact of PAL rules on real estate ownership Learn the six Nonshelterable Passive Activity (NOPA) rules that act as anti-abuse rules to the PAL rules Discuss how the PAL rules impact tax credits Discuss tax elections and planning techniques associated with PALs
GAAP Update 26-27
-
TBD
8.0 Credits
Member Price: $329
Equity method investments and joint ventures Changes in U.S. GAAP financial statement presentation and disclosure requirements Accounting and disclosure for crypto assets Various other Accounting Standards Updates (ASUs) issued during 2023 through 2026 FASB Technical Projects and Agenda, including recently exposed Proposed ASUs
Tax Planning for Sole Proprietors & Other Business Owners 26-27
-
TBD
8.0 Credits
Member Price: $329
An overview of the business-related tax changes in the One Big Beautiful Bill Using the independent contractor rules and hobby loss rules to ensure the activity is a trade or business Reviewing Schedule C deductions for travel, meals, transportation, employee fringe benefits, costs of goods sold, depreciation, and home offices Maximizing the benefits from 1040 deductions for Keogh plans, Solo 401(k)s, Simplified Employee Pension (SEP) plans, and SIMPLE plans Taking advantage of the self-employed health insurance deduction and the qualified business income (QBI) deduction Avoiding the at-risk and passive activity loss limitations Making the right business entity election In-depth coverage of what advisers of sole proprietors and single-member limited-liability-company owners need to know
Entertainment, Meals & Travel Expenses: Review and Update
-
TBD
2.0 Credits
Member Price: $89
The major topics that will be covered in this class include:Definition of what qualifies as an entertainment expenseStrategies to deduct business entertainment expensesDeductibility of mealsSituations not subject to the 50% meals and entertainment reductionHow to handle automobile issues related to employer-provided parkingProper accounting for deductible vs. non-deductible expendituresThe four steps to analyze business expensesThe latest federal legislation, cases and rulings
ACPEN: The Single Audit from Beginning to End Update
-
TBD
4.0 Credits
Member Price: $250
Introduction Applicable AICPA standards Applicable OMB Circular Gathering information - determining the major programs Identifying risk – identifying the applicable compliance requirements Assessing risk – considering the internal controls over compliance requirements Designing procedures that are responsive to assessed risks – the tests of internal controls and compliance Evaluating single audit evidence
Internal Controls Over Compliance vs Compliance
-
TBD
0.0 Credits
Member Price: $55
The major topics that will be covered in this course include:Testing internal ControlsAlign internal controls with specific compliance requirementsThe misidentification of controls and the confusion between compliance and control processes
ACPEN: Ethics Aren't for the Byrdes in Ozark
-
TBD
1.0 Credits
Member Price: $39
Ethical business behavior Ethical business decisions Ethical management decisions Ethical decisions in human resource management
ACPEN: Global Internal Audit Standards (GIAS) Domain V - Part 2
-
TBD
1.0 Credits
Member Price: $89
Internal audit Standards Institute of Internal Auditors GIAS IPPF
ACPEN: K2’s CRM – The Ultimate Business Automation Tool
-
TBD
2.0 Credits
Member Price: $89
Overview of CRM functionalities tailored to accounting, including customizations and integrations Integrated tools that leverage CRM data for automating tasks and improving efficiency Strategies for successfully adopting a CRM platform and solutions to overcome common challenges
ACPEN: Excelling at Excel: Tips, Tricks and Updates
-
TBD
2.0 Credits
Member Price: $89
Excel version differences and compatibility Customize Excel so it works the way you work Learn new shortcuts to work quicker Learn some of the newer formulas to streamline your spreadsheets Take on tables & a powerful tool for data analysis
ACPEN: Big Picture Mega-Trends, Big Data, and World We Now Face
-
TBD
2.0 Credits
Member Price: $89
On-going world economic trends Demographic changes and their impact on the economy Global technology influences Post Covid workplace Big data understanding and where is it going Learn to adapt to changing situations
ACPEN: Execute Your Strategy: Turn Planning into Results or Destroy it and Start Over…Again
-
TBD
2.0 Credits
Member Price: $89
The strategy-execution gap: common reasons why most strategic plans fail Why should financial planning lead strategy? Evaluating the lifespan and relevance of your strategic plan Building your strategy to include risk management Building an adaptive, finance-focused strategic approach What we should learn from the rise and fall of major companies How to align financial metrics with strategy
ACPEN: Independence Requirements for Auditors
-
TBD
2.0 Credits
Member Price: $89
AICPA Code of Professional Conduct independence requirements Core independence principles for CPAs in public practice Common independence risk areas PEEC ethics interpretations affecting independence Real-world application of independence guidance Practical compliance and implementation strategies Independence considerations in attest engagements