CPE & Event Calendar

Many business professionals consider PivotTables the most powerful feature in Excel, yet most accounting and 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 and 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 and quickly move to advanced techniques, including: •    Building PivotTables that consolidate data from multiple ranges •    Connecting PivotTables dynamically to external databases and financial accounting systems •    Leveraging other Excel features associated with PivotTables, such as Slicers, Power Query, and Power Pivot This seminar is a must for anyone eager to enhance their Excel skills and transform their workflow. With guidance and coaching from your K2 instructor, you'll be ready to use PivotTables to analyze and report on extensive data sets in a fraction of the time you spend completing such tasks.

Explore the critical intersections between information technology (IT) systems and data management through this specialized CPE course for accounting professionals. This session covers business resiliency and disaster recovery strategies, change management processes, and much more. Through interactive discussions and hands-on activities, participants will learn how to enhance their organization's IT framework while ensuring robust data collection and storage. Equip yourself to oversee IT systems with confidence and reinforce data integrity and system availability.

This webinar invites participants to explore the powerful intersection of ethics, spirituality, love, and belonging in the workplace. By shifting from transactional interactions to values-driven communities, organizations can cultivate cultures that honor human dignity while enhancing productivity. This is a heart centered and practical webinar emphasizing how love, belonging and spirituality shape ethical choices. Through a blend of practical strategies for personal and organizational growth and research- based insights, the session demonstrates that these elements are not optional "nice-to-haves." Instead, they are essential drivers of organizational success; shaping environments where people feel valued, connected, and inspired to contribute their best. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Navigating the complexities of estate and trust administration is a vital skill for professionals, who play an integral role in the administration team. This comprehensive course is designed to equip professionals with a thorough understanding of their responsibilities and the processes involved in estate administration, enhancing their ability to address estate settlement issues effectively. Participants will be provided with a detailed overview of the professional’s role in estate and trust administration, emphasizing practical insights and strategies for managing assets, addressing the legitimacy of debts and creditors, and ensuring the proper distribution of assets. **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 and submit to kori.herrera@acpen.com.

Although Power BI has been available for ten years, most business professionals don't fully appreciate all it can do and its easy use. Further, many are intimidated by the platform and continue to use less efficient and effective reporting practices. If this describes you, invest some time in this session to learn how to work with Power BI almost immediately. In this session, you will learn how to use Power BI to create compelling dashboard reports. You will also learn how to optimize these reports to enhance their effectiveness. If you want to improve financial and operational reporting processes, this session is for you!

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.

The new field of Positive Psychology offers many methods and ideas for helping people be happier, healthier, and better at what they do.  Nowadays, the ability to be at your best and get clients to enjoy working with you is critical to growing your business or getting ahead.   Studies show that happy people make $750,000 more over the course of their life than unhappy people, have half the number of sick days, and live 9 years longer.  In this fun and fascinating seminar, you’ll learn how to not only be happier, but help your clients be happier in working with you.

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.

With the AICPA's heightened focus on enhancing audit quality, increased oversight of the peer review process and the auditor's overall responsibility to provide high quality services, the focus on compliance with professional standards has never been greater. Add to that the requirement to implement the revised risk assessment standards (SAS 145) and it's easy to see why it's more important than ever to ensure that auditors have a good understanding of the requirements and comply with documentation standards. Recent peer reviews have indicated that auditors are often failing to perform and/or document certain critical components of an audit such as the auditor's assessment of risk and linking the results of the assessment to substantive procedures performed. In addition, auditors are not adequately documenting their consideration of fraud, expectations in analytical procedures and the appropriate level of work needed to understand an entity's internal control. Firms were required to implement the AICPA's Revised Quality Management Standards by December 15, 2025. And the firm's evaluation of the System of Quality Management is required within one year after that. This is not just a matter of tweaking the firm's existing QM document, the standard requires a risk assessment process to identify risk and there are new quality objectives that are specified in SQMS 1-3. The AICPA further issued a SAS, SSARS and SSAE that set forth requirements for quality at the engagement level. The objective of the course is to provide the insights necessary to help auditors and accountants improve not just the quality of their work but also the perception of the accounting profession as a whole. We will focus on the most significant items resulting in deficiencies identified in the peer review process. We will also discuss the applicable audit standards, documentation requirements, and best practices. We will address the new QM standards.

