Skip to main content

CPE Catalog

Note

AICPA On-Demand & Self-Study courses take up to 24 hours to process. 

Showing 11030 All Results

K2's 2023 Mastering Advanced Excel Functions

-

Online

4.00 Credits

With approximately 500 functions now available in Excel, some newer and more powerful tools are easy to overlook. But, if you do that, your productivity will suffer. In this session, you will learn how to take advantage of many of Excel’s more advanced features – some new and some legacy – to elevate your productivity to higher levels. In this session, you will learn about many of Excel’s newer tools, including XLOOKUP, SUMIFS, SWITCH, and STOCKHISTORY. Also included in this session are discussions of advanced financial functions, such as IPMT and PPMT, and how to retrieve summarized data easily using GETPIVOTDATA and CUBEVALUE. Additionally, you will learn how to make sophisticated calculations easier with Dynamic Array formulas, harness the AGGREGATE function's power, and create more accurate forecasts with Excel’s FORECAST.ETS function. No matter your experience working with Excel, participating in this course will help you work more efficiently and effectively in Excel.

K2's 2024 Improving Productivity With Microsoft 365/Office 365 Cloud Applications

-

Online

4.00 Credits

Isn’t it time you learned how to take advantage of critical features available in your Microsoft 365/Office 365 subscription? In this session, you will learn to use tools such as Teams, Planner, Power Automate, and others to enhance productivity and efficiency.

K2's 2024 Small Business Accounting Shootout

-

Online

4.00 Credits

Small business accounting solutions have never been better, with many fantastic options. In this session, you will learn about the relative strengths of these platforms so you can make the right choice when selecting and implementing a solution.

Inventory, Expense and Payroll Fraud

-

Online

2.00 Credits

Inventory is a wonderful place to both hide fraud and commit fraud.  The reasons that inventory is subject to so much fraud is the it is often very large, spread out over a large area, and many people have access to it.  When there are little or no internal controls related to inventory control, you are begging employees to steal it.  No with so many ways to dispose of stolen inventory via the internet, i.e., EBAY, inventory fraud is much more appealing to a lot of individuals. The more common ways to commit expense fraud and how to cover it up will also be discussed.  Travel and entertainment are some of the favorite areas of committing expense fraud.  In addition, payroll fraud will be discussed.  Although there are many ways to commit payroll fraud, it is very easy to prevent. This presentation is designed to familiarize the participants with the many ways to commit inventory, expense and payroll fraud, how to detect it, and more importantly, how to prevent it.

2024 Working Through Grief and Loss - How to Build a Supportive Workplace

-

Online

1.00 Credits

Now more than ever, navigating loss, grief and crisis in the workplace is a skillset that leaders must possess. Keeping the heart in human resources is so important, especially in this post-pandemic state we are living in. We will explore ways that you can show empathy to your employees while also balancing your business needs. 

The Untold LinkedIn Hyper-Growth Story

-

Online

1.00 Credits

LinkedIn is considered by many to be one of the most impressive growth stories in the history of technology companies in Silicon Valley. In just 16 years it grew from nothing into a game changing company in a new industry and the performance of the company and the stock broke all kinds of records. The untold story of LinkeIn's success is that they grew a world class company and a world class team in the midst of a massive war for talent where their competitors for talent (Google, Facebook, Apple and more) could out pay and out perk and out benefit them. They grew a company when all the leaders had never built a company before. Despite the odds the leadership team succeeded and built a company and a culture that many still consider the gold standard. Steve Cadigan was at the epicenter of this growth as the first Chief HR Officer of LinkeIn and he delivers a front row seat to the wild and crazy and amazing ride that took LinkedIn from an unknown career destination into one of the top places to work in the world! Steve delivers a first hand account of lessons learned, mistakes made and what it was like to be facing a situation he had never faced before - hypergrowth. Wherever you are in your learning journey you will enjoy this class.

Tax Power Ethics for Tax Professionals

-

Online

2.00 Credits

