CPE Catalog & Events
Power BI - Advanced Data Analytics with Power Pivot
-
Online
8.00 Credits
Member Price: $239
The major topics that will be covered in this class include:Introduction to Excel Power BI ToolsLoading data into Power Pivot using data modelingCreating "measures" using DAX functions and formulasUsing a date table to create time-intelligent measuresThe DAX calculation processTO SEE OUR FULL PREREQUISITE RECOMMENDATIONS AND INSTRUCTIONS, CLICK HERE
Big Picture Mega-Trends, Big Data, and World We Now Face
-
Online
2.00 Credits
Member Price: $79
On-going world economic trends Demographic changes and their impact on the economy Global technology influences Post Covid workplace Big data understanding and where is it going Learn to adapt to changing situations
Why People Are Irrational, Biased and Emotional With Money
-
Online
2.00 Credits
Member Price: $89
The major topics covered in this course include:Common irrational money decisionsCognitive biases and their impact on decision-making and ethical behaviorMental accountingThe ostrich effectPresent biasSunk-cost fallacyAnchoring biasStatus quo biasThe bandwagon effectEmotional responses in money decisions
Performance Targets That Deliver Results Without Burnout
-
Online
1.00 Credits
Member Price: $39
Performance target design Target testing
Introduction to Forensic Data Analytics
-
Online
2.00 Credits
Member Price: $109
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
Member Price: $79
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
Member Price: $109
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
2024 Tax Practice Ethical Challenges and Circular 230
-
Online
2.00 Credits
Member Price: $79
Circular 230 (IRS) rules for conducting a "best" tax practice How to avoid tax return preparation penalties Recent developments impacting today's tax practice Review of tax return preparer's registration rules Explanation of the revised AICPA Code of Professional Conduct Contingent fees
The 10 Must Know Excel Features
-
Online
2.00 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
-
Online
5.00 Credits
Member Price: $189
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
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
-
Online
2.00 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
-
Online
1.00 Credits
Member Price: $59
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
Member Price: $59
Classification of workers as employees or independent contractors
2024 Advanced Excel: Hidden Secrets and Gems
-
Online
2.00 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
-
Online
2.00 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
What's Going on at the FASB (2024)
-
Online
4.00 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
-
Online
2.00 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
-
Online
1.00 Credits
Member Price: $59
Sexual harassment prevention Company culture
Navigating Leaves of Absence
-
Online
1.00 Credits
Member Price: $59
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