CPE Catalog
Note
AICPA On-Demand & Self-Study courses take up to 24 hours to process.
K2's Excel PivotTables for Accountants
-
Online
8.00 Credits
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.
Consulting Services Secrets
-
Online
1.00 Credits
Award winning discussion leader Mark Hugh discusses how to create and capture value with consulting services. Whether you want to consult a little or full time, this valuable course reviews identifying a specialty, growing a practice, capturing value, creating deliverables, and effective marketplace marketing strategies.
Tech It to the Next Level: Slim Your Team for Max Efficiency
-
Online
1.00 Credits
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.
Fraud Busters: Controls to Prevent & Detect Fraud
-
Online
2.00 Credits
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.
Awesome Business Lessons from the Past: Learn from the Best!
-
Online
2.00 Credits
Why not learn, or re-learn, some amazing business lessons from the past that are still effective today? What did Henry Ford do when annual employee turnover was 370% and workers demanded more pay? Sound familiar to today’s world? Ford’s solution worked! We see today’s problems and believe that these problems have never occurred before. Not true. We will discuss timeless business lessons that are as practical today as when they were written decades ago. We will review; ‘How to Win Friends and Influence People,’ ‘Today and Tomorrow,’ and ‘The Art of War.’ Let's learn from the very best, as these lessons have been battle-tested and proven over time.
K2's Office Scripts - The New Macros
-
Online
2.00 Credits
Office Scripts is a new feature that allows you to automate tasks in Excel and other Office applications. Unlike VBA, a legacy language that runs only on Windows, Office Scripts can run on any platform and device that supports Office on the web. Further, Office Scripts has a modern and intuitive interface that lets you easily create, edit, and share your scripts. Office Scripts are stored in the Cloud, and they work with Office Online apps and integrate with Power Automate for process automation. Save time and improve productivity using Office Scripts in Excel and other Office applications.
Supporting Mental Wellness to Thrive in Work and Life
-
Online
2.00 Credits
In today's fast-paced world, maintaining a healthy work-life balance is essential for mental wellness. This course is designed to provide practical tools and strategies to help you create a balanced, fulfilling life. You'll learn actionable techniques for improving sleep hygiene, incorporating proper nutrition, fostering open communication, and managing stress. Whether you're struggling with burnout, seeking better work-life harmony, or simply looking to improve your overall well-being, this course offers valuable insights and tools to help you thrive. Designed to fit into your busy schedule, it delivers the guidance you need to make practical, sustainable changes in your life, starting today. 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 Getting Ready for Busy Season: Review Individual Tax Form Changes
-
Online
2.00 Credits
Getting ready for busy season involves not only knowing the tax rules for 2025, but also knowing how those rules are incorporated into the IRS tax forms practitioners will be using to prepare 2025 tax returns. This course provides tax return preparer attendees with an up-to-date review of important new tax forms, key tax developments, and tax law changes as they are reflected in IRS forms for 2025 and IRS filing issues and deadlines as they relate to 2025.This course qualifies for IRS credit.
Surgent's Understanding S Corporation Taxation: Late S Corporation Elections, Disproportionate Distributions, and Selling Shares
-
Online
2.00 Credits
S corporation taxation has a lot of pieces. There are helpful elections you can make that can potentially save your client money, but there are also rigid rules to adhere to. For example, if there is more than one class of stock, it can terminate the S corporation election. Learning how to successfully navigate these rules can make all the difference. In this course, we will discuss some of the more common specialty areas experienced by practitioners - late filing relief for S corporation elections, disproportionate distributions, and selling S corporation shares. While these items may not come up on every single Form 1120-S, you will be able to add more value to clients when they do.This course qualifies for IRS credit.
Will Your Ethics Be Burned by Burnout?
-
Online
2.00 Credits
Ethical behavior is not a destination it is a journey with twists, turns, and bumps in the road. We are faced with ethical dilemmas every day. Do I speed to make it to a meeting? Do I call in sick because I need a break? When does "helping my child with their homework" become "doing it for them"? CPAs are ethical most of the time, but staying ethical is hard. It gets harder when we are under stress. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
The Art of Marketing for CPAs
-
Online
4.00 Credits
To make more money in less time, all accountants need to learn to market themselves effectively to their clients or their firm. For better or worse, promotions and more money go to those who are the best marketers, rather than the most competent accountants. In this fascinating and fun workshop, participants will learn seven key ways to get more clients and/or promotions through the art of marketing.
K2's Business Intelligence, Featuring Microsoft's Power BI Tools
-
Online
8.00 Credits
Business Intelligence (BI) is perhaps the hottest topic in most professional circles in today’s business climate. Increasingly, organizations of all sizes seek to take advantage of the data available to them to identify previously undiscovered insights and gain competitive advantages thought to be out of reach just a few short years ago. A growing array of tools – from Excel add-ins to dedicated solutions such as Power BI – now allow you to leverage your existing knowledge and skills to create powerful, interactive dashboards and analyzes unthinkable until recently. This program will teach you to implement “do-it-yourself business intelligence” using various techniques and tools. First, you will learn to use advanced Excel data query and summarization features to create Excel-based dashboards. You will then learn how to leverage that knowledge to build even more powerful BI objects using Microsoft’s Power BI tools. If gaining better insights into your data to make better decisions interests you, then join us for a fast-paced look at how you can take advantage of these fantastic tools.
Recruit. Retain. Engage. Mastering LinkedIn for HR Success
-
Online
2.00 Credits
Today's savvy executives use LinkedIn to accelerate hiring, as well as, to promote employee retention and engagement. This interactive session is for the financial executive who is actively growing and nurturing a team or company and wants to leverage LinkedIn, which is the best digital resource available. Join us for this powerful webinar and unlock the full potential of LinkedIn as your HR secret weapon for recruiting top talent, retaining your best employees, and elevating overall team engagement. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Seeing Beyond the Numbers: Analysis for CFOs & Controllers
-
Online
4.00 Credits
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.
PPP Fraud and Financial Professionals
-
Online
2.00 Credits
Casey Crowther did not have a college education, but he had an outstanding work ethic. With little more than a pickup truck and some hand tools, he built a roofing company that grew. Over time, Casey's company employed more than 100 people and generated more than $20 million in annual revenues. With a company of that size, Casey relied upon advice from his bookkeeper when filling out financial documents. As a result of representations he made on bank statements and loan documents, authorities charged Casey with criminal behavior related to PPP loan fraud. What should an accounting professional learn from Casey's story? Stay tuned to find out! 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 The Americans with Disabilities Act and the Family and Medical Leave Act
-
Online
2.00 Credits
The Family and Medical Leave Act (FMLA) and the Americans with Disabilities Act (ADA) were implemented to improve the lives of employees. FMLA allows eligible employees to take job-protected leave for their own serious health conditions or to care for sick family members. The ADA was intended to ensure "equality of opportunity" and "economic self-sufficiency" for individuals with disabilities. Yet both laws have proven challenging for employers. These laws are complex with rules that can be confusing and often misunderstood. This webinar is designed to provide information, guidelines, and examples of the key concepts under both laws.
The New AICPA Statements on Standards for Tax Services
-
Online
2.00 Credits
The SSTS are tax standards that apply to all members who provide tax services and provide the framework for the AICPA ethical guidance for tax practitioners. This program explores the revised AICPA Statements on Standards for Tax Services, effective January 1, 2024.
Preparing and Reviewing Workpapers for Higher Quality Audits
-
Online
4.00 Credits
This course will focus on preparing financial statement audit documentation critical for high quality audits that can pass peer review.
Getting On Top of It All: How to Work Smarter, Not Harder - Part 2
-
Online
4.00 Credits
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 Part 2 of this seminar we will go into more depth about how to get more done in less time, as well as how to not burnout from all the work you do. We will discuss additional methods for working smarter through technology, communication, stress reduction, and creating smart and helpful goals.
K2's Microsoft Teams
-
Online
4.00 Credits
Microsoft Teams is one of the most exciting personal and organizationally productivity tools to ever appear on the business landscape. With Teams, you can communicate and collaborate easily and securely with others, including colleagues outside your organization. Further, you can extend the already-robust functionality in Teams by incorporating add-in solutions with just a few clicks of the mouse. Unfortunately, despite Teams’ power and relatively simple interface, many organizations struggle with deploying and using Teams. In this session, you will learn how you can get up and running quickly in Teams so that you can take full advantage of this powerful tool. More specifically, you will learn how you can get started in Teams and critical decisions that will affect your deployment. Also, you will learn how to work in Teams, including how to take advantage of the chat, voice, and video call services and how to share documents securely with others. Moreover, you will learn how to extend your Teams platform to external organizations for improved communication and collaboration. Additionally, you will identify how you can add other applications into Teams and optimize Team's configuration for the best overall efficiency and security. If you are working with Teams or plan to do so, this is one CPE session you can’t afford to miss!