CPE Catalog
Note
AICPA On-Demand & Self-Study courses take up to 24 hours to process.
2024 Working Through Grief and Loss - How to Build a Supportive Workplace
-
Online
1.00 Credits
Now more than ever, navigating loss, grief and crisis in the workplace is a skillset that leaders must possess. Keeping the heart in human resources is so important, especially in this post-pandemic state we are living in. We will explore ways that you can show empathy to your employees while also balancing your business needs.
The Controllership Series - The Controller's Role in Pro Forma Financial Statements
-
Online
1.00 Credits
Pro forma statements are used by businesses to make decisions on planning and control, as well as for external reporting to owners, investors, and creditors. For example, giving financial estimates for a given period in a standardized manner is known as “presenting pro forma,” a Latin phrase that means “as a matter of form.” Pro forma statements can be helpful tools for business owners, investors, creditors, or decision-makers to analyze various scenarios of future events based on certain financial assumptions. It might aid in making predictions performance of the company. A pro forma income statement displays a firm’s anticipated sales and revenue. It also highlights anticipated fixed or variable operational expenses and, in the end, displays the potential profits and retained earnings for a future financial quarter. There are various types of pro-forma statements and methods to develop them. The responsibilities/competencies of the Financial Controller position (FC) has changed in recent years. However, the creation of pro forma financial statements is still a core part of their responsibility.
Power BI - Use Power Query to Transform Your Data
-
Online
2.00 Credits
This webcast is part of the 2020 Power BI Series. Please see below for the suggested viewing order. Data can be messy! In other words, it is not always clean and neat. Data comes from various sources like text files, Excel spreadsheets, databases, report files, etc. This is how most data analysis projects fail - the inability to get the correct data. This webcast focuses on using Power Query (Get and Transform) to clean, shape and transform your messy data while still allowing you a one-click refresh. We will review various data issues including appending files, combining multiple files from a folder, adding custom columns, unpivoting data, creating a lookup table, and much more. This series is presented using Excel 2019/Office 365. Regardless of the version you are using, most concepts covered in this webcast series apply to all versions of Excel. (bold) Explore the other webcasts in the 2020 Power BI Series: Power BI - Introduction to MS Power BI Tools Power BI - Prepare Your Data Efficiently for Excel Analysis Power BI - Analyze Your Data With Excel Pivot Tables Power BI - Create Excel Dashboards for Maximum Impact Power BI - Go Beyond PivotTables with Power Pivot Power BI - Use Advanced Calculations with DAX Formulas Power BI - Use PBI Desktop to Create Reports and Dashboards Power BI - Share Your Data Analysis using PowerBI.com
QuickBooks - Know the Right Version for Your Client
-
Online
2.00 Credits
QuickBooks Desktop has been the go-to solution for companies since 1984 (Intuit originally created Quicken for bank reconciliations) and has grown into a powerful tool to track business finances. QuickBooks Online is one of the fastest growing applications in the accounting market today. With its ability to be an "on-the-go" solution, many service providers, entrepreneurs, and other industries prefer to keep it simple and use QuickBooks Online. Understanding the pros and cons of QuickBooks Desktop and QuickBooks Online will help you advise your client on the best solution for their business. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Surgent's The Risks and Benefits of ChatGPT and Artificial Intelligence
-
Online
2.00 Credits
We see multiple stories about the rapid growth of artificial intelligence (AI) and its entry into our lives in the form of AI tools, including ChatGPT. They seem to be everywhere. It is difficult to overstate how much things will change with the rise of these new technologies, or how important it is that companies embrace the opportunity to execute them correctly. Having conversations regarding the proper adoption of these technologies and tools is a crucial first step, including drafting policies to assist companies with their beneficial and thoughtful implementation and use. This course will define the state of AI tools, what benefits and risks exist, and which steps to take to begin adopting these technologies with appropriate guardrails, policies, and training. It is less likely that AI will destroy industries, and more likely that companies that embrace AI will overtake those companies that do not.
2024 Let's Meet at the Intersection of Fraud and Ethics
-
Online
4.00 Credits
This course explores actual fraud circumstances through the lens of potential prevention. We will examine how selected frauds were accomplished and consider what internal controls may have prevented fraudsters from achieving their nefarious acts. Then we will switch gears to an interactive, case-based discussion that asks participants to reach their own conclusions by analyzing facts in concert with the AICPA Code of Professional Conduct and other sources of ethical guidance. This course provides practical, action-oriented insight that can be implemented by accounting professionals in both public practice and industry.
2024 Partnership Essentials: Review & Update
-
Online
4.00 Credits
This course examines the critical issues and special opportunities facing partnerships and their partners, as well as the relationship between limited liability companies and partnerships, 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.
The ABCs of Advisory Services
-
Online
2.00 Credits
Over the next decade, the area of “Advisory Services” has the greatest potential for growth in your practice. Complexities within your clients’ financial, estate, and asset protection plans coupled with the ever-changing Internal Revenue Code has created an opportunity for the CPA, the EA, and other advisors to expand their client offerings. This course provides the practitioner with the framework for practice expansion as well as an understanding of a variety of necessary issues and techniques.
Excel - Feature Review in 100 minutes
-
Online
2.00 Credits
Over the years, Excel has added MANY new features and functionality, yet most people still use it the same way they first learned it. Many of the features were added to Excel to enhance your ability to create spreadsheets more efficiently and with more accuracy. However, if you aren't aware of these new features, how can you use them? This class will focus on walking through each ribbon (menu) to explain the capability of various features in Excel. It is a great overview for both new and advanced Excel users to make sure you know all the capabilities of Excel. You may have seen many of the features but had no idea what they could do for you. This class will help you to understand these features and determine how you might take advantage of their capabilities. This session is presented using Excel 2019/Office 365. Regardless of the version you are using, 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.
Navigating Difficult Conversations with Coworkers
-
Online
1.00 Credits
Conflict is inevitable whenever you have more than one person working together. But conflict doesn't have to be a bad thing. In fact, it's through conflict that some of the most productive conversations, changes, and innovations can occur in organizations...when they're navigated through effective communication. This workshop is designed to help you more strategically approach difficult conversations in the workplace and will arm you with both an understanding of how our minds approach these tough conversations and tools that you can use to approach these conversations more impactfully.
Common Audit and Financial Reporting Deficiencies in State and Local Governments
-
Online
2.00 Credits
Common Audit and Financial Reporting Deficiencies in State and Local Governments, is a 2 hour webcast detailing many of the more common mistakes that auditors and accountants are making in either the preparation of their annual financial statements or the audits of such financial statements. Deficiencies in audit standards (AICPA, GAO, Single Audit) and preparation standards (GASB) noted in this webcast are driven by the most recent results found in audit organization peer reviews, workpaper or desk reviews, and various organizations checklists for oversight.
2024 Nonprofit Taxation Rules and Form 990
-
Online
2.00 Credits
This course explores the latest tax provisions impacting non-profit entities, including charities, hospitals, and universities, with a focus on common issues CPAs may face when completing their clients Form 990. **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.
Mastering the Excel Lookup Functions
-
Online
2.00 Credits
In today's data-driven world, Microsoft Excel has become an essential tool for professionals in any organization. To harness the full potential of Excel, it is crucial to understand and master its lookup functions. This course is designed to equip participants with the knowledge and skills needed to effectively utilize Excel's lookup functions and enhance their data analysis capabilities. Throughout this comprehensive course, participants will dive deep into the world of lookup functions and gain experience through practical exercises and real-world scenarios. Whether you're a seasoned Excel user looking to fine-tune your skills or a beginner eager to unlock Excel's full potential, this course is tailored to meet your learning needs. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Section 199A Deduction: Rules & Forms Reporting
-
Online
2.00 Credits
This program addresses the Section 199A deduction for flow-through entity income, including a review of the major provisions, forms reporting, and recent developments. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
The Ethics Hour: I Can't Believe This Really Happened - Real World Ethics Stories
-
Online
1.00 Credits
You may have read all sorts of stories in books about how bad people steal and make their coworkers and organizations miserable. Come hear veteran Internal Auditor Rob Berry and veteran CFO John L. Daly discuss situations they have seen in the real world.
2024 Stand Out - How to Create a Unique Employer Brand
-
Online
1.00 Credits
Learn why creating an employer brand is so important and instrumental in competing in today's competitive marketplace. Elevate your recruiting experience for candidates and onboarding process for new hires to enhance your employer's brand.
The Controllers Role in Data Analytics and Big Data
-
Online
1.50 Credits
Today’s economy and all of the digital enhancements have impacted the way companies engage with their customers as well as how the company manages their internal practices. The business control function needs to keep pace. The rising importance of analytical capability is critical when defining the role of the modern controller. Execution of analytics can vary but there are still key questions that must be asked. What are the options and what we need to understand to decide the best way forward? This course focuses on the value that can be brought by the Controller when becoming involved with data analytics powered by technology and also Big Data. The digitized world we live in has made it important for the Controller function to evolve and take on this advanced task.
Introduction to Forensic Accounting
-
Online
1.80 Credits
This course provides a high-level overview and introduction into the world of the forensic accountant. Most accountants have an understanding of the concept of fraud and how it impacts companies, but many individuals do not have a full comprehension of the variance in the work performed by a forensic accountant versus a typical management accountant. This course is meant for those individuals interested in understanding the variances in the job tasks and responsibilities of forensic accountants versus typical financial or management accountants. Forensic accountants or auditors take a unique focus on performing their work. Typically, when a person with forensic experience is called in to examine financial records, it is due to suspicion of fraud, evaluation of assets, or even to track down fundamentally incorrect accounting – intentional or not. As fraud continues to raise its head in business processes, forensic accountants are discovering new and unique ways to identify, examine, and support their hypotheses and investigative techniques. The work performed by a forensic specialist can be interesting and full of potential potholes if evidence isn’t examined according to proper protocols and standards.
The Dark Web & Cybersecurity for Tax and Accounting Pros
-
Online
2.00 Credits
This course provides a concise overview of the Dark Web, a part of the internet that isn't indexed by search engines, and is often associated with anonymous transactions and nefarious activities. Discover the leading threats and risks that the Dark Web poses to accounting firms. Explore how practitioners can effectively mitigate the risk of data breaches, ransomware attacks, financial fraud and other risks connected to the Dark Web. You'll walk away with a foundational understanding of leading cybersecurity strategies that can help you maintain client trust and protect your firm's sensitive data in this complex and ever-changing threat landscape. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
2024 Managerial Accounting: Your Prescription for Better Decisions
-
Online
4.00 Credits
This session revisits useful, but potentially underutilized, managerial accounting techniques. You will appreciate a fresh look at concepts you may not have considered since your college days. We will illustrate practical ways you can immediately implement managerial accounting analysis in your professional endeavors.