This intensive 2-hour course is designed to unlock the potential of array formulas in Microsoft Excel. Array formulas are a vital tool in Excel for their unique ability to perform multiple calculations on one or more items within an array, making them indispensable for complex data analysis and calculations. They enable users to write fewer, more powerful formulas, leading to cleaner and more efficient spreadsheets. This course is tailored to enhance your data analysis and spreadsheet management skills by delving into the advanced aspects of array functions. Through a combination of theoretical knowledge and practical exercises, you will learn to streamline your work and improve efficiency in Excel.

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:

• Introduction to Array Formulas: This segment establishes the foundation by differentiating array formulas from regular Excel formulas and explaining their significance.
• Using Array Formulas: This section focuses on the practical application of array formulas, teaching participants how to effectively implement and utilize these formulas in a variety of common Excel tasks and scenarios.
• Dynamic Arrays and Spill Functions: This part covers the utilization of dynamic arrays and spill functions, highlighting their role in modern Excel data handling.
• Advanced Array Functions: Participants will delve into complex functions such as SUMPRODUCT, UNIQUE, SORT, and FILTER, focusing on multi-condition summing and data management.
• Using Array Constants:  This section teaches how simplify the use of static values called Array Constants

Who will benefit:

This course is ideal for professionals who regularly use Microsoft Excel for data analysis, financial modeling, or complex calculations.

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

This session will explore key aspects of getting more satisfaction out of the work you choose to do and how to find greater balance between the demands of work and other lifestyle choices in an ever more complex and changing world.

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 class include:

• How to get more out of one's work
• How to achieve greater balance between today's ever more demanding and complex demands of work without losing sight of what is important in daily routines
• Example of how to develop and be challenged by your own personal bucket list

Who will benefit:

Practitioners who are seeking tips and techniques to implement to improve their work life balance.

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

Since 1919, the Internal Revenue Service had a civil and criminal function in the United States tax system. Little do people know, the IRS has an elite criminal function that started with five United States Postal Inspectors. From its early days in taking down Al Capone to now solving cybercrimes, the IRS special agents are tasked with investigating tax fraud, money laundering, and other white collar crimes. This presentation will show you the importance of this law enforcement function, the training, techniques, expertise, and actions that cause them to be known as the "world's finest financial investigators."

This presentation has been prepared by a 20 year veteran with the IRS-Criminal Investigation. The presenter investigated crimes, and trained and mentored other special agents.

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:

• Introduction to IRS Criminal Investigation (CI): Overview of its mission, role, and significance in maintaining tax compliance.
• Historical Evolution: From its inception in 1919 to its current role, highlighting key milestones and notable cases.
• Investigative Techniques and Tools: Detailed look at the methods and technologies used by CI agents to uncover financial crimes.
• Importance of IRS CI: Discussion on the impact of CI’s work on tax compliance, public confidence, and the broader financial system.
• Training of CI Agents: Insight into the rigorous training programs at FLETC and ongoing professional development.
• Process of Investigations: Step-by-step breakdown of how tax fraud and money laundering cases are initiated, investigated, and prosecuted.

Who will benefit:

CPAs, forensic accountants, tax professionals

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

A well-designed internal controls system can and will drive all entity objectives. Too many times control creators focus too much on security. It is important to properly balance protection-based measures with those designed to enhance efficiency. This session works to illustrate the power of a strong and well supported control system. It also discusses steps to take in order to establish such a system. This material is becoming more and more beneficial as companies strive to address many new business challenges such as evolving markets, the rapid rate of change in the business world and the notable increase in governmental and industry-based regulation. Those that desire a balanced and workplace enhancing control system should strongly consider 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:

• An overview of control frameworks and concepts
• Strategic considerations that can be incorporated into control development
• Understanding and controlling risk that arises when organizations change or choose not to
• The COSO Internal Control Framework and the COSO ERM Framework

Who will benefit:

Accounting and other business professionals that wish to know more about controls that drive all entity objectives.

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

Ready to slim down your team and maximize efficiency without sacrificing quality? This session breaks down how to leverage tech and automation to fill workflow gaps, build a strong tech stack, and connect tools seamlessly.

Learn how one proven tech stack replaced more than half a traditional team while improving client satisfaction and reducing overhead. Walk away with practical steps to streamline operations, automate repetitive tasks, and focus your resources on what really matters.

Attendees will gain practical insights into streamlining operations, automating repetitive tasks, and focusing resources on high-value activities. The session also includes an exclusive look at a proven tech stack used to replace over half a traditional team, offering actionable steps to create a leaner, tech-driven, scalable firm.

Perfect for firm owners ready to rethink staffing, reduce overhead, and embrace the future of accounting efficiency.

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:

