CPE Catalog
Note
AICPA On-Demand & Self-Study courses take up to 24 hours to process.
Clean, Transform & Load Data in Power BI
-
Online
2.00 Credits
This intensive 2-hour course is designed specifically for those aiming to master data management skills in the modern business environment. As data becomes increasingly central to accounting and financial analysis, the ability to effectively manage, clean, and transform this data is critical. This course delves into Microsoft Power Query, a potent tool within Excel and Power BI Desktop, known for its robust data processing capabilities. This course is designed to take participants from the basics of Power Query to exploring its more sophisticated features. It is an ideal blend of theoretical knowledge and practical application, centered around diverse data scenarios encountered in multiple industries. The aim is to ensure that the skills and techniques learned are universally applicable and beneficial in any professional context. Structured to be participant-focused, the course encourages active learning through a series of practical exercises, live demonstrations, and illustrative case studies. This approach not only deepens the understanding of Power Query's features but also demonstrates how to turn complex data sets into actionable insights. While the course is broad in its application, it remains detailed in its instruction, catering to both the novice and the seasoned professional. It is particularly beneficial for those who regularly interact with data, such as business analysts, project managers, and financial professionals, providing them with the tools to streamline data processes and enhance data analysis capabilities. Additionally, the course underscores best practices in data management. Participants will learn strategic approaches to data challenges, ensuring that their data processes are efficient, scalable, and sustainable. This is not just a course about mastering a tool; it's about empowering professionals with the skills to transform data into a strategic business resource. By the end of the course, participants will be equipped to leverage Power Query in Excel or Power BI desktop to its full potential, turning data into a powerful driver for business success and innovation. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Making Culture A Competitive Advantage
-
Online
1.00 Credits
In the world of work today, nothing is more critical than Culture. If people are your competitive advantage, then culture is the best way to help your people realize a great destination. While many leaders and companies talk a lot about culture, few take the time to really plan, build, and invest in a great culture. Today, the world of work could not be more challenging, and the changes that we are seeing in the workforce, such as the rise of remote workers and increasing turnover, are adding to the complexity. Now more than ever, Culture must become your competitive advantage. In this course, you will learn about the key macro changes in the workforce and what some leading companies and leaders are doing to create amazing cultures and high-performing organizations. From LinkedIn to Patagonia to Eventbrite, you will learn from some top organizations ow they have successfully leveraged culture. You will learn what Culture is and can be, and you will learn what culture is not. As you set sail in 2024 and beyond as a leader, you will benefit from this class and learn how to make culture your competitive advantage. Your teacher for the class is Steve Cadigan, whom many credit for being the architect of LinkedIn's world-class and groundbreaking culture.
Conducting Human Resource Investigations
-
Online
1.00 Credits
Human Resources professionals are often tasked with investigating allegations of employee misconduct, discrimination, and others. Investigation training is traditionally presented from the position of an outsider looking in, such as a governmental agency, law firm, or private investigator. HR investigations require similar skills, but the environment and the approach are quite different. This session explores these differences and provides best practices for planning, executing, documenting, and reporting the results of an HR investigation. Attendees will end the session with takeaways to immediately implement in future HR investigations.
Performance Auditing Made Easy
-
Online
1.50 Credits
Unlike a traditional financial audit objective (Are the financial statements materially misstated), performance auditing can address a wide variety of objectives. Is this program working? Can it be improved? Where can we save money? How can we operate more efficiently and effectively? Are management’s assertions supported? And so forth. This session will explain what a performance audit is, describe the applicable standards, and provide examples that indicate the value of a performance audit. Performance audits can add value to any entity and practitioners can profit from adding these assurance services to their practices.
Businesses Receiving Government Assistance
-
Online
2.00 Credits
Many for-profit entities receive government assistance or are required to have financial statement or compliance audits due to law or regulation. This course will discuss the requirements under Generally Accepted Auditing Standards relevant to for-profit entity audits.
FAQ Related to the Most Recent Audit Standards SAS Nos. 142-149
-
Online
2.00 Credits
Recently issued generally accepted auditing standards were designed to enhance audit quality. This course will address the most commonly misapplied concepts and FAQ in properly implementing the new requirements in the way intended to achieve that goal.
Common Sense CFO: Dealing with Ever Changing Accounting Standards and Strategy Demands
-
Online
2.00 Credits
GAAP is changing at an increasing rate. Every successful organization has a sound strategy. Financial leaders are faced with the dual challenge of navigating evolving accounting standards while strategically guiding their organizations toward sustainable growth and profitability. What are the newer accounting changes that will impact professional accounting? This seminar will equip finance professionals with the critical skills and practical insights needed to effectively manage the complexities of ever-changing accounting standards and upgrade your essential strategic planning skills. Strategic skills are mandatory today. Strategies that do not keep pace with the market are doomed to fail. If we do not keep up, our successor will.
Communicate Financial Concepts to Non-Accountants
-
Online
2.00 Credits
Do you ever get blank looks when you present your company's financial statements? Does your board nod knowingly, during your presentation, but never seem to have any meaningful questions? It could be that they have no idea what you are talking about and are just pretending to understand! Learn how to connect with your CEO, board, fellow managers, and ordinary employees so they understand your message.
Communicating in a Virtual and Live Environment - Numbers Matter But So Do Words
-
Online
2.00 Credits
People fear presenting more than they do “death”. Communicating numbers is a scary proposition to overcome for both the presenter and the recipients. This course is designed to enhance the communication skills of CPAs and CFOs by emphasizing the importance of understanding and mastering the facts before delivering any presentation, understand the key elements of presenting a narrative, and provide examples to engage live and virtual teams in effective numbers presenting. The goal is to equip financial professionals with the tools needed to overcome fears and provide the best practices research on all types of presentations-from communicating complex financial information effectively to conducting a casual virtual meeting. This is a fun session intended to be interactive with participation either live, virtual or both.
Depreciating & Expensing Business Assets
-
Online
2.00 Credits
This course will address recent tax legislation, rules, and developments related to capitalization and depreciation; Section 179 and 168(k) 100 % bonus deduction; Depreciation of automobiles, including new luxury auto limits; ADS depreciation for electing farm and real estate business. **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.
Ethics: How to Run Your Business Well
-
Online
2.00 Credits
Ready to elevate your accounting practice through ethical decision-making? If you consistently apply the five principles of ethical intelligence that Forbes Contributor Bruce Weinstein, The Ethics Guy, presents in this high-content, results-focused webinar, your business will prosper. Beginning with the most fundamental principle of all, Do No Harm, you'll discover how to make the right decisions in a range of challenging situations. Through engaging, real-life "What would you do?" scenarios, an exploration of the principles of ethical intelligence, and a few fun writing exercises, you'll gain practical insights you can apply professionally and personally. We'll also answer some frequently asked questions about ethics that will enrich your understanding of a topic you can't afford to ignore. We end with a Call to Action, so that you can put the lessons you learn into practice immediately. You'll leave with the tools to foster trust, build a thriving practice, and impress clients with the high standards of service you live by. Who knew an ethics webinar could be both practical and fun? This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Financial Storytelling the Key in Growing Your Organization to the Next Level
-
Online
2.00 Credits
Are you responsible for presenting financial information to your organization, business associates, or clients? If you're a CEO, CFO, CPA, financial analyst or a manager needing to communicate financial information in an impactful way, this workshop will give you the necessary tools to tell more effective stories with your financial data. It is imperative in this fast-paced business environment, accountants need to gain a high-level understanding of the technology advances to help them focus their time on finding the story behind the numbers. Bring financial information to life and use it to communicate a story to an audience, with a focus on simplicity and ease of interpretation. This is accomplished through a mix of financial data, visualization, storytelling theory, best practices, and practical application.
Navigating IRS Authorizations: Understanding Power of Attorney, Form 2848, and Form 8821 - 2 hrs
-
Online
2.00 Credits
This two-hour course provides a comprehensive overview of the IRS collection process, guiding tax professionals through each stage, from the initial notice to enforced collection actions. Participants will gain insights into taxpayer expectations during the collection process, as well as strategies for resolving tax debts. The course highlights when to use Form 433-A or 433-B, the documentation needed, and the criteria for submitting an Offer in Compromise (OIC) to settle tax debts for less than the full amount owed. Attendees will also learn about the various payment options available and practical approaches to advising clients. *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
Surgent's Establishing State Residency and Saving Your Clients Money
-
Online
2.00 Credits
Many of our clients are moving to one of the seven states with no personal income tax, particularly Florida and Texas. Others may maintain multiple homes with an eye toward eventually establishing residency in a state with no income tax. This course will give you practical tips for your clients seeking to establish residency in a new jurisdiction. Cash-strapped states are increasingly attempting to assess taxpayers who have declared domicile and residency elsewhere, for example in Florida, to maintain their diminishing tax base. Arm your clients with the tools needed to save money by successfully establishing domicile and residency. As a practitioner, you can't afford to be unaware of the latest issues affecting so many relocating baby boomers and others. Avoid that state audit with the information provided in this entertaining webinar.
Surgent's Reducing a Business Owner Client's Exposure to Social Security and Self-Employment Taxes
-
Online
2.00 Credits
Many business owner clients wish to minimize their Social Security and self-employment tax liabilities. This course provides tax practitioners with the background to understand what kinds of income constitute self-employment income and earned income. It covers strategies that can be used to reduce clients' exposure to the self-employment tax and Social Security tax.This course qualifies for IRS credit.
Achieve Competency in Three Basic Tool Categories - Master the Fundamentals
-
Online
4.00 Credits
Financial skills needed in many situations are constantly changing. It is prudent to routinely look into your toolbox to restock or revise your tool set. In this course we will examine three tool categories that form the foundation for many analytical processes.
Overcome Your Obstacles to Abundance
-
Online
4.00 Credits
Getting rich requires many things. First, you need to know how to overcome previous limitations you may have had about making a lot of money. Second, you need to know and use the best financial strategies for becoming wealthy--including the latest investment and marketing strategies. And third, you need to be able to enjoy your lifestyle, and look at what obstacles get in the way of you being rich and fully contented. By exploring the latest methods for achieving financial and personal success, you'll be able to make a lot more money and have a great time doing it.
Fraud Case Studies: 21st Century Professional Misbehavior
-
Online
4.00 Credits
Savvy accountants pay attention to fraud trends so they can implement preventive and/or detective controls. This course examines novel frauds to explore potential mitigation measures. Participants will see how selected frauds were accomplished so they can consider internal controls that could have foiled the fraudsters' nefarious efforts. We examine broad ethical considerations and specific provisions of the AICPA Code of Professional Conduct. Along the way, we consider dramatic details of several fraud cases to illustrate practical applications that accountants can apply in their professional endeavors. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
K2's Data Analytics for Accountants and Auditors
-
Online
4.00 Credits
In the world of “Big Data,” virtually all business professionals have become data analysts, at least to some extent. However, that is particularly true in the field of auditing, where internal and external auditors are increasingly turning to data analytics to identify situations requiring follow-up and investigation. Those who understand how to take advantage of various tools to assist in these efforts benefit by conducting more thorough analyses and achieving superior results in less time. In this session, you will learn about various tools and techniques you can use for more thorough data analyzes. The discussion includes Excel as a data analysis tool, multiple Excel add-ins, and Microsoft’s Power BI application. If you're seeking to improve your skills in the field of data analytics, this session is the one for you!
Preparation, Compilation, and Review Engagements: Update and Review
-
Online
4.00 Credits
By reviewing the latest developments and issues relevant to preparation, compilation and review engagements, you'll be able to adhere to professional standards while performing these types of engagements.