CPE + Events Catalog
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
Taking Advantage of Array Formulas in Excel (2 hours) [NT]
-
Online
2.0 Credits
Member Price: $89
See more dates
This intensive 2-hour course is designed to unlock the potential of array formulas in Microsoft Excel. Array formulas are a vital tool in Excel for their unique ability to perform multiple calculations on one or more items within an array, making them indispensable for complex data analysis and calculations. They enable users to write fewer, more powerful formulas, leading to cleaner and more efficient spreadsheets. This course is tailored to enhance your data analysis and spreadsheet management skills by delving into the advanced aspects of array functions. Through a combination of theoretical knowledge and practical exercises, you will learn to streamline your work and improve efficiency in Excel. 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
Cryptocurrency Transactions: Navigating Federal Tax Rules (1 hour)
-
Online
1.0 Credits
Member Price: $29
See more dates
As cryptocurrencies like Bitcoin, Ethereum, and others become more popular, tax authorities around the world are working to create regulations for their use and transactions. This session will address cryptocurrency tax issues and their complexities and challenges that individuals and businesses face when dealing with the taxation of digital currencies. *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
Supervision/Management Competencies: An Ethical Approach (2 hours) [NT]
-
Online
2.0 Credits
Member Price: $89
See more dates
Job titles for individuals can vary in different organizations even though the work is the same. This webinar is designed for the individual whose role is to oversee the work of others. This webinar includes an overview of Aristotle's virtue ethics and its application to the responsibility and privilege of developing employees to be their best and for the success of the organization. We will also address issues such as going from "buddy to boss", how to manage if you are newly assigned to an existing employee that was previously supervised by someone else, and critical skill sets necessary for supervisory/managerial positions. 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
Building a Better Budget in a Time of Uncertainty (4 hours)
-
Online
4.0 Credits
Member Price: $149
See more dates
Most financial leaders would agree that budgeting is easy when business and the economy are stable. When revenues and expenses are expected to remain the same, the process becomes merely an exercise in carrying over what was done before to the current year. However, what happens when we are not sure about how the market will react to our product? What happens when the competitive landscape changes? In this course, we will discuss budgeting techniques and considerations when business lacks stability. Through a combination of theory and real-world examples, we will explore how to build flexibility into our budget - so that it can inform and drive decision-making when we don't quite know what is ahead. 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
ACPEN Signature 2025- Small Business: Hot Tax Issues Today
-
Online
8.0 Credits
Member Price: $250
See more dates
2025 will be a big year for small businesses no matter what decisions are made: Will tax cuts/changes enacted as part of the Tax Cut and Jobs Act expire at year end as scheduled or will they be extended? If extended, which provisions are included and how long is the extension? Will overtime pay be taxed differently in the future causing additional changes to small business payroll systems? Will employers be relieved of reporting tip income and what exactly is tip income? What additional requirements may be imposed on employers to deter employment of illegal/undocumented workers? What requirements and penalties are already in place and what’s coming? What will happen to ongoing judicial efforts of small businesses to fight self-employment taxes imposed by the IRS on LLC Members and active limited partners? How is the IRS reacting to changes? **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
ACPEN Signature 2025: Single Audit and Uniform Guidance Issues Update
-
Online
8.0 Credits
Member Price: $250
See more dates
If you think applying one set of audit standards is tough enough, how about applying three different sets of audit standards in one “single” audit? That’s exactly what happens when the auditor applies GAAS, the Yellow Book and the OMB requirements in a Single Audit. This session will start with a single audit “nuts and bolts” overview before delving into unique aspects and audit issues of the continued era of pandemic-related funding, and, of course, provide an update of any recent changes to the funding related to the Infrastructure and Investment in Jobs Act, or IIJA. Recent changes to the Single Audit and Uniform Guidance rules will also be covered. Join our expert panel of federal, state and local auditors and practitioners to learn what you need to know if you are performing audits under these audit standards and the Uniform Guidance for Federal Awards.
More Dates
Shortcuts that Excel Users Love (2 hours) [NT]
-
Online
2.0 Credits
Member Price: $89
See more dates
Many people that use Microsoft Excel know a great deal about the functionality of the application. There are, however, a tremendous number of hidden tools that a high percentage of users overlook. Additionally, there are newer features that some have not had the opportunity to explore. This session shows some of the numerous time-saving tools and features that often go unused by spreadsheet creators. People that wish to become more efficient when using Excel should take this session! 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
What's Changing in Risk Assessment (2 hours)
-
Online
2.0 Credits
Member Price: $79
See more dates
SAS 145, Understanding the Entity and Its Environment and Assessing the Risks of Material Misstatement, was issued in October 2021. The audit standard amends AU-C 315, including many changes to address common audit deficiencies. This course will provide an overview of SAS 145 and its changes to AU-C 315. Attendees will have an opportunity to evaluate the impact on audit methodology and documentation.
More Dates
2025 Not-for-Profit GAAP Update (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
This course will review the Accounting Standard Updates issued by the FASB that impact nonprofit entities. We will also look at the work of the Not-for-Profit Advisory Committee (NAC) and the projects they are advising the FASB on. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event. 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
Closely Held Business Owner Financial Planning Opportunities 25-26 (2 hours)
-
Online
2.0 Credits
Member Price: $99
See more dates
Many business owners need to pay more attention to the financial planning opportunities and implications when starting, growing and successfully running their businesses. This all-inclusive course brings together closely held business owner specifics, focusing on critical structure and financial planning issues, such as identifying those issues that business owners need to keep on the radar. This session will help determine the goals and objectives of the business owner when selecting or changing a form of the organization concerning start-up costs, control over the operation of the business, personal liability for business operations, flexibility in the process of the company, business structure, continuity and compensation. Financial planning issues to be discussed include cash flow management and budgeting, risk management and insurance, investing, income tax, retirement and estate planning issues.
More Dates
IRAs: What You Need to Know about Contributions, Conversions and Distributions (2 hours - late morning) - Webcast
-
Online
2.0 Credits
Member Price: $105
Dive into the essentials of IRAs with this course. We'll go well beyond the basics to cover crucial topics: when to convert traditional IRAs to Roth IRAs, how to minimize tax on conversion, and when clients should recharacterize IRA contributions (and how to recharacterize). We'll also discuss how to get waivers for clients who fail to take required minimum distributions and other traps in the IRA area including prohibited transactions, excess contributions, and impermissible investments.OSCPA has partnered with the Washington Society of CPAs for this event.
Partnership Essentials: Tax Basis Capital Accounts (2 hours)
-
Online
2.0 Credits
Member Price: $79
See more dates
This course examines the critical issues and special opportunities facing partnerships and their partners, with a focus on reporting tax basis capital accounts. **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 Features and Benefits of SEP IRAs and SIMPLE IRAs (2 hours)
-
Online
2.0 Credits
Member Price: $99
See more dates
A challenge for many small business owners is choosing the `right' type of retirement plan for their businesses. Many hesitate to adopt retirement plans for their businesses because they are intimidated by the governing rules. In those cases, SEP and SIMPLE IRAs are reasonable solutions because they are easy to establish, maintain, and communicate with employees; have minimal administrative costs; and are practical and efficient ways to start a retirement plan. These IRA-based plans - SEP IRAs and SIMPLE IRAs - have low maintenance costs and are easy to communicate to employees. With IRA-based employer plans, employer contributions are sometimes discretionary, giving business owners the choice of whether to fund every year. Despite the simplicity of these plans, employers must ensure that applicable compliance requirements are met to avoid penalties. To that end, this course will cover some key provisions of SEP and SIMPLE IRAs.
More Dates
Surgent's Stock vs. Asset Acquisitions of C Corporations (2 hours)
-
Online
2.0 Credits
Member Price: $99
See more dates
A business conducted as a C corporation can be purchased through an asset acquisition or a stock acquisition. In an asset acquisition, the buyer purchases the business by purchasing the assets that make up the C corporation's ongoing business. In a stock acquisition, the buyer purchases the stock of the C corporation that owns all or a majority of the business assets. The seller and the buyer are usually at odds over how to structure the acquisition. Tax practitioners advising their business clients should be fully conversant in the tax rules that apply to stock and asset acquisitions. Discussing and explaining those rules is the focus of this course.
More Dates
What Tax Practitioners Need to Know About Medicare (2 hours - late morning) - Webcast
-
Online
2.0 Credits
Member Price: $105
See more dates
Tax advisors often receive questions concerning all facets of Medicare. How does Medicare work? How do I apply? How much does it cost? Is Medicare optional or required? This program provides a basic introduction to the Medicare program and covers many of the areas of the Medicare program that clients are most interested in. If you, or some of your clients, have questions relating to Medicare, this program is a must for you.OSCPA has partnered with the Washington Society of CPAs for this event.
More Dates
Surgent's Update on Recent AICPA Standard Setting: Staying Current in a Changing Environment (4 hours)
-
Online
4.0 Credits
Member Price: $159
See more dates
Professional standards are changing with the times and the desire of the AICPA to move the profession into a new era where use of technology will play a key role in an audit and professional skepticism, independence, and quality are emphasized. We are seeing changes already as the AICPA has issued 15 new standards since 2019. This program will discuss SASs 134 through 149.
More Dates
Overcome Your Obstacles to Abundance (4 hours)
-
Online
4.0 Credits
Member Price: $129
See more dates
Getting rich requires many things. First, you need to know how to overcome previous limitations you may have had about making a lot of money. Second, you need to know and use the best financial strategies for becoming wealthy--including the latest investment and marketing strategies. And third, you need to be able to enjoy your lifestyle, and look at what obstacles get in the way of you being rich and fully contented. By exploring the latest methods for achieving financial and personal success, you'll be able to make a lot more money and have a great time doing it.
More Dates
Avoiding Legal Liability and Peer Review Deficiencies in Nonaudit Services, Including Bookkeeping and Preparing Financial Statements (4 hour
-
Online
4.0 Credits
Member Price: $129
See more dates
The majority of peer review deficiencies and malpractice claims result from nonaudit services. This course will provide best practices for avoiding legal liability and quality control concerns.
More Dates
S Corporations: Calculating Shareholder Basis (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
A detailed analysis of the calculations related to determining a shareholder's tax basis for S corporation shares and loans. How to use the Form 1120S, Schedule K-1 information for basis determination. An illustrative example demonstrates how the process works, as well as the many potential pitfalls. 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