Award winning discussion leader, former state accountancy board chair, and lifelong tax practitioner Mark Hugh will review ethics for tax professionals: the AICPA Code of Professional Conduct and interpretations; the Statements on Standards for Tax Services; tax preparer standards in the Internal Revenue Code; the rules for practice with and before the IRS, including IRS Circular 230; new developments; and discuss examples of best practices and case studies.

Ethics in the World of AI: An Accountant's Guide to Managing the Risks

-

Online

2.00 Credits

Discover "Ethics in the World of AI: A CPAs Guide to Managing Risks" - a concise 2-hour training session for certified public accountants. Karl Ahlrichs and Jennifer Elder discuss the current uses of AI in business, nine risk areas, and provide practical suggestions to address these risks effectively. Equip yourself with the tools to navigate the ethical challenges of AI, upholding professional standards while embracing transformative technology. Join us now for a journey towards ethical excellence in AI.

Accounting for Leases

-

Online

2.60 Credits

In February 2016, FASB issued ASU 2016-02, Leases, which provides new guidelines that change the accounting for leasing arrangements. To be able to properly account for leases, financial professionals must understand ASU 2016-02 (also referred to as Topic 842). This guidance covers information on how leases should be accounted for. The previous leasing standard (ASC 840) had been in existence for almost 40 years. Under ASC Topic 842, lessors continue to classify leases as operating, direct financing, or sales-type. While lessees now classify leases as operating or financing leases. Previous guidance only required capital leases to be reflected on the BS. The new guidance requires all leases to be reflected on the BS. This is a major change for organizations and will cause their balance sheets to swell as leases must now be disclosed on the balance sheet. The standards original effective dates were prior to 2019. In April 2020, due to COVID-19, FASB voted to defer the effective date for ASC 842 for private companies and certain not-for-profit's for one year. For private companies and private not-for-profits, the leasing standard will be effective for fiscal years beginning after December 15, 2021, and interim periods within fiscal years beginning after December 15, 2022. For public companies the leasing standard is effective for fiscal years beginning after December 15, 2019, including interim periods within those fiscal years. The course covers elements of lease classification for both lessees and lessors. Also, numerous examples are incorporated as reference.  

2024 Estate Planning for Today and Beyond

-

Online

8.00 Credits

Estate planning continues to evolve, and staying informed about the latest trends and strategies is crucial for professionals in the field. This forward-looking course delves into the intricacies of estate planning, with a specific focus on current issues. Participants will explore cutting-edge techniques, emerging legal considerations, and industry developments to ensure they are equipped with the knowledge and skills to create effective estate plans that withstand the test of time and safeguard their clients' legacies.  

The Single Audit from Beginning to End Update

-

Online

8.00 Credits

This course is an updated overview of the single audit of state and local governments and not-for-profit organizations under the OMB Unified Circular, as well as the applicable AICPA standards for compliance audits. 

The Yellow Book: From Beginning to End

-

Online

8.00 Credits

A comprehensive review of the newest version of the U.S. Government Accountability Office’s Government Auditing Standards, otherwise known as “the Yellow Book.”  The standard will affect all auditors who perform audits of government and nonprofit organizations who receive federal funds, or where application of GAO standards is required by law, regulation or contract.  It does not address the standards applicable to performance audits.

The Controller Function - Inventory Part 1

-

Online

1.80 Credits

This course is one of the courses dedicated to our Controllership series. This series of courses is dedicated to exploring the traditional controller role and stepping out of the box to identify areas where the controller can continue to add strategic value to their organizations. Within this segment of our controllership series, we will discuss the area of inventory. This specific segment in the first part of a two-part series on inventory. We explore how the controller can move these responsibilities into more of a strategic role. This course takes a look at some of the typical concepts and duties involved in the inventory function that is sometimes viewed as operational roles. We explore how these areas are strongly tied to the importance of the controllership role and how the controller can add value in each area.    

CFO Series: Better Management Reports Clear + Simple =Great!

-

Online

2.00 Credits

