CPE Catalog
Note
AICPA On-Demand & Self-Study courses take up to 24 hours to process.
Surgent's Excel: Mastering PivotTables
-
Online
2.00 Credits
PivotTable is a fancy term for an Excel report that summarizes data. If you have not yet had the good fortune of exploring PivotTables, it is about time. In this session, we'll dig into PivotTables, understand the report layout options, and examine PivotTable formulas.
Surgent's Guide to Calculating S Corporation Shareholder Stock and Loan Basis
-
Online
2.00 Credits
This program discusses, in a practical way, how an S corporation shareholder calculates their stock and loan basis on Form 7203. Form 7203 is the IRS Form on which a shareholder is sometimes required to calculate their stock and loan basis. This topic is particularly important when an S corporation has a loss and the shareholders wish to know whether they are entitled to fully utilize the loss that has been allocated to them against their other income.This course qualifies for IRS credit.
Surgent's Understanding S Corporation Taxation: Compensation Issues and Entity-Level Taxes
-
Online
2.00 Credits
Even though they have been around for several years, the tax laws pertaining to S corporations remain some of the more difficult areas of the Internal Revenue Code. In this course, we will examine how S corporations break away from the normal tax rules for flow-through entities. We will explore which employee benefits are disallowed for S corporation shareholders, as well as which taxes are assessed at the entity level. Finally, we will discuss how state level taxation may have changed permanently with the addition of PTE elections.This course qualifies for IRS credit.
Surgent's Work-Life Balance: Maximizing Productivity and Understanding Related Tax Issues
-
Online
2.00 Credits
Working as a financial professional is an accomplishment that offers the potential for a good salary with long-term growth. Despite being a sought-after career, studies show that being overworked is the greatest source of anxiety and dissatisfaction among financial professionals. Left unchecked, a life centered exclusively around the demands of work can be both physically and emotionally detrimental. Establishing a work-life balance is difficult in any profession, yet financial professionals confront unique challenges that make this goal seem even more elusive. Technology results in being "always on," with no true time to disconnect and genuinely enjoy family, exercise, or hobbies. Lack of balance comes with costs, including poor health and lower productivity. Why are some professionals able to establish a successful balance between career demands and family while others are not? How are some firms able to achieve both high employee satisfaction and strong productivity? This webinar looks at research, surveys, and simple anecdotal information to provide a better understanding of how to achieve a realistic work-life balance in the modern world. We also discuss the tax consequences that arise when professionals seek balance by working from home in one state while their employer is located in a different state.
Inventory Observation - Cretaceous Conservatory Simulation
-
Online
3.00 Credits
Step into the heart of the Cretaceous Conservatory for an unforgettable inventory observation adventure! In this immersive simulation, you'll travel to a remote island where the inventory isn't just vast, it's alive. As an auditor responsible for ensuring accuracy in the company's dinosaur-development operations, you'll face wild risks, navigate complex inventory procedures, and confront the unexpected. Through hands-on scenarios, you'll learn to identify misstatements, evaluate unique inventory challenges, and apply standard observation techniques all while staying one step ahead of potential disaster. Can you survive the wilds of the Cretaceous and emerge as the ultimate inventory explorer, or will the risks prove too much to handle?
Staff Retention Keep the Best People
-
Online
3.00 Credits
The COVID pandemic changed the way many people worked, yet others have had remote teams for decades and little changed. Many organizations trying to bring people back to the office have experienced significant turnover. Some practices have changed forever while some principles will always remain the same. Keeping your people happy equals keeping your best people. Learn the changes you should make now and the things you should do forever!
Surgent's Coaching Skills for Managers and Supervisors
-
Online
4.00 Credits
This one-day course will teach effective skills for coaching and training employees. You'll learn how to identify the characteristics of effective coaches and develop coaching strategies to support and assist your team, with the goal of helping them improve morale, productivity and quality. And, you'll learn a five-step approach for giving constructive criticism while managing defensive reactions.
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.
Real Estate Tax Issues: Passive Activity, Self-Rental and Section 199A
-
Online
4.00 Credits
This program will provide a detailed analysis of the real estate professional passive activity rules, including forms reporting examples, and integrates those rules with when real estate is considered a "business" under the Section 199A flow-through entity deduction. A detailed analysis of the self-rental passive activity rules will be given, including forms reporting examples and integrates them with the flow-through entity rules related to self-rental. *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
Becoming Conflict Competent
-
Online
2.00 Credits
Conflict is often avoided, or dealt with in a passive manner. When ignored, conflict often escalates and can become polarizing. In this session, participants will gain insights for enhancing their natural responses to conflict, learn healthy communication styles, and build constructive behaviors to manage conflict. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Create Visuals in Power BI to Successfully Analyze Data
-
Online
4.00 Credits
Unlock the full potential of your data with our cutting-edge course, "Create Visuals in Power BI to Successfully Analyze Data." Designed to span a focused, four-hour session, this course is your gateway to mastering the art of data visualization using the powerful tools of Microsoft Power BI Desktop and PowerBI.com. Whether you're a business professional, a budding data analyst, or simply someone interested in the world of data science, this course is tailored to enhance your skills in transforming raw data into visually stunning and insightful reports. Dive into the intuitive interfaces of Power BI Desktop and PowerBI.com, and learn to navigate these platforms with ease and confidence. The course is meticulously structured to provide you with demonstrations and practical knowledge. Starting with a comprehensive tour of the Power BI Desktop and PowerBI.com interfaces, you'll quickly move to the core of creating impactful visuals. Explore a wide array of available visuals and learn how to select the most effective ones for your data stories. Through detailed sessions on building interactivity into your visuals, you will discover how to create dynamic reports that not only captivate but also communicate effectively. This course will also guide you through the process of publishing your reports on PowerBI.com, ensuring that your insights reach their intended audience with the right impact. By the end of this transformative journey, you will be adept at leveraging the full capabilities of Power BI. Your newfound ability to create interactive, engaging, and informative visual reports will make you an indispensable asset in any data-driven decision-making process. Embrace this opportunity to elevate your professional profile, enhance your analytical capabilities, and become a sought-after expert in the field of data visualization. Join us for "Create Visuals in Power BI to Successfully Analyze Data" and step into the future of data analysis with confidence and skill. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Internal Controls Over Compliance vs Compliance
-
Online
1.00 Credits
Accurately identifying and testing controls over compliance is critical, yet it remains a common deficiency highlighted in peer reviews. This course offers a comprehensive overview of internal controls over compliance, with a focus on their application to Single Audits. Participants will learn how to effectively align internal controls with specific compliance requirements. Additionally, we will address one of the most frequent findings in audits of governmental entities receiving federal grants: the misidentification of controls and the confusion between compliance and control processes. This course will help clarify the distinction, equipping you with the tools to enhance audit quality and ensure compliance effectiveness.
K2'S Privacy Issues And Solutions - What You Need to Know!
-
Online
1.00 Credits
Privacy should be everywhere, yet every day seemingly brings a new story about a privacy violation. While it can be frustrating and sometimes scary to think about mishandling our personal information, it’s important to remember that we can take steps to protect our privacy. This session will teach you where your critical threats are and what information you may already have at risk. More importantly, you will learn how to manage and mitigate privacy risks. In an era of increasing connectivity – and by extension, risk – this session should be high on your list to take as soon as possible.
Excelling at Excel: Tips, Tricks and Updates
-
Online
2.00 Credits
Unlock the full potential of Excel with our comprehensive training on shortcuts and formulas. This course is designed for CPAs and financial professionals who want to enhance their efficiency and accuracy in Excel. Learn how to navigate and utilize different versions of Excel, discover powerful new functions, and master the art of creating effective tables and automations. With practical examples and hands-on exercises, you'll transform your Excel skills, making your daily tasks quicker and more precise. Plus, benefit from insider tips and tricks drawn from the instructor's extensive real-world experience. Whether it's mastering keyboard shortcuts that save you time or applying formulas that simplify complex calculations, you'll gain practical knowledge that you can immediately apply in your work. This course isn't just about learning Excel; it's about learning to excel at Excel.
Tax Procedure
-
Online
2.00 Credits
This seminar will introduce the process from filing a tax return to the IRS audit, IRS Appeals, Collections and litigation at courts of original jurisdiction. We will discuss the options taxpayers have at any point in the process with reference to real-life stories from the trenches. **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.
Transforming Strategic & Financial Management with ChatGPT - Insights for CPAs, CFOs and Controllers
-
Online
2.20 Credits
"Transforming Strategic & Financial Management with ChatGPT: Insights for CPAs, CFOs, and Controllers" is a comprehensive 2-hour CPE course designed by Jim Lindell of Thorsten Consulting Group, Inc. This course delves into the revolutionary impact of ChatGPT on financial and strategic management, offering a blend of theoretical insights and practical applications tailored for financial professionals. Through an exploration of ChatGPT's capabilities in research, communication enhancement, benchmarking, risk analysis, and more, participants will learn how to leverage this advanced AI technology to streamline operations, enhance decision-making, and foster innovation in their practices. The course not only highlights the current applications but also provides a glimpse into the future of AI in financial management, encouraging professionals to embrace technology for competitive advantage.
Advanced Excel: Hidden Secrets and Gems
-
Online
2.00 Credits
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. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Cash Management: Strategies for Long-Term Success
-
Online
2.00 Credits
Many finance departments spend considerable time managing cash, particularly if the organization is highly leveraged or cash rich. Many opportunities exist to reduce your financing costs or increase short-term cash returns if you manage cash effectively. This session will cover a wide variety of day-to-day cash management tools.
Mergers & Acquisitions: Tips and Speed Bumps to Avoid
-
Online
2.00 Credits
Mergers, acquisitions and alliances have been and continue to be major avenues to organizational growth and increased competitive advantage. Despite the great initial promise of many mergers and alliances, few seem to yield the anticipated results. Numerous studies indicate that between 55% and 77% of mergers fail to accomplish their intended purpose. This course helps financial professionals, and their advisors identify, execute, and consummate mergers and acquisitions that create shareholder value while avoiding the many traps that can cause post-acquisition failure.
Surgent's Implementing Subscription Pricing to Your Practice
-
Online
2.00 Credits
This course is designed to provide accountants with a comprehensive understanding of the subscription pricing model. As the business world increasingly shifts toward subscription-based models, it's crucial for accountants to understand the financial implications and strategies associated with this pricing approach. This course will cover the basics of subscription pricing, how to set prices, and how to analyze the financial impacts of these decisions, as well as the specific impacts to your business. By the end of this course, participants will be equipped with the knowledge and skills to effectively manage the implementation of subscription pricing to their practice.