You have a fantastic budget, but certain players are not pleased. Financial plans have a technical component and human component.  We can resolve some of our budget issues by exploring the process’ human aspect.  Understanding what makes you and others operate can enhance your understanding of the entire organization and build upon the respect and influence needed to navigate and lead the budgeting cycle. This session includes a case study that measures an individual’s personality type and then explores how to use our strengths and weaknesses to create a better budget process and quite frankly maybe a better you.  This is a great and fun course on its own, but is also part three of a four part series on budget mastery.

How much can clients contribute to a Roth IRA, Roth 401(k), Roth SEP IRA, or Roth SIMPLE IRA? When do enhanced (super) catch-up contributions apply, and when must those catch-up contributions be made on a Roth basis? How does a Roth distribution qualify as tax-free? How did SECURE Act 1.0 and SECURE Act 2.0 fundamentally change Roth funding and distribution rules? These are among the core Roth questions advisors must be able to answer with confidence. As Roth accounts continue to play an increasingly central role in retirement savings strategies — and as contribution rules become more layered and complex — Roth proficiency is no longer optional. In addition, new rules governing age-based enhanced catch-up contributions and the Roth mandate for certain higher-income participants have added a new level of coordination between tax planning, payroll, and retirement plan design. In this course, Denise Appleby simplifies the critical rules that govern Roth funding and Roth distributions across Roth IRAs, Roth 401(k)s, and related employer plans. Emphasis is placed on understanding how the rules interact, where advisors commonly make mistakes, and how recent legislative changes affect real-world planning.

In today's data-driven world, Microsoft Excel has become an essential tool for professionals in any organization. To harness the full potential of Excel, it is crucial to understand and master its lookup functions. This course is designed to equip participants with the knowledge and skills needed to effectively utilize Excel's lookup functions and enhance their data analysis capabilities. Throughout this comprehensive course, participants will dive deep into the world of lookup functions and gain experience through practical exercises and real-world scenarios. Whether you're a seasoned Excel user looking to fine-tune your skills or a beginner eager to unlock Excel's full potential, this course is tailored to meet your learning needs. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

The budgeting process can be a time consuming and frustrating process for accountants.  The constraints and pressures can lead to poor decisions in both the technical and human components.  This series will offer solutions to the budgeting woes from both the big picture and in the details.  Budget Mastery: Process, Problems, and Solutions The budgeting process can be a mundane one for accountants. Let’s be realistic and agree that even the word “budget” does not bring excitement to you and your departmental colleagues.  The constraints and pressures can lead to poor decisions in both the technical and human components.  This session is the first part of a four part series and will cover the big picture of keeping the process fresh, pragmatic and useful. We discuss these keys in an engaging manner by discussing both our flaws and strengths, including how to build on these characteristics towards an enjoyable solutions-based method that should deliver effective results for your organization.  Budget Mastery: Walkthroughs and Real World Calculations Towards Tying Budgets to Value This session takes a unique review of the fundamental budget issues faced by all and walks through a detailed modeling process intended to generate discussion and best practices to improve your organization’s financial modeling.  From the beginning of the accounting process – ‘the chart of accounts’ to the end of the process – ‘the valuation of the company’, the budgeting cycle via a live case model to learn best practices common to successful companies.   This course stands on its own but is part two of a four part budget mastery series. Budget Mastery: The Human Side of Budgeting-Navigating People's issues with 360 Insight You have a fantastic budget, but certain players are not pleased. Financial plans have a technical component and human component.  We can resolve some of our budget issues by exploring the process’ human aspect.  Understanding what makes you and others operate can enhance your understanding of the entire organization and build upon the respect and influence needed to navigate and lead the budgeting cycle. This session includes a case study that measures an individual’s personality type and then explores how to use our strengths and weaknesses to create a better budget process and quite frankly maybe a better you.  This is a great and fun course on its own, but is also part three of a four part series on budget mastery. Budget Mastery: From Numbers to Narrative: Effectively Presenting Your Budget and Reporting  Perhaps the most important element of the budget process is its communication.  If management does not understand the budget – there is an issue. Knowing the right ways to communicate at all levels is essential to stakeholders laying an ownership claim to successful budgets.  This session reveals several key guidelines in successful budget presentations and will identify key problems in how people often communicate financial plans. Presenting your budget and reporting is the final part of a four part series, but can easily stand on its own course that is intended to be fun, enjoyable and educational.

This course provides a concise overview of how artificial intelligence, particularly ChatGPT and other AI tools, is transforming accounting research methodologies and practices. Students will explore the shift from traditional search engine-based research to AI-driven insights, learning how to leverage various AI platforms for enhanced financial analysis, regulatory compliance, and strategic decision-making. The course emphasizes practical applications of AI in accounting contexts while addressing critical considerations such as data verification, ethical usage, and professional judgment. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

