CPE Catalog & Events
ChatGPT and Advanced Financial Analysis for Accountants
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Financial Modeling with ChatGPT IntegrationAdvanced Ratio Analysis TechniquesRisk Assessment and Scenario AnalysisValuation Methods and ChatGPT ApplicationsUtilizing Performance Metrics in Financial AnalysisData Analysis and Interpretation with AIInvestment Analysis Enhanced by ChatGPT
Getting SASsy - A Look at Recent Auditing Standards
-
Online
1.00 Credits
Revised audit report layout Various auditing standards that will soon be effective Selected-procedures engagements and other attestation developments
Cash Management: Strategies for Long-Term Success
-
Online
2.00 Credits
Developing short-term cash flow projections How do we assure adequate cash availability without having idle cash? Take advantage of your bank’s cash management services Working capital loans Controlled disbursement accounts Sweep accounts and other short-term investments ACH transactions Direct transfers Lock boxes Credit and collections Reconciliation frequency Managing cash short-falls
Considerations of Fraud
-
Online
2.00 Credits
AU-C 240 Auditing Yellowbook
Ethics: How to Give and Receive Criticism the Right Way
-
Virtual
2.00 Credits
The major topics covered in this course include:Entertaining lecture by a professional presenter, illustrated with relevant video clips and photographs, to cover the main points of the webinarWriting exercises, so you can see how these lessons apply to your own CPA practice and personal lifeTrue stories about CPAs and other leaders to show what can happen when apologies and criticism are done right, and the pitfalls of doing them the wrong way
Surgent's Excel Lookups: Moving Beyond VLOOKUP Limitations
-
Virtual
2.00 Credits
Using lookup functions as an alternative to direct cell references Understand the limitations of the VLOOKUP function Discover ways to move beyond these limitations
Surgent's Exploring Business Valuation Fundamentals
-
Virtual
2.00 Credits
What does value mean? Technical vs. fundamental analysis Intrinsic value Other discounted cash flow models Assumptions in the Gordon Growth Model Valuations using free cash flows Residual income model Enterprise value Value in mergers and acquisitions Small business valuations and discounts Advanced valuation models
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
Roadmap to Ethical Decision Making
-
Online
2.00 Credits
Provide best practice tips and practical strategies for preserving independence when assisting clients with technical matters Discuss the principles of professional conduct Address compliance with professional standards Use case studies to address circumstances that may create threats to independence
K2's Advanced Topics In Power BI
-
Online
2.00 Credits
Creating formulas in Power BI with Data Analysis Expressions Adding Key Performance Indicators to your Power BI reports and dashboards Managing security in Power BI Publishing your reports and dashboards to Apps and Content Packs for easy sharing with other team members
The 10 Must Know Excel Features
-
Virtual
2.00 Credits
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.
Complete Guide to Analyze Data with Excel PivotTables
-
Virtual
4.00 Credits
The major topics that will be covered in this course include:Introduction to PivotTables: Gain a solid understanding of what PivotTables are, their benefits in Excel, and how to prepare your data for creating effective PivotTables.Creating and Customizing PivotTables: Learn step-by-step how to build and format PivotTables, including filtering, sorting, and customizing layouts for optimal data analysis. Focus on Using PivotTables to Analyze Data: Explore techniques to summarize, group, and compare data with PivotTables, uncovering trends and insights for better decision-making.Advanced PivotTable Features: Discover advanced tools such as slicers, timelines, and using PowerPivot for deeper analytical capabilities. Data Visualization with PivotCharts: Learn to create PivotCharts from your PivotTables and customize them to visually present data insights effectively to stakeholders.
Guide to Deducting Travel, Meals and Entertainment Expenses
-
Online
4.00 Credits
Recent tax legislation, rules and developments impacting travel and meals expense reporting Adequate accounting rules for reimbursements, including accountable plans, going paperless, reimbursement for non-deductible expenses Reporting travel expenses: travel status, simplified per diem "Directly related to" and associated with" tests Facility vs. activity expenses 9 exceptions to Section 274 Business meals: IRS Notice 2018-76
Build Better Budgets: Fundamental Techniques
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Advantages of budgetingThe role of budgetingMaster budgetingFlexible budgetingStandards and variancesCapital budgeting
Building Your Personal Net Worth: Invest in Your Future
-
Online
2.00 Credits
Why people who appear wealthy may be living paycheck to paycheck Why a millionaire may be living in the ordinary house next door Early and mid-career strategies for accumulating wealth Where and how to invest your money Why fees and commissions should concern you Strategies for buying stocks, mutual funds and ETFs
Ethics at Work: Diversity, Equity and Inclusion
-
Virtual
2.00 Credits
The major topics covered in this class include:Overview of ethicsEthical values and principlesDEI working definitionsUnconscious bias, assumptions, microaggressionsStanding Up and Speaking OutDEI and Organizational Responsibility
Surgent's Excel Tables and Conditional Summing
-
Virtual
2.00 Credits
Using the Table object to store data Using the conditional summing function to aggregate Table data Using the Table object to create mapping tables
Building a Better Budget in a Time of Uncertainty
-
Virtual
4.00 Credits
The major topics that will be covered in this class include:Budgets vs. ForecastsCyclicalityCore Earnings & Sustainable GrowthIdentifying Key Forecast DriversReasonableness in ForecastingApproaches to BudgetingBudgeting VariancesHorizontal AnalysisFlexible Budgeting
Criminal Tax: How CPAs Bring Value to Defense Attorneys
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:The common weaknesses in a criminal tax investigation.The key documents to review (In a sea of thousands of documents).Crafting questions to recommend in court proceeding.
Casualty Losses: Disaster Relief Act of 2024
-
Virtual
1.00 Credits
The major topics that will be covered in this course include:Federal Disaster Relief Act provisions enacted in December, 2024Comparison of personal use casualties with business/investment casualtiesWhen to claim casualty lossesHow to postpone casualty gainsBusiness casualty gains and depreciation recapture
