CPE Catalog
Note
AICPA On-Demand & Self-Study courses take up to 24 hours to process.
2024 Advanced Excel: Hidden Secrets and Gems
-
Online
2.00 Credits
This course dives 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.
2024 Upholding Independence While Holding Your Client's Hand
-
Online
2.00 Credits
Many entities look to their CPA as a trusted advisor when tackling complex accounting topics. This is more relevant now than ever. The FASB's big three accounting pronouncements involving revenue recognition, leasing and credit losses have placed a magnifying glass on this reality. Practitioners need to exercise caution to ensure they maintain independence as they assist their review and audit clients with such matters, as well as with compilation engagements. This course addresses these issues and explores best practices and guidance provided by the AICPA's Code of Professional Conduct. **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.
2024 The Preparation of Form 706 and 709 - Understanding the Law
-
Online
2.00 Credits
Understanding the complexities of estate and gift taxation can be challenging for many financial professionals, especially those who lack direct experience in this area. In this comprehensive course, participants will gain a solid foundation in Federal estate and gift tax law, providing them with the necessary tools to confidently handle tax compliance issues related to Forms 706 and 709. By exploring the details of the Internal Revenue Code sections pertinent to estate and gift taxation, attendees will gain a thorough understanding of key concepts, including deductions, valuations, and tax credits. This practical knowledge will not only enhance their expertise but also empower them to provide effective tax planning strategies for their clients. Throughout the course, participants will investigate essential topics such as the valuation of assets, deductions for funeral and administrative expenses, charitable and marital deductions, and the calculation of tax credits. By mastering these critical areas, financial professionals will be better equipped to navigate the challenges of estate and gift taxation, ultimately enabling them to provide comprehensive and effective tax planning services for their clients. Whether you're looking to expand your expertise or deepen your understanding of tax compliance issues, this course offers invaluable insights and practical knowledge that can immediately be applied in your practice. **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.
2024 Tax Practice Ethical Challenges and Circular 230
-
Online
2.00 Credits
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.
SAS No. 122, AU 240, Consideration of Fraud in a Financial Statement Audit
-
Online
3.00 Credits
When performing a financial statement audit, auditors have always been responsible for the detection of anything that would cause a material misstatement of the financial statements whether caused by error of fraud. However, in the past the audit profession focused on material misstatements due to errors and more or less ignored the possibility of misstatements due to fraud. Now, SAS No. 122, AU 240 requires significant documentation as to what the auditor did in order to determine if there any material risk of a misstatement of the financial statements. This presentation is an overview of what the auditor is to document in there working papers on every financial audit as to the procedures they performed in order to determine the risk of a material misstatement. If a material risk is discovered, they are then required to document what they did in order to determine if the financial statements were misstated.
K2's 2023 Introduction To Excel Macros
-
Online
4.00 Credits
You have used Excel for years and perhaps Lotus 123 before that. And through all that time, you have repeatedly said, “One day, I’ll learn how to write macros.” Finally, that time has arrived because this four-hour program will introduce you to the wide world of Excel macros and Visual Basic for Applications (VBA). This course teaches the fundamentals of creating and working with macros in Excel and is designed specifically for those with little experience working with macros. More specifically, taking this course will teach you how to use Excel’s Macro Recorder to write simple yet effective macros. You will also learn how to secure and share macros with other Excel users and create user-defined functions to solve specific accountant-centric problems in Excel. Further, you will learn how to create macros that run when a user opens a workbook and VBA basics. Don’t miss this unique opportunity to learn how to begin working with macros – one of Excel’s most powerful tools.
K2's 2024 Small Business Accounting Shootout
-
Online
4.00 Credits
Small business accounting solutions have never been better, with many fantastic options. In this session, you will learn about the relative strengths of these platforms so you can make the right choice when selecting and implementing a solution.
Mastering The Three Pillars of Cybersecurity: Exploring the Technology Pillar
-
Online
1.00 Credits
Are you looking to fortify your practice against the ever-growing threats in the digital landscape? Join us for the second installment of our exclusive webinar series, "Mastering Cybersecurity," brought to you by Practice Protect. In today's digitally connected world, the need for comprehensive cybersecurity is paramount. With cyberattacks becoming more sophisticated, it's crucial to stay ahead of the curve in protecting your sensitive client data. This webinar series is designed to equip CPAs with the knowledge and tools needed to secure their practices and client information effectively.
Advanced Negotiations: Beyond Getting to Yes
-
Online
1.00 Credits
Anytime someone says "I want," "I need," or "Will you," you are in a negotiation. For decades, the negotiation techniques described in "Getting to Yes" by Fisher and Ury of the Harvard Negotiations Project were the world's standard negotiation methods. These techniques involved collaborative methods for discovering how to make the "pie" bigger and then split it. More recent research on human psychology has revealed new methods that will allow you to do even better. Sometimes, you can't settle for getting half of what you want. Sometimes you have to have it all. This webinar explores negotiation's human side, to give you powerful people skills that will let you get more. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Small HR Team, Big Impact: 3 Employee Engagement Strategies for Lean HR Departments
-
Online
1.00 Credits
In the modern corporate landscape, the challenge for lean HR departments isn't just managing administrative tasks—it's about curating a meaningful and enriching employee journey. Small HR teams are uniquely poised to offer a level of personalization and touch that larger departments might struggle to replicate. These compact teams have the potential to craft individualized experiences, ensuring that each step of an employee's journey, from onboarding to advancement, resonates deeply and positively. Yet, knowing the potential and harnessing it are two distinct tasks. This session provides attendees with a deep dive into three transformative engagement strategies tailored for lean HR environments. By placing the employee journey at the heart of these strategies, HR professionals can ensure every interaction, every milestone, and every touchpoint is optimized for engagement, satisfaction, and growth. Discover methods that don't just streamline processes, but elevate the entire employee experience, creating a lasting impact on both individual careers and the organization's culture.
2024 Partnerships/LLCs: Understanding Tax Basis Capital Accounts
-
Online
2.00 Credits
This program addresses the most recent developments impacting partnerships operating as LLCs, with a focus on legislative, administrative, and tax form changes. Emphasis will be placed on partners “tax basis” capital accounts – now required for tax form reporting. **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.
Securing Your Data with a Password Management App - Updated
-
Online
2.00 Credits
Cybersecurity protection is one of the most important responsibilities of every CPA professional to protect the confidentiality of sensitive client information. While there are many aspects of cybersecurity that need to be addressed, the biggest vulnerability to protect against is unauthorized access to your application login credentials. Once your login credentials are breached, the cybercriminal essentially has the keys to your data kingdom. John Higgins, a national leader in the CPA technology, will demonstrate the ease with which you can protect all of your login credentials with maximum security with minimal expense. You will leave this course prepared to deploy this state of the art security tool in your organization. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Leadershift: Drive Results Through Ethical Performance Mgmnt
-
Online
4.00 Credits
Do you find yourself challenged to achieve the results you want? While leading employees can be one of the most challenging activities, it is also one of the most impactful leadership skills few seem to master. Inspirational leadership looks like lifelong employees reaching their full potential AND impactful business results that are repeated year after year. Striking the balance between these two critical aspects does not have to be rocket science. In this power-packed course, the formula to be an Inspirational leader has been masterfully developed and covers the soft skills of Inspirational leadership and the Results Model: Goal Setting + Coaching + Follow Up with proven results from dozens of both large and small companies. These cornerstones are simple but can be hard to execute because it is HOW you do it first, then WHAT you do second. This exciting course is designed to ignite your leadership skills by putting theory into practice; drilling into real live examples and experiencing first-hand what excellence sounds like through role-playing and building your action plan. Get ready to become an inspirational leader and learn the steps required to get the results you really want. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Power BI - Use PBI Desktop to Create Reports and Dashboards
-
Online
4.00 Credits
This webcast is part of the 2020 Power BI Series. Please see below for the suggested viewing order. Power BI Desktop is a new stand-alone tool that adds visualization to your data. This webcast focus is on learning the Power BI Desktop interface, connecting to data sources and creating the visualizations. We will demonstrate the creation of each of the various visualizations and the various options related to each. We will also show how the visualization can be connected together to provide fully-interactive reports with drill-down capabilities. This webcast does not require any Excel knowledge but understanding Power Pivot and Power Query can reduce your learning curve. This series is presented using Excel 2019/Office 365. Regardless of the version you are using, most concepts covered in this webcast series apply to all versions of Excel. (bold) *However, in order to follow along and apply concepts being taught during this session, you need to have the Power Pivot add-in installed. Explore the other webcasts in the 2020 Power BI Series: Power BI - Introduction to MS Power BI Tools Power BI - Prepare Your Data Efficiently for Excel Analysis Power BI - Analyze Your Data With Excel Pivot Tables Power BI - Create Excel Dashboards for Maximum Impact Power BI - Use Power Query to Transform Your Data Power BI - Go Beyond PivotTables with Power Pivot Power BI - Use Advanced Calculations with DAX Formulas Power BI - Share Your Data Analysis using PowerBI.com
The Best Federal Tax Update Course by Surgent
-
Online
8.00 Credits
In this continually revised course, tax advisors will be fully updated on the most recent enacted legislation and IRS guidance, as well as major trends on the horizon with a view toward planning considerations. This update course is designed for all practitioners, both those working in public accounting as well as those in private industry, who need the latest information on tax changes. Please Note: Due to content overlap, it is recommended that this course NOT be taken together with BITU.This course qualifies for CFP credit.This course qualifies for IRS credit.
Walter Haig's SSARS Prep, Comp and Review Update
-
Online
8.00 Credits
This course includes an analysis of all of the relevant authoritative pronouncements that a CPA must have an understanding of in order to properly perform preparation, compilation and review engagements. Troublesome areas as identified in peer reviews and litigation will be addressed. This course is loaded with practical aids to enable CPAs to comply with the standards! Participants who take this course will enjoy a smooth sailing in their peer reviews...guaranteed! This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Ethics and Technology for CPAs
-
Online
2.00 Credits
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.
6 Practical Strategies To Promote Diversity & Inclusion In Your Workplace
-
Online
1.00 Credits
Although organizations are trying to create and manage diverse and inclusive workplaces, many are not aware of some of the best practices and simple strategies they can incorporate to promote such an environment. We are currently living in unprecedented times. Division, bias, and exclusion, based on factors associated with social injustice and a general lack of appreciation for diversity, seems to have become our current societal norm. With the high stress and anxiety created by these current trends in society, it is even more important for organizations to provide a safe space for their employees where there is a genuine sense of belonging and fair access to opportunity. The goal of this course is to outline the relationship between diversity and inclusion, while providing very practical strategies for HR Professionals in their role to promote a culture of diversity and inclusion in the workplace.
Coaching & Counseling - Performance Management
-
Online
1.00 Credits
The tools for managing performance and addressing misconduct are not identical. The failure to point this out to leaders has often resulted in the use of the wrong tool. Reinforcing good performance and securing improvements in performance requires skill in coaching employees, making effective requests, and providing effective feedback This course provides practical knowledge and scripts for setting, communicating, and enforcing performance expectations, such that personal and employer liability is avoided.
Payroll Essentials: Ethics in Payroll
-
Online
2.00 Credits
Payroll is among the most common tasks an employer undertakes in the course of running their business. At it's most basic level, payroll consists of an agreement between an employer and employee related to compensation for services. However, once you look under the hood, there is so much more to payroll, including various kinds of compensation, payroll taxes and required reporting on government forms. Ethics in payroll is present in every step in the payroll process, from handling employee confidential information and dealing with pay, compensation and fringe benefits, to acting as an intermediary on behalf of federal, state, and local governments in the collection and remittance of payroll taxes. All levels of payroll staff- from payroll processor to payroll manager to CEO - encounter ethical considerations in their conduct when dealing with payroll matters. This course will discuss ethics as it pertains to payroll. Attendees will leave with a comprehensive framework for ethical decision making in the payroll function, as well as some real-life examples of what happens when stakeholders in the payroll process make the decision to decouple ethics from payroll. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.