CPE Catalog
Note
AICPA On-Demand & Self-Study courses take up to 24 hours to process.
K2's 2023 Securing Your Data: Practical Tools For Protecting Information
-
Online
4.00 Credits
Security is not optional, and yesterday’s security techniques do not minimize today’s security threats. Therefore, now is the time for you to tune up what you know about protecting sensitive data. This program will teach you the latest tools and techniques for securing your data, including encryption, virus protection, safe communications, electronic signatures, secure authentication, and more. You will also learn how to implement a practical, five-step approach to securing your PC and the questions you should ask your staff to ensure server-based information remains protected. Security failures, such as a breach of client or customer data, are costly – they can even drive your company out of business. So, what security tools do you need, and how should you use them to secure your sensitive data and systems? Can you afford to risk attempting to manage today’s threats using yesterday’s techniques? Participate in this program to learn how to identify viable and practical solutions to mitigating today’s security threats.
K2's 2023 Next Generation Excel Reporting
-
Online
8.00 Credits
New features in Excel provide tremendous opportunities to improve Excel-based operational and financial reports. For example, Data Models, Power Query, Data Analysis Expressions, Power Pivot, and many others can help you create more powerful summaries and schedules in less time than ever. Bundle these tools with some of Excel’s “legacy” features, and you have significant new opportunities to improve your Excel-based reporting environments. In this fast-paced seminar, you will learn about the importance of using Power Query to link data into Excel data models and how you can manage these data models to facilitate better and more efficient reporting. Additionally, you will learn how to incorporate Key Performance Indicators, Slicers, and Timelines into your reports to enhance the analytics and understandability of the data. Further, you will learn best practices to quickly and easily format your spreadsheets to give them a polished and professional appearance. This course should be at the top of your professional development list if you use Excel for any reporting process.
Best Non-Google Search Tools for Accountants
-
Online
2.00 Credits
The course explains why you need more than Google to search the Internet and highlights a rich constellation of alternative search engine applications. The session also explains how to set up your own customized online research management platform, and discusses dynamic search strategies (two-step, vertical and lateral searching) that can be used to gain an extra edge when using any search engine. Participants will walk away with scores of new knowledge sources and streams that will complement their use of Google and improve their online research power. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
2024 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.
Tired of Feeling Drained by Complainers? Build Your Immunity to People's Negativity
-
Online
1.00 Credits
Do you ever get tired of other people's complaining and negativity? How can you stay calm, upbeat, and motivated despite other people’s grumpiness, rudeness, or pessimism? This program is all about helping you be your best. Even though you may not be able to change your colleagues, customers, or even your boss, you can reduce your stress and frustration by changing how you respond. Staying positive and calm is easier when you learn how to build your immunity. This course teaches you Tina’s proprietary five-step “Immunity to Negativity Formula™”. You’ll learn simple techniques for staying calm and choosing to respond as your best self. This is a key skill you can build for yourself so you can enjoy less stress and frustration. You can even teach others so they can improve customer service, teamwork, and relationships within your company.
2024 Inflation Reduction Act of 2022: Review and Update
-
Online
2.00 Credits
This program will examine the key provisions of the Inflation Reduction Act of 2022 that was enacted to not only curb inflation, but reduce the deficit, promote clean energy solutions, and much more. Learn how this new legislation can provide tax savings for both your individual and business 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.
Business Tax Update: Recent Developments
-
Online
2.00 Credits
A discussion of the latest 2021/222 tax developments impacting business taxpayers, with a focus on important provisions, rules and concepts. 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 Excel for Accountants: Using Excel to Cleanse and Prepare Data
-
Online
2.00 Credits
Do you ever import data into Excel, and then spend a bunch of time manually preparing it for use? Perhaps you delete extra columns or rows. Maybe you need to split a single column into multiple columns, or, combine multiple columns into a single column. The good news is that many of these transformations can be fully automated with Excel! The Get & Transform tools built-in to Excel 2016 for Windows, formerly available as the Power Query add-in, are incredibly powerful. At a high level, they enable us to retrieve data from a variety of sources and prepare it for use as needed. In this session, we'll use Get & Transform queries to help with several common tasks, including flattening data, splitting and combining columns, formatting data, unpivoting summarized data, and combining several csv exports. If you frequently export/import data from one system to another, you will want to understand how to use a Get & Transform query to streamline your work.
K2'S 2022 An Accountant's Guide To Blockchain And Cryptocurrency
-
Online
4.00 Credits
Blockchain technology offers the promise of digital truth. It provides a transparent, permanent, immutable, and high-speed record-keeping system when appropriately implemented. The possibilities are endless, from managing the logistics of supply chain networks to facilitating international commerce. The adoption of this technology is growing, with millions of new users every year. Organizations adopt this technology every day to help improve their existing operations through its ledger capabilities or executing smart contracts. Cryptocurrency is one example of blockchain technology. Its growth and value have exploded to over $2 trillion in the last few years. This growth has helped to fuel widespread adoption amongst Wall Street and regular investors alike. While more popular than ever, few business professionals understand these technologies, their capabilities, risks, and potential impacts on business operations and processes, such as contract execution, recording and maintaining real estate ownership records, and supply chains. In fact, this incredible technology is a mystery for most accounting professionals. This course will provide a detailed and in-depth look at this technology, including a detailed overview of the underlying technology, the benefits, the risks, the major players, and many practical applications. By participating in this session, you will gain a deeper understanding of the inner workings of this technology and recommendations on getting started.
Forensic Accounting: Court Approved Methods of Proof
-
Online
4.00 Credits
How does a forensic accountant calculate financial losses? Federal courts have approved various ways to calculate losses ranging from net worth method of proof to the expenditures method. Each method of proof depends on the available facts to the forensic accountant. This presentation will focus on the various court approved methods of proof, when to use them, and how to calculate the total loss. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Audit 504: Making Rain - Success with Clients and Prospects
-
Online
2.00 Credits
Making Rain - Improving Success with Retaining Clients and Attracting Prospects provides tips and techniques for ensuring that your firm has the capacity to grow and expand its book of business in a healthy way. It costs more money to develop a new client than to simply retain an existing one. While a CPA firm with longevity needs to continuously develop new business to replace departing clients, a proper balance of marketing efforts should be divided between existing clients and prospects. Note: This course is recommended as a part of a 8-hour audit skills curriculum for managers, while it is also appropriate for anyone who has client relationship or prospecting responsibilities. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Become a Data Analysis Expert
-
Online
2.00 Credits
In today's rapidly evolving business landscape, accounting professionals are expected to be more than just number crunchers, they are expected to be insightful interpreters of data. In an era where data is king, this course is your gateway to becoming a savvy data analyst, giving you a competitive edge in your field. We will guide you through the intricacies of making complex data analysis approachable and engaging. You will learn the all important Data Analysis Process Flow that will take you from collecting data all the way to making insightful decisions based upon your data. We will explore the basics of data modeling that will allow you to access data from multiple sources and use sophisticated calculations to create our data metrics. You will learn how to create interactive dashboards, perform sophisticated reporting, and uncover deep insights from your data. Whether you're looking to streamline your reporting process, enhance your data visualization skills, or make more data-driven decisions, this course is tailored to meet those needs. It's not just about learning a tool; it's about enhancing your professional identity as a forward-thinking accounting professional. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Coaching & Counseling - Addressing Misconduct
-
Online
1.20 Credits
The objective of corrective action is to change conduct through teaching. Corrective action may be sequential, out of order, repetitive, or not appropriate to take at all. The action selected should reflect the type, frequency, and severity of the misconduct. Changing conduct through teaching requires effective employee relations skills. This course provides practical knowledge and scripts for handling a wide array of sensitive misconduct situations with good judgment, such that personal and employer liability is avoided.
Keys to Building an Inclusive and Culturally Competent Workplace: A Guide for HR Professionals and Business Owners
-
Online
1.80 Credits
HR Professionals are business leaders who, regardless of their level of experience, are responsible for maintaining a high level of interpersonal proficiency in their job function. The willingness to gain a genuine understanding and respect for diversity and the incorporation of a safe and inclusive environment of employees in the workplace, is a strong measure of the HR Professionals’ efficacy in this area. This training is geared towards improving and/ or elevating the HR Professionals’ knowledge of cultural competence in the workplace and what it means to truly adopt a culture of diversity and inclusivity. When HR professionals take responsibility for teaching others about the differences and benefits that multiple cultures and diverse backgrounds bring to the organization, research shows that companies are more likely to win top talent and yield improvement in customer orientation, employee satisfaction and decision making, as well as a cycle of increasing returns.
An Ethical Approach to Mental Health Issues at Work
-
Online
2.00 Credits
In the past talking about mental issues in the workplace was taboo. Not anymore!!! So many of us suffer with mental health issues at some point in our lives. Poor mental health impacts, from a work perspective, productivity, absenteeism, retention and more. On a personal level it often causes personal distress and hopelessness. The Society of Human Resource Management (SHRM) is addressing mental illness as a critical factor for the wellbeing of organizations. Additionally, the EEOC is cracking down on mental health discrimination. It is a very important topic for any functional business! This ethics-based webinar will bring awareness to this issue and offer suggestions on managing mental health issues in ethical, compassionate and healthy ways. It will offer suggestions on managing mental health issues for leaders, managers and all staff to create and environment of safety and belonging. This webinar will also address the topic of suicide talking about warning signs and resources. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
2024 Federal Tax Update for Individuals with Doug Van Der Aa
-
Online
4.00 Credits
This program will address recent legislation, rulings and developments affecting individual taxpayers and provide practitioners with a comprehensive update for the upcoming tax season. **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.
K2's 2023 Technology For CPAs - Don't Get Left Behind
-
Online
8.00 Credits
How good are you with the technology you use daily? What new technology tools are available that could save you time and make you more effective? Technology continues to accelerate rapidly, and the need to keep pace is essential. If you are not an information technology (IT) expert but need a technology update to maintain and improve your skills to serve your companies or clients more efficiently and effectively, this course is for you! In this fast-paced, update-style course, you will survey today’s IT environment, learning about computer hardware, software (including Microsoft Office), operating systems (including Windows 10), and what they mean for you, and peripheral devices. You will also learn about significant trends in information technology and how to take advantage of the opportunities presented by these trends. Examples include the latest Excel features, working with PDF files, and security and privacy issues. Additionally, you will learn how to improve the overall performance of your IT investment, thereby increasing your return on investment. Throughout this program, you will learn from real-time demonstrations of practical applications of the latest tools, which can provide you with the knowledge you need to harness the power of technology, both now and in the future. Register now for this “don’t miss” opportunity to get the skills required to enhance the value of your IT investment.
Compilation, Preparation and Review Basics and Peer Reviews
-
Online
2.00 Credits
Cover the basic requirements for performing preparation, compilation, and review engagements under Statements on Standards for Accounting and Review Services (SSARS), including the new SSARS No. 25, Materiality in a Review of Financial Statements and Adverse Conclusions. Review common issues found on SSARS engagements in connection with peer reviews and the impact of various findings on the results of a peer review. Identify key issues to consider during SSARS engagements, and determine how to incorporate quality control recommendations and tips for performing high-quality SSARS engagements. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event
Feeling Stressed from Change & Uncertainty? How to Stay Positive when Things Get Tough
-
Online
1.60 Credits
When we’re going through change and life feels out of balance, it’s normal to get stuck focused on all the problems and challenges that stress us out. How will the changes impact our team, our job, our lives? It doesn’t help that our brains are wired to anticipate the worst possible outcome. This wiring can make it difficult to be our best; to provide our best teamwork, our best ideas, and our best leadership. However, studies show that there are things we can do to shift our thinking so we can spend more time in positive emotions, like curiosity, enthusiasm, and optimism. Now everything gets easier and better, including: ~ Productivity ~ Customer relations ~ Change management ~ Teamwork ~ Leadership Join Tina to learn and apply The Path for Positivity™ framework based in Positive Psychology. You will learn strategies and insights to help you experience less stress, a smoother transition, and higher productivity even when the future seems uncertain. Share the framework and strategies with your team, too.
2024 SAS 145: Modern Risk-Based Auditing
-
Online
2.00 Credits
This program provides in-depth coverage of SAS 145, a major standard that helps auditors enhance risk assessment procedures through improved techniques for identifying and assessing risks of material misstatement. This session is essential for CPAs that perform audits. The discussion will also be insightful for auditees and other professionals who want to maintain awareness of current auditing guidance.