CPE & Event Calendar

We all have 24 hours to work with each day-but only a minority truly know how to maximize the use of time. Join us and learn how to prioritize work, strategically leverage other people, know when to work on what, protect your time, manage access to you and how to say no. The webcast was originally broadcast on May 13, 2016. Note: There is a minimum passing rate of 70% for this course.

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.

The various ideas, methods, and techniques to optimize the overall compensation package for key employees and principals are examined in this mini-course. Generally, businesses may deduct employees' pay including wages, salaries, and other perks. Certain fringe benefits that can provide an unusually tax-favored manner of supplementing compensation are described and evaluated. In addition, equity participation is explored through stock sales, repurchase agreements, incentive stock options, ESOT's, stock options and bonuses. Finally, deferred compensation arrangements are investigated. The goal of this mini-course is to provide participants with a working knowledge of the types of compensation necessary to structure a compensation package minimizing tax liabilities and cost.

Before launching into an estate planning program, knowing who owns what and exactly for whom you plan is essential. This requires that methods of holding title must be analyzed, considered, and selected. Sole proprietorships, S corporations, C corporations, partnerships, and limited liability companies are analyzed for formation, operation, and ultimate disposition. Since who or what holds title imposes its own unique tax and legal consequences on the estate plan, emphasis is given to maximizing tax benefits in each business format. While each has its separate characteristics, several may be used together in more sophisticated planning.

While accounting and the practice of law are separate professions, the accountant must be conversant with essential legal concepts. Modern accounting practice requires familiarity with corporate legal structure, business entities, partnership operations, contracts, property rights, employment law, divorce, consumer protection, will & trusts, and even bankruptcy law. This course explores these specific areas with an emphasis on business and accounting issues. This informal and clear guide to the basic concepts of business law provides accountants with an excellent review of legal concepts that arise in any tax professional's practice. The attendees will gain the ability to recognize and discuss general legal concepts with both client and their counsel. Knowledge is power and nowhere is that truer than in the field law. To gain such a working knowledge of law, readily understandable explanations are given to essential and related business law subjects. The accountant is guided through the complex maze of literally hundreds of legal principles from acceptance to zoning.

Estate planning is when tomorrow becomes today! As a result of recent legislation, estate planning has been made surprisingly simple. This course surveys wills, living trusts, gifts, insurance, marital property, and probate avoidance. The will and trust forms are explored along with living wills, durable powers of attorney and nominations of conservator.

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

Practitioners are brought up-to-date information on tax issues affecting estate planning and business issues. A significant emphasis of this mini-course is practical estate planning solutions that are cost-effective. Devised to reduce or eliminate estate problems and death taxes, this comprehensive guide examines wills, trusts, gifts, insurance, private annuities, and other general estate planning tools. The planning issues and problems that arise from owning a business interest are also addressed.

This exceptional course surveys wills, living trusts, gifts, marital property, and probate avoidance. Will and trust forms are explored along with living wills, durable powers of attorney, and nominations of conservator. Designed to eliminate estate problems and death taxes, the emphasis is on practical solutions that are cost effective.

Everyone needs to do estate planning. It is more than just planning for death. Estate planning is designing a program for effective wealth building, preservation, and disposition of property at the minimum possible tax cost. This exceptional mini-course surveys wills, living trusts, gifts, marital property and probate avoidance. Designed to eliminate estate problems and death taxes, the emphasis is on practical, cost-effective solutions. The text reviews and explains both federal gift and estate tax systems giving practice pointers and planning observations.

This course will address the ethical and practical considerations related to assessing materiality in preparations, compilations and reviews and preparing financial statements when employed in the industry. This course fulfills the 4-hour ethics education requirement. Alternatively, it provides four hours of credit towards the accounting and auditing requirement.

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

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

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