CPE Catalog
Note
AICPA On-Demand & Self-Study courses take up to 24 hours to process.
Surgent's Use the Data Model to Build More Powerful PivotTables
-
Online
2.00 Credits
Do you love PivotTables? Of course, we all do! Traditional PivotTables are incredible, but they do have limitations. If you have ever encountered one of these limitations, you'll be excited to learn that by using the Data Model as the source for PivotTables, you'll be able to bypass many of the restrictions that exist with traditional PivotTables. The data model (also referred to as Power Pivot) is included in Excel 2016+ for Windows and available as a free download for previous versions (excluding Excel for Mac). Using the data model enables you to build PivotTables that were previously not practical. If you frequently build PivotTables and would like to do more with them, you'll want to understand how to use the data model (Power Pivot) to enhance your reports. Note about Excel versions: Power Pivot is not available in all versions of Excel, including Excel for Mac. If you would like to see if Power Pivot is available in your version of Excel, visit the Microsoft site.
Optimize Your Staff's Performance
-
Online
4.00 Credits
A chain is only as strong as its weakest link. The same theory applies to departmental performance—the overall result is only as strong as its weakest contributor. Leave our interactive and entertaining session with insight for developing and sustaining the best team you can possibly assemble. The four elements in this process are (1) development, (2) leadership, (3) hiring and (4) environment. Discuss how to effectively use these elements in your creation of an outstanding organization. Discover the power of the 10 Attributes for Leadership Success and the negative impact of Leadership’s Fatal 13. Above all, learn how to combine these four elements as a successful catalyst for sustained high-quality output and results.
Using AI to Instantly Transform Ideas into Revenue Streams
-
Online
2.00 Credits
Learn practical strategies to increase revenue generation using AI-driven ideation methods. This course provides a concise overview of cutting-edge artificial intelligence tools and methodologies that enable professionals to transform innovative ideas into sustainable revenue streams. Through a practical, hands-on approach, participants will explore various AI platforms and workflows that streamline the process of creating digital assets, content, and products. The course emphasizes real-world applications and demonstrates how to leverage AI technology to diversify service offerings and generate new income sources. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Multiply Your Time: Tame Your To-Do List and Fight Distractions So You Can Get The Right Things Done
-
Online
1.00 Credits
You have more to do than time to do it. When you finally find the time, distractions steal it away again. As a leader with multiple layers of demands on your time, how can you possibly get it all done? In this course, I will help you learn practical productivity strategies so you can tame your to do list and multiply your time. It’s just wrong for a to-do list to rule your life. Learn how to take back your time…and your life.
Unlocking Deep Secrets: Case Studies in Financial Analysis
-
Online
2.00 Credits
Unlock the secrets to understanding a company's financial health and management performance through comprehensive financial analysis. This seminar will guide you through essential tools such as vertical analysis, horizontal analysis, and ratio analysis to gain deep insights into business performance. - Vertical Analysis: Learn how to express each line item of financial statements as a percentage, making it easier to compare companies of different sizes and identify key trends. - Horizontal Analysis: Discover how to compare financial information over multiple periods to spot significant changes and trends, providing a clearer picture of a company's growth and performance. - Ratio Analysis: Dive into calculating and interpreting financial ratios to assess profitability, liquidity, and solvency. Understand how these ratios reveal the effectiveness of management and the potential of the business. This seminar goes beyond just teaching terms and formulas. We will apply these analytical tools to real-world financial data, demonstrating how to derive meaningful insights and make informed decisions. Join us to enhance your financial analysis skills and gain a competitive edge in evaluating business performance. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Ethical Considerations in Working with Cannabis
-
Online
1.00 Credits
This session will explore the ethical considerations CPAs and CPA firms should be cognizant of when considering services to the state legal, regulated cannabis industry. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Risk Is Increasing - and Risk Management Is Evolving
-
Online
1.00 Credits
Tools for Risk Management A key to an effective risk management process is to move from the historic silo-based approach to an enterprise-wide approach. During this webcast, you will learn: Increased risks for organizations, including technology and cyber risks The use of a risk readiness assessment to identify management's current state regarding risk management The importance of retaining talent and updating your business model Findings from executive surveys that identify potential risks
SECURE Act 2.0: What You Need to Know
-
Online
1.00 Credits
Signed by President Biden on December 29, 2022 as part of the Consolidation Appropriations Act, this program provides an explanation of the Secure Act 2.0 provisions impacting individuals and business taxpayers. Learn what you need to know for this filing season and how to plan for future years 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.
Preparing to be a Forensic Accountant - Cloud Forensics
-
Online
1.40 Credits
Cloud computing has become a source of cyber-crime. “Cloud forensics is the application of digital forensics in cloud computing as a subset of network forensics to gather and preserve evidence in a way that is suitable for presentation in a court of law.” Cloud forensics is a combination of the varied types of accounting forensics including: • Digital forensics • Network forensics. • Hardware forensics In cloud crime, the cloud is considered the object when the target of the crime is the cloud service provider they are directly affected by the act. It is considered the subject of the crime when the criminal act is committed within the cloud environment. It is considered the tool when it is used to plan or conduct a crime. This course will delve into the many concepts involved in cloud forensics. The course complements other courses in the series of Becoming a Forensic Accountant.
Independence Requirements for Auditors
-
Online
2.00 Credits
One of the three major forms of occupational fraud, along with corruption and asset misappropriation, is financial statement fraud. From improper asset valuation to fictitious revenues, this course will review financial statement fraud red flags and examine real-life examples.
Is Activity-Based Costing the Right Tool for Your Organization?
-
Online
2.00 Credits
This session provides a refresher regarding the fundamentals of activity-based costing (ABC). We will examine theoretical concepts before exploring practical possibilities for implementing ABC. A major focus of the course will be factors to consider when determining whether this managerial accounting tool is an appropriate resource for an organization.
Integrity, Objectivity and Judgment: Values in Action
-
Online
1.00 Credits
This course focuses on how to integrate integrity and objectivity in situations accounting professionals face daily. The participant will be able to know not just what is the right thing to do according to the AICPA Code of Professional Conduct, but how to put values into action! As part of this course, we will also walk through real world examples of individuals and companies faced with these dilemmas. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
The Untold LinkedIn Hyper-Growth Story
-
Online
1.00 Credits
LinkedIn is considered by many to be one of the most impressive growth stories in the history of technology companies in Silicon Valley. In just 16 years it grew from nothing into a game changing company in a new industry and the performance of the company and the stock broke all kinds of records. The untold story of LinkeIn's success is that they grew a world class company and a world class team in the midst of a massive war for talent where their competitors for talent (Google, Facebook, Apple and more) could out pay and out perk and out benefit them. They grew a company when all the leaders had never built a company before. Despite the odds the leadership team succeeded and built a company and a culture that many still consider the gold standard. Steve Cadigan was at the epicenter of this growth as the first Chief HR Officer of LinkeIn and he delivers a front row seat to the wild and crazy and amazing ride that took LinkedIn from an unknown career destination into one of the top places to work in the world! Steve delivers a first hand account of lessons learned, mistakes made and what it was like to be facing a situation he had never faced before - hypergrowth. Wherever you are in your learning journey you will enjoy this class.
The Head and Heart of Ethics - Featuring Bob Mims and Don Minges
-
Online
1.00 Credits
There are multiple facets to ethical choices, including should you use your ‘head’ or your ‘heart’? What are the pros and the cons? How can we balance these opposing views? This seminar outlines the value of; trust, courage, fairness, sensitivity, persistence, honesty and gracefulness – to help us make better ethical decisions.
How to Choose the Right Business Entity for Your Client
-
Online
2.00 Credits
Tax rates, personal liability, operations - these are all factors to be weighed when advising clients about their choice of entity decision. This session provides a comparison of the multiple entity choices to start the discussion with clients and selecting the best tax efficient option for them. *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
Surgent's Contract Law for Accounting and Finance Professionals
-
Online
2.00 Credits
Accounting and finance professionals routinely encounter a broad range of legal issues while advising clients or performing routine job functions. Contract law tops the list as the most frequent issue that intersects with the accounting and finance professions. As trusted advisors, it is wise to understand the fundamentals of contract law for both personal and professional benefit. This course provides a broad overview of contract law basics geared specifically toward the accounting and finance professions. From contract formation to enforceability, this course offers an interesting look at how contract law intersects with accounting and finance. Participants should walk away with a better understanding of common issues that arise when reviewing contracts.
Surgent's Getting Ahead: The Art of Marketing for CPAs
-
Online
2.00 Credits
To many clients, CPA firms all look the same. While services and specialties may vary significantly from one firm to another, it is hard for the average person to see this by simply looking at the sign outside our office door. Is there any way to make us stand out more to the outside world? Through surveys, statistics, and examples, this course looks at how CPA firms can develop a marketing plan beyond just relying on referrals. We look at the pluses and minuses of various marketing channels, regulatory constraints, and how to measure success in the competitive financial services space.
Tax Cluster: The One Big Beautiful Bill Act (OBBBA): What You Need To Know
-
Online
4.00 Credits
Save a minimum of $50 when you purchase any 4 or more of MOCPA's Cluster Events. USE CODE "CLUSTER25" AT CHECKOUT. Many accounting and finance practitioners have had difficulty understanding and applying the One Big Beautiful Bill Act (OBBBA). Accounting and finance practitioners are still confused and challenged by many of the new and extended tax provisions that the OBBBA delivered. Mastering these crucial provisions requires multiple exposures to these challenging tax changes. This program is a four-hour review and analysis of the most important changes from the OBBBA that impact both individual and business taxpayers. This course affords accounting and finance practitioners an opportunity to gain a broader, deeper understanding of this wide-ranging set of new tax rules, to grasp what is new and what is a continuance of prior rules, and to develop deeper planning insights into the many changes that the OBBBA contains. To the extent that the Treasury has provided guidance relating to OBBBA changes, we will discuss that guidance. We will also point out areas where Treasury guidance would be useful and areas where guidance is expected.
Microsoft Teams - Everything You Need to Know from A to Z
-
Online
4.00 Credits
Microsoft Teams is one of the most popular tools for communication, collaboration, and knowledge sharing. If you use Microsoft Teams in your practice or business, this is a "must attend" course. You will learn everything you need to know to optimize the features of Teams and maximize your productivity. We will cover everything from how to effectively design your teams and channels configuration. How to utilize all the Teams features for posting conversations and working with your Office documents, PDF files and more. You will leave this course with the skills to master all the features of Teams! This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Introduction to Yellow Book: 8-Credit Boot Camp
-
Online
8.00 Credits
This course is designed for accountants in public practice and industry who focus on nonprofit and governmental entities. We will cover the basics needed to understand what makes nonprofit and governmental accounting & auditing unique. The course starts with the key financial reporting differences for governmental and nonprofit entities and then switches focus to review the fundamentals of Yellow Book and Uniform Guidance audits. This foundational course is perfect for those getting started in the nonprofit and governmental arena and those looking for a refresher. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.This course qualifies for yellow book credit.