CPE Catalog & Events

Unlock the full potential of Microsoft Excel PivotTables with this comprehensive course. This training is designed to equip participants with the skills to effectively analyze and summarize data, transforming raw numbers into actionable insights. Whether you're a seasoned professional or new to data analysis, this course provides an in-depth understanding of PivotTables and their capabilities, helping you uncover patterns, compare data, and make informed decisions. The program includes a step-by-step approach to creating and customizing PivotTables, focusing on how to use them to analyze data efficiently. Participants will learn how to group and filter data, identify trends, and apply advanced features to solve real-world business challenges. Beyond technical knowledge, this course introduces data visualization through PivotCharts, teaching participants how to present their analysis effectively to stakeholders. By the end of the course, you'll not only master PivotTable fundamentals but also gain advanced techniques to streamline data analysis and support strategic decision-making in any context. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Business Intelligence (BI) is perhaps the hottest topic in most professional circles in today’s business climate. Increasingly, organizations of all sizes seek to take advantage of the data available to them to identify previously undiscovered insights and gain competitive advantages thought to be out of reach just a few short years ago. A growing array of tools – from Excel add-ins to dedicated solutions such as Power BI – now allow you to leverage your existing knowledge and skills to create powerful, interactive dashboards and analyzes unthinkable until recently. This program will teach you to implement “do-it-yourself business intelligence” using various techniques and tools. First, you will learn to use advanced Excel data query and summarization features to create Excel-based dashboards. You will then learn how to leverage that knowledge to build even more powerful BI objects using Microsoft’s Power BI tools. If gaining better insights into your data to make better decisions interests you, then join us for a fast-paced look at how you can take advantage of these fantastic tools. 

This intensive 2-hour course is designed to unlock the potential of array formulas in Microsoft Excel. Array formulas are a vital tool in Excel for their unique ability to perform multiple calculations on one or more items within an array, making them indispensable for complex data analysis and calculations. They enable users to write fewer, more powerful formulas, leading to cleaner and more efficient spreadsheets. This course is tailored to enhance your data analysis and spreadsheet management skills by delving into the advanced aspects of array functions. Through a combination of theoretical knowledge and practical exercises, you will learn to streamline your work and improve efficiency in Excel. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

As cryptocurrencies like Bitcoin, Ethereum, and others become more popular, tax authorities around the world are working to create regulations for their use and transactions. This session will address cryptocurrency tax issues and their complexities and challenges that individuals and businesses face when dealing with the taxation of digital currencies. *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

ProActive Response Group's Active Shooter Response Training course educates participants in current trends of active shooter incidents, how to recognize early warning signs of violence, appropriate actions to increase chances of survival in an active shooter event, and how to use basic medical equipment to save the lives of victims.   *****(Warning: This video contains simulated graphic scenes that some viewers may find disturbing)*****

You often can perform an audit in accordance with all of the standards, and still have a substandard audit IF you did not get out among the clients employees (let them know you are there and where you located), talk to as many people as you can regardless as to whether you may think that they may have any helpful information; constantly observe your surrounding where ever you are at (you never now what you might see) and lastly, listen to not only what people are saying to you but are also saying around you. This presentation is designed to illustrate the importance of making yourself available to your client’s employees, let them know that you are there and where you can be found. Talk with them because if there is a problem, somebody knows and they will often tell you all about it IF you just ask them.  Look at your surrounding everywhere you go.  What are you looking for?  I don’t know but I’ll know it when I see it. Lastly, listen to what they have to say.  Every word is important because they may say something that you had not asked about.  Remember, you never want to discover something and go to an individual who you determined knew about it and ask, why didn’t you tell me about this and their response was, you never asked me!

Organizations that use primitive costing methods make predictable mistakes, allocating too much cost to easy, high-volume "gravy" products and too little cost to difficult, low-volume "dog" jobs,  putting an organization with inferior information at a significant competitive disadvantage.  The secret to being the “smart competitor” is learning how to deal with overhead.  This session will show you how to assign 16 key overhead categories.  Whether you work in a wholesale, retail, healthcare, service or manufacturing business, you will find this session invaluable.  Get your cost right, and you will be able to give the "dogs" to your competitors and keep the "gravy" for yourself.

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.

This course will dive into the fundamentals of fiduciary accounting and provide a reporting guide for determining whether receipts and expenditures are assigned to income or principal/corpus. 

Most financial leaders would agree that budgeting is easy when business and the economy are stable. When revenues and expenses are expected to remain the same, the process becomes merely an exercise in carrying over what was done before to the current year. However, what happens when we are not sure about how the market will react to our product? What happens when the competitive landscape changes? In this course, we will discuss budgeting techniques and considerations when business lacks stability. Through a combination of theory and real-world examples, we will explore how to build flexibility into our budget - so that it can inform and drive decision-making when we don't quite know what is ahead. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

