CPE & Event Catalog

Awareness of advanced functions. Creative methods for data manipulation. Real-life examples of innovative ways to analyze and report data with Excel. Using Excel to perform e-mail merges. Many other functions and techniques that inspire you to continue exploring the depths of Excel and its seemingly bottomless toolbox.

Why we get off balance and how to overcome those tendencies. Methods that turbo charge motivation, health, and happiness. The power of culture and friends to affect our lives. The importance of clear intention in order to effect change that lasts.

Classifying receipts between "income" and "corpus" under the Uniform Principal and Income Act. Calculation of DNI utilizing three different methods, a "forms" method (Schedule B), a "code" method, and a "shortcut" method, utilizing a worksheet of common income and expenses. Proper W-2 preparation and procedures in the year of death. Forgetful fiduciaries of simple trusts. Fluctuating trusts: Simple one year, complex the next. Dividing income in the year of death. Overview of Subchapter J. Form preparation issues: Filing requirements and line-by-line explanations of Form 1041. Taxable income of estates and trusts and expense allocation issues. Specific deductions and miscellaneous itemized deductions. Income in respect of a decedent. The income distribution deduction calculation. Relation of principal and income law to DNI. Understanding how to handle capital gains and losses. Other considerations: Excess deductions on termination. Comprehensive DNI case study, with principal (cost and FMV) and income reconciliation. Comprehensive trust and estate case studies, with filled-in forms.

Utilizing your team - your whole team. Your company, your experts - your resources. Maintaining relationships with key external parties can be your secret weapon. Building key connections - who, how, and when. Making critical decisions timely. Translating data analytics into what matters. Knowing when to delegate. Gaining knowledge efficiently. Deciphering what to learn. Determining the questions to ask. Becoming the Chief Value Officer. Communicating what drives value. Understanding risk.

Understanding formula conventions. Working with functions. Examples of powerful Excel formulas.

The power of keyboard shortcuts. Often used features with more capability than meets the eye. New helpful features.

Using Excel for graphical output and dashboard reporting. Data tools and the Data Analysis ToolPak. Advanced functions and complex formulas. Working with Excel tables and PivotTables.