CPE Catalog
Note
AICPA On-Demand & Self-Study courses take up to 24 hours to process.
Digging Deep with Excel Pivot Tables
-
Online
1.00 Credits
This session focuses on the power of pivot tables within Microsoft Excel. We initially discuss the creation of pivot tables and various ways to summarize information. Then we explore ways to utilize summarized pivot table data. The course uses several practical examples that should inspire participants to find their own creative uses for pivot tables. 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.
Business Communication Essentials (Dynamic Communication in the Workplace)
-
Online
1.00 Credits
We know that effective communication is essential to growing a career and a business. But we often don't take time to think through, concsiously, about how we communicate and how small changes could change the trajectory of our messages. This workshop is designed to give you a survey of multiple communication strategies and mistakes to avoid. We start by discussing how people make decisions--which is important to understand in the context of business communication and communication in the workplace. We then transition into common communication mistakes and actionable tools and tactics that you can use to overcome and avoid these mishaps.
K2's 2023 Accessing And Managing Data In Excel
-
Online
4.00 Credits
For many business professionals, accessing and managing data in Excel is one of the biggest stumbling blocks when creating reports and analyses. Common practices include far too many manual processes and formulas, including never-ending manual processes needed to update your data and related reports. Make plans now to join us in this session to learn best practices for accessing and managing data using Excel. In this session, you will learn how you can use Power Query and other Excel tools to quickly access and manipulate your data and generate reports in record time! This is a “must-see” session for any business professional working with Excel!
Gamed: Why Performance Targets and Incentives Fail and How to Fix Them
-
Online
4.00 Credits
Target setting can drive breathtaking positive results, the moonlandings, the eradication of smallpox or the repair of the ozone layer, for example. They can also have a dark side that can put executives in jail, bring global businesses to their knees and even cause wholesale loss of life. Using practical examples and case studies, this course walks you through the steps you need to follow to design robust, effective and credible targets for your organization.
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.
2024 Instant Audit? Just Add Risk Assessment
-
Online
1.00 Credits
What would you do if you only had one workday to complete a financial statement audit? How would you optimize just a handful of hours? What would you test? More importantly, what would you minimize or eliminate? Although one day is unrealistically short, it illustrates how risk-based auditing can help auditors optimize professional effort. This course emphasizes the importance of risk assessment for enhancing both the effectiveness and efficiency of audit procedures.
2024 Design Flexible Work Options To Attract & Retain Your Workforce
-
Online
1.00 Credits
With increasing competition for finding the best qualified candidates and retaining today’s workforce, it’s more important than ever to consider flexible work options in the workplace. We will review the most popular flexible work options your company could consider implementing: telecommuting, compressed work weeks, flexible hours, phased return from leave of absence, job sharing, early release days, and more! We’ll discuss the benefits of this talent management strategy, including increased productivity, decreased costs, better work-life “integration”, and increased employee engagement and satisfaction. You’ll learn how to propose flexible scheduling to your executive team, including how to logistically roll out this program. Whether you’re in a manufacturing plant, corporate headquarters, or retail industry, you can apply any of these flexible work options to your organization.
Prioritizing Mental Health in the Post-COVID Workplace
-
Online
1.20 Credits
Over the last few years, mental health has become more of a mainstream issue. In fact, statistics indicate that approximately one in four adults experience a mental health condition. Therefore, it is more important now than ever for organizations to make mental health and wellness a priority, given all the rapid changes leading to higher levels of stress and uncertainty in the post-COVID workplace. The goal of this course is to outline the signs of mental health challenges in the workplace, such as changes in behavior, mood, or performance, while providing practical strategies for HR Professionals and Business Leaders to build and implement accommodations for a mentally healthy work environment.
2024 Business Tax Update with Steve Dilley
-
Online
2.00 Credits
This course addresses the most recent legislative developments impacting business taxpayers, with a focus on important provisions, rules and concepts to apply when preparing client returns. **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.
Ethics in the Real World - Living Values for Today
-
Online
2.00 Credits
Business ethics is not something “nice to do” but can mean the difference between success, failure and survival in today’s competitive environment. Being trustworthy, having consistent business principles and an outstanding reputation may provide an organization’s only long-term competitive advantage. This updated webcast outlines eight steps to create an ethical business environment including specific ways for financial professionals to make better ethical decisions moving forward.
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.
2024 Topic 842: Understanding the New Lease Accounting Standard
-
Online
2.00 Credits
It’s a whole new world for lessees under ASC topic 842. Soon nearly all leases will need to be disclosed as a liability on the balance sheet – from buildings right down to autos and copiers. Although the greatest impact will be on large entities, this will affect the financial statements of small and mid-size entities as well. This program will dive into the new standard on leases, effective dates, and address what you need to know now.
2024 Best Practices: Conducting Meaningful Walkthroughs
-
Online
2.00 Credits
This course will serve as an introduction to conducting effective walkthroughs to gain an understanding of the client's transaction processes as well as identify internal controls within each process. This course will review the procedures, questions to ask, and documentation requirements of walkthroughs. It will also include real-world examples of the red flags that may arise while executing a walkthrough.
Cash Forecasting, Reporting and Metrics - Managing the Lifeblood of the Business
-
Online
2.00 Credits
Financial managers and executives need to create cash projections that are relevant, current, and accurate. Too often cash planning is reactive, leading to inefficient, chaotic, and unreliable forecasts. Organizations never want to find themselves short in the availability or timing of cash. Proper cash forecasting and planning can avoid such cash shortfalls. This session will explore proactive approaches to cash forecasting.
Triple Your Memory, Prevent Dementia and Halve Your Stress - Part 1
-
Online
4.00 Credits
This is not your average CPE course! In this fun and practical course, you'll learn how to remember names, where you put things, what you read, or anything else 300% (or more) effectively than before. You will also learn how to prevent dementia, and halve your stress by using exercises that take under two minutes a day to do. Additionally, you'll receive information on ways to improve your memory by improving your overall health and wellness. This course will give you an overview of natural supplements to enhance your memory as well as share tips to improve your sleep. This course will change your life both now and in the future by making sure you know the best ways to remember information, handle stress and keep your mind sharp until the day you die. The information in this course to help increase your professional efficiency and improve your overall quality of life.
A 7-Step Framework for Marketing Client Accounting Services
-
Online
1.00 Credits
This course will help you develop an effective plan for revenue generation with client accounting services. The course will help you define and market to your chosen niches with effective and cost-efficient tactics. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Excel for Accounting Professionals Session 3: Workbook Design Principles and Organization
-
Online
2.00 Credits
Are you familiar with the five workbook design principles that help us build reliable recurring-use workbooks? This session covers them, as well as workbook and worksheet organization ideas. We also discuss how, why and when to hide administrative worksheets. The importance of highlighting input cells, using selection groups and building formulas with nested functions are also explored. 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 webcast, 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.
2024 Annual Update for Accountants & Auditors
-
Online
8.00 Credits
This course will start with the Accounting Standard Updates effective in 2024 for public entities, private entities, and nonprofits. We'll then switch our attention to the items coming down the pike, including a look at the projects identified by the FASB's Invitation to Comment: Agenda Consultation. We'll also review year 2 considerations for leases including modification accounting. Then we will switch gears, switching to the audit side of the house. We'll review the impact of the changes to auditing group audits as well as the status of the AICPA's quality management project management. This course will keep auditors up to date on the work of the ASB. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
2024 Fringe Benefit Planning - Today and Beyond
-
Online
8.00 Credits
In today's dynamic economic landscape, staying ahead with effective fringe benefit planning is more critical than ever for both businesses and individual clients. With evolving tax laws and shifting market dynamics, understanding the intricacies of fringe benefit planning is essential to ensure financial well-being and compliance. This course offers a comprehensive overview of essential tools and techniques tailored for financial professionals, allowing them to navigate the complexities of fringe benefit planning with confidence and precision. By attending this course, practitioners will gain invaluable insights into various planning tools and techniques essential for meeting fringe benefit planning objectives. From mastering the subtleties of employee benefit planning, including ERISA reporting and disclosure requirements, to unraveling the complexities of IRC §132 fringe benefit options, attendees will enhance their expertise to deliver superior advisory services. The curriculum also delves into the practical aspects of cafeteria plans, flexible spending accounts, group term life insurance plans, and strategies for financing retiree medical benefits, among others. With a focus on practical application and real-world scenarios, this course equips participants to tackle fringe benefit planning challenges head-on, providing them with the tools and knowledge needed to optimize benefits for both business and personal needs, now and in the future. **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.