CPE Catalog & Events
Introduction to Forensic Data Analytics
-
Online
2.00 Credits
Data analytics Key fraud risk management guidance documents Data analytics frameworks Leading techniques and innovations for preventing and detecting fraud
The Motives and Mystery of Ethics-Understanding the Why
-
Online
2.00 Credits
Understanding yourself and others in the workplace How emotion plays a vital role in ethical dilemmas and in solutions What are some of the various outlooks on ethics? Recognizing lies Managing ethics towards solutions
Emerging Innovations in Forensic Data Analytics, Crypto Currencies and AI, ChatGPT
-
Online
2.00 Credits
AI and ChatGPT Machine learning & predictive transaction tagging Profiles of an improper or corrupt vendor payment Data Sharing Consortium and Split Learning Techniques Cryptocurrency trends and applications from an accountant's perspective
The 10 Must Know Excel Features
-
Online
2.00 Credits
The major topics that will be covered in this class include:Excel Tables: Master the use of Excel tables for efficient data management, including sorting, filtering, and structured references, to manage data more effectively.Custom Sorting: Get to grips with custom sorting options to organize data in a way that best suits your needs, enhancing data readability and analysis.XLOOKUP: Discover the power of XLOOKUP for advanced data retrieval, a game-changer for complex analysis, allowing you to extract specific data from extensive datasets with ease.SUBTOTAL: Gain proficiency in using the SUBTOTAL function, a versatile tool for calculating data in visible cells, ideal for analyses that require dynamic calculations.SUMIF(S): Explore the functionality of SUMIF and SUMIFS functions for conditional summing, crucial for precise budgeting, expense tracking, and financial reporting.Array Formulas: Dive into array formulas to perform multiple calculations on one or more items in an array, enhancing the efficiency of complex accounting computations.Data Validations: Learn to implement data validations to ensure data integrity and prevent errors in financial data entry, a critical skill for maintaining accurate accounting records.Slicers: Learn to use slicers for interactive data segmentation in tables and PivotTables, enabling accountants to quickly filter and analyze specific subsets of financial data.Conditional Formatting: Understand how to apply conditional formatting to highlight critical financial data points, trends, and variances, making data analysis and interpretation more intuitive.PivotTables: An introduction to PivotTables, one of the most powerful Excel features, for summarizing, analyzing, and presenting large sets of financial data in a digestible format.
KPI Bootcamp for Small Businesses
-
Online
5.00 Credits
Why measure things? The ROKS Express method Goals check - identifying your business objectives and Key Results Selecting your KPI candidates using the KPI Definition Manual Shortlisting - Picking the very best KPIs from your KPI Candidates Tuning your KPI definitions Going Live
IRS Cybersecurity Checklist
-
Online
2.00 Credits
Defining Cybersecurity and Cyber Risks Implications of Cybercrime Cyber Attack Trends Landscape of Cyberattacks Laws and Regulations Security Standards and Frameworks Cybersecurity Roadmap
2024 Governmental GAAP Update
-
Online
2.00 Credits
The major topics that will be covered in this course include:New GASB standards:GASB 100, Accounting Changes and Error Corrections.GASB 101, Compensated Absences.Practical case studies.
Employment Law 101
-
Online
1.00 Credits
Title VII Americans With Disabilities Act Age Discrimination in Employment Act Family Medical Leave Act Fair Labor Standards Act Equal Pay Act National Labor Relations Act Fair Credit Reporting Act
Are Those Independent Contractors Really Independent Contractors?
-
Online
1.00 Credits
Classification of workers as employees or independent contractors
Monthly Federal Tax Updates - March 2025
-
Online
2.00 Credits
The major topics that will be covered in this course include:Current individual tax issuesCurrent business entity tax issuesAny current tax legislation occurring during the periodOther issues affecting the profession, including IRS procedure, current cases, payroll, and other federal tax issues
What's Going on at the FASB (2024)
-
Online
4.00 Credits
The major topics that will be covered in this course include:Accounting Standard Updates effective in 2024 for public entities, private entities, and nonprofits. Review year 2 implications of the leases standard including modification accounting. A look at the projects identified by the FASB's Invitation to Comment: Agenda Consultation.
Audit 203: Auditing Accounts Receivable - Common Risks
-
Online
2.00 Credits
The major topics covered in this course include:Typical risks of material misstatement related to accounts receivablePractice tailoring the detailed audit plan to the assessed risk of material misstatementOverview of more complex issues, such as methods for converting accounts receivable to cashExternal confirmation audit considerations, including evaluating responses for proprietyEvaluating the valuation of accounts receivable
Combatting Sexual Harassment in the Workplace
-
Online
1.00 Credits
Sexual harassment prevention Company culture
Navigating Leaves of Absence
-
Online
1.00 Credits
Family Medical Leave Act - full time and intermittent Americans With Disabilities Act Special rules for managers Handling fraud, abuse, and performance issues in connection with a leave of absence
Data Extraction, Transformation, Validation the Right Data Sources for Analysis
-
Online
2.00 Credits
Understand various data types Structured vs. unstructured data Completeness and validation testing Selecting the right data sources for the job Risks and pitfalls to avoid
Invest in Your Mental Health and Avoid Burnout
-
Online
2.00 Credits
The major topics covered in this course include:How to recognize burnout and evaluate where you are on the burnout scale.How impostor syndrome drives coping reactions of overworking, over preparing and perfectionism.How mindfulness can reduce stress and save time.Silencing the critical inner voice.Tools to help you become more attuned to your needs and emotions.How attending to and regulating your nervous system impacts your mood and well-being.
Dashboard and Report Design Principles Using Excel
-
Online
4.00 Credits
How to design charts for fastest possible user understanding and ease of use Review of case studies for group critique Developing a design standard for your organization Designing tables for rapid understanding and efficient space use How to use commentary, maintaining a consistent style and level of detail Using layout to support long-term memory and improve understanding The impact of trend methods on user understanding and a brief introduction to a statistically valid method for trend analysis. How to apply these techniques using Excel
Forensic Data Analytics Supercourse for Fraud Prevention and Detection
-
Online
8.00 Credits
Forensic data analytics Fraud prevention and detection Data validation and methodologies COSO's Fraud Risk Management Guide principles Innovations in anti-fraud technology
Power BI - OLAP Formulas & More Time Intelligent Functions
-
Online
2.00 Credits
The major topics that will be covered in this class include:OLAP functions to create custom calculations on an Excel worksheetMeasures that help determine the date of your refreshed dataAdvanced time intelligent functions to create date-based measures
Construction Contractors: Non-Revenue and Non-Lease Accounting Considerations
-
Online
4.00 Credits
Types of contractors Non-revenue GAAP accounting for contractors Contractor financial statements Sureties and their place in the construction relationship