CPE Catalog & Events

This intensive two-hour course addresses the critical need for accuracy and efficiency when developing spreadsheets using Microsoft Excel. Recognizing that even minor errors can have significant implications, this course delves deep into strategies and skills required to detect and correct errors in Excel. By the end of this course, participants will have a comprehensive understanding of how to efficiently identify and correct errors in Excel spreadsheets, enhancing their overall productivity and accuracy in their professional roles. 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 concise overview of Google Sheets, a cloud-based spreadsheet application by Google. Similar to Excel, the tool allows users to enter numbers, apply formulas, prepare graphs, create charts, use pivot tables and more. While Excel is the default tool and industry standard for most accountants, Sheets has many underrated capabilities which are clearly superior to Excel. These include online collaboration, team communications, mobility, version control, revision history, cloud storage, translation, Google integration, and scores of third-party add-ons. You'll walk away knowing how to use a whole new array of spreadsheet features not found in Excel that can boost your analytical powers and accelerate your financial workflow. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

2020 taught us that major risks can come at us from any direction and with barely a warning. All organizations operate in a risk environment, but all too often, they either don't realize it or they don't develop a strategy to deal with the risks. In this session, we will explore how risks work in both for-profit and not-for-profit organizations and how they can develop a strategy to identify, evaluate, and mitigate those risks. This program will not teach how to eliminate risks, but how to strategize how to reduce their total effect. We will liberally use case studies of both for-profit and not-for-profit companies to bridge the gap between concept and actual implementation. In each area we will explore what our experiences of the pandemic have taught us about this part of risk management.

The Art of Discipline and Getting Things Done - Applying Better Time, Team, and Project Management Techniques provides best practices for various areas that support this culture of discipline, including time, team, and project management. Those in a supervisory or managerial role must create a culture of discipline, where a high priority is placed in accomplishing responsibilities in an effective and efficient manner. Note: This course is recommended as a part of an 8-hour audit skills curriculum for managers, while it is also appropriate for anyone who has responsibilities for project and time management. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Until recently, a percentage of organizations discounted the risk related to external fraud attempts. Most were only concerned with protecting physical assets such as inventory or fixed assets. However, because of the many highly publicized corporate hacking events, such as the ones that affected the Colonial Pipeline and JBS Meats, more attention is being paid to external fraud risk of all types. In this session, we look at what is included in a definition of external fraud and then delve into specific control issues that can give rise to increased risk. We then discuss measures that organizations can employ to help reduce exposure to external attacks. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Are you looking to fortify your practice against the ever-growing threats in the digital landscape? Join us for the third installment of our exclusive webinar series, "Mastering Cybersecurity," brought to you by Practice Protect.  In today's digitally connected world, the need for comprehensive cybersecurity is paramount. With cyberattacks becoming more sophisticated, it's crucial to stay ahead of the curve in protecting your sensitive client data. This webinar series is designed to equip CPAs with the knowledge and tools needed to secure their practices and client information effectively.

In today's dynamic business environment, preserving a unified and engaged team culture is more challenging than ever. As the rhythm of work accelerates and organizational structures evolve, silent threats can begin to undermine our established team dynamics. These undercurrents, if left unaddressed, can erode morale, dampen productivity, and weaken the team's cohesion. This session offers a deep dive into strategies that can help identify, address, and neutralize these challenges, ensuring a positive, resilient, and inclusive workplace culture. Attendees will be equipped with a blend of insights and actionable strategies, enabling them to both recognize and respond to these potential pitfalls.

It's an exciting time to manage a public practice accounting firm! In addition to technical knowledge in tax, auditing, and accounting, we need to understand data analytics and security options in an advisory context. Beyond that, we must manage the practice and people while profitably delivering excellent client service in a competitive environment for the owners. Further, portals, CAS stacks, PBC lists, electronic signatures, Cloud, and robotic process automation are technologies we need to understand beyond our tax, audit, practice management, document management, and workflow systems. This CPA Firm Update session independently covers significant trends and technologies for CPA firms, which will help you understand your current and future choices. With such rapid change, what will your firm do?

Have you ever wanted to reduce the number of financial statement review points you receive? Have you ever been curious about a reviewer's thought process? This session will help you understand the role of an engagement quality control reviewer. You will leave this session understanding the role of an engagement quality control reviewer, and an appreciation of best practices to minimize your exposure to critique when your work is subject to review. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

