CPE + Events Catalog
Download the 2025-26 OSCPA-Select Calendars - .pdf
K2's Excel Essentials for Staff Accountants - Webcast
-
Online
8.0 Credits
Member Price: $315
See more dates
Staff accountants have specific needs when working with Excel. Unfortunately, their existing Excel knowledge often does not meet these needs. Chief among these are summarizing data quickly and accurately, generating accurate and aesthetically pleasing reports, and creating accounting-centric calculations for elements such as depreciation, amortization, and interest. By participating in this eight-hour session, staff accountants will gain the essential skills to maximize efficiency and accuracy when working with Excel. This session begins with a quick overview of Excel best practices. It then progresses rapidly into discussions that address PivotTables, sophisticated formulas, Tables, formatting, and working with dates in Excel. Throughout the session, you will learn from accounting centric examples to reinforce key learning points. In this session, you will learn in a "laptop-friendly" environment, and participants will have access to all the demonstration files. In sum, this seminar is a "must" for all staff accountants seeking to improve their efficiency and accuracy when working with Excel.
More Dates
How AI Fits into the Accounting World (2 hours - late morning) - Webcast
-
Online
2.0 Credits
Member Price: $105
This session is designed as a primer to introduce artificial intelligence (AI) and to discuss how it will impact accountants as they work. The material will briefly explain what AI is and then focus on ways that it is already serving those in the accounting realm. It will close with a look at future AI-centric developments that will have great potential to positively impact the accounting profession. Those wishing to gain an understanding of what artificial intelligence is and how it will be used by accountants should consider attending this session.OSCPA has partnered with the Washington Society of CPAs for this event.
K2's Excel Tips, Tricks, and Techniques for Accountants - Webcast
-
Online
8.0 Credits
Member Price: $315
See more dates
Excel is the accountant's tool of choice for analyzing and reporting financial data, yet many use time-consuming and error-prone processes to complete everyday tasks. Regardless of your experience level, if you use Excel, you need this course to learn more efficient and effective ways to work with Excel. In this course, you will discover countless tips, tricks, and techniques to improve your general level of productivity, reduce the amount of time you spend on mundane tasks, such as formatting, and customize Excel for greater accuracy and efficiency. You will also learn valuable formula-building skills and best practices for linking Excel data from other sources and streamlining report generation and printing processes. Your K2 instructor will reinforce key learning points throughout the program with practical, real-world examples to improve your understanding and comprehension of the topics presented. This highly acclaimed course draws on over twenty-five years of experience delivering spreadsheet training to accounting and financial professionals, assuring you of the relevance and usefulness of the information and guidance provided during the program.
More Dates
K2's QuickBooks for Accountants - Webcast
-
Online
8.0 Credits
Member Price: $315
See more dates
The QuickBooks platform is robust with features and capabilities that many users are unaware of or do not know how to utilize effectively. This course helps you get more out of QuickBooks Desktop and QuickBooks Online and resolve the issues even experienced QuickBooks users struggle with, such as locking down prior periods. This program starts fast with a chapter covering the top issues accountants face with QuickBooks. Then, the day continues with practical guidance and solutions designed to help accountants get the most out of QuickBooks for themselves or their clients. You will learn about issues like setting up a new company, configuring and customizing QuickBooks preferences, and enabling system security and password protection features. Also, you will learn how to lock down transactions in prior periods, use the audit trail, customize reports, export reports to Excel, and extend QuickBooks' usefulness with tools such as the Fixed Asset Manager and Loan Manager.
More Dates
2024 Professional Skepticism for the Public Accountant (1 hour)
-
Online
1.0 Credits
Member Price: $39
Accountants are expected to demonstrate a questioning mindset. While such professional skepticism is an obvious requirement for assurance engagements, it is applicable elsewhere in the practice of public accounting. In fact, a skeptical mindset offers benefits to both public accountants and those who work in industry. This course provides specific examples of professional skepticism while suggesting best practices.
Independence and Conflicts of Interest (1 hour)
-
Online
1.0 Credits
Member Price: $55
This course focuses on how to integrate independence and avoid conflicts of interest in situations accounting professionals face daily. Participants will be able to know not just what is the right thing to do according to the AICPA Code of Professional Conduct, but how to put values into action. As part of this course, we also walk through real-world examples of individuals and companies faced with these dilemmas. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
2024 How to Choose the Right Business Entity for Your Client (2 hours)
-
Online
2.0 Credits
Member Price: $79
Tax rates, personal liability, operations – these are all factors to be weighed when advising clients about their choice of entity decision. This session provides a comparison of the multiple entity choices to start the discussion with clients and selecting the best tax efficient option for them. **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.
Surgent's Guide to the AICPA Quality Management Standards (2 hours)
-
Online
2.0 Credits
Member Price: $99
See more dates
With only a few months to go before the AICPA's Statement on Quality Management Standards 1, 2, and 3 (SQMS 1, SQMS 2, and SQMS 3, respectively), SSARS No. 26, SAS 146, and SSAE 23 are required to be implemented, this course can help you meet the deadline. It focuses not simply on theory but on HOW to perform the steps involved. The Quality Management Suite of Standards must be implemented by December 15, 2025. The standards modernize the firm's approach to quality to reflect an increased focus on risk assessment, technology use, and the presence of outside experts on many engagements. Beginning with performing a risk-based approach, the standards provide accounting firms with the ability to enhance their quality control by shifting their focus to a proactive approach (management) from a reactive approach (control). The results of the firm's risk assessment will form the basis of its new Quality Management document. This is not just a tweak of the old document but a more robust document that adds new requirements from the new standards. We will cover how to perform a risk assessment, including the key provisions of the standards, and how to effectively implement a monitoring plan. We will also review how the firm will evaluate its System of Quality Management beginning in 2026.
More Dates
K2's 2023 Excel Tips, Tricks, and Techniques for Accountants
-
Online
8.0 Credits
Member Price: $225
See more dates
Excel is the accountant’s tool of choice for analyzing and reporting financial data, yet many use time-consuming and error-prone processes to complete everyday tasks. Regardless of your level of experience, if you use Excel, you need this course to learn more efficient and effective ways to work with Excel. In this course, you will discover countless tips, tricks, and techniques to improve your general level of productivity, reduce the amount of time you spend on mundane tasks, such as formatting, and customize Excel for greater accuracy and efficiency. You will also learn valuable formula-building skills, best practices for linking Excel data from other worksheets and workbooks, and how to streamline report generation and printing processes. Your K2 instructor will reinforce key learning points throughout the program with practical, real-world examples that will improve your understanding and comprehension of the topics presented. This highly acclaimed course draws on over twenty-five years of experience in delivering spreadsheet training to accounting and financial professionals, which assures you of the relevance and usefulness of the information and guidance provided during the program.
More Dates
2024 Annual Update for Accountants & Auditors (4 hours)
-
Online
4.0 Credits
Member Price: $239
This course will start with the Accounting Standard Updates effective in 2024 for public entities, private entities, and nonprofits. We'll then switch our attention to the items coming down the pike, including a look at the projects identified by the FASB's Invitation to Comment: Agenda Consultation. We'll also review year 2 considerations for leases including modification accounting. Then we will switch gears, switching to the audit side of the house. We'll review the impact of the changes to auditing group audits as well as the status of the AICPA's quality management project management. This course will keep auditors up to date on the work of the ASB. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Performing a Single Audit Under the Uniform Guidance
-
Online
8.0 Credits
Member Price: $332
See more dates
Performing a single audit Exploring various topics related to single audits will give you the knowledge you need to perform these engagements skillfully. You can learn about: Major program determination Pass-through entity responsibilities SEFA requirements The Compliance Supplement requirements The administrative requirements and cost principles found in the Uniform Guidance Uniform Guidance compliance audit basics Gaining an understanding of the Uniform Guidance basics will prepare you for compliance audit engagements. You can examine various topics, such as: Requirements overview Applying GAAS and the Yellow Book to compliance audits Entities that must undergo this type of engagement Federal awards decoded You can also learn the different types of federal awards, along with audit implications for a recipient or subrecipient. Federal award topics covered include: Becoming aware of the SEFA Major program determination Testing and reporting responsibilities You will acquire a fundamental understanding of your responsibilities related to testing and reporting by examining topics, such as: Testing internal control over compliance Testing compliance Writing an audit finding
More Dates
Erase the Mark: Best Practices in Penalty Abatement (2 hours)
-
Online
2.0 Credits
Member Price: $89
If there is a potential error, the IRS will assess a tax and add a hefty penalty, without even knowing the facts. As a tax professional, you will be exposed to the IRS and their methods of penalizing taxpayers for the smallest of violations. This presentation will focus on the rules and regulations that create the penalty, and the reasons that exist that the IRS will consider to remove those penalties. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Surgent's Exploring Client Advisory Services: Tax Due Dates and Penalties/Where Do I Need To File? (2 hours)
-
Online
2.0 Credits
Member Price: $99
See more dates
This course provides essential knowledge for Client Advisory Services (CAS) professionals navigating multistate taxation and managing tax deadlines. We'll start by exploring the implications of the Wayfair decision, focusing on general rules for sales and income tax nexus across states. You'll learn what to look for in state statutes and gain a solid foundation for filing requirements. Additionally, we'll cover key tax due dates, how to handle missed deadlines, and potential relief options. Whether you're new to the field or running your own practice, this course will equip you with the tools to succeed.
More Dates
Surgent's Top 10 Celebrity Estate Mistakes and How to Avoid Them (2 hours)
-
Online
2.0 Credits
Member Price: $99
See more dates
This course uses the lives of the rich and famous as a template to better understand the realm of estate planning. With stories ripped from the headlines, we will examine pitfalls and best practices. Did you know that Prince died without a will, opening the door for 45 people claiming to be his beneficiaries? Or that Michael Jackson was not careful in properly funding his trust, leading to delays and legal battles in the administration of his estate? Even Abraham Lincoln, it turns out, did not have a will. In discussing an array of celebrities, from Jackie Kennedy, Joan Rivers, Jimi Hendrix, and Whitney Houston to Aretha Franklin, Barry White, Leona Helmsley, and Florence Griffith Joyner, the course is designed as an enjoyable learning experience with tips for all levels of expertise. We may not have their fame or fortune, but we can certainly walk the red carpet when it comes to estate planning.
More Dates
Allison McLeod's 2024 Federal Tax Updates for Business Entities – 8 Hour
-
Online
8.0 Credits
Member Price: $225
See more dates
The tax landscape is constantly changing, challenging tax practitioner to stay abreast of these developments. This eight hour program will cover issues unique to business entities, including new court decisions, recent IRS publications, and the latest tax legislation that will impact businesses and individuals. The remaining time will be spent on IRS procedure and other issues. This course will provide a concise look at the hottest topics affecting every tax practitioner. **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
K2's 2024 Excel PivotTables for Accountants
-
Online
8.0 Credits
Member Price: $225
See more dates
Isn’t it time you learned about PivotTables – Excel’s best feature? If so, participate in this session to learn PivotTables from A to Z to take full advantage of this terrific tool's many benefits.
More Dates
Invest in Your Mental Health and Avoid Burnout (2 hours) [NT]
-
Online
2.0 Credits
Member Price: $89
For the ambitious female finance professional, working hard and going above and beyond are necessary for success. Sadly, taking time to care for themselves can be seen as counter-productive to meeting their career goals. Over ninety percent of women executives are feeling significantly higher levels of stress that they attribute to increased responsibilities and priorities outside the workplace compared to life before the pandemic. Burnout is a syndrome resulting from chronic workplace stress that causes exhaustion, negativity toward one's job and reduced professional efficacy. It has become so pervasive that it's now recognized as an occupational phenomenon by the World Health Organization. To reignite your enthusiasm at work, you don't necessarily need to find a new job or time for a spa day or bubble bath. You need concrete strategies to invest in your mental health without compromising your ability to rise to the next level in your career. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
2024 Internal Controls for Small and Medium-Sized Entities (1 hour)
-
Online
1.0 Credits
Member Price: $39
This session explores the importance of internal controls with an emphasis on best practices for small- and medium-sized entities. We will examine the roles of both preventive and detective controls and practical, cost-effective suggestions for implementing effective internal controls will be addressed.
2024 Inflation Reduction Act of 2022: Review and Update (2 hours)
-
Online
2.0 Credits
Member Price: $79
This program will examine the key provisions of the Inflation Reduction Act of 2022 that was enacted to not only curb inflation, but reduce the deficit, promote clean energy solutions, and much more. Learn how this new legislation can provide tax savings for both your individual and business clients. **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.
Audit 503: Management – Being a Balanced Leader-Manager (2 hours)
-
Online
2.0 Credits
Member Price: $89
Management Skills - Exhibiting Traits of a Balanced Leader-Manager provides tips and techniques for striking the right balance between managing individuals and engagement teams and leading the overall strategic direction of a firm. Short-term profitability and long-term viability are important objectives of any successful organization. Note: This course is recommended as a part of a 16-hour audit skills curriculum for managers, while it is also appropriate for anyone who has responsibilities for leading or managing others. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.