CPE Catalog & Events
Practical Excel Topics for Today's Accountant
-
Online
2.00 Credits
Member Price: $109
Data validation Underutilized, but powerful, formulas Formulas for manipulating, transforming, and cleansing data Formulas for data analysis Reference formulas such as =VLOOKUP Pivot tables Solver as a tool for performing multivariate analysis Mail merge Custom formatting
Ethical Intelligence for Artificial Intelligence
-
Online
2.00 Credits
Member Price: $89
The major topics that will be covered in this course include:Benefits and pitfalls of artificial intelligence in the accounting professionSelecting and utilizing artificial intelligence resourcesApplying professional skepticism to resultsMaintaining independence while utilizing artificial intelligenceUpholding client confidentialityData security and retentionCitation of sources and related reporting considerationsApplication of the AICPA Code of Professional ConductEthical considerations when crafting policies and establishing best practices
Treasury Circular 230 for EAs and Other Tax Preparers
-
Online
2.20 Credits
Member Price: $109
Circular 230 Conflicts of interest Loving case RTRP Other Ethical Issues Fees Qualifying continuing education
Dashboard and Report Design Principles Using Excel
-
Online
4.00 Credits
Member Price: $159
Principles of Visual Design for Dashboards and Reports Chart Design for Rapid Understanding Table Design for Efficiency Effective Use of Commentary Strategic Layout Techniques Trend Analysis Methods Developing Organizational Design Standards Excel Application Techniques Critical Review Skills Best Practices for Data Presentation
Financial Statement Analysis
-
Online
4.00 Credits
Member Price: $159
Purposes of financial statement analysis Trend analysis and vertical & horizontal analysis Simple and multivariate regression; Analysis of metrics Assessment of liquidity, solvency, and profitability Using data visualizations The role of qualitative factors
Topic 842 - Implementing Leases Workshop
-
Online
4.00 Credits
Member Price: $159
Accounting Yellowbook Leases Standards ASC 842
Ethics - A Line in the Sand; Implications for Daily Business
-
Online
4.20 Credits
Member Price: $159
Recognize the underlying drivers of individual ethical behavior Identify the relationship between ethics and integrity Highlight ethical trends in businesses throughout the world Review high profile ethics lapses in recent years
Hot Topics Audit & Attest Update
-
Online
2.00 Credits
Member Price: $89
The major topics that will be covered in this course include:Recent quality improvements to the SASs and SSARsOther matters that should be on your radar
Retaining Top Talent: Strategies for CPA Firms
-
Online
1.00 Credits
Member Price: $55
To purchase the report referenced in this presentation, or any of the research papers published by CPA Crossings, visit https://www.cpacrossings.com/research. The major topics that will be covered in this course include: The true cost of turnover versus retention investment Research findings on why professionals leave or stay Whole-person retention strategies beyond compensation Work-life balance solutions that maintain productivity Career development paths for non-partner track professionals Business model transformations for sustainable staffing Technology and outsourcing strategies to reduce burnout Retention strategies specific to diverse talent and younger professionals
Global Internal Audit Standards (GIAS) Domain II - Part 2
-
Online
2.00 Credits
Member Price: $109
Internal Audit Standards GIAS Accounting Internal Controls
Partnership/LLC Taxation: Understanding Tax Basis Capital Accounts
-
Online
2.00 Credits
Member Price: $109
Discussion of the impact of the Section 199A flow-through entities deduction on partnerships and their partners The meaning of a "tax basis capital account" - how do the financial accounting and tax capital accounts differ from one another How to determine a partner's share of the partnership's liabilities Distinguishing "recourse" loans from "nonrecourse" loans What are "qualified nonrecourse financing" & loans and how they affect partners Section 704 "built-in gain or loss" & ules and how they impact Schedule K-1 reporting Section 465 "at risk" rules and how they impact Schedule K-1 reporting
Create Paginated Reports with Power BI Report Builder
-
Online
2.00 Credits
Member Price: $89
The major topics that will be covered in this class include:Introduction to Power BI Report Builder: Overview of the tool, its interface, and integration with the Power BI ecosystem.Designing Report Layouts: Techniques for setting up professional layouts, including headers, footers, and managing pagination.Data Connection and Management: Connecting to various data sources and preparing data for reporting.Creating Visualizations: Utilizing Power BI’s visualization tools for impactful data presentation.Advanced Report Features: Exploring sub-reports, drill-through capabilities, and dynamic expressions.Publishing and Sharing: Guidelines for publishing reports to the Power BI service and sharing them with relevant stakeholders.
Nonprofit A&A Standards Update and New Developments 25-26
-
Online
2.00 Credits
Member Price: $99
Pledges and contributions Restrictions and conditions Special concerns with governmental funding Donated goods and services Special events Revenues earned through sales and services to customers
Preparing to be a Forensic Accountant - Focus on Computer Forensics - Part 3 (Steganography)
-
Online
1.60 Credits
Member Price: $79
Forensic Accounting Accounting Auditing Finance
The Controllers Role in Data Analytics and Big Data
-
Online
1.50 Credits
Member Price: $79
Accounting Finance Financial Statements
Real Estate Professionals: Passive Activity Rules
-
Online
2.00 Credits
Member Price: $109
Definition, pros and cons of being a real estate professional Integration of the real estate professional rules with reporting on Form 1040, Schedule E Real estate professionals and indirectly owned (partnerships, S corporations) entity's reporting on Form 1040 How "real estate business" is interpreted under the Section 199A rules and how it integrates with the passive activity rules
SAS 145: Modern Risk-Based Auditing
-
Online
2.00 Credits
Member Price: $109
Introducing SAS 145 Revisiting audit risk Risk assessment in the SAS 145 Era Analyzing SAS 145 Documentation requirements
Ethics in the World of AI: An Accountant's Guide to Managing the Risks
-
Online
2.00 Credits
Member Price: $125
Business uses of AI Nine risk areas of AI Three ethical frameworks Risk mitigation strategies
Excel for Accounting Professionals Session 1: Tables and Named References
-
Online
2.00 Credits
Member Price: $125
Excel conventions Critical shortcuts Named references Tables
Finding Errors in Excel Spreadsheets
-
Online
2.00 Credits
Member Price: $89
The major topics that will be covered in this class include:Understanding Common Excel Errors: Gain insights into the most common types of errors encountered in Excel, including formula errors, reference errors, and logic errors.Advanced Formulas and Functions: Learn to use advanced Excel functions and formulas that are crucial for error detection and data analysis.Data Validation Techniques: Master the art of data validation to prevent errors before they occur. This includes setting up data validation rules and using conditional formatting to highlight potential inaccuracies.Error Tracing and Auditing Tools: Delve into Excel's auditing tools to trace and fix errors. Learn to use Trace Precedents, Trace Dependents, and the Error Checking tool effectively.