CPE Catalog & Events

Unlock the full potential of Microsoft Excel PivotTables with this comprehensive course. This training is designed to equip participants with the skills to effectively analyze and summarize data, transforming raw numbers into actionable insights. Whether you're a seasoned professional or new to data analysis, this course provides an in-depth understanding of PivotTables and their capabilities, helping you uncover patterns, compare data, and make informed decisions. The program includes a step-by-step approach to creating and customizing PivotTables, focusing on how to use them to analyze data efficiently. Participants will learn how to group and filter data, identify trends, and apply advanced features to solve real-world business challenges. Beyond technical knowledge, this course introduces data visualization through PivotCharts, teaching participants how to present their analysis effectively to stakeholders. By the end of the course, you'll not only master PivotTable fundamentals but also gain advanced techniques to streamline data analysis and support strategic decision-making in any context. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

This is Part 3 of 5 in our Emerging Risk and Resilience Series for Accountants and Finance The rapid evolution of technology, globalization, and regulatory frameworks has introduced a range of emerging risks that are transforming the fields of accounting, finance, and auditing. Innovations such as artificial intelligence, blockchain, and big data analytics are redefining traditional business models while creating new challenges related to data integrity, cybersecurity, and ethical decision-making. In accounting and finance, the growing reliance on automated systems raises concerns about vulnerabilities, algorithmic bias, and the potential for misinformation. Auditors face heightened expectations for real-time assurance, transparency, and adaptability to new reporting standards, including sustainability and ESG disclosures. Geopolitical instability, economic volatility, and evolving regulatory pressures add layers of uncertainty to financial reporting and audit quality. This four-part seminar series explores these emerging risks, analyzes their implications for professionals and organizations, and highlights proactive strategies for risk management, continuous learning, and technological competency.  

Are you ready to take your productivity to the next level? Join our exclusive two-hour CPE course designed for accounting professionals and technology enthusiasts. Discover how to harness the power of Microsoft 365's versatile applications to streamline your workflows and enhance collaboration. In this course, you'll explore ten essential apps, including Shared Mailboxes, Planner, Lists, To Do, Stream, Viva Learning, Forms, Bookings, Approvals, and Places. Discover how to effectively integrate these tools into your daily tasks and experience immediate improvements in your efficiency. Don't miss out on this opportunity to unlock the full potential of Microsoft 365 and transform the way you work. Sign up now and take the first step towards a more productive and collaborative work environment!

Understanding the complexities of estate and gift taxation can be challenging for many financial professionals, especially those who lack direct experience in this area. In this comprehensive course, participants will gain a solid foundation in Federal estate and gift tax law, providing them with the necessary tools to confidently handle tax compliance issues related to Forms 706 and 709. By exploring the details of the Internal Revenue Code sections pertinent to estate and gift taxation, attendees will gain a thorough understanding of key concepts, including deductions, valuations, and tax credits. This practical knowledge will not only enhance their expertise but also empower them to provide effective tax planning strategies for their clients. Throughout the course, participants will investigate essential topics such as the valuation of assets, deductions for funeral and administrative expenses, charitable and marital deductions, and the calculation of tax credits. By mastering these critical areas, financial professionals will be better equipped to navigate the challenges of estate and gift taxation, ultimately enabling them to provide comprehensive and effective tax planning services for their clients. Whether you're looking to expand your expertise or deepen your understanding of tax compliance issues, this course offers invaluable insights and practical knowledge that can immediately be applied in your practice. **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.

Imagine being able to see into the future with confidence. The ability to be a great forecaster is not innate but learned. By examining great forecasters, we can learn to improve our ability to predict the future. We will examine best practices and current research to improve our ability to predict events that will affect our business.  

*** This is not a Florida-Approved Ethics Course***Explore the ethical implications of using generative AI. This course addresses potential risks and dilemmas, providing guidelines to ensure responsible and compliant integration. Learn how to balance innovation with ethical obligations to maintain trust and integrity. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

There has never been a greater opportunity to leverage technology tools to automate your tax services. This course will provide specific examples of how you can use AI (artificial intelligence) based tools to complement your tax planning, research and compliance services. You will learn how to leverage AI to automate the collection and organization of client data, the engagement management process, tax research, and enhance client advisory services with AI too This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Many public accountants desire to have a quick overview of only the most current changes to professional and ethical requirements. This course will provide an executive summary of the major changes in audit and other attest requirements. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event. 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 is essential and designed to assist those who want to remain up to date on guidance issued by the Financial Accounting Standards Board (FASB). Learn about the accounting requirements involving crypto assets, income taxes, joint ventures, governmental grants, interim reporting, and hedging. Hear about the results and findings of the FASB's post implementation review report involving the lease standard, and much more.

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. **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.

