CPE Catalog & Events
Excel for Accounting Professionals Session 3: Workbook Design Principles and Organization
-
Online
2.00 Credits
Member Price: $125
Enhancing Excel workbook productivity This workshop covers organizing and managing worksheet information, offering hands-on participation alongside the instructor. Through the practical tasks, you will gain a comprehensive grasp of commonly utilized Excel functions such as: Hiding worksheets Inputting cells styles for users Organizing workbooks Mastering Excel capabilities Becoming proficient in Excel entails developing workbooks that are efficient and well-organized. The facilitator will guide you through mastering complex functions, selecting cells and objects, and organizing principles of workbook design. You'll enhance your basic understanding of Excel with topics including: Creating complex formulas with nested functions Applying techniques for group selection *Session 3 is one of eight sessions that is available as an individual session. Each session builds on the prior sessions, so you'll want to consider watching [Session 4: Conditional Summing and Lookups] (https://www.aicpa-cima.com/cpe-learning/webcast/excel-for-accounting-professionals-session-4--conditional-summing-and-lookups) to further prepare to tackle real-world issues and build powerful workbooks.*Delivery Method: Individual webcastCPE Credit: Specialized knowledgeProgram Level: IntermediateThis course is being offered by a 3rd party vendor and will not be accessible on your My CPE page. Webinar access information will be emailed directly to you by AICPA.
Leading Up: The Superpower Every Ascending Leader Needs
-
Online
2.00 Credits
Member Price: $79
Most leadership training focuses on leading downstream, with the goal of eventually advancing to an executive role. Few people get to be “top dog” in their organization. So, nearly every worker will spend their entire career leading up, even while serving in a leadership role. Learn the skills and tactics needed to develop an effective working relationship with your boss and other superiors. Gain the credibility and support necessary to get things done and advance professionally. Delivery Method: Individual webcastCPE Credit: Personal developmentProgram Level: Basic
Surgent's Workplace Harassment: How to Prevent Harassment and Reduce Liability Risks in Today's Changing Environment
-
Online
2.00 Credits
Member Price: $99
Workplace harassment - especially sexual harassment - has dominated headlines in the last several years. With discussions of workplace harassment in the news, employees better understand their rights and feel more empowered to speak out, and the standard of appropriate workplace conduct is changing. With workplace harassment claims continuing to be filed at a steady pace with the United States Equal Employment Opportunity Commission, state agencies, and the courts, it is more important than ever to understand how to prevent and avoid harassment in the workplace.Delivery Method: Individual webcastCPE Credit: Personnel / human resourcesProgram Level: BasicThis course is being offered by a 3rd party vendor and will not be accessible on your My CPE page. Webinar access information will be emailed directly to you by Surgent McCoy.
How AI Fits into the Accounting World
-
Online
2.00 Credits
Member Price: $89
This session is designed as a primer to introduce artificial intelligence (AI) and to discuss how it will impact accountants as they work. The material will briefly explain what AI is and then focus on ways that it is already serving those in the accounting realm. It will close with a look at future AI-centric developments that will have great potential to positively impact the accounting profession. Those wishing to gain an understanding of what artificial intelligence is and how it will be used by accountants should consider attending 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.Delivery Method: Individual webcastCPE Credit: AccountingProgram Level: BasicThis course is being offered by a 3rd party vendor and will not be accessible on your My CPE page. Webinar access information will be emailed directly to you by CPA Crossings.
Forensic Accounting: Court Approved Methods of Proof
-
Online
4.00 Credits
Member Price: $149
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.Delivery Method: Individual webcastCPE Credit: AccountingProgram Level: BasicThis course is being offered by a 3rd party vendor and will not be accessible on your My CPE page. Webinar access information will be emailed directly to you by CPA Crossings.
Making Culture A Competitive Advantage
-
Online
1.00 Credits
Member Price: $39
In the world of work today, nothing is more critical than Culture. If people are your competitive advantage, then culture is the best way to help your people realize a great destination. While many leaders and companies talk a lot about culture, few take the time to really plan, build, and invest in a great culture. Today, the world of work could not be more challenging, and the changes that we are seeing in the workforce, such as the rise of remote workers and increasing turnover, are adding to the complexity. Now more than ever, Culture must become your competitive advantage. In this course, you will learn about the key macro changes in the workforce and what some leading companies and leaders are doing to create amazing cultures and high-performing organizations. From LinkedIn to Patagonia to Eventbrite, you will learn from some top organizations ow they have successfully leveraged culture. You will learn what Culture is and can be, and you will learn what culture is not. As you set sail in 2024 and beyond as a leader, you will benefit from this class and learn how to make culture your competitive advantage. Your teacher for the class is Steve Cadigan, whom many credit for being the architect of LinkedIn's world-class and groundbreaking culture. Delivery Method: Individual webcastCPE Credit: Personnel / human resourcesProgram Level: Intermediate
Preparing for & Conducting Discharge Meetings
-
Online
1.00 Credits
Member Price: $39
Over 80% of all employment-related lawsuits relate to termination. Every termination should be treated as a potential lawsuit. The facts supporting a leader's recommendation of discharge must be fully investigated. The discharge of an employee requires prior review and approval. Narrow self-interest, spite, or personal animosity must not play a part in making termination decisions. This course provides practical knowledge and scripts for handling discharges with good judgment such that personal and employer liability is avoided. Delivery Method: Individual webcastCPE Credit: Personnel / human resourcesProgram Level: Intermediate
Surgent's Tax and Advisory with Agentic AI
-
Online
2.00 Credits
Member Price: $119
This course examines how agentic AI is revolutionizing tax compliance, planning, and advisory services. Participants will explore real-world deployments by leading firms such as EY, which has developed agents that handle millions of global tax transactions. The course also delves into cross-border compliance issues, transfer pricing automation, and emerging advisory models powered by agent-led simulations. Risks related to bias, unauthorized practice, and data privacy will be addressed, with guidance on aligning autonomous operations with professional and regulatory standards. CPAs must understand these advancements to ensure tax compliance, manage client expectations, and mitigate professional liability risks when providing agent-assisted advisory services. Delivery Method: Individual webcastCPE Credit: Information TechnologyProgram Level: BasicThis course is being offered by a 3rd party vendor and will not be accessible on your My CPE page. Webinar access information will be emailed directly to you by Surgent McCoy.
K2's Top PDF Features You Should Know
-
Online
4.00 Credits
Member Price: $129
Stop struggling with PDFs! Adobe Acrobat and other PDF tools provide access to features that make working with PDF files a breeze. In this course, you will learn how to use tools and features such as PDF forms, redaction, converting PDFs to Word and Excel files, and electronic signatures. You will also learn how to create and apply tick marks, build indices, catalogs, and portfolios, and secure PDF documents to their fullest. The popularity and usefulness of PDFs increase daily, but most PDF users have not learned how to manipulate PDF documents effectively. Accordingly, they struggle and strain with these standard files. You do not need to let this be the case. Join us in this very timely session where you will learn the top features necessary to optimize your work with PDF documents. Delivery Method: Individual webcastCPE Credit: Computer software & applicationsProgram Level: Intermediate
Understanding Internal Control Constructs
-
Online
4.00 Credits
Member Price: $149
Organizations of all sizes often fail to successfully install needed foundational components of an internal control system. Whether large or small, entities must view policies, procedures, and all controls in a wholistic manner in order to develop a system of controls that will keep the entity on its intended course. Moreover, those that design policies and procedures benefit by knowing why control measures are necessary. This session sets forth internal control concepts and explains the importance of strong internal control policies. It provides an understanding of the interrelated nature of all controls created by any organization. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.Delivery Method: Individual webcastCPE Credit: AccountingProgram Level: IntermediateThis course is being offered by a 3rd party vendor and will not be accessible on your My CPE page. Webinar access information will be emailed directly to you by CPA Crossings.
Was It Fraud or Just Poor Audit Quality?
-
Online
1.60 Credits
Member Price: $59
This session describes a state agency's quality review of a not-for-profit organization's A-133 Single Audit. The case study describes the organization audited, its federally- and state-funded programs, and the CPA firm retained to do the audit. Various anomalies in the financial statements alerted state officials to potential problems, and a detailed quality review followed. Find out how the entity turned hundreds of thousands of dollars in bank overdrafts into hundreds of thousands of dollars of cash on its balance sheet. Explore other “creative” ways to deal with fixed assets, accounts receivable, and related-party transactions. Were the auditors just sloppy, ignorant, negligent? Or were they active participants in producing fraudulent financial statements? You be the judge. Delivery Method: Individual webcastCPE Credit: AuditingProgram Level: Basic
Excel Tips & Tricks for the Non-Accountant
-
Online
2.00 Credits
Member Price: $79
You don’t need an accounting degree to harness the power of Microsoft Excel. This course shows how Excel makes sense beyond dollars and cents. We will focus on fundamental concepts for creating, editing, and utilizing Excel content. Participants will learn how to use Excel’s menus and other functions to craft Excel workbooks. Because this course is designed for newer users, we intentionally offer a broad overview of Excel’s numerous capabilities with in-depth coverage of selected resources tailored for non-accounting applications. Delivery Method: Individual webcastCPE Credit: Computer software & applicationsProgram Level: Basic
2024 PCAOB and SEC Update
-
Online
2.00 Credits
Member Price: $89
It is imperative for public companies to produce quality financial reporting. This course will share insights into the latest SEC and PCAOB areas of emphasis and concern. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.Delivery Method: Individual webcastCPE Credit: Accounting, AuditingProgram Level: OverviewThis course is being offered by a 3rd party vendor and will not be accessible on your My CPE page. Webinar access information will be emailed directly to you by CPA Crossings.
Just Ask Why - Searching for Answers: Generating Solutions
-
Online
4.00 Credits
Member Price: $129
Breaking the Wall of blind acceptance; avoiding habitual complacency and Yoking the dots between cause and effect. Delivery Method: Individual webcastCPE Credit: Business management & organizationProgram Level: Intermediate
K2's Effective Automation And Outsourcing
-
Online
1.00 Credits
Member Price: $39
While outsourcing and automation have been used in multinational corporations, the decline in accounting program enrollment at many universities has made finding qualified entry-level staff more challenging and forced a new conversation about these tools in small and mid-sized businesses. This session will discuss the business environment for outsourcing and review the ethical, regulatory, and practical considerations associated with revealing data and relying on the work of others in your organization. Delivery Method: Individual webcastCPE Credit: Information technologyProgram Level: Intermediate
The Untold LinkedIn Hyper-Growth Story
-
Online
1.00 Credits
Member Price: $39
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. Delivery Method: Individual webcastCPE Credit: Personnel / human resourcesProgram Level: Intermediate
Benford's Law and Other Digital Analysis Techniques
-
Online
1.80 Credits
Member Price: $79
Numbers and especially the digits within those numbers can conceal a lot of information. Benford's Law and other digital analysis techniques can be the keys to unlocking that information. This session will explain what Benford's Law is, how it works, and how it can be used to reveal bogus information and made-up data. Accountants and auditors should understand how to use this valuable audit tool as well as other digital analysis techniques. But, if you attend this session, you must promise not to reveal the secret behind these techniques to any fraud perpetrators. Delivery Method: Individual webcastCPE Credit: AuditingProgram Level: Basic
AI Lessons Learned for Accountants
-
Online
2.00 Credits
Member Price: $89
This course provides accountants with the leading AI insights and strategies drawn from real-world experience, empirical studies, countless CPA case studies, and social media commentary. It goes beyond theory, offering practical lessons learned from the front lines of AI implementation in the business world and accounting industry. Participants will gain actionable knowledge on bridging the theory-application gap, navigating exponential technological changes, and creating secure, adaptive AI policies. By the end of the session, accountants will be equipped to leverage AI responsibly and innovatively in their roles. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.Delivery Method: Individual webcastCPE Credit: Information technologyProgram Level: BasicThis course is being offered by a 3rd party vendor and will not be accessible on your My CPE page. Webinar access information will be emailed directly to you by CPA Crossings.
Budget Mastery: Process, Problems, and Solutions
-
Online
2.00 Credits
Member Price: $79
The budgeting process can be a mundane one for accountants. Let’s be realistic and agree that even the word “budget” does not bring excitement to you and your departmental colleagues. The constraints and pressures can lead to poor decisions in both the technical and human components. This session is the first part of a four part series and will cover the big picture of keeping the process fresh, pragmatic and useful. We discuss these keys in an engaging manner by discussing both our flaws and strengths, including how to build on these characteristics towards an enjoyable solutions-based method that should deliver effective results for your organization. Delivery Method: Individual webcastCPE Credit: AccountingProgram Level: Intermediate
Develop Your Emotional Intelligence to Be More Successful in Life and Leadership
-
Online
2.00 Credits
Member Price: $79
The difference between star performers and average ones in leadership roles is attributable largely to emotional intelligence (EQ). It’s surprising, then, that EQ is underrated as an essential ingredient for success in life and leadership. This presentation highlights the importance of EQ and provides participants with actionable tools to develop better relationships within and outside of the workplace, build healthy teams, and navigate constant change. Delivery Method: Individual webcastCPE Credit: Personal developmentProgram Level: Basic