CPE Catalog & Events

The sources of deferred tax assets and liabilities Calculating the deferred tax asset or liability Reporting income-tax expense and balance sheet items CARES Act accounting implications Defining, analyzing, and reporting uncertain tax positions Classification of deferred tax assets and liabilities Disclosure requirements Recent and proposed changes to the accounting and disclosure requirements for income taxes

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

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

Multiple ways to create a formula using one or more functions Financial functions to calculate the internal rate of return, net present value, future value, present value, payment and depreciation Date & Time functions to insert date and time components Math & Trig functions to calculate the sum of a range of numbers; find a random number and the positive square root of a number; and round calculations to a specific number of places Statistical functions to find the average, maximum, minimum, count, median and mode of a range of numbers plus the top five numbers Lookup & Reference functions to find specific data and document worksheet formulas Specific criteria and Database functions to calculate the sum, average, maximum value, minimum value and number of cells containing numbers in a database field Text functions to improve worksheet appearance Logical functions to perform calculations based on one or more tests

PivotTable button Recommend PivotTables button  Quick Analysis feature Summarize as PivotTable button with the Data Model PivotTable values PivotTable Design tab Subtotals and grand totals PivotTable style PivotTable Analyze tab  Keyboard shortcuts Filtering arrows PivotTable structure using the Fields List PivotTable using Slicers A calculated field to a PivotTable using the PivotTable Analyze tab Value Field Settings using a shortcut menu PivotChart button to create an embedded PivotChart Standard Excel charting buttons to create a PivotChart Keyboard shortcut to create a PivotChart on its own chart sheet PivotChart and linked PivotTable simultaneously Chart elements using the Chart Elements button Chart style and color scheme using the Chart Styles button Chart layout using the PivotChart Design tab Individual chart elements using the PivotChart Format tab PivotChart using the Pivot Field buttons Chart type and subtype using a shortcut menu PivotChart fields using the Fields List Row/column orientation using the PivotChart Design tab

Identify chart elements Select an embedded Pie chart using Recommended Charts; select formatting options for the chart Select a Clustered Column chart using the Quick Analysis feature; select formatting options for the chart Recognize how to preview and print charts Select methods to change the chart type and subtype Identify how to apply a predefined chart layout and chart style Recognize ways to add, select, and format individual chart elements Select methods to add and remove data and change data orientation Select Line with Markers, Stacked Area, exploded 3-D Pie, Pie of Pie, and Clustered Column-Line on Secondary Axis, Treemap, Sunburst, and Waterfall charts; identify ways to format the charts Recognize a Sparklines chart; identify formatting options for the chart Identify ways to insert and format a picture and draw and format a shape on a chart

Describe the Excel application and explain how it is used Start Excel, describe the Start screen, and create a new workbook Describe Excel window elements Open an existing workbook Navigate in a worksheet Select in a worksheet Change Excel options Access Excel help and use Key Tips Close a workbook and close Excel Save a workbook Insert, reposition, select, delete and rename worksheets Enter, edit and format cell contents Create formulas Use functions Apply Accounting and Percent Style formatting Use Flash Fill for data entry Show and hide worksheet elements Undo and redo an action Work in Normal view, Page Layout view and Page Break Preview Set page setup options, preview, and print a worksheet

IRR, NPV, FV, PV, PMT, SLN, SYD, and DB Financial functions; NOW, TODAY, DATE, MONTH, DAY, YEAR, TIME, HOUR, MINUTE, SECOND, WEEKDAY, and NETWORKDAYS Date & Time functions; SUM, RAND, SQRT, and ROUND Math & Trig functions; AVERAGE, MAX, MIN, COUNT, MEDIAN, MODE.SNGL, and LARGE Statistical functions; VLOOKUP, HLOOKUP, and FORMULATEXT Lookup & Reference functions; DSUM, DCOUNT, DAVERAGE, DMIN, and DMAX Database functions; PROPER, SUBSTITUTE, and LOWER Text functions; and IF, AND, and IFNA Logical functions.

IRR, NPV, FV, PV, PMT, SLN, SYD, and DB Financial functions NOW, TODAY, DATE, MONTH, DAY, YEAR, TIME, HOUR, MINUTE, SECOND, WEEKDAY, and NETWORKDAYS Date & Time functions SUM, RAND, SQRT, and ROUND Math & Trig functions AVERAGE, MAX, MIN, COUNT, MEDIAN, MODE.SNGL, and LARGE Statistical functions VLOOKUP, HLOOKUP, and FORMULATEXT Lookup & Reference functions DSUM, DCOUNT, DAVERAGE, DMIN, and DMAX Database functions PROPER, SUBSTITUTE, and LOWER Text functions IF, AND, and IFNA Logical functions Quick Analysis feature

• 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

Identify basic formula and function syntax Recognize formulas pasted with relative references Select status bar options and sum (AutoSum) for quick calculations Recognize formulas pasted with mixed or absolute references Identify formula results pasted as values Select worksheets for grouping and entering formulas Identify ways to link worksheets and workbooks with 3D formulas Select the insert function button or buttons from the function library to insert functions in formulas Recognize defined names as function arguments Apply conditional formatting to formulas’ results Identify and correct common errors using the trace error icon and the formula auditing tools Identify and correct circular references Select color-coded cell borders to correct a cell reference error in a formula Identify how to step through a nested formula Identify how to use the Watch Window and other tools to analyze, protect, and hide formulas

Lesson 1: identify ways to start Excel, recognize Excel Start screen elements including the Blank Workbook template, recognize Excel window elements, select Backstage view to open an existing workbook, identify worksheet navigation methods, select worksheet cells, rows, and columns, identify and select Excel user preferences, identify ways to get help in Excel, select methods to save and close a workbook, select methods to create a new workbook, select methods to close one or more workbooks, and select methods to close Excel Lesson 2: identify ways to insert, reposition, select, delete, and rename worksheets, recognize ways to enter, edit, and format cell contents, select ways to create formulas, identify functions, identify ways to apply Accounting and Percent Style formatting, and select Flash Fill for data entry Lesson 3: identify ways to show and hide worksheet elements, select methods to undo and redo an action, recognize ways to switch between Normal view, Page Layout view and Page Break Preview, and select page setup options, preview and print options