CPE & Event Calendar
For details about the CPE and event categories below, please click here.
K2's Excel PivotTables for Accountants
-
Virtual
8.00 Credits
Member Price: $225
Many business professionals consider PivotTables the most powerful feature in Excel, yet most accounting and financial professionals do not use them in their day-to-day activities. If you are ready to learn how to take advantage of PivotTables or extend your existing knowledge of PivotTables, then plan to participate in this course. You will learn how to build PivotTables, group data inside PivotTables – including grouping options for fiscal periods – and create user-defined calculations in your PivotTables. You will also learn advanced PivotTable techniques, including building PivotTables that consolidate data from multiple data ranges and PivotTables that connect dynamically to external databases and financial accounting systems. Additionally, you will learn to take advantage of other Excel features associated with PivotTables, including Slicers, Power Query, and Power Pivot. You will be a master of Excel PivotTables at the end of the day! This course is for you if you have been leery of working with PivotTables or have struggled to realize their many benefits. With some information, guidance, and coaching from your K2 instructor, you will be ready to use PivotTables to analyze and report on extensive data sets in a fraction of the time you spend completing such tasks.
Guide Strategy, Attract Investments with Financial Forecasts
-
Virtual
2.00 Credits
Member Price: $89
Financial statement forecasting is essential for predicting a company's future financial health, guiding strategic decisions, and attracting investments. By analyzing historical data, market trends, and assumptions, businesses can anticipate risks and opportunities, enabling effective planning, resource allocation, and long-term stability and growth. - Forecasting Process: This involves projecting future income, expenses, and resources. By leveraging historical data and market insights, businesses can predict financial health, shaping strategic planning, investment decisions, and risk management. - Forecasting Profitability: Predicting future earnings informs strategic decisions, investment planning, and resource allocation. It facilitates effective budgeting, cash flow management, risk assessment, and enhances attractiveness to investors for sustainable growth. - Forecasting the Balance Sheet: Analysts forecast to predict a company's future financial position, assessing growth potential, solvency, and capital structure. This informs investment decisions, strategic planning, and risk management, ensuring financial stability and growth. Join our webinar to explore these concepts with a practical example, guiding you through the forecasting process and demonstrating its practical applications in real-world scenarios. 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 Representing a Client in an IRS Audit
-
Virtual
3.00 Credits
Member Price: $149
Recent legislation in Congress has provided the IRS with substantially increased funding to bolster its human staff and purchase software that will allow the IRS to audit many more taxpayers in a more effective way. The IRS believes it can target the right kinds of taxpayers for audits so that it will not waste its time on audits that produce little, if any, revenue. The purpose of this program is to discuss the current state of IRS audits and the anticipated increases in the IRS's ability to audit wealthier taxpayers in an efficient way. The course will discuss the state of the IRS's current audits and where the IRS is headed with audits in the coming years. Tax practitioners should also be aware of the state of the IRS's efforts to target efficiencies so as to produce the most revenue.
Accounting Fraud 25-26
-
Virtual
8.00 Credits
Member Price: $329
Gain an understanding of the concept of fraud, the Fraud Triangle theory, fraud risk, fraud detection and prevention. Learn about best practices in fraud detection and fraud deterrence. This course includes real-world cases of fraud, how they were perpetrated, and how they were detected.
Advanced Personal Financial Planning Update 25-26
-
Virtual
8.00 Credits
Member Price: $329
New personal financial planning strategies are emerging due to evolving personal goals in rough economic and legal environments. Drawn from recent publications and government directives, this course reviews the latest financial strategies and planning changes from the past year in insurance, investments, tax, estate and retirement, including Social Security and Medicare. Additionally, Randy covers estate and tax planning strategies that enable practitioners to better serve clients by allowing them to take advantage of new opportunities.
Not-for-Profit Organizations: Treasury Utilizing QuickBooks 25-26
-
Virtual
8.00 Credits
Member Price: $329
Not-for-profit organizations always need volunteers as treasurers or members of the financial oversight committee! CPAs are often asked to fulfill these roles. This course highlights the accounting needs of such organizations. Along with covering the status of the not-for-profit organizations, an update on recent ASC updates affecting nonprofit entities is covered. QuickBooks 2024 Desktop will be used to demonstrate how its tools provide more efficient and effective financial management for your not-for-profit entity. This course is geared toward hands-on, or future hands-on, treasurers of service clubs and similar not-for-profit organizations.
An Ethical Approach to Mental Health Issues at Work
-
Virtual
2.00 Credits
Member Price: $89
In the past talking about mental issues in the workplace was taboo. Not anymore!!! So many of us suffer with mental health issues at some point in our lives. Poor mental health impacts, from a work perspective, productivity, absenteeism, retention and more. On a personal level it often causes personal distress and hopelessness. The Society of Human Resource Management (SHRM) is addressing mental illness as a critical factor for the wellbeing of organizations. Additionally, the EEOC is cracking down on mental health discrimination. It is a very important topic for any functional business! This ethics-based webinar will bring awareness to this issue and offer suggestions on managing mental health issues in ethical, compassionate and healthy ways. It will offer suggestions on managing mental health issues for leaders, managers and all staff to create and environment of safety and belonging. This webinar will also address the topic of suicide talking about warning signs and resources. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
K2's Excel Essentials For Staff Accountants
-
Virtual
8.00 Credits
Member Price: $225
Staff accountants have specific needs when working with Excel – needs that are often not met by their existing Excel knowledge. Chief among these are the needs to quickly summarize data, prepare accurate and aesthetically pleasing reports, and create 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 they need to maximize their 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 used in the session. In sum, this seminar is a “must” for all staff accountants seeking to improve their efficiency and accuracy when working with Excel.
Fraud Busters: Controls to Prevent & Detect Fraud
-
Virtual
2.00 Credits
Member Price: $89
This course investigates actual real-world fraud schemes and discusses what controls could have prevented the fraud from occurring, and what controls could detect and curtail the fraud scheme. The instructor speaks from experience, finding multiple frauds very early in her career leading to a career-long focus on fraud prevention and detection. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
ChatGPT and Advanced Policy Manual Development for ACCTs
-
Virtual
2.00 Credits
Member Price: $89
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.
Surgent's Engagement and Client Retention Best Practices
-
Virtual
2.00 Credits
Member Price: $119
Positive client relationships require work. Miscommunication, unrealistic expectations, and differing personality styles may strain a client's relationship with professional advisors. Fortunately, there are tested strategies that foster and strengthen client relationships. Creating appropriate boundaries early on is one of many effective strategies that can help. This course explores actions accounting and finance professionals can take to create and grow their client relationships. This webinar provides actionable insights on how to engage new and old clients alike. Strained client relationships can harm both the client and the firm's profitability. Yet automation, for example, allows some firms to remain more engaged while others miss the mark. There is a science underlying client retention that involves understanding the client journey, ensuring consistent client interactions, and equipping employees with the tools needed to satisfy client needs. Understanding these skills should help you protect the relationships that sustain your business.
CFO Solutions to IRS Problems
-
Virtual
4.00 Credits
Member Price: $149
Many CPAs are becoming full-time or fractional CFOs for small businesses. In that position, they are the resident expert in finances, cash flow planning, and budgeting. But what about dealing with the IRS? The IRS has broad powers to administer the assessment and collection of taxes. From removing penalties to criminal prosecutions, this presentation focuses on how CFOs can prevent problems with the IRS and how to develop winning strategies if the IRS knocks on the door. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Mastering Microsoft 365 Copilot for CPAs
-
Virtual
2.00 Credits
Member Price: $89
Discover how Microsoft 365 Copilot can revolutionize your daily tasks as a CPA. Dive into the specific features and functionalities of this AI-powered assistant. Learn how to leverage Copilot to enhance productivity, automate routine tasks, and improve collaboration within your team. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Practical Ethics and Circular 230 Compliance for CPAs and EAs
-
Virtual
4.00 Credits
Member Price: $129
This comprehensive four-hour course takes CPAs beyond the basics, diving deep into the ethical quandaries that professionals face. Beyond just the rules of Circular 230, you'll explore a variety of ethical issues, discovering the best ways to handle them with integrity and wisdom. The course provides a dual focus: understanding your obligations under Circular 230 and tackling wider ethical challenges that can arise in your day-to-day work. With real-world scenarios and interactive discussions, you'll come away with practical solutions and the confidence to make the right decisions, keeping your practice ethical and your professional standing secure. **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.
What's Going on at the FASB (2025)
-
Virtual
2.00 Credits
Member Price: $89
The course will start with the Accounting Standard Updates effective in 2024 for public entities, private entities, and nonprofits. We will also review year 2 implications of the leases standard including modification accounting. We will 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. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
The Bookkeeper Goes to Prison
-
Virtual
2.00 Credits
Member Price: $89
This course profiles Brenda, a financial executive from the state of Washington. Despite earning her college degree, Brenda did not find employment in her area of study. Instead, she landed a series of dead-end jobs. Business reversals frequently led to the loss of employment. When a company that she knew to be unethical offered her an executive position that included bookkeeping tasks, including overseeing all finances, she accepted. While on the job, Brenda saw owners of the company misappropriating funds. Rather than reporting the fraud, she created an elaborate scheme to benefit herself - without the owner's knowledge. Her bad decisions led to a guilty plea for wire fraud, after authorities accused her of absconding with more than $600,000 in corporate funds. A prison term of 20 months followed. Listen and learn from Brenda's experience. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Advanced ChatGPT for Accountants
-
Virtual
2.00 Credits
Member Price: $89
This course concisely explains the latest "see, hear, speak" multi-modal updates to ChatGPT and how they can be used in an accounting context. New features include vision processing, voice conversation, image generation, real-time Internet access, advanced data analysis, plugins and more. Discover how this technology can be used in mind-blowing ways to analyze financial data, optimize processes, and solve problems in the accounting domain. Through the lens of ChatGPT, practitioners can explore innovative solutions, automate routine tasks, and generate deeper insights and value to their clients and organizations in previously unimaginable workflows. You'll walk away with scores of advanced ChatGPT strategies and tips that can be immediately applied and deliver instant results to elevate the efficiency and effectiveness of your accounting projects and tasks. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Reasonable Compensation for S Corps
-
Virtual
2.00 Credits
Member Price: $89
Between 2010 and 2020 a parade of Court Cases, IRS Factsheets, Job Aids and Internal Memos, plus Heightened IRS scrutiny and Preparer Penalties has brought the issue of 'Reasonable Compensation for S Corp's out of the shadows and placed it forefront as a priority issue for CPA's, EA's, Tax and Financial advisors to cover with their clients. We will explore key court cases, IRS guidelines, preparer penalties and some of the obscure tools the IRS has put in place. We debunk common myths and fiction on how reasonable compensation should be calculated and replace it with facts and methodologies that the IRS relies on. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Beyond the Basics: Financial Ratios You Might Be Overlooking
-
Virtual
1.00 Credits
Member Price: $55
Overview: Understanding your company's financial health requires more than just traditional metrics. This webinar is designed to reveal deeper insights through advanced, underutilized financial ratios. In this session, accounting and finance professionals will explore metrics such as operating leverage, free cash flow yield, and margin of safety-tools that go beyond standard ratios to deliver nuanced perspectives on profitability, risk exposure, and operational efficiency. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
The Controllership Series - Managerial Accounting Basics and Costs
-
Virtual
1.20 Credits
Member Price: $39
Managerial accounting provides economic and financial information for managers and other internal users. Managerial and Financial Accounting have similarities and differences. Each field of accounting deals with the economic events of a business. Both managerial and financial accounting require that a company’s economic events be quantified and communicated to interested parties. This another course in our series on the controller’s role. The controller’s role encompasses many traditional functions. Within this segment of our controllership series, we discuss the area of managerial accounting and the basic concepts that surround this discipline as it primarily relates to cost accounting issues.