CPE Catalog & Events
Improve Spreadsheets by Building Controls in Excel
Available Until
TBD
2.00 Credits
Member Price: $79
The major topics that will be covered in this class include: Learn best practices when designing your spreadsheets How to create a proper worksheet structure Learn to use Excel's built in features to find errors How to create your custom controls to prevent and find errors Using links to quickly move to controls Using Conditional Formatting to highlight errors
Mastering Partnership Basis: Inside and Outside Basis
Available Until
TBD
2.00 Credits
Member Price: $79
The major topics that will be covered in this course include: Explain the use of both "inside" and "outside" basis determination. How to calculate tax basis capital accounts, including when the entity is formed, including the impact of contributed property. Clarify the importance of partnership capital accounts and partnerships debt on partner's tax basis. Explanation of how basis is impacted distributions and by sale and/or liquidation of the partnership interest. Comprehensive example to illustrate the mechanics of the basis determination process.
Mastering the Excel Lookup Functions
Available Until
TBD
2.00 Credits
Member Price: $79
The major topics that will be covered in this class include: A review of the various lookup functions, beyond VLOOKUP Learn which lookup works best for your situation How to apply the many lookup functions Discover advanced lookup techniques like nested lookups, approximate matching, and handling errors effectively An in-depth review of the following functions: VLOOKUP / HLOOKUP XLOOKUP MATCH / INDEX XMATCH INDIRECT FILTER SORT / SORTBY UNIQUE An overview of some newer functions
SEC Case Studies: Ethical Dilemmas in Finance and Accounting
Available Until
TBD
2.00 Credits
Member Price: $79
The major topics that will be covered in this course include: Introduction to Ethics and Ethical Dilemmas Ethical Codes and Professional Standards Fraud and the Fraud Triangle Ethical Decision-Making Models Financial Statement Manipulation Tactics Cash Flow and Key Metrics Misrepresentations
The Ethical Management of Conflict
Available Until
TBD
2.00 Credits
Member Price: $79
The major topics covered in this class include: Professionalism, Conflict and Ethics Sources and approaches to conflict Managing Conflict from the Inside: Awareness of human tendencies, human emotions, and gossip Guidelines for managing conflict collaboratively
Using ChatGPT with Excel
Available Until
TBD
2.00 Credits
Member Price: $79
The major topics that will be covered in this class include: Introduction to ChatGPT and other AI (Artificial Intelligence) language models Discussion of best practices for using ChatGPT with Excel Use ChatGPT to create, debug and explain formulas Use ChatGPT to learn how to use Excel features Use ChatGPT to automate repetitive tasks in Excel Use ChatGPT to easily create macros
CPA to CFO: Essential Competencies for Finance Leaders
Available Until
Webinar
1.00 Credits
Member Price: $39
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
The Future of Audit: Technology, Talent & Transformation
Available Until
Webinar
1.00 Credits
Member Price: $39
The major topics that will be covered in this course include: Explore AI, blockchain, and data analytics impact on audits Address talent crisis through retention and upskilling strategies Navigate PCAOB standards and regulatory sandbox concepts Expand audits to include ESG and nonfinancial metrics Implement technology solutions for firms of all sizes
Ethics Based Leadership for Women
Available Until
Webinar
2.00 Credits
Member Price: $79
The major topics covered in this class include: Virtue ethics and leadership Challenges to leadership for women Self-awareness and defeating internal messages Imposter syndrome Speaking my truth, finding my voice Giving and receiving feedback Raise your hand, stand up and sit down
Fundamentals of Form 1040 -- Business
Available Until
Webinar
4.00 Credits
Member Price: $159
The major topics that will be covered in this course include: Self-employment and business income taxation (Schedule C, self-employment tax, business deductions) Reporting income from pass-through entities (Schedule E, Schedule K-1, Shareholder stock and debt basis on Form 7203) Application of Form 7217 for capital construction funds Best practices for self-employed clients and small business owners Key deductions and credits for business owners Avoiding common IRS audit triggers related to business income reporting Legislative updates impacting business income taxation in the current year
Fundamentals of Form 1040 -- Individual
Available Until
Webinar
4.00 Credits
Member Price: $159
The major topics that will be covered in this course include: Form 1040 essentials: filing requirements, due dates, and key schedules Filing status, dependency rules, and taxable income sources (wages, investment income) Adjustments to income, deductions and tax credits (standard vs. itemized deductions, EITC, Child Tax Credit, Education Credits) Preparer due diligence, Circular 230 compliance and taxpayer rights IRS cybersecurity considerations and best practices for taxpayer data security Legislative updates
Navigating IRS Correspondence: Responding to IRS Letters
Available Until
Webinar
2.00 Credits
Member Price: $79
The major topics that will be covered in this course include: Types of IRS letters: General notices, audits, collections, return requests, and errors. Deadlines for responding to IRS correspondence. Communication best practices for dealing with the IRS. Avoiding escalation and penalties through proactive responses. Ensuring compliance when addressing IRS correspondence. Real-world examples of successful IRS communications. Common pitfalls in handling IRS letters and how to avoid them. Strategies for advising clients on IRS correspondence.
Overcoming Tech Adoption Challenges in CPA Firms
Available Until
Webinar
1.00 Credits
Member Price: $39
The major topics that will be covered in this course include: Five critical technology adoption challenges facing CPA firms today Digital maturity assessment models and implementation frameworks AI integration strategies for tax, audit, and advisory services Cybersecurity considerations and risk management protocols Case studies of successful technology transformations in accounting firms
Retaining Top Talent: Strategies for CPA Firms
Available Until
Webinar
1.00 Credits
Member Price: $39
The major topics that will be covered in this course include: The true cost of turnover versus retention investment Research findings on why professionals leave or stay Whole-person retention strategies beyond compensation Work-life balance solutions that maintain productivity Career development paths for non-partner track professionals Business model transformations for sustainable staffing Technology and outsourcing strategies to reduce burnout Retention strategies specific to diverse talent and younger professionals
Tax Update: H.R. 1 "One Big Beautiful Bill" & Form 1040
Available Until
Webinar
2.00 Credits
Member Price: $79
The major topics that will be covered in this course include: Individual Taxation: Child tax credit expansion, tip/overtime exclusions, SALT cap extension Income & Adjustments: Tip income exclusion, overtime relief, educator expenses Business Taxation: Bonus depreciation, §199A expansion, interest deduction limits Estate & Gift Tax: Increased exemption thresholds, charitable deduction changes Education Incentives: Student loan discharge, 529 plan expansion, new "Trump Accounts" Compliance & Reporting: 1099-K threshold changes
The One Big Beautiful Bill: 2025 tax legislation
Available Until
Webinar
4.00 Credits
Member Price: $159
The major topics that will be covered in this course include: The Congressional process in passing tax legislation. Major Tax Provisions in the House version of Big Beautiful Bill Individual General Business International Health Care Accounts Qualified Opportunity Zones Industry Specific Provisions Tax Exempt Organizations Miscellaneous Provisions
The Role of Internal Control in the Risk-Based Audit
Available Until
Webinar
4.00 Credits
Member Price: $159
The major topics that will be covered in this course include: Specific matters auditors should consider when obtaining and documenting an understanding of the client's internal control system Development of a tailored audit approach that considers the potential reliance on internal controls Guidance for establishing an adequate basis for reliance on internal controls of less formal, smaller clients
Unlock the Power of AI with Copilot in Excel
Available Until
Webinar
2.00 Credits
Member Price: $79
The major topics that will be covered in this course include: Introduction to Copilot in Excel Automating Tasks and Enhancing Productivity Advanced Data Insights with Copilot
What's Behind the Data?
Available Until
Webinar
2.00 Credits
Member Price: $79
The major topics that will be covered in this course include: Ways in which data and information can be misleading Common pitfalls when encountering data How to re-evaluate the data to avoid those pitfalls
Workforce Transformation and Talent Management in 2025
Available Until
Webinar
1.00 Credits
Member Price: $39
The major topics that will be covered in this course include: Understanding why the traditional pyramid structure is failing firms The inverted pentagon framework and its talent retention advantages Impact of technology and AI on entry-level accounting roles The 6 Ps of Business Model Transformation implementation Accelerating specialized skills acquisition in your workforce Effective knowledge transfer through mentorship and job rotation Technology-driven training and development strategies Best practices from other industries for workforce transformation Building and retaining specialized middle layers of expertise Strategic pricing models to support the pentagon structure