CPE Catalog & Events

This course is an extension of the Power BI series of courses that specifically explores using OLAP formulas and advanced time intelligent functions. OLAP formulas provide the ability to create a calculation in a cell that is based upon the measure in the data model. This powerful tool provides the ability to create calculations in an Excel worksheet without using a PivotTable to perform the calculation. Gone are the days of creating a PivotTable, then using those values in the PivotTable for additional calculations.When using Power BI to build a data model that connects to data files, you may want to know the date of these files. This class teaches you how to create a measure based upon the refresh date of your data. In the class "Power BI - Use Advanced Calculations with DAX Formulas," you learned the basics of time intelligent functions, the ability to calculate measures based upon dates. In THIS course, we will take it to the next step and teach you how to perform many more date-based calculations.This session is presented using Excel 2019/Office 365. Regardless of the version you are using, most concepts covered in this course apply to all versions of Excel.

Before you can analyze data, you first must get the data. This course focuses on getting data into Excel using different data sources. Whether your data is text, comma delimited (CSV), reports, Excel, databases, web, applications and/or many others, Excel provides the ability to access that data. You will learn about tools that have been added to Excel that will make accessing that data even easier, such as data models and Power Query (Get and Transform). After this class, you will finally be able to get the data you need to perform data analysis.This session is presented using Excel 2019/Office 365. Regardless of the version you are using, most concepts covered in this course apply to all versions of Excel.

What good is data analysis if you can't share it? This course will focus on using Microsoft's cloud-based sharing/publishing platform, PowerBI.com. You will learn the interface as well as the benefits of using PowerBI.com. You will learn how to use PowerBI.com to leverage the work performed in Power Pivot or Power BI Desktop. Using PowerBI.com to create visuals is very similar to Power BI Desktop, so we will only review this feature. If you want detailed instructions on creating visualizations, please attend the Power BI Desktop course. This class can be taken with no Excel or Power BI Desktop knowledge, but some concepts will be a repeat from those classes and will serve as a knowledge reinforcement for experienced users. Many data analysts may create models in Power Pivot or Power BI Desktop, so we will spend time to learn how to share that data with PowerBI.com. This will ensure that everyone is looking at the same data, no matter the toolset. PowerBI.com adds the ability to create and share dashboards, so we will demonstrate how to create visualizations that can be turned into dashboards that allow users to customize their PowerBI.com with dashboards that are meaningful to them. This session is presented using Excel 2019/Office 365. Regardless of the version you are using, most concepts covered in this course apply to all versions of Excel.

This course focuses on using DAX (Data Analysis eXpressions) to create advanced calculations in Power Pivot data models. We will review what you learned in "Power BI - Go Beyond PivotTables with Power Pivot" and take your calculations to the next level using advanced DAX formulas. You will learn over 20 DAX functions that will allow you to perform calculations that were not possible with standard Excel. We will also review the use of a date or calendar table that allows us to perform date analysis that was never possible before. This will allow us to use the new time-intelligent functions to perform complex calculations on our data like: month-to-date, quarter-to-date, year-to-date, last year same period, last year-to-date, etc. You will also learn the DAX calculation process in order to proof and validate your calculations. We will be using Power Pivot to create our DAX calculations, however, the process is very similar in Power BI Desktop and the functions and formulas are identical. If you are using Power BI Desktop, you should be able to follow along and learn how to create advanced calculations. This session is presented using Excel 2019/Office 365. Regardless of the version you are using, most concepts covered in this course apply to all versions of Excel.

Power BI Desktop is a new stand-alone tool that adds visualization to your data. This course focus on learning the Power BI Desktop interface, connecting to data sources and creating the visualizations. We will demonstrate the creation of each of the various visualizations and the various options related to each. We will also show how the visualization can be connected together to provide fully-interactive reports with drill-down capabilities. This class does not require any Excel knowledge but understanding Power Pivot and Power Query can reduce your learning curve. This session is presented using Excel 2019/Office 365. Regardless of the version you are using, most concepts covered in this course apply to all versions of Excel.

