CPE Catalog & Events

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

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 - Governance and Assurance track. Not-for-profits (NFPs) are in the public eye and often held to a higher standard than for-profit businesses. Unfortunately, NFPs are not immune to ethical scandals and failures, which often play out in the media with attention from legislators and regulators. This CPE course offers you detail-rich examples and interpretations that will help you apply proven techniques to address ethical challenges and create governance practices to create a culture of ethical management. 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). Many states do not accept the AICPA course to meet the Ethics requirement for earning or maintaining a CPA license. Please contact your state board to determine which Ethics course is required

What can you do to enhance your commitment to the highest ethical standards of the profession? How will doing so bring you more business? In this unique and engaging ethics course, the instructor, Dr. Bruce Weinstein, The Ethics Guy (R), reveals ten crucial qualities of CPAs. They are: 1. Honesty 2. Accountability 3. Care 4. Courage 5. Fairness 6. Gratitude 7. Humility 8. Loyalty 9. Patience 10. Presence (focus or mindfulness) You're already a good CPA and a good person. This course will show you how to be even better. The result will be greater satisfaction in your professional relationships, a deeper commitment to the profession of accounting, and much more business. Please note that this is a stand-alone course for 2 CPE credits in Behavioral Ethics, but you'll maximize your ROI by also taking "Ethics: How to Build and Keep Your A-Team". Together these courses are two of the surest pathways to sustained success in accounting.

You may want to be on the nightly news, but not for an egregious breach of ethics. You may be saying, "that will never happen to me."; And those were the words spoken by Wells Fargo, United Airlines, Senator Al Franken, and Steve Wynn. Sadly, a claim of an ethical failure stays in the news for almost 5 years. Long enough to damage your reputation and lower your profitability. An ethical climate needs constant care and feeding to be maintained. In this lively and thought provoking session, we will discuss why ethics is both complicated and difficult, how to prevent employees (and you) from taking the first step down a slippery slope, and walk through a six-step process for creating an ethical culture.

The title of this webinar is NOT a joke. If you consistently apply the five principles of ethical intelligence that Forbes Contributor Bruce Weinstein, The Ethics Guy, presents, your business will prosper, you will take better care of yourself and lose that weight, and either find or keep the love of your life. However, you are the one that will have to do the work, day in and day out. All Bruce can do is show you the way. If you are willing to commit (or renew your commitment) to leading your business and your personal life with ethical intelligence, this is the perfect webinar for you. The work you put in during and after the webinar will help to make you a better CPA and a better person.

Can you afford to hire a single dishonest person? Of course not. But what are you doing to ensure that you hire and promote only honest, accountable people? One of the most common complaints in business is, "I can't find and keep good people on my team." This distinctive, results-focused webinar will show you the four things you must do to hire and retain the very best employees at every level of your organization. This one-hour presentation in behavioral ethics disguised as one of the most practical, revenue-building webinars you'll take this year.

The walking dead aren't the only threat to your business. So are several dangerous, even terrifying myths about what ethical leadership is and is not. This fun and distinctive webinar will present what Forbes contributor Bruce Weinstein, The Ethics Guy, calls "zombie ethics"-myths about accounting that hinder your ability to serve your clients and enjoy a thriving business. Taking a page from Nobel laureate Paul Krugman's recent work, zombie ethics are ideas about ethical leadership that deserve to remain buried but keep resurfacing from time to time. They walk the earth and wreak havoc. In this engaging webinar, The Ethics Guy will show you how to send them back to the cemetery for good. You can then fearlessly bring in new business--and watch your practice soar!

How did the world's superstars build such powerful businesses? What lessons from the biggest musicians, movie stars, athletes, and innovators will help you become more successful? We'll explore how the principles of ethics and the traits of high-character leaders have made your favorite celebrities who they are and how you can follow in their footsteps. This webinar is based on presenter Bruce Weinstein, The Ethics Guy's popular Forbes.com columns, "Lead Like..." It's an ethics presentation disguised as a fun, engaging, and entertaining journey into what makes superstars so influential and how they are able to sustain their stellar success.

"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."

While ethics training is required by many professions, the true value of the CPA license is in understanding how critically important ethical conduct is to one another and the public. This course will focus on tax-specific ethics issues, with a special focus on recent tax cases, as well as a CPA's responsibilities as defined in the AICPA Code of Professional Conduct and IRS Circular 230.

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.