CPE Catalog & Events

Although the long bull market came to an end, the interest in stock investing remains high as younger investors accumulate for retirement and retirees seek to outpace inflation. We'll explore the most popular stock investment strategies and their taxation, including dividend and capital appreciation strategies, while avoiding the net investment income tax and restrictions on losses and straddles. Companion course: Income Tax Planning For Bond Investments 2024

With approximately 500 functions now available in Excel, some newer and more powerful tools are easy to overlook. But, if you do that, your productivity will suffer. In this session, you will learn how to take advantage of many of Excel’s more advanced features – some new and some legacy – to elevate your productivity to higher levels. In this session, you will learn about many of Excel’s newer tools, including XLOOKUP, SUMIFS, SWITCH, and STOCKHISTORY. Also included in this session are discussions of advanced financial functions, such as IPMT and PPMT, and how to retrieve summarized data easily using GETPIVOTDATA and CUBEVALUE. Additionally, you will learn how to make sophisticated calculations easier with Dynamic Array formulas, harness the AGGREGATE function's power, and create more accurate forecasts with Excel’s FORECAST.ETS function. No matter your experience working with Excel, participating in this course will help you work more efficiently and effectively in Excel.

Nonprofit entities have a high degree of public accountability. This course will examine the most common fraud schemes and provide multiple examples of how to prevent or detect these schemes. Nonprofit entities have a high degree of public accountability. This course will examine the most common fraud schemes and provide multiple examples of how to prevent or detect these schemes. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

IRS Appeals is often the best place to resolve a tax dispute. Appeals can review almost all examination and collection determinations. A practitioner should not handle a complicated examination or collection matter without a thorough understanding of how Appeals operate. This is especially true with the recent changes in the independence of Appeals and the way Appeals handles cases. The course will review the appeals process and strategies for practitioners to represent a client competently before the IRS. State tax appeals will also be discussed and compared.

Business Intelligence (BI) is perhaps the hottest topic in most professional circles in today's business climate. Increasingly, organizations of all sizes seek to take advantage of the data available to them to identify previously undiscovered insights and gain competitive advantages thought to be out of reach just a few short years ago. A growing array of tools - from Excel add-ins to dedicated solutions such as Power BI - now allow you to leverage your existing knowledge and skills to create powerful, interactive dashboards and analyses unthinkable until recently. This program will teach you to implement "do-it-yourself business intelligence" using various techniques and tools. First, you will learn to use advanced Excel data query and summarization features to create Excel-based dashboards. You will then learn how to leverage that knowledge to build even more powerful BI objects using Microsoft's Power BI tools. If gaining better insights into your data to make better decisions interests you, then join us for a fast-paced look at how you can take advantage of these fantastic tools.

Client and Engagement Management - Managing the Black Holes That Erode Profitability will provide guidance on how to maximize return on time spent with critical areas, such as budgeting, scheduling, client assistance, and delegation. Sound client and engagement management can influence both the effectiveness and efficiency of an audit engagement. Note: This course is recommended as a part of a 16-hour audit skills curriculum for in-charge or supervisor auditors, while it is also appropriate for anyone who has responsibilities for client and audit engagement management. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

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.

In today's dynamic corporate landscape, HR professionals are no longer just HR experts; they are integral business strategists. This session unveils the pivotal role HR plays in shaping and influencing a company's overarching business strategy. It emphasizes the need for HR to don the hat of a businessperson first and an HR professional second. In this engaging presentation, we will delve into the critical strategic business concepts that HR leaders should not only grasp but also embrace confidently at the executive level. Moreover, we will explore how HR can navigate the fast-paced, technology-driven world by adapting to evolving strategic HR concepts. Discover how HR can transform from a support function to a strategic partner, contributing directly to the organization's bottom line. Learn how to align HR initiatives with business objectives, fostering a synergy that propels the company forward. Join us as we explore the art of blending business acumen with HR expertise to create a winning formula for success at the executive table. It's time for HR to lead the way in strategic synergy!

