CPE Catalog & Events
The 10 Must Know Excel Features
-
TBD
2.0 Credits
Member Price: $89
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
-
TBD
5.0 Credits
Member Price: $159
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
-
TBD
2.0 Credits
Member Price: $79
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
-
TBD
2.0 Credits
Member Price: $89
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
-
TBD
1.0 Credits
Member Price: $39
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?
-
TBD
1.0 Credits
Member Price: $39
Classification of workers as employees or independent contractors
2024 Advanced Excel: Hidden Secrets and Gems
-
TBD
2.0 Credits
Member Price: $79
Awareness of advanced functions Creative methods for data manipulation Real-life examples of innovative ways to analyze and report data with Excel Using Excel to perform e-mail merges Many other functions and techniques that inspire you to continue exploring the depths of Excel and its seemingly bottomless toolbox
Monthly Federal Tax Updates - March 2025
-
TBD
2.0 Credits
Member Price: $89
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
K2's Data Analytics For Accountants And Auditors
-
TBD
4.0 Credits
Member Price: $159
• Understanding the importance of data analytics in modern business environments • Generating and interpreting data analytics using everyday applications such as Microsoft Office Excel and Microsoft's Power BI platform • Using regression analysis to create and validate forecasts and projections
What's Going on at the FASB (2024)
-
TBD
4.0 Credits
Member Price: $149
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
-
TBD
2.0 Credits
Member Price: $89
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
-
TBD
1.0 Credits
Member Price: $39
Sexual harassment prevention Company culture
Navigating Leaves of Absence
-
TBD
1.0 Credits
Member Price: $39
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
2024 Was It Fraud or Just Poor Audit Quality?
-
TBD
1.6 Credits
Member Price: $59
Financial statement manipulation Ethics enforcement process Auditor conflicts of interest
Data Extraction, Transformation, Validation the Right Data Sources for Analysis
-
TBD
2.0 Credits
Member Price: $79
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
2024 Fiduciary Accounting: Fundamentals & Rules
-
TBD
2.0 Credits
Member Price: $79
Fundamentals of fiduciary accounting Uniform Principal and Income Act Mandatory and discretionary allocations and adjustments Address the trustees ability to override the fallback rules Review the contents of a proper set of trust accounting statements
Invest in Your Mental Health and Avoid Burnout
-
TBD
2.0 Credits
Member Price: $89
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
-
TBD
4.0 Credits
Member Price: $129
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
-
TBD
8.0 Credits
Member Price: $225
Forensic data analytics Fraud prevention and detection Data validation and methodologies COSO's Fraud Risk Management Guide principles Innovations in anti-fraud technology
2024 Tax Season Update with Steve Dilley
-
TBD
4.0 Credits
Member Price: $225
Update and integration of recent tax legislation impacting 2024 returns and significant individual and business tax developments related to cases and rulings Individual tax changes including the earned income credit, child credit, and child and dependent care credit Partnership and S corporation developments Section 199A changes and reporting, losses and forms Depreciation update: Section 179 and 168(k) 2025 tax rate schedule and other inflation adjusted items Tax forms update: individual, S corporation, and partnerships