This session reviews the three elements of fraud, how fraudsters think, how proper internal controls can prevent and detect fraud, and the red flags to look for to identify fraud. It looks at Radar O'Reilly, one of the most beloved characters of the TV show M*A*S*H. He was trusted by his boss to run the administrative side of the US Army medical unit. Were there red flags all around Radar? Did he have the opportunity to steal? Was he a fraudster? We'll find out? Attendees learn to recognize the traits of this type fraudster that are present in many organization. Case studies of various Radars are included.

This is Part 4 in our 5 part series on Emerging Risk and Resilience - How Accounting and Finance is Leading the Way The rapid evolution of technology, globalization, and regulatory frameworks has introduced a range of emerging risks that are transforming the fields of accounting, finance, and auditing. Innovations such as artificial intelligence, blockchain, and big data analytics are redefining traditional business models while creating new challenges related to data integrity, cybersecurity, and ethical decision-making. In accounting and finance, the growing reliance on automated systems raises concerns about vulnerabilities, algorithmic bias, and the potential for misinformation. Auditors face heightened expectations for real-time assurance, transparency, and adaptability to new reporting standards, including sustainability and ESG disclosures. Geopolitical instability, economic volatility, and evolving regulatory pressures add layers of uncertainty to financial reporting and audit quality. This four-part seminar series explores these emerging risks, analyzes their implications for professionals and organizations, and highlights proactive strategies for risk management, continuous learning, and technological competency.  

Many for-profit entities receive government assistance or are required to have financial statement or compliance audits due to law or regulation. This course will discuss the requirements under Generally Accepted Auditing Standards relevant to for-profit entity audits.

Non-fungible Tokens (NFTs), unique, identifiable digital assets based on blockchain technologies, have become a fast-growing industry. This course will provide a background on how NFTs came into the mainstream marketplace.  These materials will assist the practitioner to understand the tax implications of the creation, purchase and sale of these 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.

Transform your Excel skills with our comprehensive training program, designed for users at all levels seeking to master the full suite of Excel capabilities. From powerful data analysis tools like PivotTables and advanced functions such as XLOOKUP, to the nuances of Data Validations and Conditional Formatting, this course offers a deep dive into Excel's most impactful features. Whether you're streamlining complex data sets, enhancing your reporting skills, or just looking to boost your productivity, this session provides the insights and techniques you need to leverage Excel to its fullest potential, making it an indispensable tool in your professional or personal toolkit. 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 is designed for accounting and finance professionals who desire financial reporting flexibility for small- and medium-sized entities (SMEs). We examine special-purpose frameworks (SPFs) that may offer simplification while enhancing the usefulness of financial reporting for SMEs. Our discussion offers practical ways to align financial reporting with the decision-making needs of users and other stakeholders. Real-world examples and case discussions will help attendees confidently prepare, review, and interpret SMEs’ financial statements. 

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.

This is Part 5 in our series of Emerging Risks and Resilience - How Accountants and Finance are Leading the Way The rapid evolution of technology, globalization, and regulatory frameworks has introduced a range of emerging risks that are transforming the fields of accounting, finance, and auditing. Innovations such as artificial intelligence, blockchain, and big data analytics are redefining traditional business models while creating new challenges related to data integrity, cybersecurity, and ethical decision-making. In accounting and finance, the growing reliance on automated systems raises concerns about vulnerabilities, algorithmic bias, and the potential for misinformation. Auditors face heightened expectations for real-time assurance, transparency, and adaptability to new reporting standards, including sustainability and ESG disclosures. Geopolitical instability, economic volatility, and evolving regulatory pressures add layers of uncertainty to financial reporting and audit quality. This five-part seminar series explores these emerging risks, analyzes their implications for professionals and organizations, and highlights proactive strategies for risk management, continuous learning, and technological competency.  

Data security and privacy issues persist as a significant concern for businesses of all sizes. No matter where you look, the numbers are bad - really bad! But that doesn't mean you can't take steps to reduce these risks. In this session, you will learn about the key security and privacy risks facing businesses today and the steps you can take to mitigate these risks. This session begins with a review of how cybercriminals target businesses of all sizes and the associated costs of these attacks. From there, you will progress to discussions of practical tools, policies, and other solutions that can be used to mitigate cybersecurity risks to prudently acceptable levels. This is a "must-see" session for all concerned about data security and how to mitigate threats to sensitive and confidential data.

AU-C Section 315 requires the auditor to gain an understanding of the entity and its environment and the entity's internal controls in order to design appropriate audit procedures. This course will review the key requirements of COSO which is one of the most widely used internal control frameworks. We'll also review the limitations of internal controls. Additionally, this course will introduce the risk assessment process and the various audit procedures to evaluate controls and to determine whether to test the operating effectiveness of controls.