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: The Art of Marketing for CPAs
-
Webinar
4.00 Credits
Member Price: $149
Why marketing and self promotion are so important today What keeps people from learning this skill, and how to overcome those obstacles How to get people (your boss, co-workers or clients) to like working with you How to sell someone on your services in a single minute How to attract more clients or the attention of your boss in a way that "wows" them How to get referrals from your clients or glowing reviews from your boss The 3 communication skills every business person needs to master, and why The 3 principles that really lead to more success in the business world, and how you can use those principles for you company and career
Exercise Your Ethics: Techniques to Improve Ethical Response
-
Webinar
2.00 Credits
Member Price: $89
The major topics that will be covered in this course include:Explore research for common answers to "what does ethics mean to you?" and examine whether those are valid.Identify common ethical barriers - reflecting the latest from the ACFE Report to the Nations.Discover ways to improve ethical response.Practice, using practical advice from leading thinkers in ethics.
ACPEN: Accommodation Requests - Substance Abuse - Contagious Infections
-
Webinar
1.00 Credits
Member Price: $39
Accommodation requests - religious practices Accommodation requests - disabilities Substance Abuse - constructive confrontation Substance Abuse - duty to accommodate as a disability Disclosures of potentially contagious infections
ACPEN: What Is Your Brand Reputation?
-
Webinar
1.00 Credits
Member Price: $39
Presence
Business Partnerships: Managing Supplier Relationships
-
Webinar
1.00 Credits
Member Price: $55
The major topics that will be covered in this course include:Overview of supplier contractsCase studies of successful and not-so-successful supplier relationshipsRisk potentials
ACPEN: It Is Legal, But Is It Really Ethical?, featuring Rob Berry and Bob Mims
-
Webinar
1.00 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: The Controllership Series: The Controller's Role in Debt Management
-
Webinar
1.50 Credits
Member Price: $79
Accounting Treasury Finance
ACPEN: Roadmap to Ethical Decision Making
-
Webinar
2.00 Credits
Member Price: $89
Provide best practice tips and practical strategies for preserving independence when assisting clients with technical matters Discuss the principles of professional conduct Address compliance with professional standards Use case studies to address circumstances that may create threats to independence
ACPEN: Yellow Book Ethics
-
Webinar
2.00 Credits
Member Price: $89
Ethics Accounting & Auditing Yellowbook
ACPEN: IFRS vs. US GAAP - Major Accounting Differences
-
Webinar
2.00 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: Taxation of Non-fungible Tokens (NFTs)
-
Webinar
2.00 Credits
Member Price: $89
NFT basics Classification of NFTs Current Legislative and Policy Environment Tax implications of creation, sales and exchanges of NFTs
ACPEN: K2’s Eight Awesome PivotTable Features
-
Webinar
2.00 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
-
Webinar
2.00 Credits
Member Price: $89
Fraud Detection Challenges Fraud Characteristics Fraud Indicators Audit Responsibilities Fraud Risk Recognition Responding to Suspected Fraud
Profiles in Fraud
-
Webinar
2.00 Credits
Member Price: $89
The major topics that will be covered in this course include:Real life fraudsters: what they did, how they got away with it, how they finally were caughtProfiles: the characteristics the fraud perpetrators have in commonTechniques to prevent and deter these common schemes
ACPEN: Habits That May Keep You from Promotions, Raises or Achieving Your Potential in Organizations: Small Steps Can Lead to Big Changes
-
Webinar
4.00 Credits
Member Price: $149
Leadership Management
ACPEN: Finding the Right Fit: An Exploration Financial Reporting Options for SMEs
-
Webinar
4.00 Credits
Member Price: $149
Unique needs of SMEs The menu of available frameworks Exploration of specific SPFs U.S. GAAP provisions for SMEs Considerations when selecting a framework Audit, review, and compilation implications Pitfalls to avoid Best practices to adopt
ACPEN: Impact of OBBBA 2025 on the Individual Taxpayer
-
Webinar
6.00 Credits
Member Price: $189
OBBBA 2025 – New law provisions, those extended or made permanent with and without changes, and those repealed Illustrative example of how the OBBA changes may impact the everyday taxpayer Inflation adjusted rates for 2025 and 2026 Dependent care credit Student loan deduction Review of other individual credits and deductions
ACPEN: Eliminating Busy Season: Transforming Your Practice to Year- Round Advisory Services
-
Webinar
2.00 Credits
Member Price: $250
Limitations of the traditional busy season model Building a year-round advisory practice Transitioning existing clients Attracting higher-value clients Integrating tax, financial, and estate planning Workflow restructuring and operations Pricing and value communication Implementation challenges
Self-Rental Real Estate: Passive Activity & Section 199A
-
Webinar
2.00 Credits
Member Price: $89
The major topics that will be covered in this class include:Definition of self-rental property - both for Sections 199A and 469Self-rental income from directly owned properties and reporting on Form 1040, Schedule E, page 1Self-rental income from indirectly owned (partnerships, S corporations) and reporting on Form 1040, Schedule E, page 2Form 8582 (passive activity)The flow-through entity grouping electionIllustrative examples and consequences of failing to comply with the reporting standardsSelf-rental property and "former passive activities" rules