Data can be messy! In other words, it is not always clean and neat. Data comes from various sources like text files, Excel spreadsheets, databases, report files, etc. This is how most data analysis projects fail - the inability to get the correct data. This class focuses on using Power Query (Get and Transform) to clean, shape and transform your messy data while still allowing you a one-click refresh. We will review various data issues including appending files, combining multiple files from a folder, adding custom columns, unpivoting data, creating a lookup table, and much more. This session is presented using Excel 2019. Regardless of the version you are using, most concepts covered in this course apply to all versions of Excel.

This video-based CPE course is included in the Not-for-Profit Certificate II Program. It can be purchased individually or as a part of the Not-for-Profit Certificate II - Financial Reporting track. Many not-for-profits (NFPs) engage in strategic partnerships or ventures with other organizations. Working together, organizations share their strengths and achieve economies of scale. Because these relationships can take many different forms, half the battle is identifying which relationships will require entities to present consolidated financial statements. The other half is applying the unique reporting standards to these transactions to successfully prepare a set of consolidated financial statements. This CPE course offers you detail-rich examples and case studies that will help you understand when and how to prepare consolidated financial statements. Included in the course resources are two flow charts that will assist in determining if consolidation is required, as well as various financial statement examples. Note: As of August 1, 2018, course content has been updated to reflect implementation of FASB Accounting Standards Updates (ASUs) effective for most not-for-profit entities for their next financial reporting period, including those related to financial statement presentation (ASU 2016-14) and revenue recognition (ASU 2014-09 and ASU 2018-08).

This course is part of the IFRS Certificate Program - a comprehensive, integrated curriculum that will give you the foundational training, knowledge, and practical guidance in international accounting standards necessary in today's global business environment. This self-study course addresses requirements of IAS 1, Presentation of Financial Statements, and IAS 10, Events After the Reporting Period, including the following: The objective, structure, and content of financial statements Overriding concepts such as fair presentation, consistency, materiality, going concern, accrual basis, and offsetting The statement of financial position, including line items The statement of profit or loss and other comprehensive income, including line items and classification The statement of changes in equity Notes and comparatives Adjusting and nonadjusting events after the reporting period and related disclosures This course includes interactive learning elements, video content, and real-life application through case studies. Note: Individual courses purchased within the last year can be applied toward the purchase of the IFRS Certificate Program. Find out more.

Description: Professional Skepticism - Creating a Mindset for Finding Fraud and Error is a critical skill for audit and other attest services. The public places a high value on assurance services provided by an external public accountant, as the CPA's involvement directly enhances the degree of confidence intended users can place on the financial statements to make economic decisions. A proper mindset, including professional skepticism, is a critical feature of a high-quality audit or other attest service. Professional skepticism is an essential attitude that enhances the ability to identify and respond to conditions that may indicate possible material misstatement, whether due to fraud or error. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event. Learning Objectives: After attending this presentation, you will be able to...Identify traits of a skeptical auditorRecall applying professional skepticism on any assurance serviceRecognize fraud, including examples of fraud indicatorsIdentify the auditor's responsibility for identifying and responding to fraud in a financial statement audit Program Content: The major topics covered in this course include:The importance of professional skepticism, especially when performing audit or other attest servicesSpecific fraud responsibilities in a financial statement auditThe varying levels of persuasiveness of evidence to support assurance conclusions or opinions Who should attend: Appropriate to use as a part of audit skills training for beginning auditors or as a refresher for experienced professionals on the critical role professional skepticism plays in audit and other assurance services. Developed By: Emergent Solutions Group LLC Instructor: Jennifer Louis CPE Credit: 2.00 Field of Study: Auditing (2.00) Prerequisites: None Advanced Preparation: None Format: QAS Self Study

