CPE Catalog & Events

A significant number of projects fail to achieve their initial goals and/or are not completed within budget and their original timetable. As a team member, a CMA has a unique skill set and experiences to assist in project management. In addition to their analytical training and knowledge of budgets and controls, they typically have ongoing contacts with other professionals from a variety of backgrounds. Familiar analytical tools/techniques can be applied to managing projects. This brief program is designed to aid both experienced and less experienced participants in increasing their knowledge of, and comfort with, the steps and skills needed for success.

With approximately 500 functions now available in Excel, some newer and more powerful tools are easy to overlook. But, if you do that, your productivity will suffer. In this session, you will learn how to take advantage of many of Excel’s more advanced features – some new and some legacy – to elevate your productivity to higher levels. In this session, you will learn about many of Excel’s newer tools, including XLOOKUP, SUMIFS, SWITCH, and STOCKHISTORY. Also included in this session are discussions of advanced financial functions, such as IPMT and PPMT, and how to retrieve summarized data easily using GETPIVOTDATA and CUBEVALUE. Additionally, you will learn how to make sophisticated calculations easier with Dynamic Array formulas, harness the AGGREGATE function's power, and create more accurate forecasts with Excel’s FORECAST.ETS function. No matter your experience working with Excel, participating in this course will help you work more efficiently and effectively in Excel.

Does your organization encourage timely reporting? Does your organization provide substantive protection for those who report? Organizations should be aware of characteristics indicative of a retaliatory culture - one in which bad actors are provided ample opportunity and cover to retaliate.

In this session, participants will delve into the differences and similarities that coexist between the Baby Boomers, Gen X, Millennials, and Gen Z in the workplace. Guided by generational whisperer, Summer Jelinek, this immersive session will equip HR professionals with actionable strategies to foster understanding, drive productivity, and promote a harmonious working environment, irrespective of generational backgrounds.

Are you aware there are 470+ formula functions in Excel? Do you realize that they add new functions in every major version of Excel? Did you know that Microsoft adds new functions throughout the year in the Office 365 version of Excel? Are you stuck using old or simple functions like SUM or ROUND? Do you want to expand your knowledge of the extensive function library in Excel? If these questions peak your interest in becoming an Excel function expert, this course is right up your alley. This past-paced course digs into some of the most powerful functions in Excel. Although we cannot cover 470 functions, we will look at over 20 functions that will allow you to create advanced calculations in your spreadsheets. Some examples are: VLOOKUP, IF, IFS, FORECAST, RAND, SWITCH, TEXTJOIN, UNIQUE, SUBTOTAL, IS, TEXT and more! We will also provide example files that will include all the functions used during the class. It's time to take your Excel spreadsheets to the next level. This session is presented using Excel 2019/Office 365. Most concepts covered in this course apply to all versions of Excel. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

For many small businesses, the standards issued by the FASB may have little to no effect as they impact topics that do not reflect the type of transactions that these entities most frequently experience. This class will focus on the Accounting Standards Updates (ASUs) that are most likely to impact small businesses with a focus on ASUs initiated by the Private Company Council (PCC). We'll then look at alternative reporting options to GAAP including FRF for SMEs and IFRS for SMEs for entities who don't necessarily need to prepare GAAP financial statements but want to use accrual accounting. Finally, we will transition to audit standards that small business auditors will need to implement. 

Isn’t it time you learned how to take advantage of critical features available in your Microsoft 365/Office 365 subscription? In this session, you will learn to use tools such as Teams, Planner, Power Automate, and others to enhance productivity and efficiency.

Microsoft 365/Office 365 continues to grow and evolve, yet most utilize only a fraction of the tools available in their subscription. For example, powerful resources such as SharePoint Online and audio and video conferencing can change how your organization communicates and collaborates. In contrast, more personal apps such as Teams, Planner, Flow, and Sway allow individuals to work more efficiently and effectively in virtually all facets of their jobs. Further, security enhancements to Office 365 mean that your organization can take advantage of all these features in a highly secure environment.  Isn’t it time you learned how to move beyond the traditional Microsoft 365/Office 365 applications such as Excel, Word, and Outlook and unleash all your subscription offers? Join us in this fast-paced and highly interactive seminar where you will learn what you need to know to succeed with Microsoft 365/Office 365.

In the course of legal actions, payments may be made pursuant to a final disposition of a court case or a mutually agreed-upon settlement.  This course will cover the tax implications for payments made for personal injury, emotional distress, lost wages, punitive awards, pre- and post-judgement interest, contract claims, among other damages. **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.  

