WICPA CPE & Special Event Catalog
K2’s Excel PivotTables For Accountants
-
Online
8.00 Credits
Member Price: $250
Many business professionals consider PivotTables the most powerful feature in Excel, yet most accounting & financial professionals do not use them in their day-to-day activities. If you are ready to learn how to take advantage of PivotTables or extend your existing knowledge, then this course is for you! In this dynamic & engaging session, you'll master how to: Build PivotTables From scratch, Group data inside PivotTables, including options for fiscal periods, Create user-defined calculations in your PivotTables. We start with the fundamentals & quickly move to advanced techniques, including: Building PivotTables that consolidate data From multiple ranges, Connecting PivotTables dynamically to external databases & financial accounting systems, Leveraging other Excel features associated with PivotTables, such as Slicers, Power Query & Power Pivot. This seminar is a must for anyone eager to enhance their Excel skills & transform their workflow. With guidance & coaching From your K2 instructor, you'll be ready to use PivotTables to analyze & report on extensive data sets in a fraction of the time you spend completing such tasks.
Advanced Excel for Staff: Build Reports & Analyze Data
-
Online
2.00 Credits
Member Price: $89
Advanced Excel for Staff - Build Reports and Analyze Data is a comprehensive, 2-hour course tailored for professionals looking to enhance their Microsoft Excel skills in creating reports and performing data analysis. This course bridges the gap between basic Excel functionality and the advanced techniques required for effective data-driven reports. Participants will learn to efficiently gather, organize and structure data, apply calculations to derive key metrics and create professional-grade reports that are both visually appealing and actionable. The course emphasizes practical application, providing participants with guidance on Excel's advanced tools and functions. By mastering workflows and best practices, learners will gain the confidence to tackle complex data challenges and streamline reporting processes. Additionally, participants will explore methods to validate and share their work, ensuring that reports are accurate, insightful and easily communicated across teams. Whether you are tasked with preparing financial summaries, tracking performance metrics, or generating operational insights, this course will equip you with the tools to maximize Excel's potential, saving time and improving the quality of your outputs. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Leaders Eat Last. Why?
-
Online
1.00 Credits
Member Price: $39
Trust is essential, because without trust, there can be no teamwork. Trust is like oxygen, when it is gone: we suffocate. This session provides a 15-step action plan to gain commitment From your team members, build trust, hold each person accountable & create results for your organization.
Tax Implications of Retirement Plan Distributions
-
Online
1.00 Credits
Member Price: $55
This session will address the complex rules of retirement distributions, review key provisions of the SECURE Act 2.0 and provide practical strategies of maximizing tax benefits for your client. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Analytical Procedures: Practical Applications & Standards
-
Online
2.00 Credits
Member Price: $89
This session explores the nature of analytical procedures, with significant emphasis placed upon professional standards involving the use of analytical procedures in audit & review engagements. Practical examples to illustrate the application process will also be given.
Emerging Risks & Resilience: How Accounting & Finance are Leading the Way: Part IIII: Managing Supply Chain Risks, Data Analytics & Business Con
-
Online
2.00 Credits
Member Price: $89
This is Part 4 in our 5 part series on Emerging Risk & Resilience: How Accounting & Finance is Leading the Way The rapid evolution of technology, globalization & regulatory frameworks has introduced a range of emerging risks that are transforming the fields of accounting, finance & auditing. Innovations such as artificial intelligence, blockchain & big data analytics are redefining traditional business models while creating new challenges related to data integrity, cybersecurity & ethical decision-making. In accounting & finance, the growing reliance on automated systems raises concerns about vulnerabilities, algorithmic bias & the potential for misinformation. Auditors face heightened expectations for real-time assurance, transparency & adaptability to new reporting standards, including sustainability & ESG disclosures. Geopolitical instability, economic volatility & evolving regulatory pressures add layers of uncertainty to financial reporting & audit quality. This four-part seminar series explores these emerging risks, analyzes their implications for professionals & organizations & highlights proactive strategies for risk management, continuous learning & technological competency.
Accounting for the Gig Economy
-
Online
2.00 Credits
Member Price: $89
Freelance work & other non-permanent employment arrangements are becoming increasingly popular ways for people to earn a living. Although these non-traditional activities offer novel, flexible ways to earn income From diverse sources, they also introduce nuanced recordkeeping, reporting & attestation issues. We investigate characteristics of the gig economy, employee-versus-contractor considerations, bookkeeping, regulatory compliance & external reporting considerations. We also explore best practices for CPAs who fulfill the role of trusted advisor for gig economy clients.
Ethics: 10 Crucial Qualities of High Character CPAs
-
Online
2.00 Credits
Member Price: $89
What can you do to enhance your commitment to the highest ethical standards of the profession? How will doing so bring you more business? In this unique and engaging ethics course, the instructor, Dr. Bruce Weinstein, The Ethics Guy (R), reveals ten crucial qualities of CPAs. They are: 1. Honesty 2. Accountability 3. Care 4. Courage 5. Fairness 6. Gratitude 7. Humility 8. Loyalty 9. Patience 10. Presence (focus or mindfulness) You're already a good CPA and a good person. This course will show you how to be even better. The result will be greater satisfaction in your professional relationships, a deeper commitment to the profession of accounting and much more business. Please note that this is a stand-alone course for 2 CPE credits in Behavioral Ethics, but you'll maximize your ROI by also taking "Ethics: How to Build and Keep Your A-Team". Together these courses are two of the surest pathways to sustained success in accounting. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.Note: This course qualifies to count toward the WICPA membership Ethics CPE requirement.
Form 1041 Advanced Series Part IIII: Post Mortem Considerations 26-27
-
Online
2.00 Credits
Member Price: $99
This final segment of our four-part Form 1041 series addresses the special income tax issues that arise on the grantor's death or the first spouse. The once docile revocable living trust ignored for income tax purposes now comes to life and requires attention. Trust administration is just as rigorous as probate administration, if not more rigorous. We will review the importance of an approach to Trust Administration and the important income tax tools available to the fiduciary. Be sure to register for all courses in this series: Form 1041 Advanced Series Part I: Why Complex Trusts are Complicated Form 1041 Advanced Series Part II: Cash & Property Distribution Issues Form 1041 Advanced Series Part III: Sec. 199. Sec. 67(g) & Charitable Deductions Form 1041 Advanced Series Part IIII: Post Mortem Considerations
PFP Update: Issues, Exposures & Developing Client Strategy 26-27
-
Online
2.00 Credits
Member Price: $99
Our clients' personal financial planning issues are quickly developing and keep us challenged in a new operating environment! Many new approaches are needed in working through, understanding, diagnosing and then adopting innovative and proven strategies. Additional ways of experiencing these client situations are entering the picture. With information overload, part of the CPA's challenge is to help clients stay focused on goals while managing expectations in a rapidly changing environment. This course will update you on the newest personal financial planning changes related to insurance, investments, education, retirement, estate, cash flow management, divorce, closely held businesses and other relevant topics. We'll discuss critical issues, including planning for education, divorce, charitable, exceptional circumstances, business owners and highly compensated executives. Be sure to register for all of our PFP updates: PFP Update: Income Tax, Retirement and Estate Planning PFP Update: Issues, Exposures and Developing Client Strategy PFP Update: Investment Planning in This New Era
What's Changing in A&A for Governmental Entities (2026/27)
-
Online
4.00 Credits
Member Price: $149
This comprehensive course provides a timely update on key accounting and auditing developments affecting governmental entities, bringing together recent standard-setting, auditing and compliance changes into a single, cohesive learning experience. Participants will begin with an update on major pronouncements issued by the Governmental Accounting Standards Board, including GASB Statements No. 103, 104 and 105, along with a high-level overview of active GASB exposure drafts and ongoing projects. Emphasis is placed on understanding how these changes affect governmental financial reporting, disclosures and communication with stakeholders. The course then shifts to auditing developments, covering significant updates to the Yellow Book issued by the U.S. Government Accountability Office, including changes related to quality management, effective dates and recent updates to the Green Book. Participants will also gain insight into the GAO's implementation delay and its implications for audit planning. Finally, the course addresses recent changes affecting Single Audits, including the 2024 Uniform Guidance overhaul, updates to Appendix B of the AICPA GAS/Single Audit Guide, recent Office of Management and Budget (OMB) memoranda and reporting changes related to SAM.gov. Designed for auditors, preparers and financial leaders working with governmental entities, this course helps participants understand how recent accounting and auditing changes intersect-and what to watch for as expectations continue to evolve. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
K2’s Advanced Excel
-
Online
8.00 Credits
Member Price: $250
Elevate your Excel expertise with K2's Advanced Excel program! This laptop-friendly course is designed for experienced Excel users who are ready to take their skills to the next level. In this session, you will master critical advanced Excel skills in six key areas: Collaborating seamlessly with other users & securing your workbooks, Utilizing tables to analyze & report data efficiently, Integrating & manipulating data From external sources with ease, Creating & auditing complex formulas, Harnessing advanced data analysis tools for deeper insights, Employing visualization techniques to communicate information effectively. Drawing From over thirty years of experience in delivering Excel training to accountants & business professionals, this program is packed with relevant, real-world examples that reinforce the topics presented. Don't miss this opportunity to become more efficient & proficient in Microsoft Excel, the go-to tool for accounting & financial professionals. This course covers advanced Excel topics that are essential for business success. Participate in this session to elevate & transform your Excel skills!
Fundamentals of Form 1040: Business
-
Online
4.00 Credits
Member Price: $149
This course builds on the foundational knowledge from Part 1, Fundamentals of the 1040 - Core Concepts. It expands into business income taxation and additional reporting requirements. Participants will learn how to accurately report self-employment income, income from pass-through entities on Form 1040. This course covers Schedule C, Schedule E and essential forms such as Form 7203 and Form 7217 to ensure accurate tax preparation for clients with business activities. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Supervised AI Agents as Internal Audit Team Members
-
Online
1.00 Credits
Member Price: $39
How should internal auditors & finance team leaders use Agentic AI? What are the dos & do nots? When deployed properly AI is wonderful. Can AI help with SOX testing? We review how to avoid the common mistakes that eliminate the benefits that AI can provide. Join us to learn about those expensive lessons. Agentic AI ('Artificial Intelligence') is rapidly being deployed by leading audit, compliance & finance teams. While AI agents are not yet replacing all of today's knowledge workers like auditors, accountants & IT security professionals, the knowledge workers that effectively use Agentic AI may soon be replacing those knowledge workers who do not use these tools to drive high quality business growth & scale. AI is moving beyond automation to become a true teammate, especially in the governance, risk & compliance processes. This session will show how supervised AI agents can work alongside accountants, auditors & IT security professionals to enhance efficiency, consistency & assurance quality. Of critical importance is training & supervision so that the AI agents accomplish their testing to mee the intended quality standards. Attendees will leave with a practical view of how AI-powered testing can be applied to both internal & external assurance. Be prepared & learn From others.
CPA to CFO: Essential Competencies for Finance Leaders
-
Online
1.00 Credits
Member Price: $55
The path from CPA to CFO has evolved dramatically in recent years, with only 43% of S&P 1000 CFOs holding CPA licenses in 2022, down from 55% a decade earlier. This comprehensive course, based on groundbreaking research from the Pennsylvania Institute of CPAs surveying over 320 CEOs and hiring executives, reveals what today's leaders truly seek in CFO candidates and provides a roadmap for CPAs to secure their seat at the executive table. Participants will discover the five critical competencies that distinguish successful CFO candidates: forward-looking financial acumen that goes beyond traditional reporting, strategic leadership skills including critical thinking and strategy creation, the evolving role of emotional intelligence, industry-specific expertise requirements and the balance between technical proficiency and visionary leadership. Through practical frameworks, real-world examples and actionable strategies, attendees will learn how to transform their CPA foundation into a comprehensive skill set that meets the dynamic demands of modern CFO roles, whether in high-growth companies, nonprofits, or traditional corporations. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Emerging Risks & Resilience: How Accountants & Finance are Leading the Way: Part V: Governance, Culture & Regulatory Risk Pressures
-
Online
2.00 Credits
Member Price: $99
This is Part 5 in our series of Emerging Risks & Resilience: How Accountants & Finance are Leading the Way The rapid evolution of technology, globalization & regulatory frameworks has introduced a range of emerging risks that are transforming the fields of accounting, finance & auditing. Innovations such as artificial intelligence, blockchain & big data analytics are redefining traditional business models while creating new challenges related to data integrity, cybersecurity & ethical decision-making. In accounting & finance, the growing reliance on automated systems raises concerns about vulnerabilities, algorithmic bias & the potential for misinformation. Auditors face heightened expectations for real-time assurance, transparency & adaptability to new reporting standards, including sustainability & ESG disclosures. Geopolitical instability, economic volatility & evolving regulatory pressures add layers of uncertainty to financial reporting & audit quality. This five-part seminar series explores these emerging risks, analyzes their implications for professionals & organizations & highlights proactive strategies for risk management, continuous learning & technological competency.
Navigating IRS: Responding to IRS Notices & Letters
-
Online
2.00 Credits
Member Price: $89
This 2-hour course gives tax professionals the tools to understand, interpret & respond appropriately to IRS correspondence. Whether the letter involves audits, collection notices, missing information, or discrepancies, participants will walk away with practical tips for communication, compliance & resolution. Using real-world examples, the session covers common notices like CP2000, CP14, CP75, CP504 & audit letters, as well as IRS timelines & what they expect in a reply. We'll also talk about avoiding missed deadlines, maintaining documentation & using AI tools where appropriate to manage responses efficiently & accurately. Please Note: If you need credit reported to the IRS for this IRS approved program, please download the IRS CE request form on the Course Materials Tab & submit to terri.storer@acpen.com
SEC Case Studies: Ethical Dilemmas in Finance & Accounting
-
Online
2.00 Credits
Member Price: $89
Overview: Ethical challenges in finance and accounting can be complex and far-reaching, impacting not only individual careers but also entire organizations and the public trust. This webinar will provide a practical exploration of the ethical considerations professionals face in today's financial landscape. Through real-world case studies, participants will examine common ethical issues, learn to navigate conflicts between financial performance and ethical integrity and gain tools for making sound decisions under pressure. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.Note: This course qualifies to count toward the WICPA membership Ethics CPE requirement.
The Essential Guide to Understanding Non-GAAP Financial Statements With Renee Rampulla
-
Online
4.00 Credits
Member Price: $149
Many entities prepare their financial statements using non-GAAP frameworks, such as tax & cash basis. Participants who attend this course will learn the unique reporting & disclosure requirements when preparing non-GAAP financial statements commonly referred to as special purpose frameworks (SPFs) or other comprehensive basis of accounting (OCBOA) financial statements.
Proper Financial Accounting for Partnerships & LLCs
-
Online
4.00 Credits
Member Price: $149
Although they are the most common entities for small & mid-sized business, financial (book) accounting for partnerships & LLCs are rarely discussed. This course examines the proper financial accounting for these tax-driven entities.
