CPE Catalog & Events

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.

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.*

Many clients end up selling one or more residences during their lifetimes. Accounting and finance professionals must be aware of the tax rules that relate to such sales in order to assist their clients regarding these sales. This program provides accounting and finance professionals with the tax rules they need to know to help their clients when they sell a personal residence. This program is a comprehensive survey of the various tax issues associated with the sale of a residence.

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.*

Tax credit and incentive programs offer significant but rarely utilized savings. This presentation will introduce the most important federal and California tax credits and incentives available to business taxpayers. Attendees will hear an overview of these benefits and learn how to identify these opportunities for their clients.

Whether your employees report in every day to the floor or from an off-site network, the success of your organization depends a great deal on the motivation they bring to the job. This program helps identify specific methods you can use to improve employee motivation. You'll learn how to use observation tools to find out what motivates your employees and you'll study classic motivational theories. The results will help you influence the behaviors of others and tweak your own behavior to improve your bottom line.

Since 2017, employees have not been eligible to take an itemized deduction for a home office. The Tax Cuts and Jobs Act suspended all miscellaneous itemized deductions for tax years 2018 through 2025. That deduction is scheduled to go into effect in 2026. Self-employed individuals can deduct office expenses on Schedule C, Form 1040. The home office deduction includes typical office-connected expenditures such as supplies, postage, computers, printers, and all the other ordinary and necessary expenses a person would have in connection with running a home office. The home office tax deduction for the self-employed would cover expenses for the business use of a home, which includes mortgage interest, rent, insurance, utilities, repairs, and depreciation. This program discusses many of the most important issues relating to the deductibility of home office-related expenses.

Cash flow management is often the most important task of any CFO or financial leader. Regardless of whether one works in start-ups or established companies, non-profit or for-profit entities, cash flow makes our organizations run. Have you ever wondered whether you are optimizing your company's cash flow? In this course, we will explore how to improve your company's cash flow using analysis and financial theories in the context of real-world situations.

This comprehensive course delves into the intricate world of executive compensation, focusing on the taxation and reporting procedures for various types of compensation arrangements. Participants will gain a deep understanding of the key differences between incentive stock options (ISOs) and nonqualified stock options (NQSOs), as well as the tax treatment and reporting requirements for restricted stock awards, stock appreciation rights (SARs), phantom stock plans, and employee stock purchase plans (ESPPs). The course will also cover the accurate analysis of tax forms and schedules used for reporting executive compensation, common tax reporting errors to avoid, and strategies for handling extensions, estimated taxes, and increased IRS scrutiny.

Mastering business transformation with key skills and strategies relevant to modern businesses You'll learn tools that will help you manage day-to-day business operations as well as manage changes, including: Budgeting and forecasting approaches Strategic planning and risk management frameworks Technologies that can improve productivity. Optimizing your business model and identify value drivers You'll also understand how to identify and innovate your business model and how to incorporate intangible value drivers into your capital asset strategy by Using hands-on strategies to define your business model and capital structure Learning techniques and models that will guide business model innovation Understanding the role of technology in innovation Leading your team effectively and ethically Additionally, you'll evaluate how to build a successful team and maintain an ethical tone at the top by discovering how to: Attract and retain top talent Adapt leadership styles to different situations Formulate strategies that promote an ethical culture

Is teamwork the ultimate competitive advantage" Every manager's primary purpose is to lead a team. This seminar will help you get every member of your team on the same page, improve performance and realize the potential of the talent you have.

We're all impacted directly or indirectly by the laws of real estate taxation, possibly as an owner, investor, landlord, developer, or real estate professional. This course explores the key principles of real estate taxation from all these perspectives. We'll discuss personal residences, vacation homes, credits, passive losses, qualified business income, installment sales, involuntary conversions, like-kind exchanges, real estate investment trusts (REITs), and the One Big Beautiful Bill's enhancement of depreciation deductions.

Theoretical conundrums and compliance issues Multistate taxation has never been more relevant. This course helps you skillfully navigate the maze of corporate tax codes across jurisdictions. Learners get fresh perspectives on: Interstate activity and nexus Modifications to federal tax income to arrive at state taxable income Allocation and apportionment Filing methods for multistate taxpayers By spotlighting updates on the latest state tax reforms, this course will help you develop a working knowledge of both multistate tax compliance and related planning opportunities.

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. It will be updated and supplemented throughout the year to cover breaking developments.

Accounting and finance practitioners are continually asked for strategic planning advice. In this course, we will cover topics that will make clients, and their advisors, tax smart and tax prepared for the coming year and beyond. This program is a two-hour review and analysis of what we consider some of the most important changes from the OBBBA impacting both individual and business clients.

This professional development course equips you with practical strategies to manage challenging interactions in the workplace. Although difficult individuals may represent a small segment of the workforce, their impact can be significant, often leading to time lost and decreased productivity. In this course, you will gain essential skills to address and navigate these situations effectively. Additionally, you'll identify specific challenges and develop a personalized action plan for implementing the strategies learned back in your workplace.

This course is designed to present the most common types of financial statement fraud and embezzlement, illustrated through real cases and situations. We'll distinguish financial reporting fraud from misappropriation of assets and highlight common schemes involving one or both types of fraud. We'll review high-profile cases and other real-world situations to emphasize the CPA's role and responsibility. This course will also touch on updated GAAS requirements. Get ready to examine the methods used to perpetrate and disguise schemes, learn how fraud can be detected by both management and auditors, and explore the CPA's role in preventing and detecting both types of fraud.

Is teamwork the ultimate competitive advantage" Every manager's primary purpose is to lead a team. This seminar will help you get every member of your team on the same page, improve performance and realize the potential of the talent you have.

We're all impacted directly or indirectly by the laws of real estate taxation, possibly as an owner, investor, landlord, developer, or real estate professional. This course explores the key principles of real estate taxation from all these perspectives. We'll discuss personal residences, vacation homes, credits, passive losses, qualified business income, installment sales, involuntary conversions, like-kind exchanges, real estate investment trusts (REITs), and the One Big Beautiful Bill's enhancement of depreciation deductions.

Uncovering financial fraud and irregularities requires more than analyzing numbers'it demands strategic questioning and keen behavioral insight. This course equips CPAs with essential interviewing techniques to detect deception, gather critical information, and strengthen forensic audits. With financial fraud on the rise, mastering investigative interviewing is a crucial skill for CPAs committed to protecting organizations and ensuring financial integrity.