CPE Catalog & Events
Build a Data Model for Analysis in Power BI
-
Virtual
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.
Tax Depreciation: Review and Update
-
Virtual
2.00 Credits
The major topics that will be covered in this class include:Recent tax legislation and developments related to capitalizationEligible property for Section 179 and Section 168(k)Discussion of the Section 179 deduction and its use to depreciate real propertyThe Section 168(k) deduction and its use to depreciate real propertyDisposition of segments of real propertyExchanges of tangible personal property after repeal of the like-kind exchange rulesOther related topics
Surgent's Basics of Employment Law for Non-HR Professionals
-
Virtual
4.00 Credits
How the application of policies and employment laws within the workplace can reduce employee complaints, and protect your company from claims of discrimination or wrongful behavior Examining wage and pay practices, FMLA examples, and other challenging workplace questions, to insure actions are consistent with laws/policies Key functions of employment including recruitment, interviewing and selection
Surgent's Hiring New Workers and Payroll Taxes
-
Virtual
2.00 Credits
Form W-4 Form I-9 Form W-9 End-of-year compliance Payroll tax returns Unemployment insurance
Surgent's Successfully Completing a Gift Tax Return -- Form 709
-
Virtual
2.00 Credits
Taxpayers who do not file gift tax returns but should The annual exclusion rules for gifts to trusts including required Crummey notices What should be disclosed on the return for purposes of running the statute of limitations The reporting of installment sales and split-interest Valuations and valuation discounts for gifts of closely held businesses The utilization of Generation Skipping Transfer Tax and the related automatic allocation rules Reporting the use of a deceased spouse’s unused exclusion exemption amount (DSUEA) A line-by-line explanation of Form 709
ChatGPT Bootcamp for CPAs with John Higgins
-
Virtual
4.00 Credits
The major topics that will be covered in this course include:Review the history of ChatGPTTour of the ChatGPT app and how to use itSetting up a ChatGPT account (free & premium)Variety of hands-on case study examples for accounting, finance and taxA look under the hood at how ChatGPT worksCaution - how to avoid risks in using ChatGPTA look into the future potential for AI in business
Enterprise-Wide Risk Management in Accounting and Finance
-
Virtual
4.00 Credits
The major topics that will be covered in this course include:Enterprise-wide risk management best practices for identifying, evaluating, and determining how to respond to relevant risks.The importance of risk and uncertainty disclosures in the preparation and fair presentation of financial statements, including evolving risks with cybersecurity and ESG.Coordinating risk management efforts, including the required involvement of corporate governance.How to embed risk management into day-to-day accounting and finance activities.
The Leadership Skills of Tomorrow: Delegate and Listen
-
Virtual
2.00 Credits
The major subjects that will be covered in this course include:Three levels of listeningStrategies to remain focusedBuilding trust through listeningTactics to practice the Titanium RuleDelegating with confidenceEstablishing an accountability system
Excel for Accounting Professionals Session 2: Data Validation and Conditional Formatting
-
Virtual
2.00 Credits
Data validation Conditional formatting Subtotal function Reduce formula errors Skinny row
The Ethic of Teamwork
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Virtue ethicsTeam dynamicsCharacteristics of highly effective teamsMeeting managementTeam communicationDecision making
GPT Builder for Accountants
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Introduction to GPT Builder platform and interface for accounting professionalsCreating accounting-specific custom instructions and knowledge basesImplementing financial data analysis capabilities through GPTsDesigning GPTs for tax preparation assistance and compliance checkingBuilding client communication tools with accounting terminologyEnhancing bookkeeping efficiency with automated GPT workflowsSecurity and confidentiality considerations for financial data
Taking Advantage of Array Formulas in Excel
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Introduction to Array Formulas: This segment establishes the foundation by differentiating array formulas from regular Excel formulas and explaining their significance.Using Array Formulas: This section focuses on the practical application of array formulas, teaching participants how to effectively implement and utilize these formulas in a variety of common Excel tasks and scenarios.Dynamic Arrays and Spill Functions: This part covers the utilization of dynamic arrays and spill functions, highlighting their role in modern Excel data handling.Advanced Array Functions: Participants will delve into complex functions such as SUMPRODUCT, UNIQUE, SORT, and FILTER, focusing on multi-condition summing and data management.Using Array Constants: This section teaches how simplify the use of static values called Array Constants
Accounting of the Soul: Making the World a Better Place
-
Virtual
1.00 Credits
The major topics covered in this course include:Overview of Virtue Ethics and the Common GoodProfessionalismThe Virtue of CompassionGossip in the WorkplaceGratitude
Clean, Transform & Load Data in Power BI
-
Virtual
2.00 Credits
The major topics that will be covered in this class include:Introduction to Power Query in Power BI: Understanding the interface and basic functionalities.Data Cleaning Techniques: Removing duplicates, handling null values, and data type conversions.Data Transformation: Advanced methods for manipulating data, including pivoting, merging, and appending queries.Data Loading: Efficiently loading data into the Power BI data model.Document the Process Steps: Setting up details for each step in the process so you can document what is happening and why.
2024 Revision to Government Auditing Standards Impact
-
Virtual
4.00 Credits
The major topics that will be covered in this course include:Key changes made by the 2024 Revision to Government Auditing StandardsReview when the GAGAS requirements are applicable to a financial statement auditWhen reporting on key audit matters may apply in a GAGAS auditClarifications related to the independence requirements in a financial statement audit imposed by the 2024 Yellow BookReview the impact of the Quality Management Standards to a financial statement audit conducted under the 2024 Revision to Government Auditing StandardsOther important matters contained in the 2024 Government Auditing Standards related to financial statement audits
Tax Season Update for Individuals with Steve Dilley
-
Virtual
4.00 Credits
The major topics covered in this class include:2024/25 legislative developments, cases and rulings impacting individual taxpayersChanges to Form 1040 and other related forms, worksheets and schedulesIndividual income items, itemized deductions and creditsUpdated tax rate schedule and other inflation adjusted itemsImplications for self-employed taxpayers of various legislationSection 199A changes, including use of carryforward passive activity and 199A lossesCapital gains and lossesPassive activity and hobby loss rules changes
How Changes in Business Methods Affects Internal Control
-
Virtual
8.00 Credits
The major topics covered in this class include:How is business changing.What is driving the change and how long will it last.How specifically is an organizations control system important.What steps are needed to “keep up” with the upheaval.
Surgent's Annual Accounting and Auditing Update
-
Virtual
8.00 Credits
Recently issued FASB Accounting Standards Updates, PCC Update and items on the FASB’s Technical Agenda Leases – Topic 842 Recently issued ASUs covering common control leases, crypto assets (e.g., cryptocurrency), and income tax disclosures ASC 326: CECL Review of SAS 142 – Focus on Audit Evidence Recently issued SASs and other AICPA activity SSARS No. 25 and other recently issued SSARS Detailed review of SAS 145 Other important A&A practice matters
Surgent's Predicting Future Financial Issues Facing the Financial Executive
-
Virtual
8.00 Credits
CPA becoming attuned to broad based business knowledge, professional skepticism, and subordination of judgment The future of medical care in the United States in a post COVID-19 environment Future of social security and impact on retirement planning and employee retention Impact on financial executive if the dollar is no longer the world currency “Fate of the States” – will the location of your business make you less competitive Future of workmen’s compensation and unemployment compensation Future of interest rates Impact of greater reliance on technology AICPA top 10 trends and technologies National infrastructure ESG and DEI trends in the global economy Impact of continuing uncertainty in markets
S Corporations: Calculating Shareholder Basis
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Discuss the calculation of basis when the entity is formed including the impact of contributed propertyExplain the importance of shareholder loans to the entityUses a comprehensive example to illustrate the mechanics of the basis determination processSchedule K-1 Basis and Form 7203Discuss how basis is impacted by distributions of corporation propertyExplain how basis is impacted by sale/or liquidation of the S corporation interestDiscuss how S corporation losses impact Form 1040 Schedule E reportingShow how to get from the Schedule K-1 information to the basis calculations
