CPE Catalog & Events

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.

This professional development course equips you with practical strategies to manage challenging interactions in the workplace. Although difficult individuals may represent a small segment of the workforce, their impact can be significant, often leading to time lost and decreased productivity. In this course, you will gain essential skills to address and navigate these situations effectively. Additionally, you'll identify specific challenges and develop a personalized action plan for implementing the strategies learned back in your workplace.

In this course, we will discuss what derailer habits keep you from achieving your fullest potential and deserving place.

The QuickBooks ecosystem of accounting tools remains the most widely-used set of accounting applications used by small businesses. Yet, many of these organizations struggle because of inadequate internal controls. In this seminar, you will learn options for improving internal controls in small businesses running QuickBooks Pro, Premier, Enterprise, or Online. Participate in this program to understand how you can create a robust system of internal controls in a small business environment, including businesses using QuickBooks accounting solutions. In this session, you will also learn about the four common types of internal controls and how to assess the relative condition of the internal control structure of a small business. With this background in place, the focus then shifts to discovering the opportunities to enhance internal controls in QuickBooks-based environments using features found in the application. In addition, you will learn about additional internal control procedures for situations where you cannot establish adequate controls in QuickBooks. In sum, while many believe that QuickBooks-based organizations will forever face weak internal control structures, by participating in this session, you will learn how QuickBooks-based businesses can benefit from strong internal controls.

Many team members now work remotely, whether by choice or necessity. As a result, questions abound about remote access to desktops and data, security, communications, collaboration, and other considerations in this new normal. When implemented correctly, remote work strategies can be a “win-win” for all involved; however, failed implementations may lead to inefficiencies, security issues, and dissatisfied team members. This session will teach you today’s best practices for working remotely. Specifically, you will learn about various remote access tools, communication and collaboration options, and security best practices. You will also learn about managing and monitoring workflows in remote work environments and tools you can use. After completing this session, you can implement a remote work strategy that yields efficiency, security, and satisfaction to all involved.

This comprehensive course provides the critical updates governmental accountants and auditors need to stay informed. We'll begin with a review of recent GASB standards, including compensated absences, asset disclosures, risk and uncertainty disclosures, and financial reporting model improvements. Participants will also gain insights into GASB's current projects, exposure drafts, and agenda progress to ensure they are up to date on what's ahead. For auditors, we'll cover key changes to governmental auditing standards, including the 2024 Yellow Book updates, the transition from quality control to quality management, and implementation timelines, with early adoption options. Single Audit updates will include the 2024 Uniform Guidance changes, the 2025 Compliance Supplement, GAO reports on improper payments and government fraud, the Financial Data Transparency Act (FDTA), and recent Department of Education guidance on related parties.

With the increasing complexity and ever-changing nature of tax laws and issues, today’s accountant needs a S corporation course focusing on the birth, growth, maturity, and death of a closely held S corporation. This case driven course will deal with S corporation income tax laws from formation to liquidation.  **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

New features in Excel provide tremendous opportunities to improve Excel-based operational and financial reports. For example, Data Models, Power Query, Data Analysis Expressions, Power Pivot, and many others can help you create more powerful summaries and schedules in less time than ever. Bundle these tools with some of Excel’s “legacy” features, and you have significant new opportunities to improve your Excel-based reporting environments. In this fast-paced seminar, you will learn about the importance of using Power Query to link data into Excel data models and how you can manage these data models to facilitate better and more efficient reporting. Additionally, you will learn how to incorporate Key Performance Indicators, Slicers, and Timelines into your reports to enhance the analytics and understandability of the data. Further, you will learn best practices to quickly and easily format your spreadsheets to give them a polished and professional appearance. This course should be at the top of your professional development list if you use Excel for any reporting process.

This comprehensive 8-hour course explores the pervasive issue of fraud in State and Local governments. Our panel of experts from inside and outside government will provide participants with the tools and knowledge necessary to identify, prevent, and respond to fraudulent activities in State and local governments. The course begins by examining the types of fraud commonly encountered in governmental settings, including financial fraud, procurement fraud, and abuse of power. With our experienced panelists, participants will delve into real-world case studies to understand the tactics used by fraudsters and the impact on public trust, resources, and governance. Special emphasis will be placed on understanding regulatory frameworks and compliance measures designed to mitigate fraud risks.    

