Many Excel users have received little or no formal training to help them use the ubiquitous productivity application. This session can help users that wish to improve their Excel skills to increase their productivity. The material starts by covering basic topics such as time saving tips and keyboard shortcuts and then moves to more advanced areas like conditional formatting and complex formula building. Users that find themselves looking at the spreadsheets that others design and wishing they could do as much with Excel will benefit greatly by taking this course. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

The term "artificial intelligence" (AI) has become mainstream and while most have a layperson's understanding of AI, few know the depth and breadth of this technology's capability. AI is affecting just about everything in business and in people's personal lives. The operation of an internal control system is also changing because of this incredible advancement. This session explains what AI is and how it works and then goes into detail about how it can be applied to a system of internal control. The material speaks about changes occurring in today's world as well as what's coming in the not-too-distant future. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Everyone knows that Excel is the most widely used spreadsheet application in the world today. However, because it is ever-changing, many users are unable to keep up with the latest features and capabilities of this ubiquitous application. In this session, we look at some of the most helpful new features and tools that have been added to both the Desktop version of Excel and the Web version. Content like this is valuable to anyone that regularly works with Excel - We hope you will attend! This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

More and more entities need Yellow Book engagements, including a growing number of for-profit entities. In this course, we will review the unique independence requirements in GAGAS. We'll also review the recent changes to quality management in Yellow Book. We'll close with a reminder of common deficiencies found in Yellow Book engagements. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

ChatGPT is the fastest growing application in the history of technology with over 100 million users adopting it in within two months. It is a revolutionary technology that boosts the quality and efficiency of business processes in every industry. As "knowledge workers", CPAs and CFOs are positioned to be prime beneficiaries of this technology. This half day hands-on course will get you well on your way to becoming a ChatGPT expert. John Higgins, a nationally recognized advisor and educator on CPA technology, will guide you through the process of accessing ChatGPT and applying it to a variety of practical accounting, finance and tax scenarios. This course will catapult you to the top of the pyramid of CPAs who are knowledgeable in ChatGPT and you will be ready to put it to use in your day-to-day tasks. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Project Management is not the same as workflow management, and a project manager is more than a task master. Driving change, leading a team and managing client engagements requires a great deal of organization and planning. Successfully launching a new technology, onboarding clients, developing a new service line ... all takes more than a checklist of to-do items. You need to monitor risks and opportunities. You need to gain buy-in to drive adoption. Proper scoping and projections help keep projects on course, and not become a costly experiment that gets shoved to the back burner. Project managers are trained in analyzing the data while also managing people. In this session explore basic project management best practices and mindset to more effectively managing change in your firm.

Fraud Risk - Complying with Minimum Audit Requirements will highlight the audit procedures most effective in identifying, assessing and responding to fraud risk. The financial statement auditor's overall responsibility is to obtain sufficient appropriate audit evidence to provide reasonable assurance as to whether the financial statements are materially misstated due to fraud or error. The difficulty is that there are inherent limitations related to detecting fraud due to deliberate schemes to conceal the intent to deceive, such as collusion. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

This course will review common deficiencies identified by the AICPA and state boards of accountancy. It features discussion on a variety of topics, including analytical procedures, sampling, group audits and risk assessment. We will review the areas of concern and how you can overcome them by employing best practices. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Do you dread that annoying ERROR! message popping up on your spreadsheets? Tired of using the same long, elaborate formulas when you could be using the ones that are already built into Excel? Then this class is for you! In this webinar, we will focus on Debugging and Troubleshooting complex formulas. You will learn various techniques that will assist you in creating complex compound formulas. You will also learn techniques to resolve issues when you receive errors. This session will also discuss the 9 built-in error checking options and demonstrate resolution techniques. We will also review techniques to resolve rounding errors. This session is presented using Excel 2013. Regardless of the version you are using, ALL concepts covered in this course apply to ALL versions of 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 Professional Ethics Executive Committee (PEEC) of the AICPA has been very busy issuing new and updating existing ethics rules. This course will provide an overview of recently issued and soon to be effective ethics rules that CPAs in both industry and public accounting need to know to be compliant. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.