Professional Development and Event Catalog
Surgent's Excel Shortcuts for Accountants
1:00pm - 3:00pm
Online
2.00 Credits
Member Price: $99
See more dates
This webinar presents a variety of time-saving ideas, shortcuts, and tips that are sure to boost personal productivity. We discuss better summing, address one of the biggest pitfalls that Excel users have faced over the past 25 years, present the most important keyboard shortcuts, demonstrate a better alternative to hiding rows or columns, illustrate how to quickly navigate to other workbooks and files, and demonstrate using Excel with styles.
More Dates
Surgent's The Risks and Benefits of ChatGPT and Artificial Intelligence
1:00pm - 3:00pm
Online
2.00 Credits
Member Price: $99
See more dates
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.
More Dates
Tax Practice Ethical Challenges and Circular 230
1:00pm - 3:00pm
Online
2.00 Credits
Member Price: $79
See more dates
This presentation will provide a detailed analysis of the Circular 230 rules for conduct of a tax practice, with a review of the political, legislative and regulatory rules impacting every accounting and tax professional. Best practices and guidance provided by the AICPA’s Code of Professional Conduct will 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.
More Dates
Conducting a Remote Audit
1:00pm - 5:00pm
Online
4.00 Credits
Member Price: $225
See more dates
Understand the basics of remote auditing and how it can be used in your engagements Remote auditing has become increasingly popular in recent years. Learn how to apply auditing standards to real-life examples of remote auditing in this all-new webcast. Join us to explore ways to overcome the challenges of remote auditing and conduct efficient engagements for your clients.
More Dates
Controls to Secure the Growing Digital Footprint
1:00pm - 5:00pm
Online
4.00 Credits
Member Price: $149
See more dates
The amount of electronic content that business organizations contend with is growing at incredible rates. Terms like "Big Data" and "Information Overload", are being used by overwhelmed information workers on a daily basis. Additionally, because of the move to a much larger telecommuter footprint, electronic data is now even more prevalently utilized. This session discusses the places that businesses keep digital information and addresses the importance of securing corporate electronic data. The material effectively shows ways to achieve high security standards for content stored in fixed locations, on mobile devices and in the cloud. Participants in this session will gain an understanding of the concepts needed to improve the way they, and their companies secure digital information. 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
Exploring Internal Controls That Could Have Prevented Frauds
1:30pm - 3:30pm
Online
2.00 Credits
Member Price: $89
See more dates
This course examines 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' ability to accomplish their nefarious acts. 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 Select Estate and Life Planning Issues for the Middle-Income Client
1:30pm - 5:00pm
Online
4.00 Credits
Member Price: $159
See more dates
Clients think that estate planning only applies to the very rich. In truth, there are many issues of critical concern for which the middle-income client needs to plan. This course is a must-attend for all Accounting and Financial Professionals who work with middle-income clients and are looking for ways to provide additional quality services. Updated for developments relative to estate tax changes.
More Dates
Money Laundering 101 for CPAs
1:30pm - 5:30pm
Online
4.00 Credits
Member Price: $149
See more dates
CPAs spend most of their working lives reviewing bank statements and books and records of businesses. They are experts in understanding how to prepare financial statements according to GAAP. But would a CPA know a possible money laundering transaction if they saw it? Would they know about a money laundering business? Money laundering is a subject of many action and thriller movies, but rarely understood. This presentation will educate the CPA in understanding the basics of money laundering and how to identify money laundering. This presentation will help the CPA know the truth about money laundering, how to identify it, the statutes that define it, and the court cases that interpret it. 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
Before You Let Them Go: A Whole Brain Approach to Helping Team Members with ADHD Thrive in Your Organization
2:00pm - 3:01pm
Online
1.00 Credits
Member Price: $39
See more dates
Many employees with ADHD struggle with productivity. It’s heart-breaking to feel you have to let a team member go due to lack of performance. This course is for HR Professionals and Team Leaders who want more tools in their tool belt to help improve retention with ADHD team members. You will learn whole brain strategies to help your team members with ADHD improve performance, so they can not only survive but thrive. This innovative science-based approach is designed to help people with ADHD get more done in less time with a process designed with their creative brain in mind.
More Dates
Leveraging Analytical Procedures to the Fullest on Audits - Case Studies in Strengthening Audit Evidence
2:00pm - 3:46pm
Online
2.00 Credits
Member Price: $79
See more dates
Peer review deficiencies commonly relate to the design, documentation, and evaluation of the results of analytical procedures. This course will provide examples of how to strengthen evidence resulting from preliminary, substantive, and final analytics. It will reinforce the elements of strong analytical procedures that may enhance the quality of audits.
More Dates
Ethics, Tax Practice & The Cannabis Industry
2:00pm - 4:00pm
Online
2.00 Credits
Member Price: $79
See more dates
This course provides an in-depth discussion of the ethical considerations and compliance requirements when working with taxpayers in the cannabis industry. Attendees will review the implications of Circular 230, preparer due diligence, and the specific challenges posed by conflicting federal and state laws. Federal case law, standards set by Boards of Accountancy, and guidance from the IRS Office of Professional Responsibility will also be covered to help practitioners navigate this complex area with confidence.
More Dates
Form 1120S - Preparation and Analysis
2:00pm - 4:00pm
Online
2.00 Credits
Member Price: $79
See more dates
This course is designed for financial professionals looking to understand Form 1120S. It covers the essential aspects of S corporation taxation, including the preparation of Form 1120S, determining taxable income, and accurately reporting and allocating income, deductions, and credits. Participants will also learn how to calculate shareholder basis and understand the strategic advantages and limitations of an S corporation.
More Dates
Surgent's Introduction to Required Minimum Distributions
2:00pm - 4:00pm
Online
2.00 Credits
Member Price: $99
See more dates
Required minimum distributions (RMDs) must be taken from certain tax-deferred retirement accounts, starting when the account owner reaches their applicable age. The RMD rules are complex and must be simplified to help ensure clients understand them. Accounting and finance professionals must understand the basics of RMDs for IRAs and employer plan accounts so as to help IRA owners, plan participants, and beneficiaries meet their RMD obligations and avoid penalties that apply to RMDs not taken by their applicable deadline. Accounting and finance professionals should also be able to demonstrate tax-efficient solutions for RMDs. This course will walk accounting and finance professionals through the fundamental concepts and rules that apply to RMDs, demonstrate how to calculate RMDs, and explain how to correct RMD errors. It can be taken by anyone, including those without any experience working with RMDs. The course will include cases to promote understanding of the rules.
More Dates
Build a Data Model for Analysis in Power BI
2:00pm - 6:00pm
Online
4.00 Credits
Member Price: $149
See more dates
This intensive 4-hour course offers a deep dive into data modeling in Power BI, with a focus on Microsoft Excel's Power Pivot but applicable to Power BI Desktop. Designed for professionals looking to enhance their data analysis skills, the course covers the essential aspects of building robust, efficient data models. Participants will learn how to integrate different data sources, create meaningful relationships, and develop insightful metrics to drive business decisions. Participants will explore various aspects of data modeling such as establishing relationships, creating calculated columns, and understanding the intricacies of basic DAX (Data Analysis Expressions) measures. These skills are vital for anyone looking to extract meaningful insights from large and complex datasets. Attendees will be introduced to advanced concepts such as the strategic use of calculated columns versus measures, and the differentiation between explicit and implicit measures. This knowledge is crucial for developing sophisticated data models that not only provide accurate results but are also efficient in terms of performance. The course will also cover the creation and use of hierarchies and Key Performance Indicators (KPIs), essential for any robust data analysis framework. To ensure that the learning is well-rounded and applicable, the course includes practical exercises in using pivot tables within Power BI. This helps in validating and enhancing the measures and models created, ensuring they are robust and reliable for real-world application. "Build a Data Model for Analysis in Power BI" is an essential course for professionals aiming to leverage the full potential of Power BI 's data model. Whether you're looking to streamline your data analysis process, enhance your reporting capabilities, or drive insightful business decisions, this course will equip you with the necessary skills and knowledge. 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
Leadershift Ethics: Things Must Change!
2:30pm - 4:30pm
Online
2.00 Credits
Member Price: $89
See more dates
With the rapid pace of change, change now happens daily in business and our personal lives. It can be difficult to navigate change when right and wrong get a bit fuzzy. New processes, new technology, new circumstances and new impacts to people must be measured and decisions made as the change evolves. Change always becomes something different than what was originally planned or imagined. In this session, learn how to measure your ethics through change. You will learn how to filter everything you do during change through a simple litmus test. Through the power of story, you will learn from the lessons of other organizations and their ethical mistakes. Lastly, you will take away what is required to manage yourself so that when ethical decisions arise, you have the mental capacity to manage through it well. 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
Just Ask Why - Searching for Answers: Generating Solutions
2:30pm - 6:04pm
Online
4.00 Credits
Member Price: $129
See more dates
Breaking the Wall of blind acceptance; avoiding habitual complacency and Yoking the dots between cause and effect.
More Dates
Employee Benefit Plans Group Meeting
3:00pm - 4:00pm
TBD
0.00 Credits
See more dates
The Employee Benefit Plans Group monitors developments in the employee benefit plans arena. Friendly, interactive meetings include roundtable discussion of changes affecting plans, auditors, and employers. The group features diversified professionals e.g., auditors, actuaries, third party administrators, and attorneys, engaged in the EBP area. Outreach to the broader membership includes an annual networking social and sponsoring of an annual Employee Benefit Plans Conference. Agenda topics will be provided prior to the meeting. This will be an in-person meeting at CTCPA's new offices.
More Dates
Surgent's Data Security: Best Practices to Protect Your Business and Yourself
3:00pm - 4:00pm
Online
1.00 Credits
Member Price: $59
See more dates
Data security is a front-of-mind topic for most businesses because the risk and cost statistics are sobering. Each of us is in the crosshairs because a typical internet-connected computer faces a cyberattack every 39 seconds. Businesses of all sizes should be cognizant of the ethical issues that must be considered when planning their approach to privacy and data security. In this webinar, we will explore both the risks we have traditionally faced in the workplace personally, as well as the novel set of data privacy threats and compliance challenge issues employers face with a remote and mobile workforce.
More Dates
Benford's Law and Other Digital Analysis Techniques
3:00pm - 4:38pm
Online
1.80 Credits
Member Price: $79
See more dates
Numbers and especially the digits within those numbers can conceal a lot of information. Benford's Law and other digital analysis techniques can be the keys to unlocking that information. This session will explain what Benford's Law is, how it works, and how it can be used to reveal bogus information and made-up data. Accountants and auditors should understand how to use this valuable audit tool as well as other digital analysis techniques. But, if you attend this session, you must promise not to reveal the secret behind these techniques to any fraud perpetrators.
More Dates
Shortcuts that Excel Users Love
3:00pm - 5:00pm
Online
2.00 Credits
Member Price: $89
See more dates
Many people that use Microsoft Excel know a great deal about the functionality of the application. There are, however, a tremendous number of hidden tools that a high percentage of users overlook. Additionally, there are newer features that some have not had the opportunity to explore. This session shows some of the numerous time-saving tools and features that often go unused by spreadsheet creators. People that wish to become more efficient when using Excel should take this session! This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.