Professional Development and Event Catalog
Clean, Transform and Load Data in Power BI
11:30am - 1:30pm
Online
2.00 Credits
Member Price: $89
See more dates
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.
More Dates
Surgent's Compilations, Reviews, and Preparations: Engagement Performance and Annual Update
11:30am - 7:30pm
Online
8.00 Credits
Member Price: $299
See more dates
Specifically designed for preparation, compilation, and review practitioners, this course will provide you with a comprehensive review and hands-on application for performing financial statement preparation, compilation, and review engagements. You will learn the ins and outs of applying SSARS No. 21, Clarification and Recodification, as well as the additional guidance related to SSARS engagements through the issuance of SSARS Nos. 22-26 by the ARSC. In addition to SSARS 26, the entire suite of quality management standards is discussed. However, knowing the standards is not enough. You need to be able to effectively apply them. To support this, the course will review recent peer review feedback on SSARS engagements, providing insights on how to successfully apply this guidance. Not only will this course bring you up to date on SSARS requirements and guidance, but more importantly, it will provide you with practical examples and illustrations to help you effectively and efficiently perform these types of engagements. This course is intended to be your go-to reference for training your staff and managing your SSARS No. 21-26 services in compliance with professional, ethical, and technical requirements.
More Dates
Accommodation Requests - Substance Abuse - Contagious Infections
12:00pm - 12:55pm
Online
1.00 Credits
Member Price: $39
See more dates
Good judgment works well in handling most employee relations matters. However, there are special situations where legal requirements dictate specific handling to avoid significant personal and employer liability. This course provides practical knowledge and scripts for responding to requests for accommodation regarding religious practices or disabilities, confronting employees in substance-abuse situations, and handling disclosures of contagious infections so that individual is properly helped, and the health of your workforce is protected.
More Dates
Interviewing, Onboarding and Training 101
12:00pm - 12:58pm
Online
1.00 Credits
Member Price: $39
See more dates
Master the essential skills to build a high-performing team with our online course on interviewing, onboarding, and training. This comprehensive program dives into proven best practices for identifying top talent, creating a seamless onboarding experience, and fostering a culture of continuous development. Whether you’re a seasoned manager or new to hiring, this course equips you with the tools to make confident decisions, engage new hires effectively, and set your team up for success from day one.
More Dates
Linking Risk Management to Strategy
12:00pm - 1:00pm
Online
1.00 Credits
Member Price: $75
See more dates
Risk mitigation and response Boards and executive teams must manage an ever-changing landscape filled with uncertainty - due to economics, geopolitics, technology, tax regulations, talent pool, cyber-terrorism, data privacy and more. Emerging technologies, such as artificial intelligence and the Internet of things (IoT), are disrupting business models across all sectors. Learn strategies for mitigating risks and dealing with risks quickly.
More Dates
The ABCs of Advisory Services
12:00pm - 1:55pm
Online
2.00 Credits
Member Price: $79
See more dates
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.
More Dates
2025 AICPA Regulatory Ethics Update
12:00pm - 2:00pm
Online
2.00 Credits
Member Price: $89
See more dates
The Professional Ethics Executive Committee (PEEC) of the AICPA has been very busy issuing new and updating existing ethics rules. This course will provide an overview of recently issued and soon to be effective ethics rules that CPAs in both industry and public accounting need to know to be compliant. 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.
More Dates
Everything You Need to Know About the Pass-Through Entity Rules: IRC 199A The Code and Regulations
12:00pm - 3:39pm
Online
4.00 Credits
Member Price: $129
See more dates
As part of the Tax Cuts and Jobs Act (TCJA), IRC § 199A was added. This Internal Revenue Code section allows certain pass-through entities the ability to has made it deduct up to 20% of their qualified business. Although practitioners have had over three years of “experience” utilizing IRC § 100A, many practitioners still do not feel comfortable with this part of the Internal Revenue Code. The purpose of this presentation is to provide the practitioner with an understanding of the rules of IRC § 199A as well as an understanding of the IRC § 199A regulations. **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.
More Dates
Unlocking Deep Secrets: Case Studies in Financial Analysis
12:30pm - 2:30pm
Online
2.00 Credits
Member Price: $89
See more dates
Unlock the secrets to understanding a company's financial health and management performance through comprehensive financial analysis. This seminar will guide you through essential tools such as vertical analysis, horizontal analysis, and ratio analysis to gain deep insights into business performance. - Vertical Analysis: Learn how to express each line item of financial statements as a percentage, making it easier to compare companies of different sizes and identify key trends. - Horizontal Analysis: Discover how to compare financial information over multiple periods to spot significant changes and trends, providing a clearer picture of a company's growth and performance. - Ratio Analysis: Dive into calculating and interpreting financial ratios to assess profitability, liquidity, and solvency. Understand how these ratios reveal the effectiveness of management and the potential of the business. This seminar goes beyond just teaching terms and formulas. We will apply these analytical tools to real-world financial data, demonstrating how to derive meaningful insights and make informed decisions. Join us to enhance your financial analysis skills and gain a competitive edge in evaluating business performance. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
More Dates
AI & You
1:00pm - 1:59pm
Online
1.00 Credits
Member Price: $39
See more dates
Every organization today is facing an onslaught of pressure to master Artificial Intelligence “AI” strategies across their enterprises. Never before have we witnessed such a steep expectation for how a “technology” can transform a business, and never before have we been expected to leverage a technology so quickly and so completely. There is no denying AI presents perhaps the opportunity of a lifetime to transform and improve operations, but to date few plans or roadmaps on how to unlock the promise of AI exist. In this class, Steve Cadigan, a globally renowned future of work expert, will present a practical plan for how you can build your own AI strategy, and how you can thrive in the AI revolution. Steve will show present a roadmap of how to build your confidence with AI to address this massive change management challenge.
More Dates
Providing Ethical Leadership: Learning to be the Best Version of Yourself
1:00pm - 2:15pm
Online
1.20 Credits
Member Price: $39
See more dates
This course will examine certain qualities a leader must exhibit to set an ethical tone from the top.
More Dates
Accountants and Malpractice: Can We Get Sued for This?
1:00pm - 3:00pm
Online
2.00 Credits
Member Price: $89
See more dates
This seminar reviews situations in which a CPA or accounting professional may be in danger of being sued. We cover common law causes of action, such as negligence, and the relevant standards and case law defining what constitutes reasonable practitioner behavior. This course is ideal for lawyers, CPAs, EAs, tax preparers, accountants and insurance personnel. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
More Dates
Surgent's Managing Millennials
1:00pm - 3:00pm
Online
2.00 Credits
Member Price: $99
See more dates
By 2025, millennials will represent 75% of the workforce. Whether you are an owner of a small practice or manager in a multinational corporation, it is important to understand characteristics and expectations of this large segment of the workforce. Research reveals that many of the common stereotypes surrounding millennials are unfounded and counterproductive. This course provides an understanding of who millennials are in comparison to their predecessors, the Gen-Xers and baby boomers. Equally important, the presentation will look at common myths regarding millennials and why understanding this class of employees provides opportunities for your organization to grow and succeed.
More Dates
Surgent's Tax Research - Intermediate Concepts
1:00pm - 3:00pm
Online
2.00 Credits
Member Price: $119
See more dates
Answering clients' tax questions accurately and on time is a key challenge for tax practitioners. Through simple, plain language explanations and examples, this course will help practitioners perform tax research more efficiently by describing the structure of the primary sources, highlighting the difference between primary and secondary sources, and describing the steps in the tax research process.
More Dates
The Ethic of Teamwork
1:00pm - 3:00pm
Online
2.00 Credits
Member Price: $89
See more dates
"No one cares how much you know until they know how much you care." To be a part of a team, a team that truly cares for its people, is to be granted an opportunity for growth and inclusion and a sense of belonging. It doesn't get better than that! This ethics-based webinar examines the essence of what constitutes teams that are high functioning and highly collaborative. One essential component is the balance between content (getting the job done!) and process (how we get things done...how we treat each other). This webinar will offer concrete practical suggestions for teams both for content and process effectiveness. It will also offer opportunities for self-reflection and actions to take to enhance team performance. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
More Dates
Reviewing S Corporation Tax Returns: What Are You Missing?
1:00pm - 4:30pm
Online
4.00 Credits
Member Price: $140
See more dates
The complexity of S corporation tax law creates a formidable challenge to the tax practitioner for accurate compliance and reporting of their client's S corporation activities. In this course, we discuss the common errors practitioners make on S corporation tax returns that review staff often miss. The intent is to sharpen reviewers' skills by examining four case studies and discussing issues where additional information from the client may be warranted and areas of tax law where proper treatment requires additional analysis and information. Matters addressed include income, deductions, K- 1 reporting, and K-2 and K-3 reporting. This course follows a highly illustrative case study format to increase participant comprehension and retention.
More Dates
Surgent's Internal Controls and COSO in a Post-COVID Landscape
1:00pm - 4:30pm
Online
4.00 Credits
Member Price: $159
See more dates
Companies that fall victim to fraud schemes need to reassess internal controls in order to prevent future fraudulent activity. In this course, we will review the 18 most prevalent internal controls present as well as designed and operating effectively according to the Association of Certified Fraud Examiners' Occupational Fraud 2022: A Report to the Nations. Then we will tie these controls to the 17 internal control principles offered by the Committee of Sponsoring Organizations of the Treadway Commission (COSO), the framework used by virtually all entities and auditors to assess the design and operational effectiveness of internal controls. Lastly, we will consider the impact of the 2020 pandemic on the internal control environment in the post-COVID pandemic era.
More Dates
Partnership & S Corporations: How to Calculate Basis
1:00pm - 4:46pm
Online
4.00 Credits
Member Price: $129
See more dates
The IRS has recently increased the pressure on how to calculate and report partner and shareholder basis. Changes in the forms reflect these developments. This program provides a detailed analysis of the calculations related to determining tax basis for a partnership interest and S corporation shareholder shares and loans. How to use the Form 1065, Schedule K-1 and Form 1120S, Schedule K-1 information for basis determination. Illustrated examples with filled in forms will demonstrate how the process works and their many 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
More Dates
Building a Better Budget in a Time of Uncertainty
1:00pm - 5:00pm
Online
4.00 Credits
Member Price: $149
See more dates
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.
More Dates
Tax Depreciation: Review and Update
1:30pm - 3:30pm
Online
2.00 Credits
Member Price: $89
See more dates
A discussion of recent law changes that impact capitalization, depreciation, and disposition of assets. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.