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.
The Leadership Skills of Tomorrow: Delegate and Listen
-
Online
2.00 Credits
Mastering two leadership skills will decrease your stress, and give you room to enjoy your career. Delegating and listening are key essential skills to hone to elevate your career. You were born with two ears and one mouth. And yet, good listeners aren't born. World-class listeners deliberately practice this skill, even when their audience is challenging. This is a skill which can be learned. Participants will gain awareness into their blind spots to listening, strategies to regain focus, how to stop interrupting, and demonstrate to their audience they are listening. How often have you said, "It would just be easier if I did this myself?" or "Nobody can do this task as well as I can, so I'll just do it myself." If this sounds like you, then it's time to start working on your delegation skills. Delegation is not only important as a means to save you time, but it is also about developing the next generation of leaders. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Internal Controls for Small and Medium-Sized Entities
-
Online
1.00 Credits
This session explores the importance of internal controls with an emphasis on best practices for small- and medium-sized entities. We will examine the roles of both preventive and detective controls and practical, cost-effective suggestions for implementing effective internal controls will be addressed.
Preparing to be a Forensic Accountant - Focus on Document Review and Handwriting Analysis
-
Online
2.00 Credits
Forensic accounting, forensic accountancy or financial forensics is the specialty practice area of accounting that investigates whether firms engage in financial reporting misconduct. Forensic accountants apply a range of skills and methods to determine whether there has been financial reporting misconduct. Financial forensic engagements may fall into several categories. Economic damages calculations, whether suffered through tort or breach of contract. Post-acquisition disputes such as earnouts or breaches of warranties Bankruptcy, insolvency and reorganization Securities and tax fraud Money laundering Business valuation Computer forensics/e-discovery This session is designed to delve a bit deeper into the world of forensic accounting and identify some of the specific areas of expertise required to become a forensic accountant. We will then first delve deeper into the art of document analysis and handwriting analysis.
Employees Today and Tomorrow: The ROI on Your People?
-
Online
2.00 Credits
Employees drive the written and unwritten culture at your organization. Understanding the key workplace issues and how to solve them in today's environment can maximize the returns that employees provide for an organization. We take a deep dive into the research behind the larger issues with our workforce and discuss multiple practical solutions that will enhance your leadership and growth. How can we realize the most from our staff?
Current Cybersecurity Risk Management Trends
-
Online
2.00 Credits
One of the top concerns of any organization's leadership is how to mitigate the risk of cybersecurity threats, along with the prevention and detection of fraud. This course will focus on the most common cybersecurity vulnerabilities and fraud trends, and best practices for managing them. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
How AI Fits into the Accounting World
-
Online
2.00 Credits
This session is designed as a primer to introduce artificial intelligence (AI) and to discuss how it will impact accountants as they work. The material will briefly explain what AI is and then focus on ways that it is already serving those in the accounting realm. It will close with a look at future AI-centric developments that will have great potential to positively impact the accounting profession. Those wishing to gain an understanding of what artificial intelligence is and how it will be used by accountants should consider attending 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.
Surgent's Communicating Financial Results to Stakeholders: A Guide for Client Advisory Services
-
Online
2.00 Credits
One of the most difficult things for any Client Advisory Services (CAS) professional to learn is how to communicate financial information to non-financial people. To be successful, it's crucial to master this skill, as we frequently explain accounting jargon to those unfamiliar with the field. In this course, we will explore how to properly communicate with stakeholders, including investors, clients, boards of directors, and even other departments. We will explore biases that people have when viewing financial information and even how to make sure we keep our message on point. If you are looking to move up in the financial services world, this course is a must for you.
Surgent's Depreciation Rules for Bonus and Section 179 Expensing
-
Online
2.00 Credits
The Tax Cuts and Jobs Act of 2017 (TCJA) has had a tremendous impact on commercial real estate, including liberalizing the depreciation provisions. Bonus depreciation was expanded and increased from 50 to 100 percent for qualifying assets placed in service beginning after September 27, 2017, through December 31, 2022. After December 31, 2022, the deduction percentage began decreasing by 20 percent per year, fully phasing out after 2026. Bonus depreciation is now available on new and used assets. President Trump favors a permanent extension of the 2017 tax provisions, and we anticipate legislative changes in 2025 that may make the changes in depreciation permanent or extend them beyond 2025. We will be watching legislative developments closely in 2025 to determine how 2025 legislative changes impact the tax depreciation rules.This course qualifies for IRS credit.
Managerial Accounting: Your Prescription for Better Decision Making
-
Online
4.00 Credits
This session revisits useful, but potentially underutilized, managerial accounting techniques. You will appreciate a fresh look at concepts you may not have considered since your college days. We will illustrate practical ways you can immediately implement managerial accounting analysis in your professional endeavors.
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.
Ethics: How to Give and Receive Criticism the Right Way
-
Online
2.00 Credits
How well do you accept criticism? How might it enrich your business - and you - if you did a better job of it? This distinctive webinar will show you why it is in your best interest to accept criticism with gratitude. It's even better to welcome criticism. It's also a good idea to learn how to give criticism the right way. A related topic is the art of giving and receiving apologies, and we'll do a deep dive into this area as well. You'll leave with clear guidelines for how to criticize others, accept criticism from them, give meaningful apologies, and accept apologies with grace and ethical intelligence. The result will be a stronger CPA practice and a better you. 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 Coaching Skills for Managers and Supervisors
-
Online
4.00 Credits
This one-day course will teach effective skills for coaching and training employees. You'll learn how to identify the characteristics of effective coaches and develop coaching strategies to support and assist your team, with the goal of helping them improve morale, productivity and quality. And, you'll learn a five-step approach for giving constructive criticism while managing defensive reactions.
Surgent's The Most Critical Challenges in Not-for-Profit Accounting Today
-
Online
4.00 Credits
In recent years, not-for-profits have applied critical new standards related to contributions of nonfinancial assets, leases, and more. However, with all the focus on the new stuff, have we forgotten any of the old stuff? FASB ASC 958 has a great deal to say about various accounting and reporting issues in the form of its implementation guidance and illustrations. Not knowing this guidance can result in lost time and erroneous applications of GAAP. In this course, we will review some of the most critical illustrative not-for-profit guidance issued by the FASB.This course qualifies for yellow book credit.
Mastering The Three Pillars of Cybersecurity: Team & Compliance
-
Online
1.00 Credits
Are you looking to fortify your practice against the ever-growing threats in the digital landscape? Join us for the third installment of our exclusive webinar series, "Mastering Cybersecurity," brought to you by Practice Protect. In today's digitally connected world, the need for comprehensive cybersecurity is paramount. With cyberattacks becoming more sophisticated, it's crucial to stay ahead of the curve in protecting your sensitive client data. This webinar series is designed to equip CPAs with the knowledge and tools needed to secure their practices and client information effectively.
The SECURE Act 2.0 - Planning Opportunities for Employers
-
Online
1.00 Credits
The Secure Act 2.0 was passed in a flurry of year-end legislation. This one hour program will cover the important changes that employers need to know about company retirement plans. Employers will also need to consider how Secure Act 2.0 will the administration of existing plans or the creation of new ones. This course will provide a concise look at these hot topics. **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.
Internal Control Frameworks for Single Audit
-
Online
1.00 Credits
The Uniform Guidance identifies COSO and the Green Book as best practices for internal controls in governmental audits. This course provides a comprehensive review of the COSO framework, including its 2013 update, and explores its application to the Green Book. Attendees will learn to recall the five components and 17 principles of internal control, understand the benefits of adopting internal control frameworks, and recognize the rationale behind the COSO 2013 update and its impact on auditing practices. Additionally, the course will cover how to leverage Part 6 of the Compliance Supplement to effectively document internal controls.
The Ethics Hour: Dealing With Conflicts of Interest: Members in Business and Industry, featuring Don Minges
-
Online
1.00 Credits
Often a simple situation may seem innocent, but it can lead to large complications quickly. Conflicts of interest are unavoidable and occur frequently for CPAs in business and industry. What will you do when they happen? Will you take the necessary steps to remain ethical and to protect your license? We will show you how in detail. You and I have a responsibility to our organizations and to the public to be ethical. If you do not follow the prescribed steps, as detailed in the Code of Professional Conduct, there will be problems. Do not forget your duty to the public.
New PCAOB Quality Control Standard Overview
-
Online
2.00 Credits
Due to advances in technology, use of outside resources, and more, PCAOB released a new integrated, risk-based standard focused on accountability and continuous improvement for all PCAOB-registered firms. This course will provide an overview of the significant elements and foundational principles of this new standard.
Tax Practice Standards
-
Online
2.00 Credits
Please join us for a comprehensive discussion on standards that professionals must adhere to as tax practitioners. We will be covering the major governing rules, such as Treasury Circular 230, the AICPA Statements on Standards for Tax Services (SSTS), the Internal Revenue Code (IRC) and common law. Also included will be case studies illustrating dilemmas faced by tax practitioners. **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