CPE Catalog & Events
Excelling at Excel: The Magic of Power Query
-
Online
2.00 Credits
Member Price: $79
Elevate your data analysis capabilities with our focused course on Power Query. Tailored for financial professionals, this training will show you how to get started using Power Query and teach you some of the ways to take advantage of its ability to handle messy data and automate repetitive tasks. Harness the efficiency of Power Query to revolutionize the way you work with data. Learn how to "program" your tasks once and set them on repeat, eliminating the need for repetitive, robotic work. This automation not only saves time but also ensures consistency and accuracy in your data processes. Whether you're dealing with complex datasets or simply looking to streamline your reporting processes, this course will equip you with the tools and knowledge to make Excel work for you like never before. Delivery Method: Individual webcastCPE Credit: Business management & organizationProgram Level: Intermediate
Not Just Your Everyday FASB Update
-
Online
4.00 Credits
Member Price: $129
This course highlights significant updates that affect financial reporting and related attestation services. We will explore novel FASB pronouncements while examining the enduring impact of lease accounting and revenue recognition standards. This course will provide reminders regarding both GAAP and non-GAAP financial reporting alternatives for closely held entities. We will also explore selected guidance regarding audit, review, and compilation engagements. Delivery Method: Individual webcastCPE Credit: AccountingProgram Level: Basic
A Practical Guide to Trusts
-
Online
8.00 Credits
Member Price: $245
This course provides financial professionals with a comprehensive understanding of trusts and their role in estate planning. Participants will learn how to determine whether a trust aligns with a client's financial goals and explore strategies to maximize tax efficiency. The course covers various trust structures and their potential to reduce income, estate, and generation-skipping taxes at both federal and state levels. Additionally, it delves into trustee responsibilities and the benefits of irrevocable life insurance trusts and dynasty trusts. With a focus on practical applications and real-world scenarios, this course equips CPAs, EAs, attorneys, bankers, and financial planners with the expertise to navigate probate avoidance, streamline asset distribution, and manage complex tax considerations. Whether working with revocable or irrevocable trusts, participants will gain the tools to enhance their clients' financial well-being across generations. *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 Delivery Method: Individual webcastCPE Credit: TaxesProgram Level: Basic
K2's Accountant's Guide To QuickBooks Online
-
Online
8.00 Credits
Member Price: $225
QuickBooks Online’s (QBO) market share continues to expand, and the Cloud-based accounting platform now dominates the small business market. Yet, most accounting and financial professionals have not participated in any formal training on the Cloud-based accounting service. Thus, they are unaware of many of the tool’s available features and do not work with QuickBooks Online as efficiently and effectively as they should. This course teaches you how to set up QBO and convert QuickBooks Desktop files into a QBO instance. You will learn how to process all types of transactions, including accounts payable, accounts receivable, bank feeds, inventory, and payroll. Further, you will learn how to implement appropriate internal controls and how to capitalize on advanced features such as workflow management and management reports. Join us in this session to learn how to set up QBO properly and take full advantage of all it offers while avoiding common errors and mistakes. Delivery Method: Individual webcastCPE Credit: Accounting, Computer software & applicationsProgram Level: Intermediate
K2's Advanced Excel
-
Online
8.00 Credits
Member Price: $225
If you are an experienced Excel user seeking to elevate your skills, join the K2 team for K2’s Advanced Excel. In this laptop-friendly program, you will learn critical advanced Excel skills in six key areas: 1) collaborating with other users and securing workbooks, 2) using tables to analyze and report data, 3) integrating and manipulating data from external sources, 4) creating and auditing complex formulas, 5) advanced data analysis tools, and 6) visualization techniques to analyze and communicate information. The course draws from over twenty-five years of experience delivering Excel training to accountants and other business professionals. Throughout the program, relevant, real-world examples reinforce the topics presented. Take advantage of this opportunity to become more efficient and proficient in Microsoft Office Excel, the tool of choice for accounting and financial professionals. This course covers advanced Excel topics found in Excel 2019 and newer. Delivery Method: Individual webcastCPE Credit: Accounting, Computer software & applicationsProgram Level: Advanced
K2's Advanced Excel
-
Online
8.00 Credits
Member Price: $225
If you are an experienced Excel user seeking to elevate your skills, join the K2 team for K2’s Advanced Excel. In this laptop-friendly program, you will learn critical advanced Excel skills in six key areas: 1) collaborating with other users and securing workbooks, 2) using tables to analyze and report data, 3) integrating and manipulating data from external sources, 4) creating and auditing complex formulas, 5) advanced data analysis tools, and 6) visualization techniques to analyze and communicate information. The course draws from over twenty-five years of experience delivering Excel training to accountants and other business professionals. Throughout the program, relevant, real-world examples reinforce the topics presented. Take advantage of this opportunity to become more efficient and proficient in Microsoft Office Excel, the tool of choice for accounting and financial professionals. This course covers advanced Excel topics found in Excel 2019 and newer. Delivery Method: Individual webcastCPE Credit: Accounting, Computer software & applicationsProgram Level: Advanced
Forgotten Managerial Accounting Tools for CPAs
-
Online
2.00 Credits
Member Price: $89
This session revisits managerial accounting techniques that you may not have considered for many years, even though they could be invaluable for CPAs in both business and public accounting. You will appreciate a fresh perspective of concepts you may not have considered since your college days. We will illustrate concepts with practical examples that you can immediately bring back to the office! This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.Delivery Method: Individual webcastCPE Credit: AccountingProgram Level: IntermediateThis course is being offered by a 3rd party vendor and will not be accessible on your My CPE page. Webinar access information will be emailed directly to you by CPA Crossings.
The Controllership Series: The Controllers Role in Internal Controls
-
Online
1.50 Credits
Member Price: $59
This course in part of our series on the Controllership Role. Internal control is relevant to everyone in the workplace. It represents our moral responsibility to understand and comply with organization policies and procedures. It also provides the means to hold individuals accountable for their work. The controller is an impactful position that affects a company's processes including financial, compliance and operational. Controller functions vary across companies often following the size and complexity of the business and the industry. Smaller companies require more versatility for the controller Larger companies are more able to segregate job responsibilities across other employees. The controller should be knowledgeable of the various controls to create a control system that will appropriately safeguard company assets and processes. Internal controls are typically comprised of control activities such as authorization, documentation, reconciliation, security and segregation of duties. Delivery Method: Individual webcastCPE Credit: AccountingProgram Level: Update
Leveraging Analytical Procedures to the Fullest on Audits - Case Studies in Strengthening Audit Evidence
-
Online
2.00 Credits
Member Price: $79
Peer review deficiencies commonly relate to the design, documentation, and evaluation of the results of analytical procedures. This course will provide examples of how to strengthen evidence resulting from preliminary, substantive, and final analytics. It will reinforce the elements of strong analytical procedures that may enhance the quality of audits. Delivery Method: Individual webcastCPE Credit: AccountingProgram Level: Basic
PowerPoint: Tips & Tricks for Today's Accountant
-
Online
2.00 Credits
Member Price: $79
PowerPoint is a widely available resource that is potentially underutilized by accountants because many accountants do not stray beyond Excel and Word in the Microsoft Office suite. You will learn how to create and edit a professional PowerPoint slide deck. This session places particular emphasis on efficiency tips and tricks that will allow you to develop creative, professional visual aids while minimizing time and effort. The course’s author will share personal insights he has cultivated throughout more than two decades of public speaking. Although the session will focus on creating and editing slides, we will illustrate best practices for presentation delivery. We will also explain how PowerPoint can be used for purposes other than delivering presentations. Delivery Method: Individual webcastCPE Credit: Computer software & applicationsProgram Level: Basic
Defining Where and Why Internal Controls are Needed
-
Online
2.00 Credits
Member Price: $89
Most organizations have many of the basic controls required to operate in place. However, a notable percentage of these companies do not have important measures that can help enhance security, productivity, and the quality of information available for decision making. In this session, we work to identify areas where important internal control measures are needed. We spend time explaining why these controls should be created, and show in detail some specific controls that would be beneficial if utilized. Those wishing to strengthen an internal control system should strongly 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.Delivery Method: Individual webcastCPE Credit: AccountingProgram Level: BasicThis course is being offered by a 3rd party vendor and will not be accessible on your My CPE page. Webinar access information will be emailed directly to you by CPA Crossings.
Generative AI in Practice-Boost Efficiency and Profitability
-
Online
2.00 Credits
Member Price: $89
Unlock the potential of generative AI to streamline accounting, auditing, tax , and advisory services. This course focuses on practical applications that can save you time and enhance profitability. Learn how to integrate AI tools into your workflows to automate tasks, improve accuracy, and deliver higher-value services. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.Delivery Method: Individual webcastCPE Credit: Information technologyProgram Level: BasicThis course is being offered by a 3rd party vendor and will not be accessible on your My CPE page. Webinar access information will be emailed directly to you by CPA Crossings.
K2's Formatting Excel Spreadsheets The Right Way
-
Online
2.00 Credits
Member Price: $79
Some estimates indicate that business professionals spend almost half their time in Excel applying formats. If you want better formatting results in less time, participate in this session to learn the best practices for formatting your Excel spreadsheets. In this session, you will learn best practices for applying formats in your workbooks. More specifically, you will learn about features such as Custom Format Codes, Templates, Styles, the Accounting Format, Precision as Displayed, date formats, and many others, all of which can save you substantial time when working in Excel. Delivery Method: Individual webcastCPE Credit: Computer software & applicationsProgram Level: Intermediate
K2's Taking A Fresh Look At Teams
-
Online
2.00 Credits
Member Price: $79
Just because Microsoft Teams is no longer a new tool doesn't mean it hasn't evolved & it certainly has! Since its introduction in 2016, Teams has become the de facto business productivity platform for organizations worldwide. Yet, many users barely scratch the surface of all that Teams offers. Participate in this session to learn how to get more from Teams and enhance your ROI on the platform. In this session, you will learn about the core options available in Teams and how to leverage them. You will also learn about new enhancements in Teams, including threaded conversations, enhanced meeting features, and integration with Microsoft's Copilot platform. If you use Teams and want a deeper understanding of the platform, don't miss your opportunity to participate in this session. Delivery Method: Individual webcastCPE Credit: Computer software & applicationsProgram Level: Intermediate
Surgent's Depreciation Rules for Bonus and Section 179 Expensing
-
Online
2.00 Credits
Member Price: $99
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.Delivery Method: Individual webcastCPE Credit: TaxesProgram Level: BasicThis course is being offered by a 3rd party vendor and will not be accessible on your My CPE page. Webinar access information will be emailed directly to you by Surgent McCoy.
Surgent's Taking Advantage of Installment Sales
-
Online
2.00 Credits
Member Price: $99
When real property is sold for a gain, we always try to find ways to defer recognizing income so that it won't be necessary to send a check to Uncle Sam. There is a provision within the Internal Revenue Code that allows the taxpayer to defer recognition of immediate taxable gain in the year of sale known as an "installment sale." Knowing how and when to utilize this provision makes the Accounting and Finance Professionals very valuable to either their client or the entity they work for. We will also discuss recent proposals that could impact the future of this provision.Delivery Method: Individual webcastCPE Credit: TaxesProgram Level: IntermediateThis course is being offered by a 3rd party vendor and will not be accessible on your My CPE page. Webinar access information will be emailed directly to you by Surgent McCoy.
Surgent's Tax Research
-
Online
2.00 Credits
Member Price: $99
Answering clients' tax questions accurately and on time is a key challenge for tax practitioners. Through simple, plain language explanations and examples, this course will help practitioners perform tax research more efficiently by describing the structure of the primary sources, highlighting the differences between primary and secondary sources, and detailing the steps in the tax research process.Delivery Method: Individual webcastCPE Credit: TaxesProgram Level: IntermediateThis course is being offered by a 3rd party vendor and will not be accessible on your My CPE page. Webinar access information will be emailed directly to you by Surgent McCoy.
The Seven High Quality Questions that Lead to Success & Solutions
-
Online
2.50 Credits
Member Price: $79
“How will I EVER get this all done?" It’s a question I often hear from clients and on a particularly stressful day, I can hear myself saying these words! Instead of helping us focus, it's a question that leads to stress, anxiety and overwhelm! Regardless of where we are in business and in life, we will run into challenges and problems as we navigate business growth, leadership, work life balance and our quest for success and happiness. This workshop will explore the 7 HIGH QUALITY questions that lead to relief, enthusiasm and success. It will be an interactive exploration that will leave you with a game plan to use right away, as well as an opportunity to practice the mindset that the most successful and happiest people use daily. This program is for both the entrepreneur who wants to be more effective in their day as well as team leaders who want to stand out in their organization. For the business owner or staff member you can expect a new way to work with your day so that it's profitable, productive and happier. For leaders, you will learn new up- leveled skills to increase your efficiency, communication and productivity. You and your team will shine. Your staff will feel appreciated and connected to their value as well as the company's goals. Albert Einstein said 'we can't solve our problems with the same thinking we used when we created them'. The quality of your question will impact the quality of your solution. Learn the 7 questions that take you from confused and frustrated to creative and focused. Delivery Method: Individual webcastCPE Credit: Personal developmentProgram Level: Basic
Common Yellow Book & Single Audit Deficiencies
-
Online
4.00 Credits
Member Price: $129
Yellow Book and Single Audit engagements are considered must-select engagements for peer review. This course will review the common deficiencies noted by peer reviewers and federal agencies. We'll focus on the requirements of Yellow Book independence, CPE, and reporting. We will also review deficiencies related to internal controls over compliance, compliance testing, and major program determination for Single Audits. We'll close the course with a look at the deficiencies often identified in COVID-related funds. Delivery Method: Individual webcastCPE Credit: AuditingProgram Level: Intermediate
K2's Working Remotely- The New Normal
-
Online
4.00 Credits
Member Price: $129
Many team members now work remotely, whether by choice or necessity. As a result, questions abound about remote access to desktops and data, security, communications, collaboration, and other considerations in this new normal. When implemented correctly, remote work strategies can be a “win-win” for all involved; however, failed implementations may lead to inefficiencies, security issues, and dissatisfied team members. This session will teach you today’s best practices for working remotely. Specifically, you will learn about various remote access tools, communication and collaboration options, and security best practices. You will also learn about managing and monitoring workflows in remote work environments and tools you can use. After completing this session, you can implement a remote work strategy that yields efficiency, security, and satisfaction to all involved. Delivery Method: Individual webcastCPE Credit: Information technologyProgram Level: Intermediate