Most management reports are misunderstood and misused. Reports are dull and have been presented in the same manner for decades. Do your audiences sometimes fail to get the message? Learn how to grab your audiences' attention and deliver an actionable message. Discover the power of "The Trifecta" and the five secrets of effective reports and presentations. Learn how to make your messaging a "re-memorable event" and how to give the users what they need to know. We will discuss how to make your reports useful and understandable to your audience. If management does not understand the financial reports they receive (most do not) this seminar will provide keen insights to make your reports truly useful. Be the hero who delivers informative reports. We will show great examples of what to do and how.

DEI From the Inside Out: Part 1

-

Online

3.00 Credits

In this session, participants will delve into a comprehensive exploration of what Diversity, Equity, and Inclusion (DEI) truly entails. Often met with resistance due to its perceived condemnatory nature, this session aims to provide a more nuanced definition of DEI, fostering a better understanding among attendees. By demystifying the language surrounding DEI, participants will be equipped with straightforward approaches to seamlessly integrate these principles into their perspectives. This session will spotlight the distinctive features of our DEI model in comparison to other systems. Attendees will gain valuable insights into the model, understanding its unique perspective on achieving DEI success. At its core, our approach is grounded in the simple premise that we are all human beings sharing the common human experience. The goal is to convey to participants the importance of embracing DEI through this paradigm, effectively humanizing the DEI experience. One of the most remarkable DEI experiences unfolded during my son's 18th birthday celebration in our backyard. The event brought together individuals from diverse backgrounds, spanning various walks of life and races, who interacted in a profoundly humanistic manner— an encounter unlike any I had witnessed before. In this session, we will deconstruct this experience and draw parallels to its relevance in workplace dynamics.

SAS No. 122, AU 240, Consideration of Fraud in a Financial Statement Audit

-

Online

3.00 Credits

When performing a financial statement audit, auditors have always been responsible for the detection of anything that would cause a material misstatement of the financial statements whether caused by error of fraud.  However, in the past the audit profession focused on material misstatements due to errors and more or less ignored the possibility of misstatements due to fraud.  Now, SAS No. 122, AU 240 requires significant documentation as to what the auditor did in order to determine if there any material risk of a misstatement of the financial statements.  This presentation is an overview of what the auditor is to document in there working papers on every financial audit as to the procedures they performed in order to determine the risk of a material misstatement.  If a material risk is discovered, they are then required to document what they did in order to determine if the financial statements were misstated.

2024 Stand Out - How to Create a Unique Employer Brand

-

Online

1.00 Credits

Learn why creating an employer brand is so important and instrumental in competing in today's competitive marketplace. Elevate your recruiting experience for candidates and onboarding process for new hires to enhance your employer's brand.

Diversity, Inclusion, Equity & Belonging

-

Online

1.00 Credits

Many organizations unconsciously fail to exhibit diversity, inclusion and belonging.  This session provides an opportunity for leaders to  understand diversity language and definitions, build awareness of biases and stereotypes, recognize how our own actions protect our awareness gaps, and find a level of understanding concerning where we are and where we want to be in the future. 

The Controller Function - Inventory Part 2 - Valuation, Inventory Methods and Inventory Fraud

-

Online

1.50 Credits

This course is one of the courses dedicated to our Controllership Series. This series of courses is dedicated to exploring the traditional controller role and stepping out of the box to identify areas where the controller can continue to add strategic value to their organizations. Within this segment of our controllership series, we continue our discussion on inventory from segment one. This specific segment focuses on areas of inventory valuation, the types of physical inventory methods, and inventory fraud. These areas are critical for the controller to have a strong comprehension of and also participate in the development of policies and procedures.      

State Tax Nexus: Frequently Awkward Questions

-

Online

2.00 Credits

Award winning discussion leader Mark Hugh discusses both nexus basics and new developments in the dynamic, ever changing world of state income and sales tax nexus. This valuable course answers your frequently asked questions, reviews key factors in examining potential nexus consequences, takes a tour through the rules in states comprising 50% of the US, and identifies free, online multistate resources.