CPE Catalog
Note
AICPA On-Demand & Self-Study courses take up to 24 hours to process.
Excel for Accounting Professionals Session 4: Conditional Summing and Lookups
-
Online
2.00 Credits
This session opens with conditional summing. If you have not explored conditional summing yet, you are in for a surprise. Conditional summing is a game changer and will absolutely improve efficiency in your reporting workbooks. We then move to removing duplicates to create a list of unique report labels. We conclude with lookup basics. We discuss why we prefer lookups to direct cell references and explore the details of the most popular lookup function, VLOOKUP. The webcast is designed with time for you to work along. This hands-on workshop is an effective way to learn Excel, since you'll be completing the same exercises demonstrated by the instructor. A link will be provided, so you can download the necessary Excel files. During the session, the instructor will provide time for you to complete the exercises using your Microsoft Excel for Windows. For each topic presented, the instructor explains the topic and demonstrates it with Excel exercises. Then, the instructor provides time for you to complete many of the same exercises. Finally, the instructor demonstrates the solutions for all the exercises in the practice workbook and then moves to the next topic. This format allows you to work along rather than just watch passively, enabling you to immediately practice the skills demonstrated.
K2's 2023 Emerging Technologies For Accountants, Including Blockchain And Cryptocurrencies
-
Online
4.00 Credits
Unlike technologies we use every day, many currently emerging technologies can change how we work in the future. This session covers an assortment of technologies nearing mainstream adoption and helps you understand what they do, how they work, and some of the potential risks and rewards they offer. Attend this course, and learn the basics of blockchain, cryptocurrencies, big data, artificial intelligence, and machine learn.
Building Security and Efficiency With Internal Control
-
Online
8.00 Credits
A well-designed internal controls system can and will drive all entity objectives. Too many times control creators focus too much on security. It is important to properly balance protection-based measures with those designed to enhance efficiency. This session works to illustrate the power of a strong and well supported control system. It also discusses steps to take in order to establish such a system. This material is becoming more and more beneficial as companies strive to address many new business challenges such as evolving markets, the rapid rate of change in the business world and the notable increase in governmental and industry-based regulation. Those that desire a balanced and workplace enhancing control system should strongly consider 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.
Big Picture Mega-Trends, Big Data, and World We Now Face
-
Online
2.00 Credits
It is easy for us to get caught up in our work, but it is better to examine the ‘big picture’ by studying the outside factors that impact our business beyond our internal processes and day to day responsibilities. We are sometimes so busy with our tasks that we miss new developments until the developments have a profound impact on us and the organization. This session is designed to review many of these current trends, while thinking and discussing how these trends can impact our organizations and us. This is a fun and lively session that is intended to be interactive with participants either live, virtual or both. Our ever-changing world is evolving more than many realize.
How-To Guide to Fraud Investigations
-
Online
2.00 Credits
Learn how to investigate an asset misappropriate scheme. We will dig into asset misappropriation by learning some of the most common schemes and red flags. Learn data analysis techniques used in the early stages of a fraud investigation. You will be guided through a detailed case study to see forensic accounting techniques in action. This is the most practical fraud investigation course you will ever take. Rather than learning only the theory of fraud, you will learn how a forensic accountant actually investigates fraud from the beginning to the end. We focus on forensic accounting techniques used in the field to prove what happened, who was involved, how much money was stolen, and where the money went. How-To Guide to Fraud Investigations is Part 3 of a series of four courses on fraud investigations. Each course is a stand-alone class that may be taken individually. For comprehensive instruction on completing a fraud investigation from start to finish, take all four. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
HR Guide to Evolving Business Strategy, Finance and Development
-
Online
1.20 Credits
To move beyond the HR realm it is essential for HR professionals to understand planning at the strategic and tactical level. This session is designed to help HR professionals understand the overall strategic planning process so they can contribute at the executive level.
The Motives and Mystery of Ethics-Understanding the Why
-
Online
2.00 Credits
Our guidance on ethics comes from the AICPA and other groups, but it does not fully address the “why” behind ethics. This session will examine and define what ethics is and what it means to varying people in the workplace. Understanding what motivates people and understanding those people are key to both solving ethical dilemmas and workplace issues that can lead to greater job satisfaction and efficiency. To correct an issue, you need to delve into the root cause – the why?
K2's 2024 Time To Advance Automation - Strategies And Tools For Efficiency
-
Online
2.00 Credits
Increasingly, automating business processes is a necessity. In this session, you will learn about real-world examples of automating business processes. Remember, the survival of your business might depend upon successful automation!
Surgent's A Complete Tax Guide to Exit Planning
-
Online
2.00 Credits
When exit planning, it is important to weigh various issues, including tax implications, to achieve an effective management and/or ownership change. Many envision tax-free reorganizations being the most preferable structure to avoid capital gains tax, but the opportunities come at a cost to the seller. This course will provide a well-rounded discussion of the various strategies to consider when advising on exiting a business.This course qualifies for IRS credit.
Surgent's Opportunities in the Metaverse for Accounting and Other Professionals
-
Online
2.00 Credits
It is no secret that accounting firms, like many other organizations, have begun launching operations in the metaverse. For those unsure, the metaverse is a digital or virtual space where participants simulate a host of activities ranging from shopping to entertainment and business transactions. Why wouldn't accounting firms and other professionals want to get in early on this new frontier? All types of businesses have begun purchasing and setting up shop in this new virtual world. These are no small endeavors - professionals are creating business plans to operate successfully in the virtual world that started off originally as a niche format for gamers. Accounting firms are starting to announce their acquisition of virtual real estate, and some are paying a premium to obtain prime locations. To operate successfully in the metaverse, professionals need to understand the environment and the rules of the game. This course provides an introduction to the metaverse and an overview of opportunities, risks and rewards for professionals who wish to stay relevant in the ever-expanding virtual world. Participants will walk away with an understanding of where we are in this rapidly developing space, plus gain insights on how to establish a presence or advise clients who wish to explore metaverse opportunities.
Surgent's The Art of Delegation: Strategies for Improving Your Skills
-
Online
2.00 Credits
One of the most challenging skills for a manager or supervisor to master is delegation. This course will cover a variety of delegation-related topics and provide participants with the necessary knowledge and skills to delegate work and authority effectively.
2024 Accounting & Auditing Update
-
Online
4.00 Credits
The course will start off with a look at the Accounting Standard Updates (ASUs) issued by the FASB that will be effective in 2024 as well as those that may be great for early adoption. The course will also review year 2 issues in lease accounting including how to handle lease modifications. We'll then turn our attention from accounting to auditing where we will cover the audit standards coming down the pike including group audit and quality management.
2024 Year-End Tax Planning: Thinking Outside the Box
-
Online
4.00 Credits
Tax planning is more than an estimated tax calculation, it's a process. Where are we now and what can we change? This timely program will highlight significant 2022-23 tax developments and discuss key tax planning ideas for your clients as you prepare for the upcoming tax season. Don’t wait until late December to start planning for your clients! **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.
Circular 230 and Rogue Return Preparers
-
Online
2.00 Credits
You are not required to be a professional to prepare tax returns, but you are required to abide by regulations when preparing tax returns and representing clients with the IRS. Circular 230 is the guidebook that the United States Treasury uses to regulate those activities. Every year, return preparers are sanctioned, penalized, and sometimes imprisoned for violating various statutes and regulations. If a substantial amount of your CPA firm's revenue comes from tax preparation, this course is a must. Every year, return preparers violate these regulations, and are caught by the IRS. This presentation will help the CPA know the rules so they can stay in compliance with confidence while providing their client with tax preparation and IRS representation service. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Public Speaking and Confident Communication in Business
-
Online
1.00 Credits
No matter what role you play in your professional life, being able to command an audience--whether of one or of thousands--is an important skill. Public speaking, no matter how you slice it, is a practice that is worthy of attention. This workshop teaches you approachable strategies to improve your public speaking and presentation skills, recognizing that everyone comes with different comfort levels and experiences. There is no one-size-fits-all speaking style, and trying to force yourself into a specific presentation persona can be more harmful than helpful. Learn actionable tips to help you be more confident next time you need to take the proverbial (or literal) stage.
Audit 205: Auditing Liabilities and Long-Term Debt Risks
-
Online
2.00 Credits
Auditing Liabilities, Including Long-Term Debt - Addressing the Risks of Completeness, Classification, and Disclosure will discuss tips and techniques for auditing accounts payable, accrued expenses, and common long-term financing arrangements and related debt covenants. The completeness and proper classification of liabilities are the typical higher audit risks. The complexity of the debt financing arrangements may create a significant risk requiring more persuasive audit evidence. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
The Seven High Quality Questions that Lead to Success & Solutions
-
Online
2.50 Credits
“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.
Excel - Using PivotTables for Data Analysis
-
Online
4.00 Credits
Excel is the #1 data analysis tool for accountants, yet many accountants have never learned the basics of data analysis using Excel or the tools that Excel offers to help with data analysis. This session is designed to teach participants the importance of PivotTables for analyzing data. We will demonstrate how PivotTables can make analyzing data an easy task for all accountants. Participants will learn the step-by-step process to create PivotTables and PivotCharts. We will also cover all the setup options and features. This session is presented using Excel 2013. Regardless of the version you are using, ALL concepts covered in this course apply to ALL versions of Excel. 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 2023 Excel Best Practices
-
Online
8.00 Credits
As spreadsheets evolve, so must your practices for creating, editing, and auditing them. In this program, you will gain an in-depth understanding of the best ways to work with Excel by learning best practices associated with Excel spreadsheets in each of the following areas: creating and editing Excel workbooks, securing Excel workbooks, collaborating with others in Excel, and reporting on data contained in Excel. Today’s best practices for Excel differ significantly from those used in the past, and you will learn the best ways to work with Excel spreadsheets in this “must-see” CPE program. Course materials include relevant examples to enhance your learning experience. Join us for this program to help you utilize Excel to its fullest potential.
Payroll Essentials: Ethics in Payroll
-
Online
2.00 Credits
Payroll is among the most common tasks an employer undertakes in the course of running their business. At it's most basic level, payroll consists of an agreement between an employer and employee related to compensation for services. However, once you look under the hood, there is so much more to payroll, including various kinds of compensation, payroll taxes and required reporting on government forms. Ethics in payroll is present in every step in the payroll process, from handling employee confidential information and dealing with pay, compensation and fringe benefits, to acting as an intermediary on behalf of federal, state, and local governments in the collection and remittance of payroll taxes. All levels of payroll staff- from payroll processor to payroll manager to CEO - encounter ethical considerations in their conduct when dealing with payroll matters. This course will discuss ethics as it pertains to payroll. Attendees will leave with a comprehensive framework for ethical decision making in the payroll function, as well as some real-life examples of what happens when stakeholders in the payroll process make the decision to decouple ethics from payroll. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.