This course will explore the use of ChatGPT and artificial intelligence chatbot technologies in the accounting profession. Participants will learn how to utilize ChatGPT to automate tasks, improve efficiency and accuracy, and provide real-time support to clients. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

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.

With new accounting standards, the economic landscape and evolving technology, accounting, financial reporting and finance continue to grow in complexity. FASB has tried to address the growing complexity, by working towards making GAAP less convoluted.  The struggle to stay on top of accounting financial reporting requirements and finance changes due to the economy continues for several reasons. Lack of in-house SMEs, managing high volumes of transactions, and data and evolving information technology systems. In the future, executives must consider the challenges they will face in future years that will bring their own nuances and complexities. Budgeting is certainly one of those processes that must be evaluated and re-evaluated for efficiency. This session delves into the corporate budgeting process and discusses methods used and which methods may or may not allow for the organization’s to properly plan for a volatile future.

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.

These are uncertain times. With constant economic fluctuation, geopolitical uncertainty and inflation pressures, corporations and their professionals are facing challenges at every turn. The Controllership function is accustomed to dealing with changing variables but when the change is constant and every evolving, even the simplest of tasks like cash flow and cash forecasting can become difficult.  This webinar is to focus on what methods the controller can elicit to attempt to address the current uncertainty when working with their cash flow issues and forecasting. Of course, there are basic measures that can be employed such as: Proactively managing receivables and payables Automate your accounts payable and receivables process Keep business expenses at a minimum Work with digital methods of payment from vendors Use credit wisely However, this webinar will explore methods used to create and manage your cash flow and forecasting processes. These methods go one-step past your typical forecasting to enable management to explore various alternatives and scenarios for the business.

Managing and auditing employee spending on personal and corporate credit cards is a challenge everywhere. Legacy manual expense reporting preparation and approval processes are tedious and repetitive and are an excellent place to start your company's use of business process automation solutions. This session will cover a variety of expense workflow tools which use technologies and features like bank feeds, mobile receipt capture, OCR data extraction/filling, automated policy enforcement, and artificial intelligence-based validation to automate and eliminate the tedium. Attend this session and learn how to use automation and cure the expense reporting blues for you and your employees.

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.

CPAs spend most of their working lives reviewing bank statements and books and records of businesses. They are experts in understanding how to prepare financial statements according to GAAP. But would a CPA know a possible money laundering transaction if they saw it? Would they know about a money laundering business? Money laundering is a subject of many action and thriller movies, but rarely understood. This presentation will educate the CPA in understanding the basics of money laundering and how to identify money laundering. This presentation will help the CPA know the truth about money laundering, how to identify it, the statutes that define it, and the court cases that interpret it. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

In this five part master series, class participants will gain a comprehensive view into the world of forensic data analytics (FDA). From understanding practical use cases of FDA in the audit, internal audit, investigations and proactive monitoring to understanding necessary data sources, validation proceudres, success factors and pitfalls to avoid. We will also explore hundreds of leading anti-fraud tests around corruption, conflicts of interest, fake vendor schemes, segregation of duties, revenue recognition and sales abuse, among dozens of other schemes.  Participants will develop their own library of anti-fraud tests from various open source locations and apply them in relevant contexts such as the COSO Fraud Risk Management Guide. Finally, participants will also peek into future innovations in FDA and how technologies such as ChatGPT, data visualization, machine learning, AI and cryptocurrencies are all impacting the discipline.  We can't promise you'll be a programmer after this course, but you will certainly be armed with the information needed to project manage an FDA project and "direct" the programmers to accomplish your fraud risk / FDA objectives.  

Retaining Talent in a Competitive Marketplace -Creating a Benefits Program Employees Care About In today's competitive marketplace, retaining talented employees is becoming increasingly difficult. A solid benefits program can make a difference in the fight for talent - but only if those benefits matter to the employees you are trying to hire! Through statistics and case studies, this course will explore what benefits are most valuable to employees. We will also explore the basic types of retirement and health insurance plans and discuss what financial leaders should consider before adopting a benefits package. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

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.