CPE + Events Catalog
Download the 2025-26 OSCPA-Select Calendars - .pdf
Complete Guide to Analyze Data with Excel PivotTables (4 hours) [NT]
-
Online
4.0 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
The Updated Nuts and Bolts of IRC Section 1031 Exchanges (2 hours)
-
Online
2.0 Credits
Member Price: $79
See more dates
In today’s real estate market, IRC §1031 tax-deferred exchanges can be one of the most important planning tools available to the real estate investor. The use of this technique is filled with pitfalls and traps. This new course will assist the practitioner in understanding the mechanics of a tax-deferred exchange and the value of a tax-deferred exchange in both tax and financial planning. Updated August 2022
More Dates
The Ethical Management of Conflict (2 hours) [NT]
-
Online
2.0 Credits
Member Price: $89
See more dates
Conflict is as natural as breathing air. For many, the thought of dealing with conflict is difficult and horrifying, and yet unresolved conflict can damage relationships, cause pain and suffering as well as hinder workplace productivity. When addressed, however, conflict has the power to be transformative in strengthening workplace relationships, shared understanding, and increased productivity. This workshop will provide an intimate understanding of how to deal with conflict in collaborative and constructive ways. Using ethical values and principles, we will explore how to move conflict from an obstacle to an opportunity. This workshop is geared toward individuals who are wanting to improve their conflict management skills and create more harmonious and positive working environments. 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
Big Picture Mega-Trends, Big Data, and World We Now Face (2 hours)
-
Online
2.0 Credits
Member Price: $79
See more dates
It is easy for us to get caught up in our work, but it is better to examine the ‘big picture’ by studying the outside factors that impact our business beyond our internal processes and day to day responsibilities. We are sometimes so busy with our tasks that we miss new developments until the developments have a profound impact on us and the organization. This session is designed to review many of these current trends, while thinking and discussing how these trends can impact our organizations and us. This is a fun and lively session that is intended to be interactive with participants either live, virtual or both. Our ever-changing world is evolving more than many realize.
More Dates
Risk Assessment Under SAS No. 145: The Key to Audit Quality? (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
The AICPA has identified risk assessment as an area of focus for its Enhancing Audit Quality Initiative as deficiencies in auditor's risk assessment procedures continue to be a common issue identified in peer review. SAS No. 145, Understanding the Entity and Its Environment and Assessing the Risks of Material Misstatement, was written to improve the quality of risk-based audits. While key concepts do not fundamentally change, the standard works to clarify and enhance certain aspects of the identification and assessment of the risks of material misstatement to drive better risk assessments and hopefully overall enhance audit quality. 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
AI Privacy, Security, and Compliance Masterclass (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
In today's rapidly evolving digital landscape, understanding the interplay between generative AI and data protection is not just an asset, but a necessity. This transformative course is designed to delve deep into the crucial privacy, security, and compliance aspects of working with Generative AI (GenAI) technologies. As accountants increasingly integrate AI tools into their workflows, the stakes for safeguarding sensitive information and ensuring ethical AI practices have never been higher. Our masterclass is tailored to meet the unique needs of modern accountants, providing a thorough and practical exploration of how to navigate the complexities of secure data sharing with GPT models, implement robust AI policies, and master the intricacies of AI copyright compliance. With a focus on real-world applications and emerging threats, such as deepfakes and their implications for fraud and misinformation, this course is your gateway to becoming a trusted expert in the field. Join us to future-proof your career and lead with confidence in the digital age. 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
Basic Individual Taxation Course (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
Please join us for an introductory course on the fundamentals of preparing and filing an individual federal income tax return. We will cover topics such as what the federal income tax is and how it is computed. 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
Tech It to the Next Level: Slim Your Team for Max Efficiency (1 hour) [NT]
-
Online
1.0 Credits
Member Price: $55
See more dates
Ready to slim down your team and maximize efficiency without sacrificing quality? This session breaks down how to leverage tech and automation to fill workflow gaps, build a strong tech stack, and connect tools seamlessly. Learn how one proven tech stack replaced more than half a traditional team while improving client satisfaction and reducing overhead. Walk away with practical steps to streamline operations, automate repetitive tasks, and focus your resources on what really matters. Attendees will gain practical insights into streamlining operations, automating repetitive tasks, and focusing resources on high-value activities. The session also includes an exclusive look at a proven tech stack used to replace over half a traditional team, offering actionable steps to create a leaner, tech-driven, scalable firm. Perfect for firm owners ready to rethink staffing, reduce overhead, and embrace the future of accounting efficiency. 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 Application Lightning Round Review-Updated (1 hour) [NT]
-
Online
1.0 Credits
Member Price: $55
See more dates
Do you use Microsoft (Office) 365? Are you satisfied that you are getting the most that you can from it? If you answered yes then no, this course will provide a really high return on your investment of time and money in this application suite. John Higgins, one of the profession's leading experts on the integration of Microsoft 365 into business, will explain and demonstrate the depth and breadth of the Microsoft 365 ecosystem. The course is designed to raise your awareness of all that you can do with Microsoft 365 and substantially increase your monthly subscription ROI. 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
Leverage PowerBI.com to Create Data Analysis for Others (2 hours) [NT]
-
Online
2.0 Credits
Member Price: $89
See more dates
Unlock the full potential of data analytics with our specialized course, "Leverage PowerBI.com to Create Data Analysis for Others". This two-hour, intensive training is specifically designed to empower professionals in harnessing the powerful features of Microsoft PowerBI.com. Whether you're a data analyst, business intelligence professional, or someone keen on mastering data visualization and report creation, this course is your gateway to becoming a proficient Power BI user. Dive into the dynamic world of data analytics and learn to transform raw data into visually compelling stories that drive decision-making. Our expertly crafted program offers a deep dive into the essentials of PowerBI.com, starting with a comprehensive tour of its interface and core concepts. You'll gain experience in connecting to diverse data sources, creating stunning visualizations, and building interactive dashboards that communicate insights effectively. The course also covers the innovative Q&A feature of PowerBI.com, allowing you to explore data with natural language queries. By mastering the art of sharing datasets, reports, and dashboards, and creating comprehensive apps, you'll be equipped to deliver top-tier data analysis solutions to colleagues and clients alike. Through this course, attendees will gain a deep understanding of how to leverage the PowerBI.com platform to disseminate datasets, reports, and dashboards, catering to the specific needs of their audience. Our course is tailored for those who aspire to lead in the data-driven landscape, offering not just theoretical knowledge but real-world applications. Upon completion, participants will not only have a thorough understanding of PowerBI.com but also the confidence to apply this tool in creating impactful data analysis for diverse audiences. Join us to elevate your professional skillset, make data-driven decisions with ease, and add a valuable credential to your portfolio. 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
Getting On Top of It All: How to Work Smarter, Not Harder – Part 1 (4 hours) [NT]
-
Online
4.0 Credits
Member Price: $129
See more dates
There is always too much to do and too little time to do it all. Fortunately, if you know the right ways to manage people, projects and your time, you can get on top of everything by working smarter. In this seminar you'll learn the best ways to get more done in less time, how to stay sane with all you have to do, and how to get other people to do some of "your" work by building great relationships.
More Dates
Preparation, Compilation, and Review Engagements: Update and Review (4 hours)
-
Online
4.0 Credits
Member Price: $225
See more dates
By reviewing the latest developments and issues relevant to preparation, compilation and review engagements, you'll be able to adhere to professional standards while performing these types of engagements.
More Dates
Seeing Beyond the Numbers: Analysis for CFOs & Controllers (4 hours)
-
Online
4.0 Credits
Member Price: $149
See more dates
Financial statements are a window into what is going on in the day-to-day operations of the company. They help us see what the company's strengths and weaknesses are. However, financial statements can often have different messages depending on the user. 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
Pass-Thru Entity Owners Schedule K-1 Analysis 25-26
-
Online
8.0 Credits
Member Price: $329
See more dates
This comprehensive case-driven training is designed to quickly get the accountant up to speed in basis calculations and distribution planning for the owners of pass-thru entities (i.e., S corporations, partnerships, and limited liability companies (LLCs)). The cornerstone of this course is the line-by-line analysis of the Schedule K-1s and how it affects the basis calculations. This session is taught using a Hands-On methodology. Real-world examples and cases demonstrate the complex income tax code and regulations to enhance the participant's learning experience. Each attendee will receive the most comprehensive reference manual with numerous practice aids, real-world examples, and case studies.
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
Surgent's Preparing Not-for-Profit Financial Statements
-
Online
8.0 Credits
Member Price: $279
See more dates
In order to prepare accurate and effective not-for-profit financial statements, professionals must have a strong working knowledge of the reporting requirements. Now is the time to obtain that knowledge! This course explains the requirements, illustrates how the requirements manifest in the financial statements, and clarifies options available to not-for-profits in applying the requirements. The course covers key accounting areas that affect not-for-profits, including net assets, contributions, and functional expense reporting. The course materials utilize a highly illustrative and innovative format, including 30 focused exercises to provide an enhanced working knowledge of not-for-profit accounting and reporting.
More Dates
The Best S Corporation, Limited Liability, and Partnership Update Course by Surgent
-
Online
8.0 Credits
Member Price: $299
See more dates
This year practitioners need to keep abreast of tax changes affecting pass-through entities used by their business clients and employers, and this enlightening course delivers that information. You will learn invaluable strategies, techniques, innovative tax-planning concepts, income-generating ideas, and other planning opportunities available to S corporations, partnerships, LLCs, and LLPs. In addition, this course will discuss current trends and emerging issues, helping practitioners stay informed about relevant and significant topics that may impact their clients. Continually updated to reflect enacted legislation.
More Dates
You Don't Know What You Don't Know About Microsoft Excel [NT]
-
Online
8.0 Credits
Member Price: $239
See more dates
Many Excel users have received little or no formal training to help them use the ubiquitous productivity application. This session can help users that wish to improve their Excel skills to increase their productivity. The material starts by covering basic topics such as time saving tips and keyboard shortcuts and then moves to more advanced areas like conditional formatting and complex formula building. Users that find themselves looking at the spreadsheets that others design and wishing they could do as much with Excel will benefit greatly by taking this course. 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
Noble Leadership: An Ethical Approach (2 hours) [NT]
-
Online
2.0 Credits
Member Price: $89
See more dates
Research tells us that leaders, supervisors and managers have more impact on an employee than does a therapist and/or life partner. Being a leader is a huge opportunity and privilege and requires introspection and personal growth. This webinar is infused with values of fairness, compassion, respect and more and will be of most value to individuals who believe that everyone, regardless of circumstance, deserve "certain general conditions that are ...equally to everyone's advantage" (John Rawls). The Noble leader believes in people. The Noble leader is curious and humble and invites challenge and feedback into his/her/ world. The Noble leader is a true believer in seeing the good in others, helping them to be their best which in turn helps the Leader grow as well. The Noble leader does not shy away from confronting bad behavior/performance in a respectful and clear way while believing in the inherent dignity of each individual This workshop based on ethical principles offers a glimpse into what it takes to become a Noble Leader and how one can journey through for increased self awareness and skill development. 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
AI Lessons Learned for Accountants (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
This course provides accountants with the leading AI insights and strategies drawn from real-world experience, empirical studies, countless CPA case studies, and social media commentary. It goes beyond theory, offering practical lessons learned from the front lines of AI implementation in the business world and accounting industry. Participants will gain actionable knowledge on bridging the theory-application gap, navigating exponential technological changes, and creating secure, adaptive AI policies. By the end of the session, accountants will be equipped to leverage AI responsibly and innovatively in their roles. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.