CPE Catalog
Note
AICPA On-Demand & Self-Study courses take up to 24 hours to process.
Excel - Working with Text, Date & Time Functions & Formulas
-
Online
2.00 Credits
Want to automatically update the date and time on your spreadsheet? Or pick text strings from other cells to automatically copy and update to a different cell? You will learn how to incorporate text, date and time functions in your spreadsheet that will make data entry a breeze. In this webinar, we will focus on Text functions and Date & Time functions. In the Text function section, you will learn how to use the various Text functions to join and separate text entries as well as formatting the results. In the Date & Time function section, you will learn how to perform various date and time calculations. 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.
Supervision/Management Competencies: An Ethical Approach
-
Online
2.00 Credits
Job titles for individuals can vary in different organizations even though the work is the same. This webinar is designed for the individual whose role is to oversee the work of others. This webinar includes an overview of Aristotle's virtue ethics and its application to the responsibility and privilege of developing employees to be their best and for the success of the organization. We will also address issues such as going from "buddy to boss", how to manage if you are newly assigned to an existing employee that was previously supervised by someone else, and critical skill sets necessary for supervisory/managerial positions. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Real Estate Professionals, Passive Activity and Section 199A
-
Online
2.00 Credits
This program will provide a detailed analysis of the real estate professional passive activity rules, including forms reporting examples, and integrates those rules with when real estate is considered a "business" under the Section 199A flow-through entity deduction. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Excel - Using Charts for a Non-Financial Audience
-
Online
2.00 Credits
This webinar will show you how to use Excel's charting and formatting features to present financial data to a non-financial audience. As the saying goes, "A picture is worth a thousand words." People tend to better understand your point when visuals are used. We will explore the many capabilities of presenting your data without showing rows and rows or columns and columns of data. Help your audience visualize the meaning of the data, whether it is a trend, an exception, a distribution or a good vs. bad relationship. 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.
How To Build High-Performing Teams in Challenging Times
-
Online
2.00 Credits
Team development and performance are critical to leadership success. In this session, participants will examine team formation, learn about the balance between team performance and team health, develop team agreements, and understand the latest tips from Google's Perfect Team research to strengthen team experience. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Managing with a CEO Mentality
-
Online
1.00 Credits
In this dynamic session, Sharrin Fuller, Entrepreneur and CEO, will share her insights on managing with a CEO mentality. Sharrin will guide participants in developing the mindset and skills necessary to excel as managers. Through real-life examples and practical strategies, attendees will learn how to adopt a CEO mindset, think strategically, and make informed decisions that align with long-term business goals. Additionally, valuable techniques will be presented for inspiring and motivating teams, fostering a culture of accountability, and driving high performance within their organizations. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Independence and Conflicts of Interest
-
Online
1.00 Credits
This course focuses on how to integrate independence and avoid conflicts of interest in situations accounting professionals face daily. Participants will be able to know not just what is the right thing to do according to the AICPA Code of Professional Conduct, but how to put values into action. As part of this course, we also walk through real-world examples of individuals and companies faced with these dilemmas. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Communicating Financial Information to Non-Accountants
-
Online
2.00 Credits
Do you ever get blank looks when you present your company's financial statements? Does your board nod knowingly, during your presentation, but never seem to have any meaningful questions? It could be that they have no idea what you are talking about and are just pretending to understand! Learn how to connect with your CEO, board, fellow managers, and ordinary employees so they understand your message. Learn to motivate them to action. Come hear a veteran CFO tell you how. 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
-
Online
4.00 Credits
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.
Walter Haig's Business Financial Health Checkup
-
Online
8.00 Credits
This course fills an important need for both financial managers and accountants in the practice of public accounting by offering the tools to help ensure the future success of a business. Practical guidance for the effective use of benchmarking and analytical procedure is also provided. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Motivating the Right Way - Get the Most From Your Staff!
-
Online
2.00 Credits
Are you getting the most from your staff? Are you paying top-dollar and still not getting high performance? New research gives us the insights to effectively motivate your people. This session discusses proven people motivation tactics. Many 'old' methods really did not motivate in the past and certainly do not work today. Getting the most from your people requires new, very learnable, leadership techniques. Whether your business is large or a start-up, getting people to move forward as one is a challenge. This session will show you how to create an environment where your talented employees can excel. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Starting a Fraud Investigation
-
Online
2.00 Credits
In this session we focus on the early stages of a fraud investigation, including: who should be on the team, how to create an investigation plan, and the evidence that should be acquired and evaluated. Investigative techniques involving a variety of different sources will be covered, including financial document analysis, background checks, data analysis, and interviewing. This is the most practical fraud investigation course you will ever take. Rather than learning only the theory of fraud, you will learn how a forensic accountant actually investigates fraud from the beginning to the end. We focus on forensic accounting techniques used in the field to prove what happened, who was involved, how much money was stolen, and where the money went. Starting a Fraud Investigation is Part 2 of a series of four courses on fraud investigations. Each course is a stand-alone class that may be taken individually. For comprehensive instruction on completing a fraud investigation from start to finish, take all four. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Audit 303: Internal Controls - Required Communications
-
Online
2.00 Credits
Internal Control Deficiencies and Other Matters - Adding Value Through Required Auditor Communications will help the auditor with understanding how to improve required internal control communications to be more value-added from the perspective of the client. Professional and regulatory audit standards require communication of internal control matters noted in a financial statement audit. This assists management and those charged with governance with satisfying responsibilities for designing, implementing, maintaining, and monitoring internal controls. In addition, in order to retain existing clients, lower fee pressures and gain invaluable referral sources, financial statement auditors must place a priority on being a value-added business advisor. Note: This course is recommended as a part of a 16-hour audit skills curriculum for in-charge or supervisor auditors, while it is also appropriate for anyone who has responsibilities for communicating internal control related matters to the client. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
CFO Series: Bridging the Gap with Marketing Mgt: the Four Ps
-
Online
2.00 Credits
What should we know about marketing and what are the four 'P's of marketing? Many financial leaders are not sufficiently knowledgeable about the marketing function, marketing management, and measuring marketing results. When we know more, both functions can work collaboratively to help drive a superior bottom line. We can more accurately measure success, for example, in order to approve a cost-effective strategy to maintain and grow the business organically. We will discuss proven techniques to help your organization grow and thrive. Finance and marketing can and should help each other - we will show you how.
How Fraud Can Affect Smaller Organizations
-
Online
4.00 Credits
Many small to medium sized companies do not properly address the risk that arises related to fraud because these organizations do not have the resources needed to mitigate this risk or because owners or those in top level management underestimate the scope of the issue. All organizations, regardless of size, must be aware of the risks associated with intentional fraudulent acts and know that a significant and effective fraud scheme could even create going concern issues for some entities. In this session, we delve into the reasons that fraud takes place. The material discusses the types of defalcations that are often executed against smaller entities and then explores measures that organizations can implement to help stop fraud activities and add security. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Money Laundering Awareness for Accountants
-
Online
2.00 Credits
The course provides general information on how to identify money laundering activities during the conduct of normal tax audits. Discover key resources and tools available for effective detection and deterrence. Explore the impact of money laundering on ethical decision-making, and how examiners and auditors can assist criminal investigators in countering money laundering. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Whistleblowers and the Law
-
Online
2.00 Credits
Honest people face real challenges when working in an unethical environment. Business owners may be at risk if team members feel as though policies and practices within the business violate rules, regulations, or laws. Some of those employees may contact authorities. Perhaps they work in an undercover capacity, exposing the business owner and other people that work with the business, or align with the business, to both government investigations and potentially criminal prosecutions. Participants will learn from a real story which led to criminal prosecution for Medicare Fraud. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Basic Individual Taxation Course
-
Online
2.00 Credits
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.
Create Measures in Power BI that Define Your Metrics
-
Online
4.00 Credits
Unlock the full potential of your data with our specialized course, "Create Measures in Power BI that Define Your Metrics". Designed for professionals who aspire to excel in the dynamic world of data analysis, this 4-hour intensive training delves deep into the advanced functionalities of Microsoft Power BI. You'll embark on a journey to master the art of Data Analysis Expressions (DAX), a powerful tool in the Power BI suite to create metrics. This course is meticulously crafted to transform you into a proficient user, capable of harnessing complex DAX calculations to bring your data to life. The course content is thoughtfully structured to ensure a comprehensive learning experience. Starting with the foundational elements of DAX, you'll rapidly progress to tackle advanced formulas and time-intelligent functions, essential for nuanced data analysis. The highlight of the course is the emphasis on the DAX calculation process, a crucial aspect for validating measures in Power BI. Additionally, the practical application of PivotTables for measure validation will equip you with the skills to confirm the accuracy and effectiveness of your data measures. These advanced techniques are not just theoretical concepts but are presented through engaging, real-world scenarios, enabling you to apply your learning immediately to your daily tasks. This course is an invaluable step towards mastering Power BI and making data-driven decisions with confidence. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Audit 304: Auditing Basic Investments - Common Risks
-
Online
2.00 Credits
Auditing Investments - Understanding Risks and Procedures for the Most Common Investments will provide an overview for evaluating the proper recognition, measurement and disclosure of the most common investments types. Many small- and mid-size entities hold less-complex investments, including mutual funds, 'plain vanilla' derivatives (such as interest rate swaps), and permanent life insurance policies. Note: This course is recommended as a part of a 16-hour audit skills curriculum for in-charge or supervisor auditors, while it is also appropriate for anyone who has responsibilities for auditing common investments. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.