CPE Catalog & Events

Fields in a PivotTable Benefits of PivotTable Contextual tabs for a PivotTable Field setting dialog box Value field setting dialog box Pivot table options Exercises- PivotTables Creating a PivotTable Grouping by date Sorting a PivotTable Filtering a PivotTable Calculations in a PivotTable Slicers and timelines Introduces OLAP (Online Analytical Processing) pivot tables in Power Pivot

Visualization tools in Excel (camera, slicers, and timelines) Data view- why it went away. Power BI is the visualization tool to use All concepts learned in course are brought together in this last class to create a dashboard: Power Query- to extract transform and load data for the dashboard Power Pivot -to create the data model for the dashboard DAX formulas- for pivot tables to calculate values needed for model Pivot tables and charts- to create visualizations Camera tool to create dashboard Exercise- Using the data analytics workflow introduced in first class of series- to create dashboard for JE testing Journal entry by month and income statement accounts Descriptive statistics of journal entries Number of journal entry by month Journal entries by day of week Round journal entries Evaluate output of journal entry analytic Other approaches What are the false positives (noise)? Next steps in data analytics journey

Definition of Data Analytics Assessing your organization's current status and establishing an environment for success Financial staff's core activities Common uses of analytics and current examples Behavioral forces that impact decisions Examples of inaccurate forecasts Identifying strategic measurements (KPIs) Improving budgeting and forecasting and addressing Black Swan events Collecting and using data from traditional and non-traditional data sources Statistical tools, including Median, Mode, Moving average, Ratio analysis, Pareto analysis, Rolling forecast, Mission-based budgeting, Trend analysis, Regression, Z-Score (public and private organizations), and Simulation Analytical techniques, including Brainstorming, Mind mapping, and Delphi technique Software tools that are readily available and can assist in visually exploring data; expanding the scope of available data, as well as collecting, analyzing and presenting results (including Dashboards). Specific ideas for using Data Analytics, including immediate opportunities and areas for further consideration Expanded lists of readings and next level software for a participants' future reference

Definition of data analytics and big data; challenges and goals; establishing an environment for success; governance; common uses of analytics and current examples Behavioral forces that impact decisions; examples of inaccurate forecasts; identifying strategic measurements (KPIs); data sources Statistical tools, including median, mode, moving average, ratio analysis, Pareto analysis, trend analysis, regression, z-score, and simulation Software tools that are readily available and can assist in visually exploring data, expanding the scope of available data, as well as collecting, analyzing, and presenting results Specific ideas for using data analytics for accountants and financial managers, including current examples and areas for further consideration Lists of readings and next-level software for a participant's future reference

Why have companies struggled to implement data analytics? What are the barriers you face in becoming a data-driven organization? How does self-service business intelligence help in developing a data-driven organization? Why is Power BI the self-service business intelligence application you should use? Why should everyone in your company be assigned a data role?

Ethical duty to safeguard employee, client, and litigant data Common threats, including phishing, ransomware, and bad password management Security management of business and personal electronic devices Best practices for creating and securing passwords Insight into how our personal information is exploited in our daily lives

Bonus depreciation for acquisitions and construction History of qualified property categories and QIP The CARES Act and related Rev. Procs. Section 179 expensing Energy incentives The tangible property regulations 1031 exchanges Strategic hierarchy

Understanding the risk-based program selection approach to identifying major programs The four-step major program determination process How to identify not low-risk type A programs and high-risk type B programs

Coming soon!

Overview of uncertainties, contingencies, litigation, claims and assessments and related disclosures Auditing managements assumptions in making the going concern evaluation Evaluating substantial doubt about an entity's ability to continue as a going concern for a reasonable period of time as defined in professional standards.

What stock options are and why they are growing in popularity How stock options work, including the process of conveyance and vesting How to exercise stock options and the implications from doing so The risks associated with stock options and how to manage exposure Tax consequences and updates regarding stock options Strategies for selecting the best time to exercise stock options The difference between the two types of stock options: non-qualified and incentive The basic terminology relevant to owning and exercising options

The 20 common law factors in a worker classification audit that are used to distinguish an employee from an independent contractor How disgruntled independent contractors can use IRS Form 8919 against a former employer When and how to use §530 as a defense in worker classification audits What is "industry practice" for §530 purposes Common sense steps that will avoid the recharacterization of workers treated as independent contractors to employees The IRS's Voluntary Classification Settlement Program advantages and disadvantages

Managing client expectations How automation improves client engagement Understanding the role of feedback systems Seeking referrals Building client loyalty Customer retention marketing Expanding services offered to clients Knowing when it is appropriate to enter new markets

Overview of ERM and how it affects all organizations What COVID-19 has taught us about risk management Risk tolerance and developing a plan Risk identification Risk analysis Risk responses Strategy risk

Resolved technical glitches for qualified improvement property Detailed coverage of §179 expense elections and §168(k) bonus or additional first-year depreciation; how to maximize them, definitions, limitations, qualified property, etc. Sale of property and the depreciation recapture rules (§1245, §1250, unrecaptured §1250 gain for real estate, §291 for corporations) MACRS depreciation; finding the proper method, convention, and recovery period Listed property and the current limitations Amortization of start-up, organization, and other expenditures AMT depreciation adjustments and how to avoid them Examples, cases, and rulings of depreciation and amortization issues and how they impact clients, along with useful planning opportunities

Types of sampling and sampling risk Attribute testing for tests of controls and compliance Variable sampling for substantive assurance Differentiating statistical and nonstatistical sampling approaches Determining sample sizes in a compliance audit

Typical provisions in state statutes regarding domicile and residency In depth analysis of domicile and residency definitions Issues regarding one's permanent abode Analysis of jurisdiction where taxpayer has the greatest connections Detailed discussion of criteria used to establish domicile and residency

SAS 142, Audit Evidence (recently issued) Relevance and reliability of audit evidence Sources of evidence Audit procedures Evaluation of tests of controls Evaluation of sufficiency and appropriateness of evidence

The Yellow Book's general requirements and application guidance related to independence The conceptual framework used for making independence determinations Requirements and guidance for auditors providing nonaudit services The Yellow Book documentation requirements related to independence

ASU No. 2016-02, Leases (Topic 842) Overall lease accounting guidance Lessor Accounting 101 Lessee Accounting 101 Detailed review of accounting by lessees and lessors Sale and leaseback transactions Transition guidance Other operational issues Recently issued updates to the lease accounting guidance FASB guidance on accounting for COVID-19-related rent concessions Feedback from the public company adoption of Topic 842