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.

New functions in Excel such as TEXTJOIN, IFS, and SWITCH. Working with CUBE functions and Data Models. Extracting data from PivotTables with the GETPIVOTDATA function. Summarizing data with the SUBTOTAL and AGGREGATE functions. Creating reports using EOMONTH, INDIRECT, and SUMIFS. Working with Excel's primary date-oriented functions.

Exchanging and working with QuickBooks data. Advanced reporting issues. Managing inventory with QuickBooks.

Fundamentals of effective visualizations. Creating visualizations in excel. Beyond the basics for more effective visualizations and communication.

Macro recorder. Visual basic editor. Quick access toolbar.

External data. Text files. Data preparation. Accounting system data. Getting graphics.

Selected shortcuts. Named references tables. Data validation. Conditional formatting basics.

Better summing. Skinny row. Hide worksheets. Highlight input cells. Workbook organization. Worksheet organization. Nested functions. Selection groups. Workbook design principles.

Conditional summing basics with SUMIFS. Remove duplicates. Lookup basics. Improving VLOOKUP with MATCH. Improving VLOOKUP with VALUE and TEXT. Moving beyond VLOOKUP with INDEX.

Trap errors with IFERROR. The IF function. List comparisons. The ISERROR function. Multicolumn list comparisons with COUNTIFS. Indentation. Perform lookups with SUMIFS.

Determine the last day of the month with EOMONTH. Date parts: MONTH and YEAR. Build your own date with DATE. Concatenation basics. Improve SUMIFS with CONCATENATE.

Dynamic headers. Horizontal reports. Mapping tables. Data validation and reporting. Improving error check with Boolean values and the logical AND function.

PivotTable basics. Row fields. Value fields. Column fields. Filter fields. Updating data. Groups and subtotals. Value formats.

Report type comparison options. Report layout and design. Multiple value fields. Calculated fields. Calculated items.