Many businesses are being held back by legacy solutions. The old way of doing things doesn't work anymore. Instead, Software as a Service (SaaS) has transformed many mid-market companies. In this new world of cloud-based, workflow-enabled, data-centric, and connected solutions, you can solve existing and future business problems in new ways without being bogged down by paper-centric environments. This session covers integrated and ERP solutions that should work for businesses in the $10 Million to $1 Billion range. If your existing system has been in place for seven or more years, it is time to consider upgrading or replacing it. Leverage your instructor's knowledge of the market to minimize your risk.

You are likely familiar with the Trust Fund Recovery Penalty or TFRP, BUT - aside from appealing the proposed assessment, did you know that you can make a request to remove the TFRP by making an administrative request on Form 843 (Claim for Refund and Request for Abatement)? This program will provide an overview of the Trust Fund Recovery Penalty with an emphasis on evidence gathering and using Form 843 to prevail on the IRS as to why they should accept your request for refund, effectively undoing the TFRP. This will include what to request in a FOIA, what criteria need to be met for refund, analyzing the IRS' TFRP file, and reconciling requirements in the IRM. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Construction accounting is not just about revenue, but it is a lot about revenue. Leases too. Diving deep into the five-step approach for revenue recognition in the construction industry, this course has all of the rules and interpretations that you might need. Further, practical examples help to drive home the learning. Additionally, leases are critical for contractors. From equipment to warehouse space, leases appear prominently on many contractors' book. Review the current guidance and begin to understand the new guidance under ASC 842. Program features: Detailed discussion of the guidance under FASB ASC 606, Revenue from Contracts with Customers. Examples and exercises to understand the five-step recognition process. Detailed discussion of the guidance under FASB ASC 842, Leases. Reasons why leases are so important to contractors. A walkthrough of both current and future lease guidance.

This course dives into the powerful, but potentially under-utilized, capabilities of Microsoft Excel.  Designed for sophisticated users willing to approach spreadsheets from a unique perspective, this program encourages users to challenge the status quo by considering opportunities to take acceptable spreadsheets to a new level.

Designed to provide you with the knowledge to be more efficient and effective at planning and performing audits in accordance with the requirements of the Uniform Guidance and the Single Audit Act, this course examines how the Single Audit Act relates to OMB Uniform Guidance, as well as the different types of guidance and requirements found in the Uniform Guidance. The course also covers responsibilities and requirements of the auditor and the auditee, how to identify federal assistance and how to determine a nonfederal entity's major programs. Make sure your skills are up to date with the latest information in this challenging audit area.

As our business environment shifts, so do trends with fraud schemes and perpetrators. This course will give you the absolutely latest information with how to identify and mitigate shifting fraud risks in any entity. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Designed for accounting and attestation practitioners at all levels in both public accounting and business and industry, this course provides a comprehensive review of recent standard-setting activities of the FASB and AICPA. In addition to providing a detailed review of SAS No. 145, this course will bring you up to date on FASB and AICPA standards issued over the past few years. The course also provides many hands-on examples and illustrations to help you apply the guidance in practice. In addition to a financial accounting update, the course will discuss what you will need to do differently as you adopt new audit standards 142-149 over the next few years, including a detailed review of the new audit requirements under SAS 142. The course will also cover the key changes related to SSARS No. 25. Finally, the course reviews the AICPA's quality management project. In summary, the course is your go-to source for all things A&A and will prepare you for your upcoming engagements throughout the rest of the year.

The most difficult concepts to master when dealing with flow-through business entities are the basis and distribution concepts. Major error and malpractice issues occur if the CPA does not fully understand the impact of these rules. This course is designed to focus on the practical applications of these rules.

This highly informative course comprehensively covers all the latest tax law developments. The focus is on individual taxation and discussion of the planning opportunities practitioners need to understand to help clients respond effectively. You will come away from the course with the up-to-date knowledge to educate your individual tax clients and implement tax-saving ideas that will serve their ever-evolving needs. This course is continually updated to reflect enacted legislation. Please Note: Due to content overlap, it is recommended that this course NOT be taken together with BFTU.

The course provides a concise overview of how accountants can use ChatGPT to assist with communications involving intricate and often sensitive topics that require a deep understanding of both financial principles and human resource policies. These conversations can range from budgeting and compensation to ethical considerations and regulatory compliance. The course also explores the use of ChatGPT in crafting clear, accurate, and empathetic responses to complex queries related to financial audits, tax planning, and employee benefits. It emphasizes the importance of balancing technical financial knowledge with effective communication skills to address diverse stakeholders' needs in various scenarios, from internal team discussions to client consultations. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

The TCJA made turning business losses into tax refunds far more difficult.  The CARES Act suspended and modified many of these changes.  This course will address the revised rules for deducting business losses and discuss planning ideas and potential pitfalls.  **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.