Professional Development and Event Catalog

Budget methods are the key to allowing department managers to efficiently prepare their budget in Excel. For example, a budget method may be to spread prior year actuals or match prior year actuals, or match prior year actuals less 10%. In this webinar, we will explore how to allow users to pick a budget method from a drop-down list for each account and then have Excel perform different calculations depending on the budget method selected. We use several features and functions at the same time to pull this off. Even if you are not involved in the budgeting process, the underlying features and functions discussed have a wide range of uses.

Even though the current transfer tax exemption is extremely high to the point that few decedents have a federal estate tax liability, administering an estate is a burden for many family members. In many cases, the family members will look to their professional advisors for help in estate planning and administering an estate. The purpose of this program is to discuss those issues that practitioners with clients involved in estate planning administration need to know to advise those clients. Lack of planning and preparedness in estate issues can cost the heirs time and money upon a decedent's death.

What makes a business valuable? Who determines value? What are the key factors that make businesses valuable? In this course, we explore the different ways to value a business. We will apply foundational valuation and corporate finance concepts to real world examples in an effort to see what makes up an investment's price.

For CFOs and Controllers, the emergence of regulatory, fiscal, and monetary policy directly impacting their organizations' costs, competitiveness, and financing options, are causing them to understand the effect of shocks well outside of their control. The Dodd-Frank Act, health care reform, shortfalls in Social Security, unfunded pension liabilities, and deficit spending will all be explored relative to their impact on the CFO/Controller and your organization.

How do you pull a value from a cell into another cell? Do you use a direct cell reference, like =G10? If so, you are probably missing out on some efficiency gains that could be achieved by using a variety of Excel's lookup functions. Veteran Excel users, who are aware of the VLOOKUP function, are also painfully aware of its limitations--especially that it cannot go left. We will explore how to bypass VLOOKUP's limitations by nesting functions and by moving beyond VLOOKUP altogether.

Do you love PivotTables? Of course, we all do! Traditional PivotTables are incredible, but they do have limitations. If you have ever encountered one of these limitations, you'll be excited to learn that by using the Data Model as the source for PivotTables, you'll be able to bypass many of the restrictions that exist with traditional PivotTables. The data model (also referred to as Power Pivot) is included in Excel 2016+ for Windows and available as a free download for previous versions (excluding Excel for Mac). Using the data model enables you to build PivotTables that were previously not practical. If you frequently build PivotTables and would like to do more with them, you'll want to understand how to use the data model (Power Pivot) to enhance your reports. Note about Excel versions: Power Pivot is not available in all versions of Excel, including Excel for Mac. If you would like to see if Power Pivot is available in your version of Excel, visit the Microsoft site.

Buying and selling a business can be a complex transaction with many tax issues. These issues include whether the transaction is or should be a stock or an asset sale when the business involved is a corporation, as well as the tax consequences associated with the sale of a partnership or a C or S corporation. Tax practitioners who advise clients who are buying or selling a business primarily focus on the tax issues that apply. This program explains and analyzes the tax issues practitioners must address in order to properly advise clients who are either buyers or sellers of businesses.

For roughly 90% of American retirees, Social Security income will be the foundation of their retirement income. Yet, many are ill-prepared and lack understanding of the critical aspects of making an informed claiming decision. Further challenged to separate fact from fiction, consumers crave accurate information from knowledgeable professionals to make the most out of these coveted monthly benefits. This course dispels common myths about Social Security that lead to confusion and replaces them with the truth to an empowered retirement. Help your clients navigate their claiming age decisions with greater confidence, equipped with the essential truths they should consider before pushing the Social Security "on" button.

Designed for accounting and attestation practitioners at all levels in both public accounting and business and industry, this course provides a detailed review of the multitude of FASB and AICPA standards issued over the past few years. The course also provides many hands-on examples and illustrations to help apply the guidance in practice and discusses other important A&A practice matters to be aware of, including an update on peer review and audit quality.