This course is one of the courses dedicated to our Controllership series. This series of courses is dedicated to exploring the traditional controller role and stepping out of the box to identify areas where the controller can continue to add strategic value to their organizations. Within this segment of our controllership series, we will discuss the area of inventory. This specific segment in the first part of a two-part series on inventory. We explore how the controller can move these responsibilities into more of a strategic role. This course takes a look at some of the typical concepts and duties involved in the inventory function that is sometimes viewed as operational roles. We explore how these areas are strongly tied to the importance of the controllership role and how the controller can add value in each area.    

During this presentation, the most common mistakes made by employee benefit plan auditors, as well as, plan sponsors will be identified. Best practices for handling specific issues that arise during the course of the engagement will also be explored. This discussion will help auditors recognize potential pitfalls in audit procedures/documentation and assist plan sponsors with compliance issues.

Award winning discussion leader, former state accountancy board chair, and lifelong tax practitioner Mark Hugh will review ethics for tax professionals: the AICPA Code of Professional Conduct and interpretations; the Statements on Standards for Tax Services; tax preparer standards in the Internal Revenue Code; the rules for practice with and before the IRS, including IRS Circular 230; new developments; and discuss examples of best practices and case studies.

Single Audits are an area of focus for the AICPA's Enhancing Audit Quality Initiative. The Uniform Guidance provides very unique audit requirements when auditing federal funds. This course will look into the unique performance and reporting requirements in Single Audits. Participants will have a basic understanding of internal controls over compliance, compliance requirements, how to use the Compliance Supplement, and the elements of a finding in a Single Audit.

In today's digitally-driven landscape, the role of artificial intelligence in accounting and tax processes is rapidly evolving. For accounting professionals, tax experts, and all CPAs aiming to remain at the forefront of their profession, understanding how to strategically select, learn, and implement AI technologies like ChatGPT is paramount. This course offers a comprehensive guide tailored to accounting and tax professionals' unique needs, delving into the art of harnessing AI's potential through step-by-step instruction, examples, anecdotes, and case studies. Master a principles-based framework designed specifically for effective AI adoption in accounting and taxation, ensuring heightened productivity, accuracy, and timeliness in all financial and tax deliverables. Whether you're a dedicated tax professional, an accounting expert, or a multifaceted CPA, gain the insights required to navigate the benefits and challenges AI presents in the financial domain.

Embracing and cultivating Diversity, Equity and Inclusion (DEI) in the workplace IS Ethics at Work! This session explores ethical values and principles related to these initiatives and examines workplace behaviors, individually and collectively, that foster and promote organizational well being. Robbie offers findings on strategies that work to improve DEI efforts based on best practices and interviews with experts in the field. Please note that for those of you who have taken courses from Robbie there will be some duplication and much new content. This session is designed for people who wish for a more fair and just world and workplace. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Stay up to date with the ever-evolving realm of individual income taxation in this essential course tailored for tax practitioners seeking to enhance their knowledge. This course offers an in-depth review of the complexities surrounding Form 1040 for the current tax year. Delve into the recent changes and updates within the tax code, providing you with a comprehensive understanding of the shifting tax landscape. Our course ensures you are well-prepared to assist your clients by navigating the most recent tax changes, regulations, and guidelines.

Isn’t it time you learned about PivotTables – Excel’s best feature? If so, participate in this session to learn PivotTables from A to Z to take full advantage of this terrific tool's many benefits.

This workshop explores how each of us can play a part in helping to make the world a more fair and gentler place. This one-hour webinar includes an overview of Aristotle's virtue ethics and its application to present day life. We will focus on the virtue of compassion both individually and organizationally and its impact on individual, organizational and world wellbeing. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Team development and performance are critical to leadership success. In this session, participants will examine team formation, learn about the balance between team performance and team health, develop team agreements, and understand the latest tips from Google's Perfect Team research to strengthen team experience. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Some CPAs & FAs might focus on estate administration; however, many more will come across this through routine work with a client. This course provides an overview of how you can help to administer an estate. It includes a checklist of tasks and an overview of what each entails. This webinar covers minor points such as what information you'll need to collect and when to get an EIN. It also covers substantial discussions of essential topics, such as developing an inventory, estate accounting, allocating income between Form 1040 and form 1041, and filing your client's final Form 1040.

The AICPA's Auditing Standards Board has several large projects that will be impacting entities in the near future. We'll take a deep dive into the changes related quality management as well as group audits. We'll also review common audit deficiencies. This course will keep auditors up to date on the work of the ASB.