CPE Catalog & Events
Build a Data Model for Analysis in Power BI
-
Online
4.00 Credits
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.
Interpreting the New Revenue Recognition Standard: What All CPAs Need to Know
-
Online
4.00 Credits
5-step process for recognizing revenue
2024 Annual Update for Accountants & Auditors
-
Online
8.00 Credits
The major topics that will be covered in this course include:Accounting Standard UpdatesProjects identified by the FASB's Invitation to Comment: Agenda Consultation.Year 2 considerations for leases including modification accounting.The impact of the changes to auditing group auditsThe status of the AICPA's quality management project management.The current work of the ASB.
Surgent's Latest Developments in Government and Nonprofit Accounting and Auditing
-
Online
8.00 Credits
Developing issues related to Yellow Book audits and single audits Key AICPA developments affecting audits of governments and nonprofits (including SAS No. 145 on risk assessment) Recent GASB activities directed toward state and local governments (e.g., the implementation of GASB Nos. 100 and 101, and additional GASB projects) Lessons learned by nonprofits (and lessons remaining) from the implementation of FASB ASC 842, Leases and ASU No. 2020-07 related to contributions of nonfinancial assets Other issues related to nonprofits
2024 Yellow Book Update
-
Online
2.00 Credits
The major topics that will be covered in this course include:Yellow Book engagements.Independence requirements in GAGAS.Quality management in Yellow Book. Common deficiencies found in Yellow Book engagements.
The Ethical Side of Trust, featuring Richard A. Karwic and Don Minges
-
Online
1.00 Credits
The seven components of trust High standards, loyalty, doing the right thing, listen, empathy and accountability The value of trust How ethics relates to trust and how trust relates to ethics
2024 Common Deficiencies in Employee Benefit Plans
-
Online
2.00 Credits
Common Defiencies DOL EBPs
Introduction to Single Audit
-
Online
2.00 Credits
Compliance Federal Funds Single Audit
Inventory Accounting GAAP, Software and Recognizing Variances
-
Online
2.00 Credits
Inventory accounting GAAP Methods for dealing with variances
Surgent's Starting a Small Business: What Every Trusted Advisor and Entrepreneur Needs to Know
-
Online
2.00 Credits
Understanding the time commitment required to start and run a business Selecting a corporate structure to protect your personal assets Building your product or service Sales and marketing in your business Establishing your owners, investors, managers, and employees Accounting, recording-keeping, and other software programs Leases, contracts, and employee agreements Protecting intellectual property Insurance Business plans Financing Market position
The Trustworthy Leader: Ethics and Trust in a Time of Social Change
-
Online
2.00 Credits
Ethics Leadership
Triple Your Memory, Prevent Dementia and Halve Your Stress - Part 1
-
Online
4.00 Credits
Why the brain can remember some things a hundred times better than others Why we typically forget names and faces, and what can be done about it How our emotions follow the motion of our body, and how that can be used to instill instant confidence How to tap into a completely relaxed and/or confident state of mind in 10 seconds or less using advanced hypnotic conditioning and Neuro-Linguistic Programming techniques How to prevent dementia and brain “fog” using specific supplements and exercise How to stay motivated to use the methods outlined in this course to advance your career and achieve a higher quality of life How to use the concept of constant learning to help you maintain a balanced and fulfilling
2024 Excel Essentials for Today's Accountant: Become an Expert in One Day
-
Online
4.00 Credits
Using formulas to manipulate and transform data Using formulas and reference formulas such as =VLOOKUP Using pivot tables Understanding Solver to perform multivariate analysis Awareness of advanced functions Creative methods for data manipulation Using intellectual curiosity and professional skepticism to develop a problem-solving mentality Real-life examples of innovative ways to analyze and report data with Excel Using Excel to perform e-mail merges Enhance creativity in your approach to developing Excel models Computer software and application
Data & Predictive Analytics & Business Intelligence for Controllers/CFOs
-
Online
4.00 Credits
DA and BI relationship to accountant value. Current trends in BI and DA, including the emergence of AI tools like ChatGPT. The changing accountant roles: data analyst, data scientist, and data storyteller, with an emphasis on how ChatGPT can be utilized in these capacities. Obtaining datasets to compare and contrast with their organization's data, and how ChatGPT can assist in analyzing and interpreting this data. BI tools and the inclusion of AI technologies such as ChatGPT to streamline processes and improve analytical capabilities.
2024 Tax Depreciation: Review & Update
-
Online
4.00 Credits
Recent tax legislation, rules and developments related to capitalization and depreciation Capitalization of tangible property, including materials and supplies, building and improvements Small taxpayer safe harbor Section 179, including 2020 inflation adjustment Section 168(k) 100% bonus deduction
IRAs - Contributions & Distributions for Traditional, Roth, SEP & SIMPLE IRAs
-
Online
8.00 Credits
An emphasis on newly enacted tax legislation affecting IRAs including the NEW final required minimum distribution (RMD) regulations Contribution limits to and tax treatment of distributions from Traditional, Roth, SEP and SIMPLE IRAs Deductible phase-out limits for Traditional IRA contributions for taxpayers that are active participants in qualified retirement plans Roth IRA contribution phase-out limits as well as tax-free qualified distributions Planning opportunities for conversions to ROTH IRAs Rollover rules to/from different retirement accounts and the one-rollover-per-year limitation The different options of receiving IRA distributions before age 59 ½ and avoiding the 10% early distribution penalty (including substantially equal periodic payments) The required minimum distribution (RMD) rules from IRAs needed to avoid the 50% penalty after the account owner turns age 72 or dies The tax ramifications of spouse and non-spouse beneficiaries and how this affects the RMD calculation after the account owner’s death Overview of health savings account (HSA) eligibility rules, contribution limits and distribution rules
Federal Tax Update - C & S Corporations, Partnerships & LLCs (Forms 1120, 1120S & 1065)
-
Online
8.00 Credits
Discuss the most recent business income tax legislation passed to date Review numerous business income tax provisions including but not limited to the 20% qualified business income (QBI) deduction; changes to NOLs, §461(l) business loss limitations, §163(j) business interest deduction limitations, accounting method changes, depreciation, fringe benefits and entertainment expenses Brush up on issues related to compensation, distributions, liquidations, self-employment taxes and retirement plan Look at any changes to the Forms 1120, 1120S, and 1065 and other related schedules and forms
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
ACPEN Signature 2024: Annual Tax Update
-
Online
8.00 Credits
Our panel of national tax experts will explain as they discuss federal tax changes and developments during 2024 and pending changes, including legislative, administrative and procedural changes of which you need to be aware ACPEN will give you the best information anywhere on current tax issues…current to the day of the broadcast! Explore in detail the latest statutory, regulatory and judicial developments impacting tax issues. Get the latest details and all the developments in this up-to-the minute tax program that you won't want to miss.
ACPEN Signature 2024: Financial Statement Preparation: Compilation and Review Update
-
Online
8.00 Credits
Ethics Update Preparation Engagements Compilation Engagements Review Engagements Hot GAAP Topics New Quality Management Standards