This course provides a focused analysis of the individual and small business provisions in Pub. L. 119-21 (H.R.1), "One Big Beautiful Bill." Tailored for tax professionals working with Form 1040 filers, the course explores impactful updates, from the no-tax-on-tips provision to enhanced bonus depreciation. Designed to inform planning strategies and compliance for the 2025 tax year and beyond. Participants will gain actionable insight into newly proposed deductions and expanded credits. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Developments in the Management Commentary and MD&A Narrative reporting is entering a new era-one that moves beyond compliance checklists to focus on cohesive, decision-useful communication. This seminar examines the evolution of corporate narrative reporting through the revised 2025 IFRS Practice Statement 1: Management Commentary and the U.S. GAAP-based MD&A under SEC Regulation S-K, with key comparisons to help practitioners understand how each framework supports investor-focused disclosure. Using real-world examples and excerpts from the actual annual report of an IFRS reporting company, this seminar highlights how the revised Management Commentary guidance aims to improve the quality, relevance, and connectivity of narrative insights. Participants will explore its emphasis on strategy, risks, sustainability factors (ESG), key performance indicators (KPIs), and the integration of financial and non-financial information. The session also analyzes the modernization efforts in U.S. MD&A, including principles-based guidance, reduction of boilerplate disclosures, and expanded expectations for entity-specific analysis and trend-based insights. Through a comparative approach, participants learn how both frameworks are converging around common principles: enhanced connectivity, balanced presentation, entity-specific content, and alignment of strategy, performance, risk, and value creation. This practical seminar provides accounting, finance, and business professionals with the knowledge needed for better understanding the management commentary and MD&A. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Step into the future of accounting and finance with our cutting-edge course on Artificial Intelligence (AI). Designed to demystify AI and transform it from a theoretical concept into a practical tool, this course will equip you with the skills to tackle modern challenges head-on. Whether you're looking to boost productivity, enhance accuracy, or streamline operations, our course has you covered. Discover the incredible problem-solving capabilities of AI, tailored specifically for accounting and financial professionals. Learn how to leverage AI features integrated into everyday applications like Excel to detect fraud, identify transaction errors, and elevate your financial operations. Witness firsthand how AI is revolutionizing the industry and positioning you at the forefront of this technological wave. Join us and unlock the full potential of AI to transform your workflow and drive success. Don't miss out on this opportunity to stay ahead of the curve and lead the way in the future of accounting and finance!

Embark on a journey to master Power BI, a powerful tool for data analysis and business intelligence, in our comprehensive course, "Get Started with Power BI." This course is meticulously designed for professionals who seek to understand the full spectrum of Power BI capabilities, including its integration with Excel's Power BI features like Power Pivot and Power Query, and its comparison with standalone Power BI tools such as Power BI Desktop, Power BI Service, and Power BI Report Server. In the first part of the course, participants will be introduced to the fundamentals of Power BI. This includes an overview of Power BI's interface, key features, and its seamless integration with Excel. The course will cover Excel's Power BI tools - Power Pivot, for advanced data modeling, and Power Query, for efficient data transformation and preparation. This segment is essential for understanding how Power BI extends and enhances the data processing and analytical capabilities of Excel. The second section of the course delves into the standalone Power BI tools. Here, participants will explore Power BI Desktop for creating complex data models and sophisticated reports, Power BI Service for cloud-based collaboration and sharing, and Power BI Report Server for on-premises report deployment. This part of the course will focus on the unique features and strengths of these standalone tools, providing attendees with the skills to leverage Power BI in a variety of business contexts. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Enter the complex world of elder planning with this comprehensive course tailored for financial professionals. Gain invaluable insights into estate and financial strategies designed specifically for older clients, equipping you with the knowledge and skills to address their unique needs and challenges. Throughout the course, participants will explore a wide range of topics, from understanding the complexities of Medicare and various life insurance types to navigating Social Security considerations and exploring Medicaid planning details. With a focus on practical application, attendees will learn to customize estate planning strategies, explore housing and care alternatives, and address gifting complexities relevant to older clients. By the end of the program, you'll develop expertise in executing specialized planning requirements for mature clients, ensuring you're well-prepared to provide informed counsel and support in this important aspect of financial practice. Join us and enhance your knowledge in estate and financial planning for the older client today. *Please Note:  If you need credit reported to the IRS for this IRS approved program, please download the IRS CE request form on the Handouts Tab and submit to kori.herrera@acpen.com

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.