Professional Development and Event Catalog

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.

Do you use Microsoft (Office) 365? Are you satisfied that you are getting the most that you can from it? If you answered yes then no, this course will provide a really high return on your investment of time and money in this application suite. John Higgins, one of the profession's leading experts on the integration of Microsoft 365 into business, will explain and demonstrate the depth and breadth of the Microsoft 365 ecosystem. The course is designed to raise your awareness of all that you can do with Microsoft 365 and substantially increase your monthly subscription ROI. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Key factors and considerations for organizations seeking to implement a cryptocurrency-based payment system. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Financial statement disclosures are important to provide the information necessary for financial statement users to make economic decisions. Disclosures further explain and clarify information provided in the basic financial statements, but also provide critical information about subsequent events, litigation risk, and other concerns. This course focuses on the most common financial statement disclosures for small- or medium-sized nonpublic entities. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Organizations are challenged with identifying, evaluating, and responding to a wide variety of risks. This course will discuss tips and best practices for enterprise-wide risk management for accounting and finance professionals. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

New Technology, the move toward telecommuting, the widespread adoption of electronic documentation, and a wide range of other factors have significantly and forever changed the way business is conducted. It should go without saying that changes in tools and methods lead to upheaval in any organizations internal control system. In this session, we look at all the changes that are occurring and discuss what's coming in the not too distant future. The material then looks at how internal controls have been affected and what other updates are on the horizon. Anyone trying to use controls to keep their organization efficient and secure should consider this session because the rate of change to both operational methods and control processes has been and will continue to be incredible. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Did you know Excel has 400-500 functions depending on your version? Did you know there are 12 different function categories? Did you know you could create your own functions? After you attend this class, you will be in the know! In this webinar, we will focus on proofing and auditing your spreadsheets. You will learn how to build spreadsheets that validate the accuracy of your calculations and techniques to use the Data Validation feature to validate data entry. You will also learn techniques to cross-foot your data to ensure accuracy as well as how to use the various Excel Auditing Tools. 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 work for clients is not as linear as it used to be with the inclusion of more advisory services, more cross functional teams, and due dates moving. Quality client engagements are not just about a solid workflow, we need project management skills. In this session we will discuss how to apply project management techniques to designing a one firm, team approach to serving clients. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Recently issued accounting standard updates provide important clarifications for determining whether a not-for-profit (NFP) organization's transactions are an exchange transaction or a contribution. This course will provide those responsible for preparing financial statements for NFPs examples of the proper accounting for exchange transactions covered by ASU No. 2014-09 versus contributions covered by ASU No. 2018-08. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Retaining Talent in a Competitive Marketplace -Creating a Benefits Program Employees Care About In today's competitive marketplace, retaining talented employees is becoming increasingly difficult. A solid benefits program can make a difference in the fight for talent - but only if those benefits matter to the employees you are trying to hire! Through statistics and case studies, this course will explore what benefits are most valuable to employees. We will also explore the basic types of retirement and health insurance plans and discuss what financial leaders should consider before adopting a benefits package. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

You are likely familiar with strategies for removing the Trust Fund Recovery Penalty (TFRP) or brokering an installment agreement with a Revenue Officer or ACS Representative, but what should you do and when? What happens when things break down? Who should you contact and when? This topic will help guide practitioners on getting around certain obstacles or roadblocks while working cases with the IRS. This includes best practices for contesting the TFRP, who to contact and how to prepare when negotiating installment agreements, and steps to elevate cases that are seemingly going nowhere. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Auditing Liabilities, Including Long-Term Debt - Addressing the Risks of Completeness, Classification, and Disclosure will discuss tips and techniques for auditing accounts payable, accrued expenses, and common long-term financing arrangements and related debt covenants. The completeness and proper classification of liabilities are the typical higher audit risks. The complexity of the debt financing arrangements may create a significant risk requiring more persuasive audit evidence. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Ethics are of central importance to the CPA profession. But what do we mean by ethics? Is it just appropriate behavior, compliance with laws, or is it more than that? In this course, we'll discover what sets ethics apart and, therefore, sets the profession apart as well. We'll explore the tools available, the role of bias, and dive into real life case studies. We'll apply the AICPA's ethical framework and detect where bias was involved in the case studies. We'll even discover that one person set the price tag on their ethics at $53.7 million, only to lose it all in the end. 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 provides an overview of cybersecurity from the CPA perspective. We will discuss the components of an IT environment that need to be considered in audits - e.g. network, operating systems, database, and application layers. Additionally, we will discuss an overview of cybersecurity frameworks under the influence of the AICPA and/or ISACA - e.g. SOC2, COBIT, COSO, SOX IT controls, etc. and key cybersecurity controls. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

How does a forensic accountant calculate financial losses? Federal courts have approved various ways to calculate losses ranging from net worth method of proof to the expenditures method. Each method of proof depends on the available facts to the forensic accountant. This presentation will focus on the various court approved methods of proof, when to use them, and how to calculate the total loss. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

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.

This course explores the increasingly complex features of Excel that facilitate efficient data analysis. We will introduce numerous analytical methods and techniques by using practical examples to illustrate how to unleash the power of Excel when manipulating, analyzing, and reporting information. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Analytical Procedures - Comprehending Financial Statement Audit Fundamentals will provide the tips and techniques necessary to gather sufficient appropriate audit evidence to support conclusions using analytic procedures common to financial statement audits. Properly designing, documenting and evaluating results of analytic review procedures is critical for performing an effective and efficient audit engagement. Note: This course is recommended as a part of a 16-hour audit skills curriculum for experienced staff auditors, while it is also appropriate for anyone who has responsibilities for performing financial statement audit analytics. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Payroll is among the most common tasks an employer undertakes in the course of running their business. At its most basic level, payroll consists of an agreement between an employer and employee related to compensation for services. Once you look under the hood, there is so much more to payroll, including various kinds of compensation, payroll taxes and required reporting on government forms. This course will provide a general introduction to the workings of the payroll returns an employer is required to file. We will cover the various types of federal and state payroll taxes, what various payroll returns an employer may need to file, how to complete the most common types of payroll returns accurately, and real-life illustrations for reconciling at year end and ensuring your payroll returns are correct. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Ethics involve relationship to self, others, and the world in which we live. In the busyness of our world we often act out of habit without realizing that what we do truly matters. We matter! This session explores ethical values and principles as they apply to creating an Ethic of Care in the workplace with specific emphasis on compassion, accountability and respect. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.