CPE Catalog
Note
AICPA On-Demand & Self-Study courses take up to 24 hours to process.
Mastering the Excel Lookup Functions
-
Online
2.00 Credits
In today's data-driven world, Microsoft Excel has become an essential tool for professionals in any organization. To harness the full potential of Excel, it is crucial to understand and master its lookup functions. This course is designed to equip participants with the knowledge and skills needed to effectively utilize Excel's lookup functions and enhance their data analysis capabilities. Throughout this comprehensive course, participants will dive deep into the world of lookup functions and gain experience through practical exercises and real-world scenarios. Whether you're a seasoned Excel user looking to fine-tune your skills or a beginner eager to unlock Excel's full potential, this course is tailored to meet your learning needs. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
The Trustworthy Leader: Ethics and Trust in a Time of Social Change
-
Online
2.00 Credits
The ethical challenge of trustworthy leadership has never been harder than right now. We’re living in a time of major social change, generational transition, and troubling possibilities. People are dangerously agitated by uncertainty over what leadership to trust any more. They see angry culture conflict among citizens and between nations. They witness big failures of integrity in public and private spheres of leadership. Many feel afraid and alienated from institutions across the board. Such heightened sensitivity guarantees that unethical behavior from untrustworthy leaders will inflict disproportionate harm. People trust leaders with authority only as long as that power is not abused. Leaders in our culture are duty-bound to uphold that foundational trust through their actions and words. This updated session is meant for anyone who wonders how trustworthy leadership is even possible “these days”. Don’t despair. Moral courage plus basic ethical wisdom is the answer for all times. Whether you aspire to leadership or not, the information and questions presented in this course will enlighten and encourage.
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.
2024 S Corporation Checkup: Key Tax Issues & Forms Reporting
-
Online
4.00 Credits
A detailed analysis of the calculations related to determining a shareholder's tax basis for S corporation shares and loans. How to use the Form 1120S, Schedule K-1 information for basis determination, as well as an update on Schedules K-2 and K-3. An illustrative example demonstrates how the process works, as well as the many potential pitfalls. **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.
What If Your Client Didn't Take Reasonable Compensation
-
Online
1.00 Credits
Are you a new advisor handling S Corp clients, or perhaps a seasoned professional facing this common scenario: "My S Corp client didn't take reasonable compensation last year. Now what?" Knowing that reasonable compensation isn't just a tax obligation, but a strategic financial decision, you need to be armed with expert knowledge to help your client navigate this situation. Join us to discuss IRS regulations, understand preventive measures, and address challenges within the year. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
The Happiness Advantage: How to Use Positive Psychology to Enjoy Work More, Get More Done, and Be a Better Professional
-
Online
4.00 Credits
The new field of Positive Psychology offers many methods and ideas for helping people be happier, healthier, and better at what they do. Nowadays, the ability to be at your best and get clients to enjoy working with you is critical to growing your business or getting ahead. Studies show that happy people make $750,000 more over the course of their life than unhappy people, have half the number of sick days, and live 9 years longer. In this fun and fascinating seminar, you’ll learn how to not only be happier, but help your clients be happier in working with you.
2024 Spring Tax Update for Business with Steve Dilley
-
Online
4.00 Credits
This program provides an update to the latest tax developments, rules and regulations impacting business taxpayers, including a review and integration any new tax legislation. **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 Accounting & Auditing Update for Small Businesses
-
Online
4.00 Credits
For many small businesses, the standards issued by the FASB may have little to no effect as they impact topics that do not reflect the type of transactions that these entities most frequently experience. This class will focus on the Accounting Standards Updates (ASUs) that are most likely to impact small businesses with a focus on ASUs initiated by the Private Company Council (PCC). We'll then look at alternative reporting options to GAAP including FRF for SMEs and IFRS for SMEs for entities who don't necessarily need to prepare GAAP financial statements but want to use accrual accounting. Finally, we will transition to audit standards that small business auditors will need to implement.
2024 Moving Beyond the Basics of Excel
-
Online
2.00 Credits
This course explores the increasingly complex features of Excel that facilitate efficient data analysis. We will introduce numerous analytical methods and techniques by using practical examples to illustrate how to unleash the power of Excel when manipulating, analyzing and reporting information.
2024 Internal Controls That Could Have Prevented Frauds
-
Online
2.00 Credits
This course examines actual fraud circumstances through the lens of potential prevention. We will examine how selected frauds were accomplished and consider what internal controls may have prevented fraudsters’ ability to accomplish their nefarious acts.
2024 Practical Excel Topics for the Public Accountant
-
Online
2.00 Credits
This course introduces practical ways that public accountants can use Excel to enhance both the efficiency and effectiveness of client engagements. We will reinforce core concepts by illustrating ways that Excel is a tool for analysis and reporting. We will introduce numerous analytical methods and techniques by using practical examples to illustrate how to unleash the power of Excel when obtaining, analyzing, and reporting information.
2024 Depreciation: Guide to Capitalizing Tangible Property
-
Online
2.00 Credits
This presentation highlights the latest legislative changes affecting depreciation and capitalization rules, including inflation increases and Section 179 and 168(k) deductions. Planning and potential pitfalls will also be presented. **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 2024 Small Business Accounting Solutions And Add-Ons
-
Online
2.00 Credits
Small businesses have better options now than ever before in the market of accounting solutions. Participate in this session to learn more about these options and which might be best for you or your clients.
K2's 2023 Excel Charting And Visualizations
-
Online
4.00 Credits
Charts and graphs are nothing new. However, many professionals struggle with building compelling visualizations. If that statement describes you, participate in this session to improve your skills in creating Excel charts and other visualizations. As a result, you will create visualizations to enhance your communication skills. This session is much more than just a seminar on fundamental charts. Instead, in this session, you will learn how to create advanced charts that are interactive, dynamic, and aesthetically pleasing – three qualities that will help to ensure that your readers and audience will understand the data you are presenting. This seminar is a must if you want to improve your communication skills.
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.
Triple Your Memory, Prevent Dementia and Halve Your Stress - Part 2
-
Online
4.00 Credits
This is not your average CPE course--Part 2! In this second part course (which is equally fun and engaging), you will learn how to feel confident--even in highly stressful situations. You will learn new secrets to great health that take under 10 minutes per week, and you will learn how to know what is most important to you--so you can be happier and healthier in the long run. Tune in for techniques to relieve stress and tips on incorpating meditation into your daily routine. All of which will help improve your memory and overall mental health and wellbeing. In addition, you'll learn an unsurpassed method for making sure you stay consistent with actually implementing these methods in your daily life.
How To Use Microsoft 365 Forms to Create Online Surveys
-
Online
1.00 Credits
When you need to create a simple survey or form to capture data online, the Microsoft 365 Forms app can be just the right solution. You can use it for simple forms such as a client information form or client service evaluation form. You can create more sophisticated forms, such as a client tax organizer. All responses can remain confidential and can be viewed in Excel format for further analysis or to prepare the form data for import into another application. This course will take you through the step-by-step process for creating, distributing, compiling and analyzing digital forms and surveys. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
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.
2024 Individual Tax Update with Steve Dilley
-
Online
2.00 Credits
This course addresses the most recent legislative developments impacting individual 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.
The Bookkeeper Goes to Prison
-
Online
2.00 Credits
This course profiles Brenda, a financial executive from the state of Washington. Despite earning her college degree, Brenda did not find employment in her area of study. Instead, she landed a series of dead-end jobs. Business reversals frequently led to the loss of employment. When a company that she knew to be unethical offered her an executive position that included bookkeeping tasks, including overseeing all finances, she accepted. While on the job, Brenda saw owners of the company misappropriating funds. Rather than reporting the fraud, she created an elaborate scheme to benefit herself - without the owner's knowledge. Her bad decisions led to a guilty plea for wire fraud, after authorities accused her of absconding with more than $600,000 in corporate funds. A prison term of 20 months followed. Listen and learn from Brenda's experience. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.