2025 will be a big year for small businesses no matter what decisions are made:  Will tax cuts/changes enacted as part of the Tax Cut and Jobs Act expire at year end as scheduled or will they be extended? If extended, which provisions are included and how long is the extension?  Will overtime pay be taxed differently in the future causing additional changes to small business payroll systems?  Will employers be relieved of reporting tip income and what exactly is tip income?  What additional requirements may be imposed on employers to deter employment of illegal/undocumented workers?  What requirements and penalties are already in place and what’s coming? What will happen to ongoing judicial efforts of small businesses to fight self-employment taxes imposed by the IRS on LLC Members and active limited partners?  How is the IRS reacting to changes? **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.

If you think applying one set of audit standards is tough enough, how about applying three different sets of audit standards in one “single” audit?  That’s exactly what happens when the auditor applies GAAS, the Yellow Book and the OMB requirements in a Single Audit.  This session will start with a single audit “nuts and bolts” overview before delving into unique aspects and audit issues of the continued era of pandemic-related funding, and, of course, provide an update of any recent changes to the funding related to the Infrastructure and Investment in Jobs Act, or IIJA.  Recent changes to the Single Audit and Uniform Guidance rules will also be covered.  Join our expert panel of federal, state and local auditors and practitioners to learn what you need to know if you are performing audits under these audit standards and the Uniform Guidance for Federal Awards.

QuickBooks Online’s (QBO) market share continues to expand, and the Cloud-based accounting platform now dominates the small business market. Yet, most accounting and financial professionals have not participated in any formal training on the Cloud-based accounting service. Thus, they are unaware of many of the tool’s available features and do not work with QuickBooks Online as efficiently and effectively as they should. This course teaches you how to set up QBO and convert QuickBooks Desktop files into a QBO instance. You will learn how to process all types of transactions, including accounts payable, accounts receivable, bank feeds, inventory, and payroll. Further, you will learn how to implement appropriate internal controls and how to capitalize on advanced features such as workflow management and management reports. Join us in this session to learn how to set up QBO properly and take full advantage of all it offers while avoiding common errors and mistakes.

Many people that use Microsoft Excel know a great deal about the functionality of the application. There are, however, a tremendous number of hidden tools that a high percentage of users overlook. Additionally, there are newer features that some have not had the opportunity to explore. This session shows some of the numerous time-saving tools and features that often go unused by spreadsheet creators. People that wish to become more efficient when using Excel should take this session! This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

This is a continuing part of our series on forensic accounting. Within this segment we discuss the concepts that are part of computer forensics known as cryptology. The term cryptography is from Ancient Greek and means “hidden secret”. It is the practice and study of techniques for secure communications in the presence of adversarial behavior. Cryptography is about constructing and analyzing protocols that prevent third parties or the public from reading private messages. Cryptography starts with secrets. Various aspects in information security such as data confidentiality, data integrity, authentication and non-repudiation (where a statement’s author cannot successfully dispute its authorship) are central to modern cryptography.

This course will review the Accounting Standard Updates issued by the FASB that impact nonprofit entities. We will also look at the work of the Not-for-Profit Advisory Committee (NAC) and the projects they are advising the FASB on. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Many business owners need to pay more attention to the financial planning opportunities and implications when starting, growing and successfully running their businesses. This all-inclusive course brings together closely held business owner specifics, focusing on critical structure and financial planning issues, such as identifying those issues that business owners need to keep on the radar. This session will help determine the goals and objectives of the business owner when selecting or changing a form of the organization concerning start-up costs, control over the operation of the business, personal liability for business operations, flexibility in the process of the company, business structure, continuity and compensation. Financial planning issues to be discussed include cash flow management and budgeting, risk management and insurance, investing, income tax, retirement and estate planning issues.

This course examines the critical issues and special opportunities facing partnerships and their partners, with a focus on reporting tax basis capital accounts.  **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.

A challenge for many small business owners is choosing the `right' type of retirement plan for their businesses. Many hesitate to adopt retirement plans for their businesses because they are intimidated by the governing rules. In those cases, SEP and SIMPLE IRAs are reasonable solutions because they are easy to establish, maintain, and communicate with employees; have minimal administrative costs; and are practical and efficient ways to start a retirement plan. These IRA-based plans - SEP IRAs and SIMPLE IRAs - have low maintenance costs and are easy to communicate to employees. With IRA-based employer plans, employer contributions are sometimes discretionary, giving business owners the choice of whether to fund every year. Despite the simplicity of these plans, employers must ensure that applicable compliance requirements are met to avoid penalties. To that end, this course will cover some key provisions of SEP and SIMPLE IRAs.

A business conducted as a C corporation can be purchased through an asset acquisition or a stock acquisition. In an asset acquisition, the buyer purchases the business by purchasing the assets that make up the C corporation's ongoing business. In a stock acquisition, the buyer purchases the stock of the C corporation that owns all or a majority of the business assets. The seller and the buyer are usually at odds over how to structure the acquisition. Tax practitioners advising their business clients should be fully conversant in the tax rules that apply to stock and asset acquisitions. Discussing and explaining those rules is the focus of this course.