Professional Development and Event Catalog

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. 

Business ethics is not just something “nice to do” but can mean the difference between success, failure, and survival in today’s increasingly competitive environment.  This seminar outlines steps to create an ethical business culture and provides specific ways for financial managers to make better ethical decisions.

In the fight against global corruption, accountants are being asked to be more forthcoming when they discover information or evidence that points to illegal or prohibited activities. This ethics workshop considers new international professional ethics proposals for responding to non-compliance with laws and regulations (NOCLAR). This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

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.

As spreadsheets evolve, so must your practices for creating, editing, and auditing them. In this program, you will gain an in-depth understanding of the best ways to work with Excel by learning best practices associated with Excel spreadsheets in each of the following areas: creating and editing Excel workbooks, securing Excel workbooks, collaborating with others in Excel, and reporting on data contained in Excel. Today’s best practices for Excel differ significantly from those used in the past, and you will learn the best ways to work with Excel spreadsheets in this “must-see” CPE program. Course materials include relevant examples to enhance your learning experience. Join us for this program to help you utilize Excel to its fullest potential.  

The Not-for-Profit Advisory Committee (NAC) has been meeting with FASB to discuss the impact of various standards on the nonprofit community. We'll look at the work of the NAC and the impact they've had. We'll then transition to the Accounting Standards Updates (ASUs) issued by the FASB that impact nonprofit entities. We'll review year 2 considerations of the leases standard. We'll also review common nonprofit deficiencies identified in peer review. Once we've wrapped up the accounting update, the course shifts to the audit side of the house with a look at what's going on at the AICPA. We'll review the impact of the changes to group audits as the changes coming down the pike for quality management. This course will keep auditors up to date on the work of the ASB. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Today's savvy executives use LinkedIn to accelerate hiring, as well as, to promote employee retention and engagement. This interactive session is for the financial executive who is actively growing and nurturing a team or company and wants to leverage LinkedIn, which is the best digital resource available. Join us for this powerful webinar and unlock the full potential of LinkedIn as your HR secret weapon for recruiting top talent, retaining your best employees, and elevating overall team engagement. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

The AICPA has determined than 1 in 10 firms are not compliant with the risk assessment standards. This course will discuss how to properly identify risks and assess risks under AU-C 315. We will then review how to respond to identified risks under AU-C 330. The course will focus on the inherent risk model. We will also review common deficiencies and how a proper risk assessment can drive a more efficient and effective audit.

Once an employee decides to report an issue, the risk for retaliation must be minimized. Metrics matter. As such, capturing and reviewing employee data for indicators of possible retaliation are key to protecting those who report. The more subtle forms of retaliation, though, require a focused communication plan to address. This course offers recommendations for implementing specific retaliation monitoring protocols.

Elevate your data reporting skills to new heights with our cutting-edge course, "Create Paginated Reports with Power BI Report Builder." This two-hour, expertly crafted training is designed to transform the way you visualize and present data, leveraging the powerful capabilities of Microsoft Power BI Report Builder. Ideal for professionals who aspire to turn complex data into compelling, print-ready reports, this course is a game-changer in the realm of data visualization and business intelligence. Delve into the world of paginated reporting with a curriculum that balances theoretical knowledge with practical examples and demonstrations. You'll learn how to navigate the Power BI Report Builder interface with ease, design intricate report layouts, and connect to diverse data sources for comprehensive reporting. The course covers a spectrum of skills, from creating eye-catching visualizations to utilizing advanced features like sub-reports and drill-through capabilities. By the end of this session, you'll be adept at publishing and sharing professional-grade, paginated reports that can inform and persuade your audience. Enroll now and take the first step towards mastering the art of paginated reporting with Power BI Report Builder. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Do you ever import data into Excel, and then spend a bunch of time manually preparing it for use? Perhaps you delete extra columns or rows. Maybe you need to split a single column into multiple columns, or, combine multiple columns into a single column. The good news is that many of these transformations can be fully automated with Excel! The Get & Transform tools built-in to Excel 2016 for Windows, formerly available as the Power Query add-in, are incredibly powerful. At a high level, they enable us to retrieve data from a variety of sources and prepare it for use as needed. In this session, we'll use Get & Transform queries to help with several common tasks, including flattening data, splitting and combining columns, formatting data, unpivoting summarized data, and combining several csv exports. If you frequently export/import data from one system to another, you will want to understand how to use a Get & Transform query to streamline your work.

Does your firm have interest in expanding its’ services beyond traditional CPA services?  Do you have staff with the expertise to compete against non-CPA firms? Welcome to a course that will lead you through the maze of creating a successful Consulting Business Practice for your CPA firm. The course will help you understand: where consulting business opportunities exist, what are the firm’s professional responsibilities and most importantly how to recognize the needs of the client.

This program provides an update to the latest tax developments, rules and regulations affecting individual taxpayers, including a review and integration of late 2023 -24 legislation.   **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 highlights significant updates that affect financial reporting and related attestation services. We will explore novel FASB pronouncements while examining the enduring impact of lease accounting and revenue recognition standards. This course will provide reminders regarding both GAAP and non-GAAP financial reporting alternatives for closely held entities. We will also explore selected guidance regarding audit, review, and compilation engagements.

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 then move to the NFP side of the house with a look at the Accounting Standard Updates issued by the FASB that impacts nonprofit entities. Following that, we review the work of the Not-for-Profit Advisory Committee (NAC) and the projects they advise the FASB on. After the break, we will conduct a deeper dive into Yellow Book and Single Audit engagements. The course closes with a look at the significant changes in the 2024 Compliance Supplement, the changes to the Uniform Guidance and the common deficiencies identified by the federal agencies and peer reviewers. 

The Paperless Office is not a myth! With today’s technology, you have many fantastic options for “going paperless,” In this session, you will learn how to leverage these technologies for better document management and storage practices.

Modern technology solutions have enabled people to operate more effectively from home using cloud-based technologies and services. This course will cover cybersecurity best practices to help CPAs protect their data and devices while using internet-based cloud technologies. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Award winning discussion leader Mark Hugh discusses how to create and capture value with consulting services. Whether you want to consult a little or full time, this valuable course reviews identifying a specialty, growing a practice, capturing value, creating deliverables, and effective marketplace marketing strategies.