WICPA CPE & Special Event Catalog
Excel for Accounting Professionals Session V: Error Trapping & Improving Lookups
-
Online
2.00 Credits
Member Price: $89
Practical hands-on Excel learning exercises taught by a highly engaging expert in the field You'll develop your expertise with real-world Excel workbooks. Despite the popularity of VLOOKUP, it has its drawbacks. This session will address these drawbacks while offering alternatives. You'll walk through the VLOOKUP and IFERROR functions and explore the following topics: Improving the use of VLOOKUP with VALUE/TEXT Improving the use of VLOOKUP with MATCH. Moving beyond VLOOKUP with INDEX Trapping errors with IFERROR Moving beyond basic Excel functions Grasping the limitations and possible enhancements for the VLOOKUP feature, along with methods to handle errors can elevate your proficiency in Excel. You'll also partake in hands-on Excel activities that showcase the integration of functions and their use in crafting spreadsheets, encompassing: Combining functions to enhance flexibility Utilizing functions for atypical data categories Perfecting sophisticated lookup functions Session 5 is one of eight sessions that is available as an individual session. Each session builds on the prior sessions, so you'll want to consider watching Session 6: List Comparisons and Indenting to further prepare to tackle real-world issues and build powerful workbooks.
Form 706 Preparation Part I: Overview Including Portability 26-27
-
Online
2.00 Credits
Member Price: $99
This section of the four-part series will cover basic Form 706 preparation and help participants develop a solid foundation in preparing the federal estate tax return. It will also cover running the engagement, administration issues and completing pages 1-4 of the form, including the portability election. For example, worksheets and practice resources will be provided. Form 706 Series: Part I: Overview Including Portability Part II: Reporting Assets Part III: Reporting Deductions Part IIII: GST Schedule R, Form 8971, Payments & Credits
Monthly Federal Tax Updates: April 2027
-
Online
2.00 Credits
Member Price: $89
Seismic changes in tax legislation is currently taking place and the well-informed tax practitioner will want to attend this two hour monthly program in order to stay abreast of these developments! Approximately one-half of the program is devoted to individual tax issues and the remaining time is spend on business entity taxation, IRS procedure, tax legislation and other issues. Due to the changing nature of the topic, learning objectives, course descriptions and program content will vary and will be provided in more specificity closer to presentation time. This course provides a concise look at the hottest topics affecting every tax practitioner. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Balance Sheet Management: The Least Understood Risk 26-27
-
Online
4.00 Credits
Member Price: $99
Most organizations manage their income statement, but many virtually ignore the balance sheet until balance sheet problems create seemingly insurmountable emergencies. This session discusses how to analyze and manage your financial statements more holistically, allowing you to identify and correct balance sheet issues early. How do you choose whether to raise debt or equity" What are the key considerations and the advantages of each" What is the cost of capital" What are the "hidden" balance sheet risks" We will also examine several crucial ideas you can incorporate into your analyses to enhance performance and reduce risk. If you want to enhance your corporate finance skills, this session is for you.
IRAs: Contributions & Distributions for Traditional, Roth, SEP & SIMPLE IRAs
-
Online
8.00 Credits
Member Price: $300
This case-driven training is designed to get the inexperienced accountant up to speed quickly in the most common areas of S-corporation taxation. The cornerstone of this course is the preparation of the Form 1120S using a fairly complex trial balance common to most S corporation income tax returns. 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
K2’s Small Business Internal Controls, Security, And Fraud Prevention And Detection
-
Online
8.00 Credits
Member Price: $250
In today's fast-paced business environment, internal controls are more crucial than ever, especially for small organizations. However, many small businesses face significant challenges in implementing effective internal control structures. Our comprehensive program is designed to help you evaluate, develop & implement a robust internal control system tailored to the unique needs of small businesses. Join us to learn how to assess risks & implement preventive, detective, deterrent & compensating controls to mitigate these risks, even in the absence of proper segregation of duties. Our program also covers technology-focused techniques for preventing & detecting fraud, securing information systems & protecting sensitive data. Don't let the complexities of internal controls overwhelm you. Our expert-led sessions will provide you with the insights & tools necessary to design, implement & monitor effective internal controls, security measures & anti-fraud strategies. Ensure your small business is safeguarded against risks & positioned for success.
Individual Tax Update: OBBA & Recent Developments
-
Online
2.00 Credits
Member Price: $89
A discussion of the latest tax developments impacting individual taxpayers, with a focus on important provisions, rules and concepts. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Executive Presence, Personal Brand: Structure Your Narrative
-
Online
1.00 Credits
Member Price: $55
Professional credibility is communicated, not assumed. In this 1-CPE session (Professional Development), participants examine structured approaches to articulating their professional identity. Drawing directly from the course framework, the session covers development of an elevator pitch, a professional value proposition and a concise executive biography. Participants will analyze how credibility is established through clarity, relevance and alignment with audience needs. The course emphasizes service-centered communication rather than self-promotion and provides structured guidance for refining professional messaging in leadership and client-facing contexts. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Crypto, Blockchain & Taxes
-
Online
2.00 Credits
Member Price: $89
For accounting & tax professionals, understanding the inner workings of blockchain & cryptocurrency is no longer just an advantage-- it's a necessity. This course provides an in-depth look into the mechanics of digital currencies & revolutionary blockchain technology, equipping attendees with the knowledge to navigate benefits & risks effectively. Special emphasis is placed on the tax implications for both individuals & estates, ensuring that attendees can confidently advise on these issues, which are becoming increasingly relevant in financial planning & asset management. This offering is more than just a learning experience; it's an investment in one's professional growth. By understanding the tax complexities & estate planning challenges posed by digital assets, participants will be able to offer valuable insights & strategic solutions. They will emerge From this course not just with theoretical knowledge but with actionable skills that can be applied immediately. In a landscape where digital assets are becoming commonplace, this is the education that will differentiate the exceptional From the average. Join today & step into a role as a leader in finance for the digital age.
Data Analytics: Practical Insights for Today's Accountant
-
Online
2.00 Credits
Member Price: $89
This session explores tools & techniques that can enhance the efficiency & effectiveness of client engagements & business processes using data analysis tools. We will introduce some of today's popular & software tools & examine the AICPA's Five-step approach to incorporating data analytics into public accounting engagements.
AI 101 for CPAs: Core Concepts & Practical Applications 26-27
-
Online
2.00 Credits
Member Price: $99
New to AI" Start here. This beginner-friendly course explains how generative AI works, what terms like "LLM" and "agentic AI" really mean and how CPAs can safely put these tools to use. You'll leave with a solid understanding of AI fundamentals and how they apply to accounting, tax and finance.
AI Lessons Learned for Accountants
-
Online
2.00 Credits
Member Price: $89
This course provides accountants with the leading AI insights and strategies drawn from real-world experience, empirical studies, countless CPA case studies and social media commentary. It goes beyond theory, offering practical lessons learned from the front lines of AI implementation in the business world and accounting industry. Participants will gain actionable knowledge on bridging the theory-application gap, navigating exponential technological changes and creating secure, adaptive AI policies. By the end of the session, accountants will be equipped to leverage AI responsibly and innovatively in their roles. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Getting On Top of It All: How to Work Smarter, Not Harder: Part I
-
Online
4.00 Credits
Member Price: $149
There is always too much to do & too little time to do it all. Fortunately, if you know the right ways to manage people, projects & your time, you can get on top of everything by working smarter. In this seminar you'll learn the best ways to get more done in less time, how to stay sane with all you have to do & how to get other people to do some of "your" work by building great relationships.
Mary Jane Hourani’s Federal Tax Update: Individual
-
Online
4.00 Credits
Member Price: $149
This course provides a practical review of recent federal tax law changes affecting individual taxpayers. It covers enacted & proposed tax legislation, IRS regulations & rulings, recent tax-related court cases & updates to IRS procedures. The course focuses on how these developments impact individual taxpayers & common tax positions. Participants will work through real-world scenarios & examples to apply current law to individual tax situations, including the use of deductions, credits & other available tax benefits. Emphasis is placed on applying new guidance in practice while maintaining compliance with current IRS rules & procedures. 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
No Tax on Overtime: Payroll Compliance
-
Online
2.00 Credits
Member Price: $89
This course provides tax and accounting professionals with a comprehensive overview of overtime requirements under the Fair Labor Standards Act (FLSA). Participants will explore the statutory definition of overtime, exemptions and the calculation of the "regular rate of pay." Through practical examples and compliance-focused scenarios learners will gain the skills to identify risks, properly compute overtime pay and advise clients or employers on best practices. The course emphasizes regulatory compliance, accurate application of rules and strategies to avoid common pitfalls in wage and hour audits. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
The Future of Audit: Technology, Talent & Transformation
-
Online
1.00 Credits
Member Price: $55
The audit profession stands at a critical inflection point, facing unprecedented challenges from technological disruption, evolving regulatory landscapes and workforce transformation. This comprehensive course, based on the Pennsylvania Institute of CPAs' groundbreaking research report "The Future of the Audit: Building Relevance and Sustaining Quality," provides auditors with essential insights and actionable strategies to navigate these seismic shifts. Through expert perspectives from industry leaders including PCAOB board members, Big Four executives and audit committee chairs, participants will explore how artificial intelligence, blockchain and data analytics are fundamentally reshaping audit practices while creating new opportunities for value creation and risk assessment. Beyond technology adoption, this course addresses the pressing talent crisis facing the profession and offers practical solutions for building a future-ready workforce. Participants will learn how to leverage emerging technologies to enhance audit quality, understand the implications of regulatory modernization including the concept of "regulatory sandboxes," and develop strategies for attracting and retaining top talent in an increasingly competitive market. Whether you're a partner in a small firm, a manager in a large organization, or an audit professional seeking to future-proof your career, this course provides the roadmap for maintaining relevance, ensuring quality and thriving in the evolving audit landscape. You'll leave with concrete action steps for immediate implementation and a clear vision for transforming your audit practice to meet the demands of tomorrow's financial ecosystem. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Benefits & Best Practices for Telework
-
Online
2.00 Credits
Member Price: $89
Prior to the COVID-19 pandemic, telework in state & local government was not often embraced as a form of employment. As the pandemic continues, governments are beginning to experience the benefits of remote work & are reevaluating hiring practices to offer more telework & hybrid work options, not simply as a result of an emergency. This course will review various telework options & best practices for success.
Real Estate Professionals: Passive Activity, Sec. 199A & Investment Income Tax
-
Online
2.00 Credits
Member Price: $89
When do they exist & how to report them? This program will provide a detailed analysis of the real estate professional passive activity rules, including forms reporting examples & integrates those rules with when real estate is considered a "business" under the Section 199A flow-through entity deduction. 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
Ethical Intelligence for Artificial Intelligence
-
Online
2.00 Credits
Member Price: $89
Organizations & individuals enticed by the siren song of artificial intelligence cannot ignore ethical considerations. Professionals must consider accuracy of information, data privacy, independence, source citations, organizational policies, security, data retention & other ethical matters. This course discusses ethical issues associated with the utilization of AI in a professional setting & provides suggested best practices.Note: This course qualifies to count toward the WICPA membership Ethics CPE requirement.
Financial Accounting for Related Party Transactions
-
Online
2.00 Credits
Member Price: $89
Loans, rental agreements, business combinations: what do these all have in common? They all have the potential of creating a related party transaction. This program presents a detailed analysis of the financial accounting rules for transactions with related parties, as well as compares & contrasts those rules with the AICPA financial reporting framework for small & medium-sized entities. This course does not qualify for IRS credit.