One of tax practitioners' most fundamental yet frustrating tasks is tax research: getting answers to tax questions. This two-part series will cover the six-step process of tax research from establishing the facts, identifying issues, locating and evaluating authority to developing and communicating recommendations and conclusions of the research. With each of these steps, tips and techniques are discussed and demonstrated to improve the process's efficiency and effectiveness through electronic tax research services (CCH IntelliConnect and RIA Checkpoint) and the Internet.

Whether you are responsible for managing 1 employee or 20, your leadership can make or break your team. Learn practical leadership strategies that you can implement when you return to your office. In today’s competitive market, it’s more imperative than ever that as leaders we are inspiring and motivating our teams to success.  

Understanding how people make buying decisions is key to any successful pricing strategy. By grasping the concepts of how humans make decisions, you can be better equipped to price successfully and increase your profitability. This session will provide a look at behavioral economics, marketing strategy, customer psychology and how these principles should be applied to pricing. This course is ideal for any professional who is interested in being among the leaders in the profession, moving away from the old business model of "We sell time" while embracing the critical success factors of the knowledge economy, will find this presentation stimulating, dynamic, and thought-provoking.

In this comprehensive course, practitioners gain a deep understanding of strategic planning considerations and potential hurdles encountered when clients face difficult circumstances. Delving into an array of scenarios often classified as "challenging," the course offers tax insights. From divorce and personal bankruptcy to intricate personal relationship matters, participants will equip themselves to adeptly guide clients through these challenging scenarios by understanding the tax implications.

According to the Gallup Organization, only 10% of employees believe that their organization does a good job onboarding new employees. This means most organizations are overlooking this crucial phase of the employee lifecycle, which not only includes the often-neglected pre-boarding stage but also the continuous efforts to reduce uncertainty, bolster excitement, and foster connections for their new recruits. By streamlining these processes and crafting impactful moments from pre-boarding through the initial weeks, HR and Business leaders can significantly enhance efficiency, foster trust, and establish a foundation of psychological safety for years to come. In this session, attendees will discover strategies and resources that craft a holistic onboarding experience, mitigating risks like employee ghosting, and paving the way for heightened engagement and retention.

With over 4.3 employees leaving their jobs as of early 2022, The Great Resignation presents a huge challenge for companies as they attract and retain talent. During this course, you'll learn practical strategies you can implement immediately to ensure you have the right tools in your toolbox to win the war on talent. 

In the modern corporate landscape, the challenge for lean HR departments isn't just managing administrative tasks—it's about curating a meaningful and enriching employee journey. Small HR teams are uniquely poised to offer a level of personalization and touch that larger departments might struggle to replicate. These compact teams have the potential to craft individualized experiences, ensuring that each step of an employee's journey, from onboarding to advancement, resonates deeply and positively. Yet, knowing the potential and harnessing it are two distinct tasks. This session provides attendees with a deep dive into three transformative engagement strategies tailored for lean HR environments. By placing the employee journey at the heart of these strategies, HR professionals can ensure every interaction, every milestone, and every touchpoint is optimized for engagement, satisfaction, and growth. Discover methods that don't just streamline processes, but elevate the entire employee experience, creating a lasting impact on both individual careers and the organization's culture.

This course will review the Federal Trade Commission's proposed rule banning non-competes. It will also briefly go over the rule making process and timeline for the proposed rule to go into effect. In the second half, the presentation will review the patchwork quilt of state laws that have curtailed enforcement of non-competes, as well as best practices for businesses to consider when implementing non-competes in the workforce. 

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 and contrasts those rules with the AICPA financial reporting framework for small and medium-sized entities. **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 course introduces practical ways that public accountants can use Excel to enhance both the efficiency and effectiveness of client engagements. We will reinforce core concepts by illustrating ways that Excel is a tool for analysis and reporting. We will introduce numerous analytical methods and techniques by using practical examples to illustrate how to unleash the power of Excel when obtaining, analyzing, and reporting information.

Surveys show that the average North American company completes its monthly financial statement closing in six days. However, some companies can close their books in one day or less. You don't have to sacrifice accuracy for speed. This session will show you how to close month-end faster, better and cheaper. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.