This CPE course is included in the comprehensive Not-for-Profit Certificate I Program. It can also be purchased individually or as a part of the Not-for-Profit Accounting and Financial Reporting track. Some not-for-profit organizations (NFPs) provide benefits to their constituencies in the form of programmatic investments such as loans, equity interests, and guarantees. For the NFP investor, the principal benefits are the achievement and sustainability of the mission-related program. In this CPE course, you will learn about the core considerations for accounting and reporting of various types of programmatic investments. You will have an opportunity to work through some real-world scenarios. Note: As of August 1, 2018, course content has been updated to reflect implementation of FASB Accounting Standards Updates (ASUs) effective for most not-for-profit entities for their next financial reporting period, including those related to financial statement presentation (ASU 2016-14) and revenue recognition (ASU 2014-09 and ASU 2018-08).

Counter the erosion of trust Find ways to create a culture of trust and rebuild where it has eroded, because distrust is bad for business. Learn how to grow and maintain business relationships, which is crucial to realize your business's full potential. Recognize red flags regarding trust and reputation, and learn whether the culture of your organization is at risk, which could ultimately endanger its effective functioning. Dealing with trust in tumultuous times Discover questions to consider for future conversations about business changes to help strengthen trust in a crisis and tips on how to repair trust. Drive performance and success Learn about initiatives to build trust with specific stakeholders, which will help drive success. Using up-to-date research and examples, uncover how to build long-term value for your business. This course provides 1.5 hours of CPE credit in the Business, Management and Organization field of study.

Save when you buy the complete Tax Staff Essentials, Level 3 online bundle. Develop your knowledge of real estate taxation Develop your knowledge of real estate taxation. Learn more about real estate, such as passive activity limitations, like-kind exchanges, involuntary conversions, and Section 1237. With this knowledge, you can avoid mistakes related to these provisions and ensure that your clients receive the most current tax planning and saving strategies for their tax plans.

A comprehensive learning approach. Frauds in governments are as unique as government entities themselves. In this self-study course, you will learn about real-world government fraud, including cyber fraud, and your responsibilities when dealing with government. Analyzing several unique frauds that occurred in the sector, this course offers a comprehensive learning approach using examples, explanations of audit standards, and informative case studies.

Recognize red flags. Due to the nature of NFPs, fraud may be more common than it seems. Learn how to recognize red flags of fraud, including cyber fraud. This self-study course offers a comprehensive learning approach using real-world examples, explanations of audit standards, and informative case studies that analyze several unique frauds which occurred in the NFP industry.

At its height, LIBOR was the benchmark for over US $350 trillion in financial contracts worldwide. Yet, due to concerns over the manipulation of the rate, standard setters determined that LIBOR should be discontinued. The global response to reference rate reform required financial reporting standard setters to provide practical expedients and exceptions to current modification guidance. This course will provide an overview of the standards issued (including amendments) from both the FASB and GASB to address the transition away from LIBOR.

Short-term decision-making is vital in any business. This course introduces several techniques used for short-term decision-making as well as relevant costs and revenues for decision-making. By identifying the optimal production plan when resources are limited, you can determine the most effective course of action that will drive company flexibility and success. Value added topics: Factors for short-term decision-making Relevant cost and revenue Product mix decisions Gain practical experience. The exercises use real-world examples and are designed to equip you with the skills you need to apply advanced costing strategies and acquire a deeper understanding of the decision-making process to assist financial reporting and control. This is a standalone course but if you're interested in more of this type of learning while earning a designation, explore the CGMAr Finance Leadership Program.

AICPA's Fundamentals of Forensic Accounting Certificate Program This course is part of the Fundamentals of Forensic Accounting Certificate Program - a comprehensive, integrated curriculum - covering AICPA's entire Body of Knowledge in this topic area. The program will provide you with the training, knowledge, and practical guidance needed for a solid understanding of financial forensics. Credit for individual courses purchased can be applied to the full program when you enroll within one year of the original purchase date. Please visit cpa2biz.com/forensic for information on the complete program. This course will help you to better understand the reporting requirements and professional standards that you will need to know in order to create an effective, accurate, and sustainable report. Discounts FVS Section Members Save an Additional 20%! When you log into this website with your AICPA member user account, the section discount will be automatically applied during checkout. Please contact the AICPA Service Center at 888-777-7077 or service@aicpa.org if you have any questions or encounter any issues.

