CPE Catalog & Events
Surgent's Current Issues in Accounting and Auditing: An Annual Update - Download
Available Until
Online
4.00 Credits
Recently issued FASB Accounting Standards Updates, the PCC Update, and items on the FASB’s Technical Agenda Leases – Topic 842 Review of SAS No. 142 – Audit Evidence Recently issued SASs and other AICPA activity Detailed review of SAS No. 145 Other important A&A practice matters
Surgent's Current Issues in Accounting and Auditing: An Annual Update - On-Demand Webcast
Available Until
Online
4.00 Credits
Recently issued FASB Accounting Standards Updates, the PCC Update, and items on the FASB’s Technical Agenda Leases – Topic 842 Review of SAS No. 142 – Audit Evidence Recently issued SASs and other AICPA activity Detailed review of SAS No. 145 Other important A&A practice matters
Surgent's Data Analytics Readiness Series: Advanced Formulas- Array Formulas and DAX Formulas - On-Demand Webcast
Available Until
Online
1.00 Credits
Key to understanding array formulas is Implicit Intersection How to enter and evaluate an array formula Examples- array and DAX formulas Array formulas- Implicit Intersection Understanding DAX formulas Calculated columns and measures Evaluation context Context transition Implicit vs explicit measures Examples- DAX formulas Creating a calculated column in Power Pivot
Surgent's Data Analytics Readiness Series: Artificial Intelligence- Basic Concepts in Excel - On-Demand Webcast
Available Until
Online
1.00 Credits
Understanding difference between supervised and unsupervised learning Formulas in Excel (Correl and Trend and Forecast) Linear regression What is artificial intelligence? Examples- artificial intelligence Forecast function Trend function Regression in Excel with the data analysis ToolPak Creating a prediction model
Surgent's Data Analytics Readiness Series: Calculated Columns and Dimensions - On-Demand Webcast
Available Until
Online
1.00 Credits
Where can you create a calculated column? Understanding evaluation context- row and filter context When does evaluation of the formula occur (before, as, or after the data is loaded?) Understanding storage requirements of calculated columns Understanding the analytical data model of the Star Schema Dimensions Facts Exercises- calculated columns Adding a calculated column in a table in Excel Creating a dimension table in Power Query Creating a hierarchy in Excel with calculated columns Adding a calculated column in Power Query JE testing with calculated columns Other test- opening balances
Surgent's Data Analytics Readiness Series: Data Extraction and Data Sources - On-Demand Webcast
Available Until
Online
1.00 Credits
Introduction to a Data Analytics Workflow (will be re-introduced in final class to bring all concepts together) Overview of various definitions of data analytics Data analytics needs multiple sources of data Introduction to Power Query (Get & Transform)- on data tab in Excel Exercise- connecting to various Data Sources Importing Excel workbook into Power Query Connecting to a website in Power Query
Surgent's Data Analytics Readiness Series: Data Modeling - On-Demand Webcast
Available Until
Online
1.00 Credits
How to join tables using VLOOKUP Power Query- append queries and merge queries Power Pivot- Creating a relationship via diagram view Types of relationships Data integrity Normalization Facts vs dimension tables Exercises- data modeling VLOOKUP and index match formula Appending data in Power Query Merging data in Power Query Connection only queries Creating a relationship in Power Pivot
Surgent's Data Analytics Readiness Series: Data Preparation Using Get and Transform - On-Demand Webcast
Available Until
Online
1.00 Credits
An ETL tool- Extract Transform and Load How Power Query ups your game in data analytics Interface components of Power Query Column level and table actions Power Query is a sequential macro recorder What is M Code? Exercise- cleaning and transforming a general ledger
Surgent's Data Analytics Readiness Series: Excel Tables - On-Demand Webcast
Available Until
Online
1.00 Credits
Creating a table Parts to a table Benefits of an Excel table Structured references How it helps to create formulas Formulas are column based not cell based Tables are data sources for Power Query Exercises- tables Creating a table Resizing a table Removing duplicates Descriptive Statistics using the Total Row Inserting a slicer Creating formulas using structured references
Surgent's Data Analytics Readiness Series: Formulas, Named Ranges, and Formula Auditing - On-Demand Webcast
Available Until
Online
1.00 Credits
Named ranges- how they help in creating formulas Naming conventions and why they are important What you need to know to master formulas How to audit your formulas to limit errors Exercises- formulas Named ranges How to enter a formula- best practices to improve skill levels
Surgent's Data Analytics Readiness Series: PivotTables - On-Demand Webcast
Available Until
Online
1.00 Credits
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
Surgent's Data Analytics Readiness Series: Visualizations and Reporting - On-Demand Webcast
Available Until
Online
1.00 Credits
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
Surgent's Data Analytics Toolkit - Tools and Applications - On-Demand Webcast
Available Until
Online
2.00 Credits
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
Surgent's Data Analytics for Accountants and Financial Managers - On-Demand Webcast
Available Until
Online
2.00 Credits
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
Surgent's Data Analytics: Planning and Implementation Strategies - On-Demand Webcast
Available Until
Online
1.00 Credits
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?
Surgent's Data Security: Best Practices to Protect Your Business and Yourself - On-Demand Webcast
Available Until
Online
1.00 Credits
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
Surgent's Delaware Ethics for CPAs - Download
Available Until
Online
4.00 Credits
Professional and ethical conduct requirements specifically applicable to Delaware CPAs, including 2016 amendments to the Delaware Licensure Law The core principles of professional conduct -- integrity, objectivity, and independence The AICPA Code of Professional Conduct Principles and concepts which form the foundation of ethical behavior
Surgent's Delaware Ethics for CPAs - On-Demand Webcast
Available Until
Online
4.00 Credits
Professional and ethical conduct requirements specifically applicable to Delaware CPAs, including 2016 amendments to the Delaware Licensure Law The core principles of professional conduct -- integrity, objectivity, and independence The AICPA Code of Professional Conduct Principles and concepts which form the foundation of ethical behavior
Surgent's Depreciation Rules for Bonus and Section 179 Expensing - On-Demand Webcast
Available Until
Online
2.00 Credits
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
Surgent's Did I Pick the Right Major? Selecting Major Programs in a Single Audit - On-Demand Webcast
Available Until
Online
2.00 Credits
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”