CPE Catalog & Events
2024 Practical Excel Topics for the Public Accountant
-
Webinar
2.00 Credits
Member Price: $79
Data validation Underutilized, but powerful, formulas Formulas for manipulating, transforming, and cleansing data Formulas for data analysis Reference formulas such as =VLOOKUP Pivot tables
Audit 103: Adapting to the Engagement - Complying with SSARS
-
Webinar
2.00 Credits
Member Price: $89
The major topics covered in this course include:Compare and contrast the basis and requirements of preparing financial statements, compilations, reviews, and auditsCritical elements of compilation, review, and audit reportsImpact of special purpose accounting frameworks and other special issuesExercise on designing inquiries and analytics in a reviewCase study differentiating the scope of various non-attest and attest servicesAvoiding litigation risks in accounting services
Power BI - Introduction to MS Power BI Tools
-
Webinar
2.00 Credits
Member Price: $118
The challenge of using Excel for Data Analysis An overview of the various Power BI Tools An overview of when and why to use each Power BI Tool A tour of each tools interface
Secure Act 2.0 - Everything that you Need to Know
-
Webinar
2.00 Credits
Member Price: $79
Mandatory Automatic Enrollment Credit For Small Employer Pension Plan Startup Costs Enhancement Of The Saver’s Credit Increase In Starting Age For RMDs Indexing IRA Catch-Up Higher Catch-Up Limit Age 61, 62, 63, And 64 Student Loan Payments As Elective Deferrals For Matching Contributions Start Up Credit Costs For Employers Joining An Existing Plan Financial Incentives For Contributing To a Plan Withdrawals For Certain Emergency Expenses SIMPLE Plan changes Starter 401(K) Plans Sec 529 Plan To Roth Rollovers Emergency Savings Accounts Enhancement of 403(B) Plans Qualified Charitable Distributions to Split Interest Entity Retirement Savings Lost and Found
Staff Retention Keep the Best People
-
Webinar
3.00 Credits
Member Price: $99
Remote workforce Employee retention Staff turnover
K2's Securing Your Data: Practical Tools For Protecting Information
-
Webinar
4.00 Credits
Member Price: $159
Understanding today's cybersecurity risks Identifying major cybersecurity risks Implementing specific steps to reduce risk
Fraud Assessment for Small and Medium Sized Businesses
-
Webinar
4.00 Credits
Member Price: $129
The fraud triangle The fraud savvy model Symptoms of fraud Benford's Law The net worth method The vulnerability chart 10 steps for action today
Build a Data Model for Analysis in Power BI
-
Webinar
4.00 Credits
Member Price: $149
The major topics that will be covered in this class include:Data Modeling Essentials: Understanding the core concepts of data modeling in Power BI, including integration of various data sources.Building Relationships: Techniques to establish and manage relationships between different data sets.Calculated Columns and Basic DAX Measures: Introduction to DAX (Data Analysis Expressions) and its application in creating calculated columns and basic measures.Calculated Columns vs Measures: Insights into when to use calculated columns and when to opt for measures.Explicit vs Implicit Measures: Understanding the difference and appropriate application of explicit and implicit measures in data analysis.Hierarchies in Data: Creating and utilizing hierarchies to enhance data analysis and reporting.Using Pivot Tables to Validate Measures: Practical skills in using pivot tables within Power BI to validate and refine measures.
Leverage PowerBI.com to Create Data Analysis for Others
-
Webinar
2.00 Credits
Member Price: $89
The major topics that will be covered in this class include:Tour of the PowerBI.com Interface: An in-depth walkthrough of the PowerBI.com environment, focusing on user interface elements, navigation, and customization.PowerBI.com Concepts: Fundamental concepts of PowerBI.com, including its architecture, data handling capabilities, and integration features.Connecting to Data: Techniques for connecting various data sources to PowerBI.com, ensuring seamless data integration and synchronization.Visualizations and Dashboards: Creating impactful visualizations and assembling informative dashboards to present data compellingly.Q&A Feature: Explore the interactive Q&A feature to derive insights through natural language queries.Sharing Datasets, Reports, Dashboards: Best practices for sharing datasets, reports, and dashboards with different audiences so they can leverage your data analysis work.Creating Apps: Learn how to package reports and dashboards into apps for easy distribution and consumption.
Fraud Risk Management
-
Webinar
2.00 Credits
Member Price: $79
Fraud risk management Fraud risk assessments Data analytics Fraud risk management tools
Devious Ethics: Avoiding Snakes in Suits
-
Webinar
2.00 Credits
Member Price: $79
Discuss psychopathy's symptoms Review accounting professional ethics standards for dealing with a boss, co-worker or client who is breaking the rules Look at precautions you should take when considering a new boss or employee Help identify someone who might con you or your company
Introduction to Governmental Accounting
-
Webinar
2.00 Credits
Member Price: $79
Fund Accounting MD&A ACFR
Cost and Pricing Models: Creating an Effective Tool
-
Webinar
2.00 Credits
Member Price: $79
Building computer costing models & sub models The importance of volume sensitive models Your twelve most important indirect costs Using rate tables Modeling – Professional Services Job Costs Modeling – Repetitive Manufacturing Why return on sales may be an inferior way to plan for profit
Forgotten Managerial Accounting Tools for CPAs
-
Webinar
2.00 Credits
Member Price: $89
The major topics covered in this class include:Target profit analysisBreak-even analysisRelevant costs and decision-makingStandard costs and variancesActivity-based costingSegment reporting and analysis
Impact of GASB Activities on State and Local Government
-
Webinar
3.00 Credits
Member Price: $166
GASB statements issued GASB projects
Managing Your Money in Retirement
-
Webinar
3.00 Credits
Member Price: $99
Social Security Retirement Asset allocation Fraud
The Successful Family Business
-
Webinar
4.00 Credits
Member Price: $129
Business Management Organization
2024 Moving Beyond the Basics of Excel
-
Webinar
2.00 Credits
Member Price: $79
Using formulas to manipulate and transform data Using formulas and reference formulas such as =VLOOKUP Using pivot tables
Drive Results with Metrics
-
Webinar
2.00 Credits
Member Price: $79
Performance Metrics Budgets
PowerPoint for Accountants
-
Webinar
2.00 Credits
Member Price: $89
The major topics covered in this course include:Exploration of tabs within PowerPoint's ribbonInitial creation of a slide deckUsing slide mastersUtilization of external contentSmartArtAlignments and layoutsTips and tricks for efficiencyBest practices for effective presentation deliveryOther creative uses for PowerPoint