This session opens with how to use Excel's lookup functions to perform list comparisons. Also, this webcast covers how to perform multicolumn list comparisons without first combining several columns into a single lookup column. We discuss how a minor detail like how we indent can produce major efficiency gains. We end the webcast by comparing traditional lookup functions to Excel;'s multiple condition summing function. The webcast is designed with time for you to work along. This hands-on workshop is an effective way to learn Excel since you'll be completing the same exercises demonstrated by the instructor. A link will be provided, so you can download the necessary Excel files. During the webcast, the instructor will provide time for you to complete the exercises using your Microsoft Excel for Windows. For each topic presented, the instructor explains the topic and demonstrates it with Excel exercises. Then, the instructor provides time for you to complete many of the same exercises. Finally, the instructor demonstrates the solutions for all the exercises in the practice workbook and then moves to the next topic. This format allows you to work along rather than just watch passively, enabling you to immediately practice the skills demonstrated.

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.

• Identify time wasters and adopt strategies for eliminating them
• Recognize the variety of causes of procrastination and apply techniques to overcome them
• Use practical techniques for prioritizing work
• Delegation strategies
• Incorporate wellness and stress management into your day in short increments
• Understand their energy cycles and use it to manage your schedule
• Learn techniques to decrease stress in the moment (based on neuroscience)

Who will benefit:

Professionals leading a team or project, or will be in the future.

This webcast is hosted on CPA Crossing platform. Attendees will receive instructions on how to attend the webcast via e-mail.

U.S. Department of Treasury's Financial Crimes Enforcement Network (FinCEN) imposed a new reporting requirement that went into effect on January 1, 2024. Millions of businesses may have to file a Beneficial Ownership Information (BOI) Report. In a surprise turn of events, the Federal District Court from the Northern District of Alabama ruled on March 1, 2024 in National Small Business United v. Yellen ("NSB") that the CTA is unconstitutional. This course will discuss the CTA's provisions and the court's decision in NSB. Also covered will be future implications for business entities and steps to consider given the recent ruling.

We will also discuss recent proposed rulemaking by FinCen with respect to nonfinanced purchases of residential real estate and gratuitous transfers so that businesses can prepare for any additional reporting burdens that might arise.

This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

The major topics that will be covered in this course include:

• Background of the Corporate Transparency Act
• Beneficial Ownership Information Reporting (BOIR) Rule
• Entities required to report.
• Reporting requirements imposed by the CTA
• Due dates of reports
• Information needed to satisfy the BOIR
• Impact of failure to report
• How to submit a report
• Court rulings on CTA’s unconstitutionality
• Implications to entities as a result of the ruling in NSB.
• Potential reporting requirements due to FinCen’s proposed rulemaking with respect to non-financed purchases of residential real estate and gratuitous transfers.

Who will benefit:

This course is suitable for Corporate tax and finance executives, directors, managers and staff, CPAs, CAs Enrolled Agents, accountants, attorneys and business/financial advisors who work with and advise businesses and individuals that have these tax implications. All in-house and public practice t

This webcast is hosted on CPA Crossing platform. Attendees will receive instructions on how to attend the webcast via e-mail.

Don't look now, but ChatGPT is taking the business world, including the accounting profession, by storm. Every CPA, whether in public accounting or working in corporate, should have a fundamental understanding of ChatGPT and generative AI applications more broadly. This course will provide you with a foundation of knowledge about ChatGPT technology that will prepare you to have conversations with clients, customers, colleagues and service providers. More importantly, you will learn how to leverage ChatGPT to increase your personal productivity. If you feel your ChatGPT knowledge is lacking, that will not be the case after you attend this course, taught by John Higgins, one of the leading technology strategists and thought leaders for the accounting profession.

This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

The major topics covered in this course include:

• Overview of the current landscape for AI in business
• History of ChatGPT and generative AI
• Fundamentals of generative AI technology and related nomenclature
• ABC's of how to use ChatGPT
• Demonstration of practical ChatGPT applications for accounting, finance and tax
• A word of caution: What you should be concerned about
• Developing a ChatGPT usage policy for your firm / business

Who will benefit:

Anyone who wants to develop a fundamental understanding of ChatGPT and its potential impact on accounting, finance and tax.

This webcast is hosted on CPA Crossing platform. Attendees will receive instructions on how to attend the webcast via e-mail.

