Professional Development and Event Catalog
Excel Tips & Tricks for the Non-Accountant
2:30pm - 4:18pm
Online
2.00 Credits
Member Price: $79
See more dates
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.
More Dates
2024 PCAOB and SEC Update
2:30pm - 4:30pm
Online
2.00 Credits
Member Price: $89
See more dates
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.
More Dates
K2's Effective Automation And Outsourcing
3:00pm - 3:56pm
Online
1.00 Credits
Member Price: $39
See more dates
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.
More Dates
The Untold LinkedIn Hyper-Growth Story
3:00pm - 4:02pm
Online
1.00 Credits
Member Price: $39
See more dates
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.
More Dates
AI Lessons Learned for Accountants
3:00pm - 5:00pm
Online
2.00 Credits
Member Price: $89
See more dates
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.
More Dates
Budget Mastery: Process, Problems, and Solutions
3:00pm - 5:00pm
Online
2.00 Credits
Member Price: $79
See more dates
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.
More Dates
Excel for Accounting Professionals Session 4: Conditional Summing and Lookups
3:00pm - 5:00pm
Online
2.00 Credits
Member Price: $125
See more dates
Boosting productivity with Excel For those unfamiliar with conditional summing, you're in for a revelation -it's an impactful technique that improves productivity in creating reports. You'll learn how to optimize Excel efficiency by managing duplicates, selecting appropriate shortcuts, and performing lookups. Practical hands-on Excel learning exercises taught by highly engaging expert in the field You'll also deepen your skills and tackle real-world Excel workbooks that address the following: Benefits of using lookup functions over direct cell referencing A comprehensive exploration of the popular VLOOKUP function Techniques for removing duplicates to create a distinct set of report labels *Session 4 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 5: Error Trapping and Improving Lookups] (https://www.aicpa-cima.com/cpe-learning/webcast/excel-for-accounting-professionals-session-5--error-trapping-and-improving-lookups) to further prepare to tackle real-world issues and build powerful workbooks.*
More Dates
Surgent's Controllership Skills Update: Risk Management
3:00pm - 5:00pm
Online
2.00 Credits
Member Price: $99
See more dates
The most recent recession and its fallout, weather (look at 2017), process and product failures, and unethical behavior have again highlighted failures by numerous organizations in identifying and managing risk. The size and reputation of organizations proved not to be the key to success. Again, we saw that failures can result in areas/industries thought to be "under control" through their policies, practices and/or regulations. A core activity of financial management is to effectively protect the assets of their organizations, without significantly reducing new ideas and growth. This brief program provides insights and approaches to identify risk and manage the above noted trade-off. The course is designed for financial managers looking to quickly build upon their existing knowledge and experience, as well as to help to start the less experienced individual. It offers ideas that can be used immediately, as well as longer term approaches. Updated to include new information particularly in the areas of disaster planning, business continuity, and ethics, as well as a sample group exercise to test your current risk management systems.
More Dates
Take Command of your Time
3:30pm - 5:30pm
Online
2.00 Credits
Member Price: $89
See more dates
Manage distractions, decrease stress and improve productivity. This training is designed to help business professionals improve their productivity and work performance by learning how to prioritize time, decrease distractions and lower stress. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
More Dates
Accommodation Requests - Substance Abuse - Contagious Infections
4:00pm - 4:55pm
Online
1.00 Credits
Member Price: $39
See more dates
Good judgment works well in handling most employee relations matters. However, there are special situations where legal requirements dictate specific handling to avoid significant personal and employer liability. This course provides practical knowledge and scripts for responding to requests for accommodation regarding religious practices or disabilities, confronting employees in substance-abuse situations, and handling disclosures of contagious infections so that individual is properly helped, and the health of your workforce is protected.
More Dates
Clean, Transform and Load Data in Power BI
4:00pm - 6:00pm
Online
2.00 Credits
Member Price: $89
See more dates
This intensive 2-hour course is designed specifically for those aiming to master data management skills in the modern business environment. As data becomes increasingly central to accounting and financial analysis, the ability to effectively manage, clean, and transform this data is critical. This course delves into Microsoft Power Query, a potent tool within Excel and Power BI Desktop, known for its robust data processing capabilities. This course is designed to take participants from the basics of Power Query to exploring its more sophisticated features. It is an ideal blend of theoretical knowledge and practical application, centered around diverse data scenarios encountered in multiple industries. The aim is to ensure that the skills and techniques learned are universally applicable and beneficial in any professional context. Structured to be participant-focused, the course encourages active learning through a series of practical exercises, live demonstrations, and illustrative case studies. This approach not only deepens the understanding of Power Query's features but also demonstrates how to turn complex data sets into actionable insights. While the course is broad in its application, it remains detailed in its instruction, catering to both the novice and the seasoned professional. It is particularly beneficial for those who regularly interact with data, such as business analysts, project managers, and financial professionals, providing them with the tools to streamline data processes and enhance data analysis capabilities. Additionally, the course underscores best practices in data management. Participants will learn strategic approaches to data challenges, ensuring that their data processes are efficient, scalable, and sustainable. This is not just a course about mastering a tool; it's about empowering professionals with the skills to transform data into a strategic business resource. By the end of the course, participants will be equipped to leverage Power Query in Excel or Power BI desktop to its full potential, turning data into a powerful driver for business success and innovation. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
More Dates
Casualty Losses: Disaster Relief Act of 2024
5:00pm - 6:00pm
Online
1.00 Credits
Member Price: $55
See more dates
Literally thousands of individual taxpayers may have increased deductions or exclusions from gross income as a result of the Disaster Relief Act of 2024! Casualty provisions of the Act are retroactive to December 19, 2019 through early 2025. Both low and high income taxpayers may benefit from the Act through exclusions of payments received as compensation for wildfire damages - retroactive to 2014! This course will review the provisions of this new act. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
More Dates
SAS 145 - Risk Assessment
9:00am - 9:58am
Online
1.00 Credits
Member Price: $39
See more dates
SAS 145, Understanding the Entity and Its Environment and Assessing the Risks of Material Misstatement, was issued in October 2021. This audit standard amends AU-C 315, making many changes to address common audit deficiencies. This course will provide an overview of SAS 145 and its changes to AU-C 315.
More Dates
CTCPA Town Hall Meeting
9:00am - 10:00am
Online
1.00 Credits
See more dates
Join us for our monthly Town Hall Meetings – a must-attend event for anyone looking to stay ahead of the latest hot topics impacting the profession. This is your chance to hear directly from Executive Director & CEO Bonnie Stewart and engage with leading voices in the finance and accounting industry. Gain insights, ask questions, and connect with experts who are shaping the future of our field. Don’t miss this opportunity to be informed and involved! You must register to attend and receive CPE credit.
More Dates
Generation Intelligence: Navigating the Generational Divide
9:00am - 10:00am
Online
1.00 Credits
Member Price: $39
See more dates
Unlock the power of multigenerational teams to future-proof your firm. Today’s workplace is more generationally diverse than ever—spanning five, soon to be six, distinct generations. And while this mix can create miscommunication and friction, it also holds untapped potential for innovation, connection, and resilience. This dynamic course helps professionals in accounting, law, banking, insurance, and financial services understand and harness generational dynamics. You'll explore how shared formative experiences shape values, communication styles, and expectations at work—from the frugality of the World War II generation to the digital fluency of Gen Z and the up-and-coming Generation Alpha. Rather than getting stuck in generational stereotypes, you’ll learn to lead, collaborate, and connect more effectively across ages. With insights drawn from workplace psychology, sociological research, and real-world examples, this course equips you with practical tools to bridge the gap—so you can build stronger client relationships, more collaborative teams, and a culture people want to stay in.
More Dates
Reasonable Compensation for S Corps
9:00am - 11:00am
Online
2.00 Credits
Member Price: $89
See more dates
Between 2010 and 2020 a parade of Court Cases, IRS Factsheets, Job Aids and Internal Memos, plus Heightened IRS scrutiny and Preparer Penalties has brought the issue of 'Reasonable Compensation for S Corp's out of the shadows and placed it forefront as a priority issue for CPA's, EA's, Tax and Financial advisors to cover with their clients. We will explore key court cases, IRS guidelines, preparer penalties and some of the obscure tools the IRS has put in place. We debunk common myths and fiction on how reasonable compensation should be calculated and replace it with facts and methodologies that the IRS relies on. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
More Dates
Surgent's Information Security and Privacy
9:00am - 11:00am
Online
2.00 Credits
Member Price: $99
See more dates
In today's interconnected world, safeguarding information systems is crucial. This course offers a deep dive into information security and privacy principles with a focus on modern cybersecurity threats tied to cloud environments, Internet of Things (IoT), and mobile technologies. The course will also cover data protection during application development. Taking this course will equip accounting professionals with the knowledge to lead in cybersecurity strategy.
More Dates
Controls to Secure the Growing Digital Footprint
9:00am - 1:00pm
Online
4.00 Credits
Member Price: $149
See more dates
The amount of electronic content that business organizations contend with is growing at incredible rates. Terms like "Big Data" and "Information Overload", are being used by overwhelmed information workers on a daily basis. Additionally, because of the move to a much larger telecommuter footprint, electronic data is now even more prevalently utilized. This session discusses the places that businesses keep digital information and addresses the importance of securing corporate electronic data. The material effectively shows ways to achieve high security standards for content stored in fixed locations, on mobile devices and in the cloud. Participants in this session will gain an understanding of the concepts needed to improve the way they, and their companies secure digital information. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
More Dates
Effective Coaching Strategies for High Performance
9:00am - 1:00pm
Online
4.00 Credits
Member Price: $129
See more dates
This business coaching course is designed to enhance your coaching effectiveness by integrating innovative tools like ChatGPT (Generative AI) to support and elevate your coaching practice. You'll explore the key differences and similarities between coaching and managing, uncover the most important skill every coach should master, and learn how to get to the root cause of any problem. With hands-on coaching strategies, including neuro-linguistic programming (NLP) techniques, you'll enhance your ability to drive results. Additionally, you’ll discover how to use performance gap analysis to identify and bridge gaps, ensuring the success and growth of the individuals you coach.
More Dates
Leading and Managing the Accounting Department
9:00am - 1:00pm
Online
4.00 Credits
Member Price: $129
See more dates
Welcome to a management course that helps CFOs and Controllers lead the Accounting Department. It is essential that the Accounting Department have a Vision which is aligned with the Business goals. Controllers must also be comfortable with wearing multiple 'hats' in the business. The head of the Accounting Department must be skilled in a variety of leadership skills, technical skills, managerial skills and current management techniquest.