CPE + Events Catalog

You have used Excel for years and perhaps Lotus 123 before that. And through all that time, you have repeatedly said, "One day, I'll learn how to write macros." Finally, that time has arrived because this four-hour program will introduce you to the wide world of Excel macros and Visual Basic for Applications (VBA). This course teaches the fundamentals of creating and working with macros in Excel and is designed specifically for those with little experience working with macros. More specifically, taking this course will teach you how to use Excel's Macro Recorder to write simple yet effective macros. You will also learn how to secure and share macros with other Excel users and create user-defined functions to solve specific accountant-centric problems in Excel. Further, you will learn how to create macros that run when a user opens a workbook and VBA basics. Don't miss this unique opportunity to learn how to begin working with macros - one of Excel's most powerful tools.

Designed for accounting and attestation practitioners at all levels in both public accounting and business and industry, this course provides a detailed review of SAS No. 145 and brings you up to date on 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.

Best Practices for Identifying and Evaluating Audit Risk - Linking Risk to the Detailed Audit Plan will emphasize the key concepts and best practices that drive a thoughtful risk-based approach to forming an opinion on the financial statements. Properly identifying, assessing, and responding to risk through a detailed audit plan is critical to an effective and efficient financial statement audit. Note: This course is recommended as a part of a 16-hour audit skills curriculum for experienced staff, while it is also appropriate for anyone who has the need to better understand how to link risk assessments to the detailed audit plan. 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 shows how undisciplined decisions in business can lead to government investigations and prison terms. We profile three entrepreneurs from three separate industries who built billion-dollar enterprises. Despite well-developed infrastructures, simple business decisions led to their being wrapped into government investigations, criminal indictments, and collateral consequences that accompany felony convictions for white-collar crime related to federal election laws, tax fraud, and securities fraud. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Learn the basics of employment law and how they affect best practices to help control the interview and discover hidden talents of applicants.

What exactly is cryptocurrency and its cousin named blockchain? Are they here to stay? This session will provide a big picture examination of the technologies and currencies by explaining how we got here. We discuss the systems and technical aspects of cryptocurrencies and blockchain. What is the broad view of the technologies that currently do, and will continue to, impact our workplace and lives?

Environmental, Social and Governance (ESG) has become a hot topic among standard setters. This session will look at the work of the FASB, GASB, and AICPA in the areas of ESG. We’ll also look at the types of engagements CPAs can provide to entities who want assurance around their ESG reporting.

Please join us for an introductory course on the fundamentals of preparing and filing an individual federal income tax return. We will cover topics such as what the federal income tax is and how it is computed. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

This session introduces theories on human nature and organizational factors affecting ethical choices. Robbie examines the role of gossip in the workplace, provides tools for ethical decision making and offers concrete actions for creating and sustaining an ethical work environment. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Staying current on significant changes in Government Audit Standards can be difficult. This course covers the most important issues and changes relevant to Yellow Book financial statement audits. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

The Tax Division, United States Department of Justice, is responsible for enforcing the nation's tax laws fully, fairly, and consistently, through both criminal and civil litigation. This course will explore the role of the Tax Division in ensuring fair and uniform enforcement of tax laws, protecting the public, encouraging voluntary compliance with tax laws, and how their operations impact regulatory ethics. 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 begins with a look at the GASB standards effective this year, including GASB 100, Accounting Changes and Error Corrections and GASB 101, Compensated Absences. We'll include practical application of the topics in the form of case studies. 

The Microsoft 365 ecosystem of apps offers tremendous value for any business organization. The key to maximizing the ROI of your monthly subscription fees is to understand how all the apps work together. John Higgins, a strategic advisor to the profession on Microsoft 365 deployment, will share a number of "best practices" for deploying Microsoft 365. This course will help you discover the hidden gems in the Microsoft ecosystem to increase productivity across your organization and help you avoid making costly mistakes in your deployment. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Review the availability and application of three special rules that allow exclusion or deferral of gain from the sale of the stock of a corporation not making the S corporation election. IRC 1202 provides that all or part of the gain from the sale of "qualified small business stock" can be excluded from gross income. IRC 1045 describes situations when the gain from the sale of "qualified small business stock" can be deferred. To understand the application of these two favorable provisions, the meaning of "qualified small business stock" and other requirements and limitations must be understood. IRC 1042 allows the deferral of gain from the sale of corporate stock to an employee ownership plan ( ESOP). This deferral requires a qualified reinvestment in an adequate amount at the right time. Study how these three provisions apply in the context of tax planning for corporate businesses.

The Not-for-Profit Advisory Committee has been busy discussing several projects that the FASB is working on and their impact on nonprofits. In this course, we will review the key issues and discussions from recent NAC meetings. We'll also take a look at ASUs issued by the FASB that may impact nonprofit financial statements. After a break, we then transition from accounting to auditing with a look at the common deficiencies found in nonprofit Yellow Book audits with a focus on CPE, reporting, and independence.

Ethics is simple: Do no harm, just tell the truth, keep your word, and when in Rome do as the Romans do. For most people in most circumstances, these "bumper sticker" sayings provide helpful ethical guidelines. For accountants, however, ethics -- and especially, professional ethics -- can quickly turn into a tangle of ethical conflicts and competing rules. This workshop untangles some of these situations by working from ethical theory and practice. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

This program analyzes and applies the AICPA Code of Professional Conduct and other sources of ethical guidance to actual scenario-based case studies, providing accounting professionals with ethical standards to integrate into their practices. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

This session provides a refresher regarding the fundamentals of activity-based costing (ABC). We will examine theoretical concepts before exploring practical possibilities for implementing ABC. A major focus of the course will be factors to consider when determining whether this managerial accounting tool is an appropriate resource for an organization.

This course provides a concise overview of how to utilize ChatGPT for advanced financial analysis in accounting. The session reveals how to combine sophisticated evaluation and interpretation of financial data with the cutting-edge AI capabilities of ChatGPT. Aimed at enhancing the understanding of an entity's performance, predicting future financial health, and aiding in informed business decision-making, this course goes beyond basic financial statement analysis to include a wide array of techniques and tools. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Probably one of the greatest conflicts in an organization is determining which is more important: compliance or customer service. This program digs deeply into the issue and prepares the finance professional to achieve high levels of compliance and customer service in the department and in the entire organization. We will examine both disciplines from an analytical standpoint, proving why they are necessary for both for-profit and nonprofit businesses to achieve success.