Professional Development and Event Catalog
Excelling at Excel: The Magic of Power Query
12:00pm - 1:47pm
Online
2.00 Credits
Member Price: $79
See more dates
Elevate your data analysis capabilities with our focused course on Power Query. Tailored for financial professionals, this training will show you how to get started using Power Query and teach you some of the ways to take advantage of its ability to handle messy data and automate repetitive tasks. Harness the efficiency of Power Query to revolutionize the way you work with data. Learn how to "program" your tasks once and set them on repeat, eliminating the need for repetitive, robotic work. This automation not only saves time but also ensures consistency and accuracy in your data processes. Whether you're dealing with complex datasets or simply looking to streamline your reporting processes, this course will equip you with the tools and knowledge to make Excel work for you like never before.
More Dates
Cash Management: Strategies for Long-Term Success
12:00pm - 1:49pm
Online
2.00 Credits
Member Price: $79
See more dates
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.
More Dates
Taking a Global View of Professional Ethics
12:00pm - 1:50pm
Online
2.00 Credits
Member Price: $79
See more dates
Just as there is some convergence of U.S. accounting standards (GAAP) with international standards (IFRS), a convergence of U.S. professional ethics standards (AICPA Code of Professional Conduct) with the international Code of Ethics for Professional Accountants is continuing to emerge. This workshop compares these two sets of ethics standards, emphasizing both the theoretical aspects and practical implications for today's accounting professionals.
More Dates
Financial Decisions that Led Two Businessmen to Prison
12:00pm - 2:00pm
Online
2.00 Credits
Member Price: $89
See more dates
Two college graduates built impressive careers: One worked in sales, the other in technology and investing. Both of those people made decisions in the course of their business that led to government investigations. They had to hire attorneys, go through judicial processes, face charges, and plead guilty. Each of those people are on their way to prison. Learn from the lessons they offer. We interview both financial professionals, and they tell us more about how their decisions influenced the consequences that followed. 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
HR Investigations - Episode 2 - Interview Techniques
12:00pm - 2:00pm
Online
2.00 Credits
Member Price: $79
See more dates
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 provides best practices for interviewing to gather accurate information, such as creating and asking open ended questions, effective listening, and understanding verbal and non-verbal communication. Attendees will end the session with takeaways to immediately implement in future HR investigations. Two of three Episodes in the series.
More Dates
Surgent's The Accountant as the Expert Witness
12:00pm - 2:00pm
Online
2.00 Credits
Member Price: $99
See more dates
As litigation becomes more complex, attorneys are relying more on accountants to serve as consulting experts or expert witnesses at trial. Serving as an expert witness is not as difficult as you might expect. Accounting experts educate lawyers and jurors on issues such as valuation, tax liability, and forensics. Learn how accountants become expert witnesses, the role they play during pre-litigation through to trial, and the techniques experts employ to avoid challenges from opposing counsel.
More Dates
Measuring Audit Risks
12:00pm - 2:49pm
Online
3.00 Credits
Member Price: $99
See more dates
In order not to perform an excessive number of audit procedures (over audit) auditors must perform procedures in order to determine in what areas are there weak internal controls that could result in a risk that the financial statements would be materially misstated and not be detected. SAS No. 122, AU 300 – 499, Measuring Audit Risk provides guidance as well as required procedures that must be performed in every audit in order to determine the risk of material misstatement. No longer can the auditor state that they assess the risk of material misstatement at maximum without having a basis for making such assessment. As a result, the standards now require that the auditor make such an assessment of a material misstatement of the financial statement on every audit in order to have a basis for such assessment. This program is an overview of the statement documentation requirements in assessing such a risk.
More Dates
Ethics - A Line in the Sand; Implications for Daily Business
12:00pm - 3:49pm
Online
4.20 Credits
Member Price: $129
See more dates
Ethical behavior continues to be a problem in society and even in the CPA ranks. "Ethics - A Line in the Sand" looks at the behavioral issues that influence how CPA's act. The course will address why individuals make ethical blunders, the state of ethical conduct in business organizations, the relationship between strong cultures, policy and procedures and successful ethical work environments. In addition, the course will highlight the one behavior to watch for as an indicator of potential ethical violations.
More Dates
Complete Guide to Analyze Data with Excel PivotTables
12:00pm - 4:00pm
Online
4.00 Credits
Member Price: $149
See more dates
Unlock the full potential of Microsoft Excel PivotTables with this comprehensive course. This training is designed to equip participants with the skills to effectively analyze and summarize data, transforming raw numbers into actionable insights. Whether you're a seasoned professional or new to data analysis, this course provides an in-depth understanding of PivotTables and their capabilities, helping you uncover patterns, compare data, and make informed decisions. The program includes a step-by-step approach to creating and customizing PivotTables, focusing on how to use them to analyze data efficiently. Participants will learn how to group and filter data, identify trends, and apply advanced features to solve real-world business challenges. Beyond technical knowledge, this course introduces data visualization through PivotCharts, teaching participants how to present their analysis effectively to stakeholders. By the end of the course, you'll not only master PivotTable fundamentals but also gain advanced techniques to streamline data analysis and support strategic decision-making in any context. 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
Internal Control - Testing for Operating Effectiveness
12:30pm - 2:30pm
Online
2.00 Credits
Member Price: $89
See more dates
Properly designed and effectively operating internal control over financial reporting is critical for preventing, or detecting and correcting, material misstatement. This course describes how to satisfy the audit requirements related to taking a control reliance strategy by testing the operating effectiveness of internal controls, while promoting an effective and efficient financial statement audit. 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
PowerPoint: Tips & Tricks for Today's Accountant
1:00pm - 2:46pm
Online
2.00 Credits
Member Price: $79
See more dates
PowerPoint is a widely available resource that is potentially underutilized by accountants because many accountants do not stray beyond Excel and Word in the Microsoft Office suite. You will learn how to create and edit a professional PowerPoint slide deck. This session places particular emphasis on efficiency tips and tricks that will allow you to develop creative, professional visual aids while minimizing time and effort. The course’s author will share personal insights he has cultivated throughout more than two decades of public speaking. Although the session will focus on creating and editing slides, we will illustrate best practices for presentation delivery. We will also explain how PowerPoint can be used for purposes other than delivering presentations.
More Dates
Ethics and Technology for CPAs
1:00pm - 3:00pm
Online
2.00 Credits
Member Price: $89
See more dates
Explore the ethical principles included in the Code of Professional Conduct that address the emerging practice issues created by new technologies. Consider how technologies may impact audit quality and the integrity of the financial systems, and whether they create a need for CPAs to adjust their skill sets to address those challenges. Look at the potential ethical challenges created by the data related to privacy, security, and its application. Discuss the changes being proposed to address emerging ethics challenges. 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
Power BI - Bringing It All Together for Data Analysis
1:00pm - 3:00pm
Online
2.00 Credits
Member Price: $89
See more dates
Power BI - Bringing It All Together for Data Analysis is an advanced-level course designed for professionals looking to integrate and optimize their use of Microsoft Power Pivot and Power BI. Building on the foundational knowledge from previous courses, this session focuses on the crucial next steps after creating data models and measures, guiding participants on how to fully utilize the potential of these tools to uncover insights and create impactful, actionable visualizations. This course takes a deep dive into the critical aspects of using Power BI to its fullest potential, emphasizing a holistic approach to data analytics. You'll learn how to build a streamlined workflow, ensuring every step in your data journey contributes to actionable insights. The course also focuses on optimizing performance for data models, utilizing advanced features of Power BI Services, and moving beyond basic data models to create advanced solutions tailored to real-world business needs. By the end of the course, you'll be able to synthesize all your Power BI skills to design and deliver powerful analytics solutions tailored to any audience. Whether you're presenting to stakeholders, sharing insights across teams, or managing enterprise-level reporting, this course will equip you with the tools and strategies to succeed. Perfect for Power BI users looking to tie all the pieces together into a comprehensive, efficient workflow. 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 Successfully Completing an Estate Tax Return - Form 706
1:00pm - 3:00pm
Online
2.00 Credits
Member Price: $99
See more dates
Since the early 2000s, the estate tax burden on taxpayers has gradually decreased along with the number of practitioners specializing in the field. Nevertheless, some of your most wealthy clients will owe estate tax and this issue will eventually be thrust upon you. Finding an affordable, competent specialist who you trust to work with you and your client may be difficult. Learning the basics of the tax and how to complete the form will give you confidence to help your clients navigate that difficult time.
More Dates
Surgent's Tax Research
1:00pm - 3:00pm
Online
2.00 Credits
Member Price: $99
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 differences between primary and secondary sources, and detailing the steps in the tax research process.
More Dates
Global IIA Standards (GIAS) Fundamentals and Domain I and II - PART 1
1:00pm - 3:01pm
Online
2.20 Credits
Member Price: $79
See more dates
In May 2023, the IIA released a draft of the new Global Internal Audit Standards. The intent was to provide more effective standards for Internal Audit globally. The new Global Internal Audit Standards were released on January 9, 2024, and will become effective January 9, 2025. The previous version, the International Standards for the Professional Practice of Internal Auditing, released in 2017, remains approved for use during a one-year transition period. The Global Internal Audit Standards guide the worldwide professional practice of internal audit. They serve as a basis for evaluating and elevating the quality of the internal audit function. The Standards use 15 guiding principles with five separate domains that enable effective internal audit implementation and examples of evidence of conformance. The Global Standards are organized into five domains. Domain I: Purpose of Internal Auditing Domain II: Ethics and Professionalism Domain III: Governing the Internal Audit Function Domain IV: Managing the Internal Audit Function Domain V: Performing Internal Audit Service
More Dates
Practical Tools and Tips to Help CPAs Manage Risk (Tax Services Focus)
1:00pm - 5:00pm
Online
4.00 Credits
Member Price: $159
See more dates
Managing the risk of offering tax services Providing tax services can help attract new clients to your firm, unlocking significant growth. At the same time, there are risks to offering tax services. The tax services practice area is particularly prone to professional liability claims, according to the latest data. You can mitigate the risks of professional liability claims by implementing processes designed to curb the potential for client disputes. Protecting your firm from risk This session will present day-to-day risk management protocols and provide realistic ways to adjust your operations to insulate your firm and staff from risk. You can learn tips for: Client acceptance Engagement letters Client communications Onboarding Billing and fee management Acknowledging risks beyond your tax practice Although tax services represent a significant share of all malpractice claims against CPA firms, other practice areas come with their own risks. You'll also examine the risks of offering certain accounting services and learn how to create processes that reduce the risk of malpractice. Additional benefits In addition to earning CPE credits, CNA policyholders may earn up to a 10% premium credit for three consecutive years on their AICPA Professional Liability Insurance policy. *Please consult your agent for further details regarding eligibility.*
More Dates
Best Practices: Conducting Meaningful Walkthroughs
1:30pm - 3:30pm
Online
2.00 Credits
Member Price: $89
See more dates
This course will serve as an introduction to conducting effective walkthroughs to gain an understanding of the client's transaction processes as well as identifying internal controls within each process. This course will review the procedures, questions to ask, and documentation requirements of walkthroughs. It will also include real-world examples of the red flags that may arise while executing a walkthrough. 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
HR Investigations - Episode 3 - Gathering-Analyzing-Reporting
2:00pm - 3:06pm
Online
1.00 Credits
Member Price: $39
See more dates
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 provides best practices for gathering and analyzing evidence and reporting the investigation results. Attendees will end the session with takeaways to immediately implement in future HR investigations. Three of three Episodes in the series.
More Dates
S Corporations - Overview
2:00pm - 4:00pm
Online
2.00 Credits
Member Price: $79
See more dates
This course provides an overview of the key aspects and tax implications of S Corporations. Participants will learn the mechanics of electing Subchapter S status, compare S Corporations to other entity structures, and explore compliance requirements such as corporate formalities. Highlights include a detailed discussion of Form 1120S, accountable plans, taxable fringe benefits, officer reasonable compensation, and IRS audit strategies. The course also covers Schedules K-1, K-2, and K-3, as well as the concept of effectively connected income. Practitioners will gain practical insights into advisory services and strategies for representing clients before the IRS. *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