CPE Catalog
Note
AICPA On-Demand & Self-Study courses take up to 24 hours to process.
Build a Data Model for Analysis in Power BI
-
Online
4.00 Credits
This intensive 4-hour course offers a deep dive into data modeling in Power BI, with a focus on Microsoft Excel's Power Pivot but applicable to Power BI Desktop. Designed for professionals looking to enhance their data analysis skills, the course covers the essential aspects of building robust, efficient data models. Participants will learn how to integrate different data sources, create meaningful relationships, and develop insightful metrics to drive business decisions. Participants will explore various aspects of data modeling such as establishing relationships, creating calculated columns, and understanding the intricacies of basic DAX (Data Analysis Expressions) measures. These skills are vital for anyone looking to extract meaningful insights from large and complex datasets. Attendees will be introduced to advanced concepts such as the strategic use of calculated columns versus measures, and the differentiation between explicit and implicit measures. This knowledge is crucial for developing sophisticated data models that not only provide accurate results but are also efficient in terms of performance. The course will also cover the creation and use of hierarchies and Key Performance Indicators (KPIs), essential for any robust data analysis framework. To ensure that the learning is well-rounded and applicable, the course includes practical exercises in using pivot tables within Power BI. This helps in validating and enhancing the measures and models created, ensuring they are robust and reliable for real-world application. "Build a Data Model for Analysis in Power BI" is an essential course for professionals aiming to leverage the full potential of Power BI 's data model. Whether you're looking to streamline your data analysis process, enhance your reporting capabilities, or drive insightful business decisions, this course will equip you with the necessary skills and knowledge. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Leverage PowerBI.com to Create Data Analysis for Others
-
Online
2.00 Credits
Unlock the full potential of data analytics with our specialized course, "Leverage PowerBI.com to Create Data Analysis for Others". This two-hour, intensive training is specifically designed to empower professionals in harnessing the powerful features of Microsoft PowerBI.com. Whether you're a data analyst, business intelligence professional, or someone keen on mastering data visualization and report creation, this course is your gateway to becoming a proficient Power BI user. Dive into the dynamic world of data analytics and learn to transform raw data into visually compelling stories that drive decision-making. Our expertly crafted program offers a deep dive into the essentials of PowerBI.com, starting with a comprehensive tour of its interface and core concepts. You'll gain experience in connecting to diverse data sources, creating stunning visualizations, and building interactive dashboards that communicate insights effectively. The course also covers the innovative Q&A feature of PowerBI.com, allowing you to explore data with natural language queries. By mastering the art of sharing datasets, reports, and dashboards, and creating comprehensive apps, you'll be equipped to deliver top-tier data analysis solutions to colleagues and clients alike. Through this course, attendees will gain a deep understanding of how to leverage the PowerBI.com platform to disseminate datasets, reports, and dashboards, catering to the specific needs of their audience. Our course is tailored for those who aspire to lead in the data-driven landscape, offering not just theoretical knowledge but real-world applications. Upon completion, participants will not only have a thorough understanding of PowerBI.com but also the confidence to apply this tool in creating impactful data analysis for diverse audiences. Join us to elevate your professional skillset, make data-driven decisions with ease, and add a valuable credential to your portfolio. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Forgotten Managerial Accounting Tools for CPAs
-
Online
2.00 Credits
This session revisits managerial accounting techniques that you may not have considered for many years, even though they could be invaluable for CPAs in both business and public accounting. You will appreciate a fresh perspective of concepts you may not have considered since your college days. We will illustrate concepts with practical examples that you can immediately bring back to the office! This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
PowerPoint for Accountants
-
Online
2.00 Credits
PowerPoint is a widely available resource that is potentially underutilized by accountants because many accountants do not stray beyond Excel and Word in the Microsoft Office suite. You will learn how to create and edit a professional PowerPoint slide deck. This session places particular emphasis on efficiency tips and tricks that will allow you to develop creative, professional visual aids while minimizing time and effort. The course's author will share personal insights he has cultivated throughout more than two decades of public speaking. Although the session will focus on creating and editing slides, we will illustrate best practices for presentation delivery. We also will explain how PowerPoint can be used for purposes other than delivering presentations. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Audit 104: Audit Documentation - Workpapers To Pass Review
-
Online
2.00 Credits
Audit Documentation - Creating Workpapers That Pass Review is an important foundational course. Proper documentation is essential to a high-quality audit and other assurance services, as auditors are required to prepare and maintain documentation to demonstrate that sufficient and appropriate audit evidence was obtained to support the auditor's opinion. It is critical for workpapers to provide a clear understanding of the nature, timing and extent of procedures applied, the results of those procedures, source of evidence obtained, and conclusions reached. Both audit effectiveness and efficiency are directly impacted by the nature and extent of audit documentation. Note: This course is a part of a recommended 16-hour audit skills curriculum for beginning staff. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Professional Skepticism
-
Online
2.00 Credits
To believe or disbelieve ... that is the question often faced by CPAs in public accounting and by accountants and financial professionals in business and industry. This workshop addresses the mindset of professional skepticism that is often required in a variety of settings. 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: Enhancing Ongoing Client Engagements
-
Online
2.00 Credits
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.
The Bookkeeper Goes to Prison
-
Online
2.00 Credits
This course profiles Brenda, a financial executive from the state of Washington. Despite earning her college degree, Brenda did not find employment in her area of study. Instead, she landed a series of dead-end jobs. Business reversals frequently led to the loss of employment. When a company that she knew to be unethical offered her an executive position that included bookkeeping tasks, including overseeing all finances, she accepted. While on the job, Brenda saw owners of the company misappropriating funds. Rather than reporting the fraud, she created an elaborate scheme to benefit herself - without the owner's knowledge. Her bad decisions led to a guilty plea for wire fraud, after authorities accused her of absconding with more than $600,000 in corporate funds. A prison term of 20 months followed. Listen and learn from Brenda's experience. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
IRS Highly Effective Penalty Relief Strategies
-
Online
1.00 Credits
You are likely familiar with the various forms of penalty relief (reasonable cause, administrative remedies, and first-time penalty relief), BUT can you apply this and consistently expect a favorable outcome? This program will focus on crafting a well-executed request for penalty relief, along with exploring a lesser-known option which can be employed as an effective case resolution tool. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Leveraging Marketing Automation for Accounting Firm Growth
-
Online
1.00 Credits
This course will provide an overview of 6 key areas of automation that accounting firms can leverage to effectively increase their lead generation and client retention efforts while reducing the burden on their time and budget. These areas include: 1. Social media 2. Content development. 3. Email marketing. 4. Text (SMS) marketing. 5. Chatbots and other interactive AI tools. 6. Drip marketing campaigns. Attendees will receive a practical guide to the technologies and tactics needed to improve marketing efforts with efficiency and ease! This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
You Don't Know What You Don't Know About Microsoft Excel
-
Online
8.00 Credits
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.
Becoming a Fraud Investigator
-
Online
2.00 Credits
The course helps the forensic accountant prepare to perform a fraud investigation. We discuss occupational fraud schemes and their characteristics, and how to spot a fraud in progress. You will learn the skills a fraud investigator needs for successful investigations, as well as how to plan and prepare for a fraud investigation. 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. Becoming a Fraud investigator is Part 1 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.
Ethics: Plain Talk About IRS Ethics and Conduct
-
Online
2.00 Credits
The course provides a concise overview of the most common conduct and ethical issues faced by IRS employees. This is based on an internal IRS directive entitled "Plain Talk About Ethics and Conduct". The document provides guidance to IRS staff at all levels on the agency's ethical standards. All IRS employees are subject to the Office of Government Ethics (OGE) Standards of Ethical Conduct. The OGE Standards, which are applicable to all executive branch employees, are uniform ethics regulations covering such topics as gifts between employees, conflicts of interest, appearances of a lack of impartiality, and outside employment. Participants will walk away with an increased situational awareness of the ethical requirements of IRS employees, and how practitioners can avert or prevent any potential ethical problems before they occur when communicating or interacting with IRS officials at any level. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Audit 105: The Audit Risk Model - Foundational Principles
-
Online
2.00 Credits
The Audit Risk Model - Understanding Foundational Principles is a critical foundational course. Financial statement auditors are engaged to provide reasonable assurance that financial statements are not materially misstated, whether due to fraud or error. Professional standards require auditors to obtain sufficient and appropriate evidence to support that opinion. It is critical for effective and efficient auditors to have a clear understanding of all the important elements and concepts related to properly identifying, evaluating, and deciding how to respond to risk in a financial statement audit. Note: This course is recommended as a part of a 16-hour audit skills curriculum for beginning auditors, while it is also appropriate for anyone who has the need to understand the foundational principles of the audit risk model. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Office 365 Teams App - Optimizing Your Setup & Configuration
-
Online
4.00 Credits
If you are familiar with the Office 365 Teams app, you know it is an extremely powerful tool to transform the way you communicate, collaborate and share knowledge. What you may not know is how to configure Teams to optimize your ROI and how effectively your team members use it. This course takes you on a tour of the important setup and configuration settings you need to be familiar with to ensure the best Teams experience for your organization. Whether you are already using Teams, in the process of deploying it, or are contemplating whether or not to bring it into your organization, this course will prove to be invaluable. The information shared in this course is sure to help you avoid costly mistakes in your Teams app deployment. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Cybersecurity 101 for CPAs
-
Online
2.00 Credits
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.
Engagement Management with the Microsoft 365 Planner App
-
Online
2.00 Credits
Are you using Excel to keep track of progress and task completion for your engagements? Or, are you using a sophisticated engagement management app that takes too much time or requires too much information to keep your task completion progress up to date? Worst of all, are you relying primarily on email communications to keep track of your engagement task completion progress? If any of these scenarios apply to your practice, this course will show you a better way to manage engagements from simple 1040 tax preparation to comprehensive audits. The Microsoft 365 Planner app, which you are likely already paying for as part of your Microsoft 365 subscription, provides a comprehensive, yet simple solution for all of your client engagements and internal projects. John Higgins, a nationally recognized strategic accounting technology advisor will guide you through the process of how to deploy this app to effectively manage all your projects. This app is effective for sole practitioners and firms of all sizes. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
The 10 Must Know Excel Features
-
Online
2.00 Credits
Transform your Excel skills with our comprehensive training program, designed for users at all levels seeking to master the full suite of Excel capabilities. From powerful data analysis tools like PivotTables and advanced functions such as XLOOKUP, to the nuances of Data Validations and Conditional Formatting, this course offers a deep dive into Excel's most impactful features. Whether you're streamlining complex data sets, enhancing your reporting skills, or just looking to boost your productivity, this session provides the insights and techniques you need to leverage Excel to its fullest potential, making it an indispensable tool in your professional or personal toolkit. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Audit 106: Internal Control Fundamentals - Evaluating Design
-
Online
2.00 Credits
Internal Control Fundamentals - Satisfying Audit Requirements for Evaluating Design and Implementation is a critical foundational course. Obtaining an understanding of the entity and its environment is part of assessing risk of material misstatement, in order to design the nature, timing and extent of further audit procedures necessary to obtain sufficient appropriate audit evidence to support the auditor's report. A critical component of understanding the entity and its environment is to evaluate the design and implementation of internal control over financial reporting. Note: This course is recommended as a part of a 16-hour audit skills curriculum for beginning auditors, while it is also appropriate for anyone who has responsibilities for evaluating the design and implementation of internal controls over financial reporting. 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.