CPE + Events Catalog

Your clients depend on you more than ever to help them reduce risk and position themselves for financial success in the future. This course will help keep you on top of recent developments in elder care, including cautionary tales for adult caregivers and caretakers of parents & spouses.

This course delves into the psychological phenomenon where individuals doubt their abilities and fear being exposed as frauds despite evidence of their competence. Through insightful modules, you'll gain insights into the origins, manifestations and impact of Imposter Syndrome. Using practical strategies and tools, you'll learn to navigate and overcome these self-limiting beliefs, fostering confidence and resilience in both personal and professional spheres. Join us on this empowering expedition to unravel the complexities of Imposter Syndrome and emerge with the skills to conquer self-doubt. Whether you're a student, professional or entrepreneur, this transformative course has been meticulously designed to empower you to conquer Imposter Syndrome and embrace the true magnitude of your worth. Refuse to let Imposter Syndrome hinder your journey any longer. Embrace this opportunity to step into your authentic self and forge a path toward unparalleled growth.

This session will focus on audit documentation, providing an overview of general documentation standards, as well as discussion of many specific elements of the audit process. Topics to be covered will include independence, planning, risk assessment, internal controls, fraud inquires, related parties & parties-in-interest, subsequent events, risks & uncertainties, and more!

New auditing standards may require changes in your firm's audit methodology, especially in performing EBP audit risk assessments. Look at recent auditing standards (SAS No. 142-145) that may impact the 4 ERISA employee benefit plan audit season. Make sure you're up to date with new auditing and accounting guidance so your audits are conducted in accordance with professional standards and carried out efficiently and effectively. Find out when additional documentation is required and get tips to reduce the risk of deficient audits. Come away with valuable insights and a broader perspective on how others are implementing the new standards.

This session will explore the most common compliance errors impacting retirement benefit plans, including the impact of recent legislation. Gain valuable insights to enhance your auditing practices and ensure compliance. In this session, you will learn about the top compliance errors impacting retirement benefit plans, the available correction options, and the potential impact of recent legislation.

"Just the facts ma'am; just the estate planning facts." Designed to give a quick overview of estate planning essentials, this course surveys wills, living trusts, gifts, marital property, and probate avoidance with an Internet flair. Will and trust types are examined in the context of general estate and gift taxation. Designed to eliminate estate problems and death taxes, the emphasis is on practical solutions that are cost effective. Talk about having it all in an overview course - there is even a quick review of immediate postmortem death tax planning and filling out the Form 706.