• How to leverage tech and automation to fill workflow gaps,
• How to build a strong tech stack, and connect tools seamlessly.
• How one proven tech stack replaced more than half a traditional team while improving client satisfaction and reducing overhead.

Who will benefit:

Firm Owners, Accountants, Managers, CPAs

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

This course is designed for tax professionals seeking to understand and navigate the IRS collection process effectively. Participants will gain indepth knowledge of the various collection methods employed by the IRS, including liens, levies and wage garnishments. Additionall, participants will leand strategies to avoid or halt collection actions and the implications of the statute of limitations on tax collection.

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:

• Overview of the IRS collection process.
• Taxpayer rights and the Taxpayer Bill of Rights.
• Collection due process and appeals.
• Installment agreements and offers in compromise.
• Wage garnishments, levies, and liens.
• Penalties and interest.

Who will benefit:

CPAs, EAs, Tax Professionals, Financial Planners, Investment Advisors, Attorneys, Tax Professionals assisting cleitns with tax resolution

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

An audit is an investment in reliable financial reporting and compliance, and an increased return on those dollars can be achieved by hiring the right auditors. This course will provide key factors for you to consider when evaluating whether you are getting the most quality and insight from your auditors, to enable them to perform the most value-added audit possible in the given circumstances - while retaining the trust of a CPA.

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:

• Limitations in roles and responsibilities an auditor can accept without impairing independence
• Assessing the strength of your auditor's ability to think critically, strategically, and creatively in appropriate circumstances
• Evaluating your auditor's time and project management stills
• Grading your auditor's communication and interpersonal skills, in exceeding your expectations on an audit

Who will benefit:

Anyone who manages the external auditor relationship

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

This intensive two-hour course addresses the critical need for accuracy and efficiency when developing spreadsheets using Microsoft Excel. Recognizing that even minor errors can have significant implications, this course delves deep into strategies and skills required to detect and correct errors in Excel. By the end of this course, participants will have a comprehensive understanding of how to efficiently identify and correct errors in Excel spreadsheets, enhancing their overall productivity and accuracy in their professional roles.

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

• Understanding Common Excel Errors: Gain insights into the most common types of errors encountered in Excel, including formula errors, reference errors, and logic errors.
• Advanced Formulas and Functions: Learn to use advanced Excel functions and formulas that are crucial for error detection and data analysis.
• Data Validation Techniques: Master the art of data validation to prevent errors before they occur. This includes setting up data validation rules and using conditional formatting to highlight potential inaccuracies.
• Error Tracing and Auditing Tools: Delve into Excel's auditing tools to trace and fix errors. Learn to use Trace Precedents, Trace Dependents, and the Error Checking tool effectively.

Who will benefit:

This course is ideal for anyone who uses Excel extensively in their work, especially those involved in financial analysis, reporting, auditing, or any role where accuracy and efficiency in handling Excel spreadsheets are paramount.

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

The AICPA has identified risk assessment as an area of focus for its Enhancing Audit Quality Initiative as deficiencies in auditor's risk assessment procedures continue to be a common issue identified in peer review. SAS No. 145, Understanding the Entity and Its Environment and Assessing the Risks of Material Misstatement, was written to improve the quality of risk-based audits. While key concepts do not fundamentally change, the standard works to clarify and enhance certain aspects of the identification and assessment of the risks of material misstatement to drive better risk assessments and hopefully overall enhance audit quality.

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

The topics that will be covered in this class include:

• New concepts due to the issuance of SAS No. 145
• Revised requirement to separately assess inherent risk and control risk
• A new definition of significant risk
• New emphasis on IT controls and risk of material misstatement
• New guidance on maintaining professional skepticism
• Revised requirements to evaluate the design of certain controls
• Revised requirements regarding audit documentation
• New guidance on scalability

Who will benefit:

Practitioners who perform audit engagements

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

The amount of electronic content that business organizations contend with is growing at incredible rates. Terms like "Big Data" and "Information Overload", are being used by overwhelmed information workers on a daily basis. Additionally, because of the move to a much larger telecommuter footprint, electronic data is now even more prevalently utilized. This session discusses the places that businesses keep digital information and addresses the importance of securing corporate electronic data. The material effectively shows ways to achieve high security standards for content stored in fixed locations, on mobile devices and in the cloud. Participants in this session will gain an understanding of the concepts needed to improve the way they, and their companies secure digital information.

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:

• Securing individual documents
• Protecting information resident in the Cloud
• Securing data stored on or accessed by mobile devices

Who will benefit:

Accounting and other business professionals that need to add security to the electronic content with which they work.

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