CPE Catalog & Events

This CPE course can be purchased individually, or as a part of the Fundamentals of Personal Financial Planning program. Lay the foundation for providing financial planning services that serve the best interests of your clients. By understanding the essentials of personal financial planning, you will have taken the first step in developing a comprehensive and practical financial plan for your clients. Understand the core concepts behind providing personal financial planning services for clients by learning, through real-life scenarios and practical guidance, about the following areas: The personal financial planning process, including not only the steps in the process (both required and optional) but, also behavioral and psychological methods of building client rapport, gathering ata, and life planning. Statement on Standards in Personal Financial Planning Services No. 1, which establishes a framework for delivering personal financial planning services with the highest levels of integrity, professionalism, objectivity, and competence. Personal financial planning concepts and responsibilities, including assumptions, personal statement of financial position, the spending plan, financial ratios, maintaining an emergency fund, and financing strategies.

Save when you buy the complete Tax Staff Essentials, Level 3 online bundle. Have a strategy in place for taxes in estate planning Learn how best to manage: Tax obligations of trusts and estates, and how these obligations affect beneficiaries The federal income taxation of trusts and decedents' estates, along with the effects certain tax scenarios have on beneficiaries Planning options that can minimize your clients' taxes during income accumulation, and the distribution or transfer of wealth to intended beneficiaries Learning Objectives Learn about the various types of trusts. Advise clients on filing requirements for Form 706 and Form 709. Identify the elements of an estate. Identify the elements of a grantor trust. Minimize transfer taxes by incorporating exemptions and credits. Understand statutory provisions that mandate or protect the interests of a decedent's spouse and children.

About the Personal Financial Planning Certificate 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 CFP 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 Estate Planning Certificate Program Part of the Personal Financial Planning Certificate Program, the Estate Planning Certificate Program is an informative and engaging learning experience that will enhance your knowledge of estate planning. Updated for the Tax Cuts and Jobs Act (TCJA) of 2017, this program includes eight courses covering steps in the estate planning life cycle, including gifting strategies, charitable planning, and integrating your clients' estate plans with their tax and financial plans. And, if you are seeking a thorough understanding of estate planning as outlined in the AICPA Personal Financial Planning (PFP) Body of Knowledge, this program is for you! This certificate includes the following courses: The Estate Planning Process Trusts and Estate Planning Documents Basic Estate and Gifting Strategies Advanced Estate Planning Strategies Closely Held Business Estate Planning Incapacity and Postmortem Estate Planning Integrating Estate Planning With the Tax and Financial Plan Charitable Planning Enhanced On-Demand Format This enhanced on-demand format offers meaningful and relevant content in the form of tables, charts, and discussion points on slides. An instructor who is an expert on the topical area breaks down complex topics, offers best practices, provides clarity, and shares insights that help the learner achieve the learning objectives for the course.

This CPE course can be purchased individually, or as a part of the Fundamentals of Fundamentals of Personal Financial Planning program. Understand estate and charitable planning as part of developing a comprehensive and practical financial plan for your clients. By learning the essentials of both estate planning and charitable planning, you can help your clients create such plans and understand all of the necessary considerations therein. Learn first the historical context of estate taxation in the United States, so that you can understand how the current environment has evolved. Then, through real-life scenarios and practical guidance, explore the following topics: The fundamentals of estate planning, including probate and typical deductions and exclusions Estate planning documents, including wills, revocable trusts, power ofattorney, living wills, and advanced health care directives Estate tax calculation, starting with the gross estate and covering deductions and adjustments The flow of funds in estates, including general power in an irrevocable trust; Crummey powers; health, education, maintenance, and support standards; and 5 or 5 power Learn how charitable planning is an integral part of estate planning as well as a major consideration in tax planning by exploring the following topics: IRC Section 501(c)(3) organizations and tax deductible contributions Charitable gifts, including cash, real estate, personal property, ordinary income property, and life insurance Charitable trusts, including split-interest trusts, lead trusts, remainder trusts, private foundations, and donor-advised funds Taxation and income tax planning, including the application of limitations, ordering rules, carryover rules, and qualified charitable distributions

" It is essential for CPAs to have an understanding of the ethical problems and principles that impact their daily interactions with clients, employers, and regulatory authorities. This course reviews the frameworks provided in the Florida Statutes, the Rules of the Florida Board of Accountancy, and the AICPA Code of Professional Conduct that determine the expectations for your behavior as a Florida CPA. Through an interactive and engaging dialogue, we will focus on the application of specific rules and requirements within that framework and recent trends in business and professional ethics. The course fulfills the biennial ethics requirement for Florida CPAs. This course is QAS self-study and must be completed by one year of purchase. This course is included in the 24/7 Learning Library."

