CPE Catalog & Events
Finding Errors in Excel Spreadsheets
-
Online
2.00 Credits
Member Price: $89
This intensive two-hour course addresses the critical need for accuracy and efficiency when developing spreadsheets using Microsoft Excel. Recognizing that even minor errors can have significant implications, this course delves deep into strategies and skills required to detect and correct errors in Excel. By the end of this course, participants will have a comprehensive understanding of how to efficiently identify and correct errors in Excel spreadsheets, enhancing their overall productivity and accuracy in their professional roles. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.Delivery Method: Individual webcastCPE Credit: AuditingProgram Level: IntermediateThis course is being offered by a 3rd party vendor and will not be accessible on your My CPE page. Webinar access information will be emailed directly to you by CPA Crossings.
The AB5s of Employees and Independent Contractors
-
Online
2.00 Credits
Member Price: $79
This course explores the tests used to determine whether a worker is properly characterized as an employee or an independent contractor for tax purposes, with a focus on the cost of getting it wrong and possible Section 530 relief. The game changing impact of the Dynamex case and AB5 will also be discussed. **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. Delivery Method: Individual webcastCPE Credit: TaxesProgram Level: Intermediate
Surgent's Employer's Handbook: Health Care, Retirement, and Fringe Benefit Tax Issues
-
Online
4.00 Credits
Member Price: $159
The employer-employee relationship strains both sides in uncertain times, and businesses need CPAs, controllers, and other advisors to provide understanding of the complex legal, tax, and health care issues associated with all aspects of employment. This course provides in-depth coverage of this critical area.Delivery Method: Individual webcastCPE Credit: Business law, TaxesProgram Level: BasicThis course is being offered by a 3rd party vendor and will not be accessible on your My CPE page. Webinar access information will be emailed directly to you by Surgent McCoy.
Effective Coaching Strategies for High Performance
-
Online
4.00 Credits
Member Price: $129
This business coaching course is designed to enhance your coaching effectiveness by integrating innovative tools like ChatGPT (Generative AI) to support and elevate your coaching practice. You'll explore the key differences and similarities between coaching and managing, uncover the most important skill every coach should master, and learn how to get to the root cause of any problem. With hands-on coaching strategies, including neuro-linguistic programming (NLP) techniques, you'll enhance your ability to drive results. Additionally, you’ll discover how to use performance gap analysis to identify and bridge gaps, ensuring the success and growth of the individuals you coach. Delivery Method: Individual webcastCPE Credit: Personal developmentProgram Level: Basic
Forensic Accounting: Finding Hidden Treasure in Tax Returns
-
Online
4.00 Credits
Member Price: $149
Almost every business and individual has to file tax returns, which can be a great treasure trove of information for forensic accountants. Whether in a divorce, partnership dispute, recreating books and records, or bankruptcy proceeding, analyzing tax return information should be an initial step in uncovering income and assets. The IRS retains a large amount of information, both from taxpayers and 3rd parties who report financial transactions. This course will be your guide in gathering, analyzing, and evaluating tax return information, so that you have a full picture of the financial investigation. Your presenter is a 20 year veteran with IRS-Criminal Investigation, who used this information as a basis for his federal criminal investigations. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.Delivery Method: Individual webcastCPE Credit: TaxesProgram Level: IntermediateThis course is being offered by a 3rd party vendor and will not be accessible on your My CPE page. Webinar access information will be emailed directly to you by CPA Crossings.
Managing Current Fraud Trends in a Shifting Environment
-
Online
8.00 Credits
Member Price: $239
As our business environment shifts, so do trends with fraud schemes and perpetrators. This course will give you the absolutely latest information with how to identify and mitigate shifting fraud risks in any entity. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.Delivery Method: Individual webcastCPE Credit: Specialized knowledgeProgram Level: BasicThis course is being offered by a 3rd party vendor and will not be accessible on your My CPE page. Webinar access information will be emailed directly to you by CPA Crossings.
Surgent's Compilations, Reviews, and Preparations: Engagement Performance and Annual Update
-
Online
8.00 Credits
Member Price: $299
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.Delivery Method: Individual webcastCPE Credit: AuditingProgram Level: UpdateThis course is being offered by a 3rd party vendor and will not be accessible on your My CPE page. Webinar access information will be emailed directly to you by Surgent McCoy.
Understanding the New Forms K-2 and K-3
-
Online
2.00 Credits
Member Price: $89
Schedules K-2 and K-3 are promulgated by the IRS in order to standardize the reporting of foreign-related tax information for pass-through entities. Even pass-through entities that have no foreign activities, investments, or partners may have a reporting requirement. Schedules K-2 and K-3 for reporting partners' income, deductions, and credits from foreign activity are now required for passthrough returns (Form 1065, 1120-S and 8858). This requirement starts with returns with a tax year that ends in 2021. This course discusses each part of these schedules and explain these new reporting obligations in detail. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.Delivery Method: Individual webcastCPE Credit: TaxesProgram Level: BasicThis course is being offered by a 3rd party vendor and will not be accessible on your My CPE page. Webinar access information will be emailed directly to you by CPA Crossings.
Excel Essentials for Today's Accountant: How To Become an Expert in One Day
-
Online
4.00 Credits
Member Price: $129
This course explores the increasingly complex features of Excel that facilitate efficient data analysis. We will introduce numerous analytical methods and techniques by using practical examples to illustrate how to unleash the power of Excel when manipulating, analyzing and reporting information and dive 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. Delivery Method: Individual webcastCPE Credit: Computer software & applicationsProgram Level: Intermediate
Create Measures in Power BI that Define Your Metrics
-
Online
4.00 Credits
Member Price: $149
Unlock the full potential of your data with our specialized course, "Create Measures in Power BI that Define Your Metrics". Designed for professionals who aspire to excel in the dynamic world of data analysis, this 4-hour intensive training delves deep into the advanced functionalities of Microsoft Power BI. You'll embark on a journey to master the art of Data Analysis Expressions (DAX), a powerful tool in the Power BI suite to create metrics. This course is meticulously crafted to transform you into a proficient user, capable of harnessing complex DAX calculations to bring your data to life. The course content is thoughtfully structured to ensure a comprehensive learning experience. Starting with the foundational elements of DAX, you'll rapidly progress to tackle advanced formulas and time-intelligent functions, essential for nuanced data analysis. The highlight of the course is the emphasis on the DAX calculation process, a crucial aspect for validating measures in Power BI. Additionally, the practical application of PivotTables for measure validation will equip you with the skills to confirm the accuracy and effectiveness of your data measures. These advanced techniques are not just theoretical concepts but are presented through engaging, real-world scenarios, enabling you to apply your learning immediately to your daily tasks. This course is an invaluable step towards mastering Power BI and making data-driven decisions with confidence. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.Delivery Method: Individual webcastCPE Credit: Computer software & applicationsProgram Level: IntermediateThis course is being offered by a 3rd party vendor and will not be accessible on your My CPE page. Webinar access information will be emailed directly to you by CPA Crossings.
K2's Paperless Office
-
Online
8.00 Credits
Member Price: $225
Would you like to find important documents in 10 seconds or less? Would you like to ensure your digital information is safe and secure? Would you like to improve workflow efficiency? Of course, you would, and with some planning and guidance, you will realize these and other benefits of a paperless office. Naturally, no one expects a fully “paperless” office, but reducing the amount of paper we shuffle can offer tremendous rewards. This course will teach you the best practices and proven processes for effective document management. Participating in this program will teach you how to implement simple, inexpensive document management systems at an individual, workgroup, or small business level. You will also learn about sophisticated and comprehensive document management systems appropriate for larger offices and organizations, including systems with automated workflow processing. Your instructor will guide you through issues such as digitizing paper files, exporting and importing data from specialized applications into a document management system, essential hardware and software considerations, and the policies necessary to facilitate a successful office. Upon completing this course, you will have a comprehensive understanding of your options and a clear direction for implementing your version of a Paperless Office. Delivery Method: Individual webcastCPE Credit: Information technologyProgram Level: Intermediate
Strategies for Guiding Clients Through Challenging Situations: Tax Insights
-
Online
8.00 Credits
Member Price: $225
In this comprehensive course, practitioners gain a deep understanding of strategic planning considerations and potential hurdles encountered when clients face difficult circumstances. Delving into an array of scenarios often classified as "challenging," the course offers tax insights. From divorce and personal bankruptcy to intricate personal relationship matters, participants will equip themselves to adeptly guide clients through these challenging scenarios by understanding the tax implications. **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. Delivery Method: Individual webcastCPE Credit: TaxesProgram Level: Basic
State Tax Nexus: Frequently Awkward Questions
-
Online
2.00 Credits
Member Price: $79
Award winning discussion leader Mark Hugh discusses both nexus basics and new developments in the dynamic, ever changing world of state income and sales tax nexus. This valuable course answers your frequently asked questions, reviews key factors in examining potential nexus consequences, takes a tour through the rules in states comprising 50% of the US, and identifies free, online multistate resources. *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 Delivery Method: Individual webcastCPE Credit: TaxesProgram Level: Intermediate
Clean, Transform & Load Data in Power BI
-
Online
2.00 Credits
Member Price: $89
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.Delivery Method: Individual webcastCPE Credit: Computer software & applicationsProgram Level: BasicThis course is being offered by a 3rd party vendor and will not be accessible on your My CPE page. Webinar access information will be emailed directly to you by CPA Crossings.
Mastering Partnership Basis: Inside and Outside Basis
-
Online
2.00 Credits
Member Price: $89
This course will provide a detailed analysis of how to determine a partner's tax basis for a partnership interest, with an explanation of the use of both "inside" and "outside" basis determination. An illustrated example with filled in forms will demonstrate how the process works and the potential pitfalls. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.Delivery Method: Individual webcastCPE Credit: TaxesProgram Level: IntermediateThis course is being offered by a 3rd party vendor and will not be accessible on your My CPE page. Webinar access information will be emailed directly to you by CPA Crossings.
Surgent's Data at 30,000 Feet: Traveling Smart with Client and Personal Information
-
Online
2.00 Credits
Member Price: $119
Whether you're heading across town or across the globe, traveling with electronic devices carries real risks to the sensitive client and firm data stored on them. In this session, we'll explore the ethical obligations CPAs have to protect confidential information, including guidance from the AICPA Code of Professional Conduct and applicable laws. We'll examine how data can be accessed - legitimately or maliciously - by third parties during travel, and offer practical strategies to minimize risk, from using loaner devices and mobile device management to coordinating with IT before departure. The session includes current border search rules, international considerations, and actionable tips for staying secure in transit.Delivery Method: Individual webcastCPE Credit: Information technologyProgram Level: BasicThis course is being offered by a 3rd party vendor and will not be accessible on your My CPE page. Webinar access information will be emailed directly to you by Surgent McCoy.
Surgent's Introduction to Charitable Gifting for Individual Taxpayers
-
Online
2.00 Credits
Member Price: $119
This course is designed to provide a comprehensive understanding of charitable gifting strategies and their implications for individual taxpayers. Participants will explore the fundamentals of charitable giving, including the tax benefits, legal considerations, and planning opportunities available under current tax law. The course will cover the types of organizations that qualify for charitable contributions, the income and estate tax treatment of gifts, and the various methods of structuring charitable donations to maximize tax efficiency. Attendees will learn about specific charitable gifting techniques such as donor-advised funds, charitable remainder trusts, and qualified charitable distributions from retirement accounts. The course will also examine tax deduction limits, substantiation requirements, and the impact of state tax credits on charitable giving. By the end of the course, participants will be equipped with the knowledge and tools to guide clients in implementing effective charitable giving strategies that align with their financial and philanthropic goals.Delivery Method: Individual webcastCPE Credit: TaxesProgram Level: BasicThis course is being offered by a 3rd party vendor and will not be accessible on your My CPE page. Webinar access information will be emailed directly to you by Surgent McCoy.
Surgent's Where To Live in Retirement
-
Online
2.00 Credits
Member Price: $119
Deciding where to live in retirement is a challenge that involves a multitude of factors that differ for everyone. Each person and couple should evaluate their current living situation to see where their goals and lifestyles in retirement can best be met. The program covers the various factors that most people should consider when thinking about where to spend their retirement years.Delivery Method: Individual webcastCPE Credit: TaxesProgram Level: BasicThis course is being offered by a 3rd party vendor and will not be accessible on your My CPE page. Webinar access information will be emailed directly to you by Surgent McCoy.
Just Ask Why - Searching for Answers: Generating Solutions
-
Online
4.00 Credits
Member Price: $129
Breaking the Wall of blind acceptance; avoiding habitual complacency and Yoking the dots between cause and effect. Delivery Method: Individual webcastCPE Credit: Business management & organizationProgram Level: Intermediate
Financial Statement Analysis
-
Online
4.00 Credits
Member Price: $129
This hands-on workshop offers an analytical approach for designing, executing, and communicating results of a comprehensive financial statement analysis. We will explore numerous techniques and approaches that facilitate in-depth financial statement analysis. Accountants in public practice will obtain insight regarding analytical procedures, additional client services, and enhanced compliance with professional standards. Accountants in private enterprises will develop more robust techniques for understanding their organization’s financial statements to facilitate forward-thinking decisions and communication to internal and external stakeholders. Delivery Method: Individual webcastCPE Credit: AccountingProgram Level: Intermediate