An innovative and interactive session that taps the areas of neuroscience, psychology and biology to understand how science, emotion and ethical decision-making interact. Instead of critiquing how our minds are supposed to work, this session delves into the fascinating world of how our minds work when we face complex problems where a `best choice" doesn't seem to exist. The talk will also explore why ethical codes have often failed and how to improve individual and organizational ethical reasoning.

What do you do when a setting, shortcut or command isn't available in Excel? Well, you create a macro, of course. Macros allow Excel users to extend the capabilities of Excel and create shortcuts and commands. In this session, you will use the recorder to create a macro that applies a built-in format setting. You will then write a macro in the visual basic editor to provide a shortcut to a popular Excel function. The course will also cover how to add macros to the Quick Access Toolbar so you can easily execute them in the future. Presented in Excel for Windows. Note: Items presented may not be available in all Excel versions, including Excel for Mac, iPad or web. The webcast was originally broadcast on May 3, 2016. Note: There is a minimum passing rate of 70% for this course.

This session continues the discussion about external data and digs into the details for retrieving data from other sources. Pull data from an Access database using Microsoft Query; learn how to retrieve data from simple text files; and prepare data for use with Excel. This session concludes by examining several data visualization tools in Excel, including PivotCharts. This is part 10 of a 10-part series: Module 1: Fundamental Features Module 2: Fundamental Functions, Concepts, Techniques Module 3: Six Critical Excel Functions Module 4: Handling Errors and Comparing Lists Module 5: Date and Text Functions Module 6: Time-Saving Techniques Module 7: Introduction to PivotTables Module 8: PivotTable vs. Formula-Based Reports Module 9: PivotTable Wrap-Up and Web Data Module 10: Getting, Preparing and Summarizing Data

The Excel Power User series is designed to help improve your Excel proficiency and enable you to get your Excel tasks done more quickly. In the first session, we'll cover the fundamental features that help build a solid foundation. We'll continue to integrate these features as we proceed throughout the series. This is part 1 of a 10-part series: Module 1: Fundamental Features Module 2: Fundamental Functions, Concepts, Techniques Module 3: Six Critical Excel Functions Module 4: Handling Errors and Comparing Lists Module 5: Date and Text Functions Module 6: Time-Saving Techniques Module 7: Introduction to PivotTables Module 8: PivotTable vs. Formula-Based Reports Module 9: PivotTable Wrap-Up and Web Data Module 10: Getting, Preparing and Summarizing Data

Cover fundamental functions, concepts and techniques that provide a firm foundation for our workbooks. Continue to integrate these items as we proceed throughout the series. This is part 2 of a 10-part series: Module 1: Fundamental Features Module 2: Fundamental Functions, Concepts, Techniques Module 3: Six Critical Excel Functions Module 4: Handling Errors and Comparing Lists Module 5: Date and Text Functions Module 6: Time-Saving Techniques Module 7: Introduction to PivotTables Module 8: PivotTable vs. Formula-Based Reports Module 9: PivotTable Wrap-Up and Web Data Module 10: Getting, Preparing and Summarizing Data

Explore six important Excel functions that enable us to automate a variety of tasks, as well as continue to integrate these functions as we proceed throughout the series. This is part 3 of a 10-part series: Module 1: Fundamental Features Module 2: Fundamental Functions, Concepts, Techniques Module 3: Six Critical Excel Functions Module 4: Handling Errors and Comparing Lists Module 5: Date and Text Functions Module 6: Time-Saving Techniques Module 7: Introduction to PivotTables Module 8: PivotTable vs. Formula-Based Reports Module 9: PivotTable Wrap-Up and Web Data Module 10: Getting, Preparing and Summarizing Data

Examine functions that help us trap and handle errors and discuss efficient methods to perform list comparisons. Continue to integrate these features as we proceed throughout the series. This is part 4 of a 10-part series: Module 1: Fundamental Features Module 2: Fundamental Functions, Concepts, Techniques Module 3: Six Critical Excel Functions Module 4: Handling Errors and Comparing Lists Module 5: Date and Text Functions Module 6: Time-Saving Techniques Module 7: Introduction to PivotTables Module 8: PivotTable vs. Formula-Based Reports Module 9: PivotTable Wrap-Up and Web Data Module 10: Getting, Preparing and Summarizing Data

Apply numerous features and functions examined in previous sessions in a variety of time-savings techniques. Continue to integrate these features as we proceed throughout the series. This is part 6 of a 10-part series Module 1: Fundamental Features Module 2: Fundamental Functions, Concepts, Techniques Module 3: Six Critical Excel Functions Module 4: Handling Errors and Comparing Lists Module 5: Date and Text Functions Module 6: Time-Saving Techniques Module 7: Introduction to PivotTables Module 8: PivotTable vs. Formula-Based Reports Module 9: PivotTable Wrap-Up and Web Data Module 10: Getting, Preparing and Summarizing Data

This session introduces the PivotTable feature and covers the basics. Learn the four report layout areas, rows, columns, values and filters. Then you will learn how to update PivotTable reports and ensure that any new transactions appended to the data source are included in the report. You will explore how to create monthly columns and how to properly format the values in a PivotTable. This is part 7 of a 10-part series: Module 1: Fundamental Features Module 2: Fundamental Functions, Concepts, Techniques Module 3: Six Critical Excel Functions Module 4: Handling Errors and Comparing Lists Module 5: Date and Text Functions Module 6: Time-Saving Techniques Module 7: Introduction to PivotTables Module 8: PivotTable vs. Formula-Based Reports Module 9: PivotTable Wrap-Up and Web Data Module 10: Getting, Preparing and Summarizing Data

This session begins by comparing the formula-based reports we built previously to PivotTables. Dig into the details between these two report types so you are comfortable with applying them to specific workbooks. Create two versions of many reports, one version with formulas and the other with PivotTables so you become comfortable replacing formula-based reports with PivotTables when appropriate. This is part 8 of a 10-part series: Module 1: Fundamental Features Module 2: Fundamental Functions, Concepts, Techniques Module 3: Six Critical Excel Functions Module 4: Handling Errors and Comparing Lists Module 5: Date and Text Functions Module 6: Time-Saving Techniques Module 7: Introduction to PivotTables Module 8: PivotTable vs. Formula-Based Reports Module 9: PivotTable Wrap-Up and Web Data Module 10: Getting, Preparing and Summarizing Data

This session concludes the PivotTable discussion by examining various ways to present report values; discussing the subtly of properly sorting a recurring-use PivotTable; and covering numerous filtering options, including slicers. Next you'll explore the look-up function designed specifically to retrieve values from PivotTables. The session concludes by transitioning to data acquisition techniques, and you'll retrieve data from perhaps the largest external data source of all-the Internet. This is part 9 of a 10-part series Module 1: Fundamental Features Module 2: Fundamental Functions, Concepts, Techniques Module 3: Six Critical Excel Functions Module 4: Handling Errors and Comparing Lists Module 5: Date and Text Functions Module 6: Time-Saving Techniques Module 7: Introduction to PivotTables Module 8: PivotTable vs. Formula-Based Reports Module 9: PivotTable Wrap-Up and Web Data Module 10: Getting, Preparing and Summarizing Data

Explore functions that operate on-and return-date values and text strings. You'll continue to integrate these features as we proceed throughout the series. This is part 5 of a 10-part series: Module 1: Fundamental Features Module 2: Fundamental Functions, Concepts, Techniques Module 3: Six Critical Excel Functions Module 4: Handling Errors and Comparing Lists Module 5: Date and Text Functions Module 6: Time-Saving Techniques Module 7: Introduction to PivotTables Module 8: PivotTable vs. Formula-Based Reports Module 9: PivotTable Wrap-Up and Web Data Module 10: Getting, Preparing and Summarizing Data

This session will discuss the key areas that the family law practitioner and forensic accountant should be aware of when dealing with the apportionment of property. While the primary focus will be a discussion related to key areas to understand when dealing with the apportionment of real estate, the session will also discuss various other areas of property apportionment that the family law practitioner and forensic accountant should be aware of. This conference is tailored to equip CPAs and attorneys with the expertise to navigate family law cases effectively. Focused on the critical role of CPAs in managing intricate financial matters during divorce, child support, and asset division. This session was recorded at the 4 Family Law Virtual Conference on October 17, 4.

This 75-minute session will provide an in-depth analysis of pivotal court decisions and their practical implications, ensuring you are well-equipped with the knowledge needed to make informed decisions in your practice. This conference is tailored to equip CPAs and attorneys with the expertise to navigate family law cases effectively. Focused on the critical role of CPAs in managing intricate financial matters during divorce, child support, and asset division. This session was recorded at the 4 Family Law Virtual Conference on October 17, 4.