A discussion of the latest 2021/222 tax developments impacting business taxpayers, with a focus on important provisions, rules and concepts.

This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

The major topics that will be covered in this class include:

• 2021/22 legislation impacting business taxpayers
• Extenders legislation update
• Meals and entertainment expense reporting
• Partnership and S corporation update
• Income and deductions

Who will benefit:

CPAs in public practice and industry seeking an update on the latest tax developments affecting individual taxpayers.

This webcast is hosted on CPA Crossing platform. Attendees will receive instructions on how to attend the webcast via e-mail.

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.

The major topics that will be covered in this course include:

• Developments at the PCAOB.
• Recent trends in SEC comment letters.
• Enforcement actions and administrative proceedings.
• Conclusions and predictions for the future.

Who will benefit:

Anyone interested in public company accounting and auditing issues.

This webcast is hosted on CPA Crossing platform. Attendees will receive instructions on how to attend the webcast via e-mail.

Many CPAs are becoming full-time or fractional CFOs for small businesses. In that position, they are the resident expert in finances, cash flow planning, and budgeting. But what about dealing with the IRS? The IRS has broad powers to administer the assessment and collection of taxes. From removing penalties to criminal prosecutions, this presentation focuses on how CFOs can prevent problems with the IRS and how to develop winning strategies if the IRS knocks on the door.

This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

• The authority of IRS in assessing and collecting taxes.
• The common misconceptions when dealing with IRS.
• Common questionable actions by business owners.
• How to prepare for an IRS audit.
• The seven options in IRS collections.
• Possible criminal tax violations by CFOs and small business owners.

Who will benefit:

CFO, controllers, finance professionals, CPAs, and attorneys.

This webcast is hosted on CPA Crossing platform. Attendees will receive instructions on how to attend the webcast via e-mail.

Most financial leaders would agree that budgeting is easy when business and the economy are stable. When revenues and expenses are expected to remain the same, the process becomes merely an exercise in carrying over what was done before to the current year. However, what happens when we are not sure about how the market will react to our product? What happens when the competitive landscape changes? In this course, we will discuss budgeting techniques and considerations when business lacks stability. Through a combination of theory and real-world examples, we will explore how to build flexibility into our budget - so that it can inform and drive decision-making when we don't quite know what is ahead.

This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

The major topics that will be covered in this class include:

• Budgets vs. Forecasts
• Cyclicality
• Core Earnings & Sustainable Growth
• Identifying Key Forecast Drivers
• Reasonableness in Forecasting
• Approaches to Budgeting
• Budgeting Variances
• Horizontal Analysis
• Flexible Budgeting

Who will benefit:

CFOs & Controllers who are involved in the budgeting process.

This webcast is hosted on CPA Crossing platform. Attendees will receive instructions on how to attend the webcast via e-mail.

Many people that use Microsoft Excel know a great deal about the functionality of the application. There are, however, a tremendous number of hidden tools that a high percentage of users overlook. Additionally, there are newer features that some have not had the opportunity to explore. This session shows some of the numerous time-saving tools and features that often go unused by spreadsheet creators. People that wish to become more efficient when using Excel should take this session!

This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

The major topics covered in this course include:

• The power of keyboard shortcuts
• Oft used features with more capability than meets the eye
• New helpful features

Note: This session is taught using Hands-On methodology. We provide practice files that tie to the examples in the course materials so participants can undertake all the steps in unison with the instructor.

Who will benefit:

Accounting and other business professionals that work in Excel who want to become more efficient with the application.

This webcast is hosted on CPA Crossing platform. Attendees will receive instructions on how to attend the webcast via e-mail.

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.

The major topics that will be covered in this class include:

• Introduction to Power Query in Power BI: Understanding the interface and basic functionalities.
• Data Cleaning Techniques: Removing duplicates, handling null values, and data type conversions.
• Data Transformation: Advanced methods for manipulating data, including pivoting, merging, and appending queries.
• Data Loading: Efficiently loading data into the Power BI data model.
• Document the Process Steps: Setting up details for each step in the process so you can document what is happening and why.

Who will benefit:

This course is ideal for accounting professionals, financial analysts, and anyone who regularly works with data and seeks to improve their skills in data management and analysis using Power Query.

This webcast is hosted on CPA Crossing platform. Attendees will receive instructions on how to attend the webcast via e-mail.