The past two years have ushered in an explosion of ransomware attacks affecting businesses and individuals. Many of us read or hear about these attacks, but there is little understanding of how they occur, how a response is undertaken, and how the chances of experiencing one can be reduced. Join us to learn about these topics so you can be prepared with the best response and the knowledge to avoid common mistakes in a ransomware event.

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.

The Internal Revenue Service has targeted complex partnerships it believes are not in compliance with the tax law for audit. One of the abuses the IRS has attacked is transfers of interests in partnerships which result in an increase in the basis of a partner who is subject to a high marginal income tax rate. This perceived abuse results in lower income tax and/or a higher basis in partnership property for the higher marginal income tax partner. The final regulations basically characterize certain partnership-related basis adjustments as transactions of interest on the part of the IRS. In a practical sense, this means that property transfers in a partnership with related party partners may run the risk of IRS scrutiny if audited. It is common for certain types of partnerships, such as real estate limited partnerships, to have related-partner partnerships. The IRS may decide to scrutinize partnerships with related party transfers. Since these final regulations presume an understanding of the rules for partnership distributions and Section 754 elections, the program begins with coverage of those two topics, with time devoted to adjustments under both Section 743(b) and Section 734(b). It would be hard to understand the IRS's claim of abuse without a working knowledge of these transactions.

One of the most intimidating aspects of going into business for yourself is compliance. Tax, employment, and regulatory laws are difficult to navigate, so it often falls on the CPA to know the basics in these areas to help their clients avoid costly litigation. In this course, we will cover basic compliance areas for small business owners. We will look at the main elements of a contract, taxation of entity types, worker classification, property law, and many of the other areas that are often overwhelming for small business owners. By being able to speak to these issues, practitioners will be able to add value and help their small business owner clients grow and thrive.

Explore the intricacies of federal income taxation as it intertwines with rental real estate activities. This course delves into the calculation of rental income, understanding the nuances of deductions, and unraveling the complexities of passive activity loss rules. Whether it's mastering Schedule E or understanding Congress' intent behind tax laws, professionals will leave with an enriched understanding.

Understanding unconscious bias is key to creating an inclusive workplace and to making the best business decisions. This course explores the concept of unconscious bias, the science behind it, and how it can affect the way employers hire, evaluate, and treat employees. We will also discuss strategies employers can use to reduce unconscious bias and create a more inclusive workplace.

In today's rapidly changing world, finance professionals are required to wear many hats and are often the keys to the success of the organization. On one hand, they need to be abreast of the latest proven financial skills for making the best decisions, and on the other hand they need the best skills to motivate, manage, and lead people. Being pigeon-holed into one area or another is neither good for career building nor good for the organization. We'll cover the latest issues that all CFOs and controllers need to know about and provide how-to guidance to allow for immediate use in their organizations.

While ethics training is required by many states, the true value of the CPA license is in understanding how critically important ethical behavior is to our customers, our firms, and the public. This course will explore the basic tenets of ethical behavior and use case studies to explore ethical dilemmas in various companies and organizations with a focus on dilemmas that may face CPAs in the industry.

Increased funding resulting from the enactment of the Inflation Reduction Act will allow the IRS to target many more wealthy individuals and large businesses for audit. These efforts will become more intense over the next several years as the IRS employs artificial intelligence in more of its audits. This program discusses how and when the IRS's energized audit efforts will result in more audits of taxpayers and what attendees need to know to effectively represent clients that the IRS audits.

Whether you are an experienced veteran or new to the industry, one of the toughest parts of being a tax practitioner is keeping up with all of the changes in tax legislation. This course takes a look at recent changes to tax law from a practitioner perspective. In this session, we will explore the nuances of virtual currency and the new Form 8300 reporting requirements.

This webinar presents a variety of time-saving ideas, shortcuts, and tips that are sure to boost personal productivity. We discuss better summing, address one of the biggest pitfalls that Excel users have faced over the past 25 years, present the most important keyboard shortcuts, demonstrate a better alternative to hiding rows or columns, illustrate how to quickly navigate to other workbooks and files, and demonstrate using Excel with styles.