Description: You are likely familiar with and/or have experience with IRS summonses. BUT - Did you know there's a lot of procedure and decorum that goes into issuing a summons that you can leverage to help your client? This program will focus on the basics of an administrative summons, what the IRS can summons for, how you should comply with a summons, summons referral criteria, and common errors and misnomers the IRS can make in generating/serving a summons. 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...Distinguish IRS authority to summons.Identify practical approaches to complying with an IRS summons.Recognize IRS summons procedure.Recall the steps involved when the IRS decides to make a summons referral.Recognize how to elevate summons disputes. Program Content: The major topics that will be covered in this course include:The ingredients that make up an IRS summons.The IRS' legal authority to summons.How to comply with a summons.Whether to appear in response with your client or not.Common errors the IRS can make that will invalidate a summons.Following DOJ summons referral process; all based on an actual case. Who should attend: EA's, CPA's, attorneys, and anyone Interested in learning more about IRS representation and tax problem solving. Developed By: Billy Fauller Instructor: Billy Fauller CPE Credit: 1.00 Field of Study: Taxes (1.00) Prerequisites: None Advanced Preparation: None Format: QAS Self Study

This CPE course can be purchased individually or as part of the Core Forensic Accounting Certificate. Factual evidence is the bedrock of a forensic accountant's case. Gaining this evidence efficiently and properly is important to the forensic engagement. Through narration by an industry subject matter expert and application exercises, this CPE course describes topics such as types of evidence, the process to find the evidence, reviewing and analyzing documents, as well as finding and verifying electronic evidence.

Adapt and evolve. The business ecosystem will adapt and evolve in response to changes in the wider environment. As the business environment has become more competitive, dynamic, and complex, the focus has shifted to not only identifying customers' needs and wants, but also to creating customer wants where they did not exist before. In this course, you will learn how evolving can change the business ecosystem and how to analyse customers to support your organisation's strategy. Gain experience with detailed exercises. Using case studies, real-life scenarios, and exercises, this course will give you the necessary tools to identify drivers for change in the business ecosystem and how to analyse your customer base to boost your overall success. 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. Key topics Ecosystems and strategy formulation The business ecosystem Understanding customers

The importance of Defined Names and Excel Tables is detailed in our course "Excel - Two Must Know Features: Defined Names & Tables." Once you understand these two features, how can you use them to build advanced spreadsheets?This course is designed to demonstrate how you can use these features to build better spreadsheets that are easier to read, easier to update and more accurate. Learn about the INDIRECT function and how to use it with Defined Names to build a summary table. You will also learn the importance of Consistent Column Calculations and how tables can help. We will demonstrate the use of Structured Table References, as this is the foundation for using the advanced data analytics.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.

In this course, we will focus on Financial, Statistical and Math functions. In the Financial functions section, you will learn how to use the financial functions to build better amortization schedules. In the Statistical and Math functions sections, you will learn how to use various statistical functions to analyze your data. Depending on your version, Excel has over 500 functions already built in and ready to use. How many of those do you incorporate into your spreadsheets? You will learn some powerful functions that will take your calculating power to the next level. 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.

In the "Excel - Formatting Spreadsheets for Beginners" class, you learned basic formatting of a spreadsheet. In this class, we take you to the next level by teaching you how to customize many of the formatting options.Learn to customize cell styles and how to use these styles in other workbooks. Most Excel users know how to select number formats but this class shows how to leverage the Custom Number Formatting option to create special formatting options.Many of the formatting options are applied manually, cell-by-cell or by range. This can be tedious if there is a condition by which you want to apply a format. You will learn to use Conditional Formatting to format based upon a criteria.Have you ever finalized a spreadsheet, only to accidently make changes over the top? This action is something that is very easy to do. This class demonstrates various options to prevent this from happening and will look at various security options within Excel.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.

In this course, we will focus on debugging and troubleshooting complex formulas. You will learn various techniques that will assist you in creating complex compound formulas. You will also learn methods to resolve issues when you receive errors. Do you dread that annoying ERROR! message popping up on your spreadsheets? Tired of using the same long, elaborate formulas when you could be using Excel's built-in formulas? Then this class is for you!This session will also discuss Excel's nine built-in error-checking options and then demonstrate different approaches to error resolution. We will also review techniques to resolve rounding errors.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.

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 course, 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.