This CPE course is included in the 15-hour Preparation, Compilation, and Review Staff Essentials program. It can also be purchased as a part of the Review Engagements Series. This innovative CPE course has been designed to provide a convenient, accessible way for firms to train their staff in this area of practice. With the introduction of the SSARS No. 21, Statement on Standards for Accounting and Review Services: Clarification and Recodification, this area of practice will be experiencing a level of change not seen in over 30 years. This CPE course provides fundamental training on the requirements associated with reporting on compilation engagements performed in accordance with SSARSs. This enhanced learning program contains a customized "learning coach" to create a flexible, engaging learning experience. This CPE course has also been updated to reflect the most recent changes resulting from the issuance of SSARS No. 22 and SSARS No. 23, to help practitioners comply with the latest developments in regulation.

This CPE course is included in the 15-hour Preparation, Compilation, and Review Staff Essentials program. It can also be purchased as a part of the Review Engagements Series. This innovative CPE course has been designed to provide a convenient, accessible way for firms to train their staff in this area of practice. With the introduction of the SSARS No. 21, Statement on Standards for Accounting and Review Services: Clarification and Recodification, this area of practice will be experiencing a level of change not seen in over 30 years. This CPE course provides fundamental training on the requirements associated with reporting on review engagements performed in accordance with SSARSs. This enhanced learning program contains a customized "learning coach" to create a flexible, engaging learning experience. This CPE course has also been updated to reflect the most recent changes resulting from the issuance of SSARS No. 22 and SSARS No. 23, to help practitioners comply with the latest developments in regulation.

About the Personal Financial Planning Certificate Program The SECURE Act is the first major legislation to revamp retirement plans in over a decade. The provisions and planning strategies to help your clients avoid unintended tax consequences on their estate and retirement plans have been implemented into this learning program. The Personal Financial Planning Certificate Program is a series of certificates covering the core areas of personal financial planning (PFP), including retirement, estate, risk management and insurance, and investment planning, and how tax planning relates to each area. This certificate program is a combination of education and a certificate exam that gives you the opportunity to enhance your knowledge and demonstrate competence in that specific discipline. Bundle exam + education and save! This PFP certificate program offers three different options: Certificate: You can display your competence and understanding in one or more core areas with a digital badge awarded upon completion of each certificate exam, an online proctored exam taken from the convenience of your home or office. This certificate offers optional online education to provide a thorough comprehension of the material in preparation for the exam. Education: If CPE is your goal, you can purchase the education, without the certificate exam, and simply earn CPE credit for your CPA license, PFS credential, and/or CFPr credential. If you hold the PFS credential, there is no need to take the certificate exam because your PFS credential exam tests this material. Credential: If you are an active CPA who wants to obtain the PFS credential, the certificate program provides an alternative pathway for meeting the exam and education requirements. See aicpa.org/pfs for details. The Retirement Planning Certificate Program The Retirement Planning Certificate Program is an informative and engaging learning experience that will enhance your knowledge in retirement planning. Part of the Personal Financial Planning Certificate Program, this certificate program includes six dynamic courses covering critical steps in the retirement planning life cycle, including unique planning for aging and chronically ill clients. This certificate includes the following courses: The Retirement Planning Process Governmental and Employer Retirement Plans Personal Retirement Investments, Income, and Expenses Analyzing Client Retirement Data Creating, Implementing, and Monitoring the Retirement Plan Elder and Special Needs Planning CPA, PFS, and CFP Continuing Education These courses meet the CPE requirements for the CPA license and PFS credential. In addition, it qualifies for CFP board CE credits. The AICPA will report CE credits to the CFP Board every two weeks on a rolling basis as courses are completed. To have your CE reported please complete the following steps as there is not an automated feed to the CFP Board: Send an email to CFPReporting@aicpa-cima.com with the following information: Name, CFP Number, Copy of Certificate of completion and number of CE hours requested to be reported.