CPE Catalog & Events

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

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

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

New professional standards issued by the FASB and AICPA Guidance on likely COVID-19-related accounting issues that you are likely to face Insights on best practices in managing new working environments Other topics of importance for all accounting practitioners

New professional standards issued by the FASB and AICPA Guidance on likely COVID-19-related accounting issues that you are likely to face Insights on best practices in managing new working environments Other topics of importance for all accounting practitioners

New professional standards issued by the FASB and AICPA Guidance on likely COVID-19-related accounting issues that you are likely to face Insights on best practices in managing new working environments Other topics of importance for all accounting practitioners

New professional standards issued by the FASB and AICPA Guidance on likely COVID-19-related accounting issues that you are likely to face Insights on best practices in managing new working environments Other topics of importance for all accounting practitioners

New professional standards issued by the FASB and AICPA Guidance on likely COVID-19-related accounting issues that you are likely to face Insights on best practices in managing new working environments Other topics of importance for all accounting practitioners

New professional standards issued by the FASB and AICPA Guidance on likely COVID-19-related accounting issues that you are likely to face Insights on best practices in managing new working environments Other topics of importance for all accounting practitioners

New professional standards issued by the FASB and AICPA Guidance on likely COVID-19-related accounting issues that you are likely to face Insights on best practices in managing new working environments Other topics of importance for all accounting practitioners

New professional standards issued by the FASB and AICPA Guidance on likely COVID-19-related accounting issues that you are likely to face Insights on best practices in managing new working environments Other topics of importance for all accounting practitioners

New professional standards issued by the FASB and AICPA Guidance on likely COVID-19-related accounting issues that you are likely to face Insights on best practices in managing new working environments Other topics of importance for all accounting practitioners

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

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

Principles and concepts which form the foundation of ethical behavior The core principles of professional conduct -- integrity, objectivity, and independence The AICPA Code of Professional Conduct New York professional standards and responsibilities for the practice of public accounting

What is blockchain technology? How do you buy crypto? How do you store crypto? Use cases of cryptocurrency Blockchain technology  Use cases of cryptocurrency Tax overview How taxes work for cryptocurrency investors How taxes work for cryptocurrency mining Taxation of other transactions Foreign reporting requirements and crypto How to use a tool like CoinTracker to calculate capital gains and losses New developments in the space Tax planning opportunities  Why do accountants need to care?