In this course, we will focus on the Logical, Information and Lookup and Reference functions. In the Logical function section, you will learn to perform logical tests using the IF function along with AND, OR and NOT. In the Information function section, you will learn various ERROR checking functions that can be combined with the Logical functions. In the Lookup and Reference section, you will learn to use the various LOOKUP functions and the INDIRECT function. Excel has over 500 functions that are built in and ready to use. You just have to figure out which one to use and when. Integrating functions into each and every one of your spreadsheets not only improves efficiency, it also makes your task easier to execute. 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.

In this course, you will learn how to build robust dashboards for analyzing key metrics in Excel. We will begin with some dashboard design guidelines, such as understanding your audience and identifying necessary metrics. Then we will work through importing data, setting up calculated fields and columns, and creating key performance indicators (KPIs) for the dashboards.Most business professionals use Excel to help them make decisions about their data. However, as the amount of data grows, it becomes more difficult to make strategic decisions based on rows and rows and columns and columns of data. You will learn how to add charts and eye-catching visuals with Power View, which will make your dashboards easily understood.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.

Over the years, Excel has added MANY new features and functionality, yet most people still use it the same way they first learned it. Many of the features were added to Excel to enhance your ability to create spreadsheets more efficiently and with more accurately. However, if you aren't aware of these new features, how can you use them? This class will focus on walking through each ribbon (menu) to explain the capability of various features in Excel. It is a great overview for both new and advanced Excel users to make sure you know all the capabilities of Excel. You may have seen many of the features but had no idea what they could do for you. This class will help you to understand these features and determine how you might take advantage of their capabilities. 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.

Formatting Excel spreadsheets to look their best can be a tedious task. From deciding which fonts to use to cell formatting to multiple sheets to printing to distribution, these factors can take considerable valuable time. This class is designed to help you efficiently format spreadsheets, so you can spend time on more profitable tasks like analyzing data.Learn to format multiple sheets at the same time as well as use Cell Styles to quickly format cells and ranges. Learn how to create and use templates that are pre-formatted. We will also review print options.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.

Have you ever opened a blank workbook in Excel and just stared at it, wondering where to begin? Or, do you spend most of your time just formatting cells to make your spreadsheet look pretty? Or, do you just wonder if there is a better way to creating your spreadsheets? This course is designed to take you from a blank worksheet to a completed report. Our example will be a financial statement but you can use the knowledge gained in the course and apply it to your specific job function. You will learn to import data instead of manually entering it. Learn that you can use functions and formulas to build calculations that will eliminate the need to manually manipulate your data. Our goal is to make sure you have all the information needed to build reports without having to manually enter it every month. You will learn techniques to use your data to build your reports. This will include building formulas that are flexible with your changing data. You will learn techniques to validate your report calculations so you can improve the accuracy of your reports. You will also learn how to quickly format reports and techniques that allow you to efficiently change the format. Lastly, you will learn how PivotTables can provide a more dynamic reporting option instead of using pre-defined report formats. Obviously, we will be covering a lot of ground, so to enhance your learning experience all examples will be provided to each participant along with instructions. This will allow you to follow along and use as you apply your new knowledge to your spreadsheets. 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.

Are you aware there are 470+ formula functions in Excel? Do you realize that they add new functions in every major version of Excel? Did you know that Microsoft adds new functions throughout the year in the Office 365 version of Excel? Are you stuck using old or simple functions like SUM or ROUND? Do you want to expand your knowledge of the extensive function library in Excel? If these questions perk your interest in becoming an Excel function expert, this course is right up your alley. This past-paced course digs into some of the most powerful functions in Excel. Although, we cannot cover 470 functions, we will look at over 20 functions that will allow you to create advanced calculations in your spreadsheets. Functions like: VLOOKUP, IF, IFS, FORECAST, RAND, SWITCH, TEXTJOIN, UNIQUE, SUBTOTAL, IS, TEXT and more! We will also provide examples files that will include all the functions used during the class. It's time to take your Excel spreadsheets to the next level. 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.

Are you self-taught on Excel?Have you ever wondered if you really know how to use Excel?Do you want to build a great foundation for using Excel?Are you new to using Excel?If you answered YES to any of these questions, this is for you.This course is designed to start with the basics of using Excel from the interface to the structure to data entry to formula basics. Whether you're a beginner or an intermediate user, you will gain valuable foundational knowledge for using Excel.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.