CPE Catalog & Events

A review of the various lookup functions, beyond VLOOKUP Which lookup works best for your situation? How to apply the many lookup functions Advanced lookup techniques like nested lookups, approximate matching, and handling errors effectively An in-depth review of the following functions: VLOOKUP/HLOOKUP, XLOOKUP, MATCH / INDEX, XMATCH, INDIRECT, FILTER, SORT/SORTBY, UNIQUE An overview of some newer functions

Importance of client retention Understanding client needs and expectations through client satisfaction surveys and analyzing client feedback Developing effective client retention strategies Fostering client loyalty Handling client complaints and issues through effective complaint resolution

Home office deduction Alimony payments Charitable contributions Medical expense deduction Home mortgage interest deduction State and local income tax (SALT) deduction Gambling winnings and losses

How crowdfunding works The different types of crowdfunding programs Strategies for building a crowdfunding campaign

Introduction to cryptocurrency and key terms   Chronology of cryptocurrency   Virtual currency taxation   Information on any updated guidance

Choice of entity decisions Client consultation questions regarding entity selection

Stock grants, including Restricted Stock Awards (RSAs), Restricted Stock Units (RSUs), and Performance Share Units (PSUs)               Stock options and rights, including Incentive Stock Options (ISOs), Non-Qualified Stock Options (NQSOs), Stock Appreciation Rights (SARs), and phantom awards Employee Stock Purchase Plans (ESPPs) Equity awards and partnerships / S corporations

Why accounting and other professionals should use the metaverse Where accountants and other professionals can find their space in the metaverse How the metaverse is changing the way we work

Tips and tricks to prepare the Schedule C Income and expenses Tax invoice preparation Legal invoice Entertainment invoice Education invoice

Business development Types of properties Rental property use  Rental expenses Deductible expenses Repairs and maintenance Capitalization of expenses Depreciation Accounting methods Treatment of security deposits

How and why a partnership makes a 754 election  The effect of the 754 election when an interest in a partnership is sold or inherited  How the 754 election applies when a partnership makes a distribution of property to one or more of its partners  How to make the 754 basis adjustment

Discussion of capital gain planning Transaction analysis and reporting Elements of a tax-free reorganization Overview of non-federal taxes: state tax implications, estate taxes, gift taxes, generation-skipping taxes, and property taxes

Retirement benefits: What the amount of benefits is in various circumstances Spousal benefits: Should a spouse return to work? What benefits does a spouse have and when and how do they relate to benefits decisions by the client? Claiming Social Security: Advantages and disadvantages at ages 62, full retirement age, and 70 Planning: What clients approaching retirement age should consider now with respect to benefits for them, their spouses, and their children Coordinating benefits: Should you take Social Security first and higher-balance IRA distributions later, or take IRA balances first and enhanced Social Security benefits later?

Using metrics that correctly measure the goals of the organization How metrics will differ for non-profits and governments Using metrics to balance cost and benefit Internal and external benchmarking for comparison Having a set of balanced metrics

• Use the PivotTable button to create a PivotTable • Use the Recommend PivotTables button to create a PivotTable • Use the Quick Analysis feature to create a PivotTable • Use the Summarize as PivotTable button with the Data Model to create a PivotTable • Format the PivotTable values using a shortcut menu • Change the PivotTable layout using the PivotTable Tools Design tab • Rearrange, hide and show subtotals and grand totals using the PivotTable Tools Design tab • Apply a PivotTable style using the PivotTable Tools Design tab • Refresh a PivotTable using the PivotTable Tools Analyze tab or keyboard shortcut • Filter a PivotTable using the filtering arrows • Modify the PivotTable structure using the Field List • Filter a PivotTable using slicers • Add a calculated field to a PivotTable using the PivotTable Tools Analyze tab • Modify the Value Field Settings using a shortcut menu • Use the PivotChart button to create an embedded PivotChart • Use the standard Excel charting buttons to create a PivotChart • Use a keyboard shortcut to create a PivotChart on its own chart sheet • Create a PivotChart and linked PivotTable simultaneously • Add or remove chart elements using the Chart Elements button • Change the chart style and color scheme using the Chart Styles button • Change the chart layout using the PivotChart Tools Design tab • Select and format individual chart elements using the PivotChart Tools Format tab • Filter the PivotChart using the Pivot Field buttons • Change the chart type and subtype using a shortcut men • Add, remove, and reposition the PivotChart fields using the Field List • Switch the row/column orientation using the PivotChart Tools Design tab

Emerging sales tax topics: Elimination of the physical presence standard in determining nexus (Wayfair case); economic nexus for remote sellers; assisting remote sellers in determining a plan of action in states that enforce economic nexus Emerging compliance issues in the new sales tax economy Income Tax (and other forms of tax): Economic nexus (taxation without physical presence) Will states shift away from income tax and increase reliance on sales tax after Wayfair? Treatment of Tax Cuts and Jobs Act by the states: presence of intangible property; is P.L. 86-272 still valid? When to consider voluntary compliance even though the laws do not dictate a sales tax responsibility

The domicile dilemma: Issues for individuals with homes in multiple states; traveling employees; where to withhold? Emerging sales tax topics: Elimination of the physical presence standard in determining nexus (Wayfair case); economic nexus for remote sellers; assisting remote sellers in determining a plan of action in states that enforce economic nexus Emerging compliance issues in the new sales tax economy Income Tax (and other forms of tax): Economic nexus (taxation without physical presence) Will states shift away from income tax and increase reliance on sales tax after Wayfair? Treatment of Tax Cuts and Jobs Act by the states: Attributional and agency nexus; presence of intangible property; is P.L. 86-272 still valid? Income-tax apportionment issues: Prevalence of the single sales factor; determining the type of property being sold; sourcing of income from intangible property and services; sourcing of service income; Market Based versus Cost of Performance Pass-through problems: Nexus issues for interest owners Treatment of the 199A deduction for pass through entities by states: Withholding issues; sourcing of income; taxation at the entity level Practical considerations in dealing with multistate taxation: Dealing with state nexus questionnaires When to consider voluntary compliance: Responsibility of officers, members, partners, and shareholders; planning ideas and opportunities; updates on pending federal legislation relative to state tax

Preparing a valid Appeals Protest for small case requests when tax, penalties, and interest for each period are $25,000 or less Writing and filing a Formal Protest, including required information Alternative Dispute Resolution options available to clients Negotiation and time limitations Preparing and submitting a Tax Court petition to preserve a client’s rights

New format of the auditor’s opinion, including the inclusion of key audit matters Significant unusual transactions Determining materiality Conforming changes to other reports issued under the SAS

An overview of workplace harassment and discrimination laws Clear definitions of unlawful harassment, hostile work environment, discrimination, and protected categories An overview of sexual harassment, workplace retaliation, and both internal and external complaint procedures Real-world examples to help employees understand the differences between unlawful harassment and lawful workplace interactions and assess whether they need to modify their workplace conduct