CPE Catalog & Events

Realistic Excel training for skill development Shifting from manual inputs to automated formulas in Excel can help enhance data efficiency. Understanding that Excel can handle date and text values broadens the potential to improve efficiency when managing data in Excel. This webcast will focus on the following essential functions: EOMONTH MONTH and YEAR DATE CONCAT SUMIFS with CONCAT Practical hands-on Excel learning exercises taught by a highly engaging expert In this webcast, you'll develop your skills and implement Excel techniques that will boost the effectiveness of conditional summing functions using comparison operators. Additionally, you'll gain in-depth knowledge of the following: Adding helper columns Distinguishing key function differences Combining values *Session 7 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 8: Dynamic headers, mapping tables and error check] (https://www.aicpa-cima.com/cpe-learning/webcast/excel-for-accounting-professionals-session-8--dynamic-headers-mapping-tables-and-error-check) to further prepare to tackle real-world issues and build powerful workbooks.*

New personal financial planning strategies are emerging due to passage of the One Big Beautiful Bill and evolving personal goals in difficult economic and legal environments. Drawn from recent publications and government directives, this course reviews the latest financial strategies and planning changes from the past year in insurance, investments, tax, estate and retirement, including Social Security and Medicare. Additionally, Randy covers estate and tax planning strategies that enable practitioners to better serve clients by allowing them to take advantage of new opportunities.

If you're ready to move beyond Excel's fundamental features, participate in K2's Advanced Excel. This course will teach you about collaboration options, security techniques, tables, data models, PivotTables, and advanced formulas.

An in-depth coverage of ASC Topic 842, Leases . Leasing is popular among corporations for needs including office space and equipment. Since ASC Topic 842, Leases has been adopted by most entities, it is time to review the topic, including any recently issued updates. Excerpts from publicly traded companies' recent disclosures on Leases are also examined.

In this webinar we will explore the powerful concept of splitting data from reports and dig into the mechanics that enable this technique. The key feature discussed is the Tables feature, and the key function discussed is the multiple-condition summing function. We will illustrate these items in a variety of ways, including building crosstab style reports and mapping tables.

Do you want to build stronger relationships with your clients, improve client retention, and drive growth in your practice? This course delves into the essential strategies for effective client management in today's competitive landscape. Client relationships, like any relationship, can be challenging to manage. Miscommunication, differing work styles, and unrealistic expectations are some of the challenges accounting and finance professionals routinely encounter. However, when accounting clients and members of your team are on the same page, client loyalty and profitability improve while conflict is minimized. This webinar explores proven strategies to improve relationships between accounting and finance professionals and their clients.

Be the go-to person on financial statement compilation and preparation engagements. Specifically designed for those performing preparation and compilation engagements, this course will provide you with a hands-on application for performing preparation and compilation engagements under AR-C Section 70 and 80, respectively. You will learn the ins and outs of relevant sections of the SSARS related to preparation and compilation engagements with a focus on how recently issued updates to SSARS No. 21 impact these engagements. More importantly, you will be provided practical examples and illustrations to help you effectively and efficiently perform those engagements, including a detailed discussion of the reporting requirements under AR-C 80 related to compilation engagement. Lastly, the course will review recent peer review feedback on these types of engagements, highlighting areas where you can improve engagement quality.

Arguably the most discussed topics to come out of the One Big Beautiful Bill Act (OBBBA) are the taxation of tips and overtime. Practitioners need to understand these provisions now, as they are effective for 2025 tax returns. This program provides practitioners with the background currently available to advise clients regarding these two important tax developments. Both employers and employees need to understand these timely changes to taxation.

Specifically designed for preparation, compilation, and review practitioners, this course provides a comprehensive review and hands-on application for performing financial statement preparation, compilation, and review engagements. You will learn the ins and outs of applying SSARS No. 21, Clarification and Recodification, as well as additional guidance related to SSARS engagements through the issuance of SSARS Nos. 22-27 by the AICPA's Accounting and Review Services Committee (ARSC). The course also reviews recent peer review feedback on SSARS engagements, providing insights on how to successfully apply this guidance. Not only will this course bring you up to date on SSARSs requirements and guidance, but more importantly, it will provide you with practical examples and illustrations to help you effectively and efficiently perform compilation, preparation, and review engagements.

The IRS defines the "gig economy" as people earning income providing on-demand work, services, or goods on either a part-time or full-time basis. The economic times we live in are changing, and accounting and finance professionals must learn how the rules apply in this new gig economy. The tax rules that apply to gig workers challenge traditional ideas of who is an employee and who is an independent contractor, and accounting and finance professionals must have the knowledge to make this determination. This program addresses federal and state tax issues accounting and finance professionals must address with clients and their own workers.

Good writing is good business. Studies show that the average business worker receives 121 emails per day. That's a lot of emails. Are your emails effective? Are they being read? Are they professional and tone-smart? In this course, you will learn techniques and skills to get your emails to stand out and improve their effectiveness and professionalism.

When putting together a financial plan, it is important to remember that the tax situation of the business and the individual are often intertwined. Therefore, decisions about entity type are vitally important. Practitioners need to understand not only how different entities are taxed, but also which taxes will have the greatest impact on the individual owner. In this course, we will explore when self-employment taxes apply to business income, as well as some of the lesser-known taxes that apply to flow-through entities. We will even explore when a PTE election could be helpful to a small business owner.

An innovative and interactive session that taps the areas of neuroscience, psychology and biology to understand how science, emotion and ethical decision-making interact. Instead of critiquing how our minds are supposed to work, this session delves into the fascinating world of how our minds work when we face complex problems where a "best choice" doesn't seem to exist. The talk will also explore why ethical codes have often failed and how to improve individual and organizational ethical reasoning.

Participants will review how to maintain a heightened awareness of fraud with clients and gain a better understanding of how to detect fraud. This interactive workshop, designed for practitioners in small and medium-sized CPA firms, will include a lecture with generous time for questions and case studies to reinforce the concepts.

Every two years, the Association of Certified Fraud Examiners releases a study that details fraud cases internationally. This comprehensive study can serve as an important tool in investigating fraud, establishing internal controls, and identifying red-flags in an audit.

We all make predictions in our personal and professional lives. We base our decisions to marry, buy a house, launch a new product or hire staff on expectations about the future. How can we use best practices and current research to improve our ability to predict the future" We will examine current best practices in forecasting to help us prepare better budgets and projections. We will also examine budgeting pitfalls and ways to avoid budget traps. We will discuss the risks that cause actual results to vary from our predictions and discuss methods to deal with both known and unknown risks.

The employer-employee relationship strains both sides in uncertain times, and businesses need CPAs, controllers, and other advisors to provide understanding of the complex legal, tax, and health care issues associated with all aspects of employment. This course provides in-depth coverage of this critical area.

The past few years have taught us that major risks can come at us from any direction and with barely a warning. All organizations operate in a risk environment, but all too often, they either don't realize it or they don't develop a strategy to deal with the risks. In this session, we will explore how risks work in both for-profit and not-for-profit organizations and how they can develop a strategy to identify, evaluate, and mitigate those risks. This program will not teach how to eliminate risks, but how to strategize how to reduce their total effect. We will liberally use case studies of both for-profit and not-for-profit companies to bridge the gap between concept and actual implementation. In each area we will explore what our experiences of the pandemic have taught us about this part of risk management.

Do you ever import data into Excel, and then spend a bunch of time manually preparing it for use? Perhaps you delete extra columns or rows. Maybe you need to split a single column into multiple columns, or, combine multiple columns into a single column. The good news is that many of these transformations can be fully automated with Excel! The Get & Transform tools built-in to Excel 2016 for Windows, formerly available as the Power Query add-in, are incredibly powerful. At a high level, they enable us to retrieve data from a variety of sources and prepare it for use as needed. In this session, we'll use Get & Transform queries to help with several common tasks, including flattening data, splitting and combining columns, formatting data, unpivoting summarized data, and combining several csv exports. If you frequently export/import data from one system to another, you will want to understand how to use a Get & Transform query to streamline your work.

There is a lot of buzz and rules of thumb about Roth strategies, but very little discussion on what the fiduciary-level analysis methodology should be. This course will provide insights on creating and evaluating an analysis and recommendations with targeted vetting questions. Rules of thumb can sometimes be detrimental, causing families to pay much more in taxes over their lifetimes than necessary. A very significant portion of the population is prevented from executing a straight-forward Roth Contribution due to the income restrictions. What was once a risky way to thwart that rule has now become accepted, and many clients can benefit. These contributions should typically take precedence to saving to a brokerage/taxable account, but there are some steps that need to be addressed to prevent unwanted taxation. In addition, you'll learn about the mega-backdoor Roth. SECURE 2.0 includes many new rules, and some of them address Roth IRA/401k. We'll cover these and how they can help your clients.