CPE + Events Catalog
Clean, Transform & Load Data in Power BI (2 hours) [NT]
-
Online
2.0 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
Internal Control Changes for Remote Workers (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
For the past two decades the trend has been to move away from brick and mortar offices and have a greater number of people work or telecommute from home. Because of the upheaval caused by recent events, the rate of this move has been accelerated. This has and will continue to create control challenges and organizations must work to address these. Such things as moving from time based employee value to task completion based measurement and the ability to drive needed inter-company communication are just a sample of the issues with which entities must contend. This session looks at the benefits and pitfalls of workers that telecommute. It then discusses important risks and controls to consider as this trend continues and evolves in the business world. 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
Retirement Planning Issues: Where We Stand Now (4 hours)
-
Online
4.0 Credits
Member Price: $129
See more dates
This course is designed to equip CPAs, EAs, attorneys, and tax professionals with the essential knowledge and strategies needed to navigate the latest developments. Explore innovative approaches to maximize retirement savings, discuss tax- efficient retirement plan options, and align estate planning techniques with current trends. Gain a thorough understanding of altered rules for Required Minimum Distributions (RMDs) and discover how to optimize estate plans in response to changing regulations. This update is tailored for professionals seeking practical insights in the realm of contemporary retirement planning. **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
Forensic Accounting: Crafting Expert Reports (4 hours)
-
Online
4.0 Credits
Member Price: $149
See more dates
When forensic accountants are hired to conduct an analysis and investigations, they are commonly expected to write a report. This report can be short or long, depending on the circumstances. This presentation is how to write an effective expert report that will withstand scrutiny of both parties of litigation and the court. The presentation will also include best practices, ethics, and components of an effective report. 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
ChatGPT and Advanced Policy Manual Development for ACCTs (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
This course provides a concise overview of how to leverage ChatGPT and other AI tools to develop comprehensive, efficient, and compliant policy manuals for accounting firms. The revolutionary PRIME Method (Policy Refinement and Integration through AI-Managed Elaboration) empowers accounting professionals to create sophisticated policy documentation while maintaining human oversight and expertise. 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
Keeping Up with the FASB (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
This course will explore significant elements of the FASB's technical agenda, focusing on recent updates to revenue recognition and lease accounting standards. A Special Purpose Framework overview will be provided, which may reveal salient alternatives to U.S. GAAP for certain entities. 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
Installment sales: Maximize Tax Benefits and Stay Compliant (1 hour)
-
Online
1.0 Credits
Member Price: $55
See more dates
This course explores the complex rules of installment sales, with a focus on their tax treatment and strategies to maximize the benefits. 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
The Controllership Series - The Controllers Role in Procurement Function (1.2 hours)
-
Online
1.2 Credits
Member Price: $39
See more dates
The procurement function is a critical area of organizations where spend is a top priority. The Controllership function is involved in spend management. It is logical that the Controller should take a role in working with the procurement function. The procurement function may report to various areas within an organization including the Chief Operating Officer (COO), Chief Procurement Officer (CPO), Chief Executive Officer (CEO) and the Chief Financial (CFO) or Accounting Officer (CAO). Regardless of the reporting line of the function, the accounting and controllership functions must have an integral understanding of all processes involved within procurement. This understanding assists the controller and accounting area in properly optimizing and controlling costs associated with the process.
More Dates
Emerging Innovations in Forensic Data Analytics, Crypto Currencies and AI, ChatGPT (2 hours)
-
Online
2.0 Credits
Member Price: $79
See more dates
In this course, participants will learn about key trends and innovations impacting the field of forensic data analytics. From generative AI to ChatGPT, machine learning and transaction review, data sharing consortiums and cryptocurrency trends, this course is for the futurist who wants to be leading edge in compliance and anti-fraud technology innovation.
More Dates
Microsoft Outlook "Must Know" Email Tips (2 hours) [NT]
-
Online
2.0 Credits
Member Price: $89
See more dates
If you use Outlook on a daily basis to process your email, chances are pretty good that you are missing out on a lot of opportunities to improve your efficiency in composing, processing and organizing your messages. There are many different features in Outlook that often get overlooked, even though we are working in the app all day, every day. John Higgins, a strategic advisor to the profession on Microsoft 365 deployment, will review numerous tips and features to improve your productivity in Outlook. You will learn many time-saving, practical ways to improve the quality of your email message. 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 A Complete Guide to Form 1099-K (2 hours)
-
Online
2.0 Credits
Member Price: $99
See more dates
The Internal Revenue Code (IRC) requires entities making certain types of payments, including business payments to contractors, to file information returns with the IRS. Information returns are intended to improve voluntary compliance with tax law by providing information about potentially taxable transactions to the IRS and taxpayers. A payment settlement entity (PSE) must file Form 1099-K for payments made in settlement of reportable payment transactions for each calendar year.
More Dates
Surgent's The Risks and Benefits of ChatGPT and Artificial Intelligence (2 hours)
-
Online
2.0 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
Surgent's Business Law for Small Business Owners (4 hours)
-
Online
4.0 Credits
Member Price: $159
See more dates
One of the most intimidating aspects of going into business for yourself is compliance. Tax, employment, and regulatory laws are difficult to navigate, so it often falls on the CPA to know the basics in these areas to help their clients avoid costly litigation. In this course, we will cover basic compliance areas for small business owners. We will look at the main elements of a contract, taxation of entity types, worker classification, property law, and many of the other areas that are often overwhelming for small business owners. By being able to speak to these issues, practitioners will be able to add value and help their small business owner clients grow and thrive.
More Dates
The Bottom Line on the New Lease Accounting Requirements (4 hours)
-
Online
4.0 Credits
Member Price: $225
See more dates
FASB ASC 842, *Leases* explained Understanding lease fundamentals is essential to applying FASB lease requirements appropriately. As such, you'll delve into key concepts that define what a lease is, as well as basic lease accounting topics, such as: Contracts containing leases Lease classification Amortization of the right-of-use asset Impairment considerations Lease presentation and disclosure requirements Comprehensive examples and case studies will guide you through approaches to help you adopt accounting guidance for FASB ASU 2023-01. You'll also review the presentation and disclosure requirements, and other topics, including: Lease versus non-lease components Sales-type lease Direct financing lease Operating lease Lease terminations
More Dates
Navigating IRS Authorizations: Form 2848 & Form 8821 (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
Providing a practical overview of the IRS Power of Attorney, Form 2848, and IRS Tax Information Authorization, Form 8821. Participants will explore the differences between these forms, understand when each is required, and how to comply with IRS requirements for representing clients and accessing their tax information. The course will cover practical issues, ethical considerations, and best practices for managing client authorizations through the IRS Centralized Authorization File (CAF) system. 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
Microsoft 365: Save More Time, Make More Money (4 hours) [NT]
-
Online
4.0 Credits
Member Price: $149
See more dates
Join us for an insightful presentation featuring John Higgins, a renowned technology advisor to the CPA profession, who has assisted many firms with Microsoft 365 deployment. Discover how to leverage the Microsoft 365 suite of applications to unlock new efficiencies and opportunities within your business organization or CPA firm. Don't miss this chance to supercharge your operations with cutting-edge tools! Whether you are working in public practice or business and industry, this event will provide you with a return on investment many times greater than your investment to attend. 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
How to Audit Prepaid Expenses (2 hours)
-
Online
2.0 Credits
Member Price: $79
See more dates
Understanding how to effectively audit prepaid expenses is a key skill for audit staff. This course provides a comprehensive overview of the fundamentals, including the applicable audit assertions and common risks and threats associated with the prepaid expense balance. Participants will learn how to perform substantive auditing procedures to ensure accuracy and reliability, with guidance on applying these techniques to real-world scenarios. Designed to enhance practical knowledge, this session equips auditors with the tools and confidence needed to navigate prepaid expense audits with proficiency.
More Dates
Hot Topics Accounting Update (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
Many accountants desire to have a quick overview of only the most current issues in accounting and financial reporting. This course will provide an executive summary of the most important changes in U.S. GAAP. 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
Mergers & Acquisitions: Tips and Speed Bumps to Avoid (2 hours) [NT]
-
Online
2.0 Credits
Member Price: $79
See more dates
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.
More Dates
Surgent's Introduction to Required Minimum Distributions (2 hours)
-
Online
2.0 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
