CPE Catalog & Events

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.

Unlock the power of artificial intelligence to transform your firm's marketing strategy. This course will explore how AI can revolutionize your marketing efforts, helping you to reach your target audience more effectively and boost your firm's growth. In this session, Gaynor Meilke will guide you through the steps to implement an AI-enabled marketing strategy tailored to your firm's needs. Key Takeaways: Understand the fundamental principles of AI and its applications in marketing. Learn how to leverage AI tools and technologies to enhance your marketing campaigns. Discover practical strategies for integrating AI into your firm's marketing workflow. Gain insights into measuring the effectiveness of your AI-driven marketing efforts. Explore real-life case studies and success stories of firms that have successfully implemented AI in their marketing strategies. By the end of this course, you will be equipped with the knowledge and tools to harness the power of AI, streamline your marketing processes, and achieve remarkable results for your firm. Don't miss this opportunity to stay ahead of the competition and lead your firm to new heights with AI-enabled marketing This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

*** Save 15% on this event when you use the code SUMMER15 at checkout ***In this contemporary continuing education course, CPAs will embark on a journey into the world of blockchain, Bitcoin, and other digital assets. As the financial landscape is revolutionized by these emerging technologies and asset classes, it is imperative for accounting professionals to stay abreast of the latest developments. Participants will gain a foundational understanding of the operation of blockchain technology, the mechanics behind Bitcoin transactions and its value creation, and the broader universe of digital assets. More crucially, the course will explore the current guidelines, challenges, and best practices associated with the accounting and reporting of these assets, ensuring that CPAs are equipped to navigate the complexities of digital asset management in line with prevailing standards and regulations. Embrace the future of finance by mastering the accounting intricacies of this digital frontier.

This course provides a high-level overview and introduction into the world of the forensic accountant. Most accountants have an understanding of the concept of fraud and how it impacts companies, but many individuals do not have a full comprehension of the variance in the work performed by a forensic accountant versus a typical management accountant.   This course is meant for those individuals interested in understanding the variances in the job tasks and responsibilities of forensic accountants versus typical financial or management accountants. Forensic accountants or auditors take a unique focus on performing their work.  Typically, when a person with forensic experience is called in to examine financial records, it is due to suspicion of fraud, evaluation of assets, or even to track down fundamentally incorrect accounting – intentional or not. As fraud continues to raise its head in business processes, forensic accountants are discovering new and unique ways to identify, examine, and support their hypotheses and investigative techniques.  The work performed by a forensic specialist can be interesting and full of potential potholes if evidence isn’t examined according to proper protocols and standards.  

It's a whole new world for lessees under ASC topic 842. This program will dive into the new standard on leases and its impact on every size entity, review effective dates, and address what you need to know now. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Many organizations struggle to keep budgets current in an ever-changing business climate.  Twenty-first century performance metrics focus on determining what budgets should be rather than what they were in the past.  Using performance metrics effectively reduces work, reduces politics, provides flexibility and substantially improves the performance management process.  This session will show you powerful techniques to drive your organization’s performance.

Required minimum distributions (RMDs) from employer retirement plans and IRAs must be made or steep penalties will be incurred. Planning opportunities exist in certain situations to minimize distributions. Also, special rules exist for inherited retirement funds. Your clients depend on you to help them navigate the rules regarding required minimum distributions and the taxation of distributions. This course addresses compliance issues and planning opportunities regarding required minimum distributions.

The majority of peer review deficiencies and malpractice claims result from nonaudit services. This course will provide best practices for avoiding legal liability and quality control concerns.

This business coaching course is designed to enhance your coaching effectiveness by integrating innovative tools like ChatGPT (Generative AI) to support and elevate your coaching practice. You'll explore the key differences and similarities between coaching and managing, uncover the most important skill every coach should master, and learn how to get to the root cause of any problem. With hands-on coaching strategies, including neuro-linguistic programming (NLP) techniques, you'll enhance your ability to drive results. Additionally, you’ll discover how to use performance gap analysis to identify and bridge gaps, ensuring the success and growth of the individuals you coach.

We kick off this course with a look at the GASB standards that are effective this year including GASB 100, Accounting Changes and Error Corrections and GASB 101, Compensated Absences. We will then switch to the audit side of the house to examine the impact of the 2024 Compliance Supplement on Single Audits and the changes to the Uniform Guidance. We close with a look at common deficiencies found in Single Audits. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

This comprehensive case-driven training is designed to get the accountant up to speed quickly in the area of basis calculations and distribution planning for the owners of pass-thru entities (i.e., S corporations, partnerships, and limited liability companies (LLCs)). The cornerstone of this course is the line-by-line analysis of the Schedule K-1s and how it affects the basis calculations.  **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

Look beneath the surface of S corporation taxation in this discussion of special topics concerning S corporations.

Recent new auditing standards are designed to improve overall audit quality. The course will address the most common misapplied audit concepts in planning and performing effective and efficient financial statement audits. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Employment taxes are often overlooked as an area where more planning may be effective. Payroll taxes have become an increasing burden for the average business, and IRS penalties for noncompliance have risen dramatically in recent years. They have also been subject to employer incentives. The Service has announced that uncovering noncompliance by employers ranks high on its audit list. This course presents a comprehensive overview of federal payroll taxes, Form 1099, and related compliance issues.

Bitcoin, the original cryptocurrency, was released in 2009. After 15 years the cryptocurrency market consists of over 5,000 unique coins/tokens with a market capitalization of over 1.5 trillion as of 1/1/24. This course will provide an update on the cryptocurrency market and the blockchain technology that supports it. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

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.

Enhance your productivity and streamline your accounting practices with ideas learned in this course. This dynamic program, designed specifically for accountants seeking a competitive edge, delves into the practical applications of ChatGPT in your daily workflow. From conducting comprehensive research and crafting compelling correspondence to swiftly addressing technical inquiries and optimizing Excel formulas, you will gain invaluable skills to expedite your tasks and improve overall efficiency. Furthermore, we will delve into the power of ChatGPT plugins, equipping you with the knowledge to process PDF documents seamlessly and efficiently navigate the vast expanse of the web. Join us on this transformative journey and unlock your potential as a proficient and empowered accountant.

Collaboration is a key to productivity and success. But remote work can make collaboration more challenging, including collaborating on spreadsheets. Fortunately, tools such as portals with check-in/check-out capabilities, version control, comment tracking, and co-authoring can enable online spreadsheet collaboration. Further, Excel’s Inquire tool can facilitate spreadsheet collaboration in offline environments. Don’t let remote work hamper your spreadsheet collaboration needs! Participate in this session to learn how to collaborate on spreadsheets effectively from anywhere using tools you already own or license.

This session explores tools and techniques that can enhance the efficiency and effectiveness of client engagements and business processes using data analysis tools. We will introduce some of today's popular and software tools and examine the AICPA's Five-step approach to incorporating data analytics into public accounting engagements.

Required Peer Reviews are an important element for ensuring high quality audit and attest services are being offered by CPAs. This course will explore the most common deficiencies identified through the Peer Review program, so that CPAs know what potential problems to avoid.