CPE Catalog & Events
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.
Cost and Pricing Models: Boost Your Bottom Line
-
Online
2.00 Credits
Cost Accounting Activity-based Costing
Defining Where and Why Internal Controls are Needed
-
Virtual
2.00 Credits
The major topics covered in this course include:Control design basicsAreas or segments of an enterprise to controlControls to reduce riskControls to drive operations
The Ethics of Care in the Workplace
-
Virtual
2.00 Credits
The major topics that will be covered in this class include:Ethical Values and PrinciplesCompassionManaging ExpectationsRespect and HumilityAttribution Theory
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
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
Money Laundering 101 for CPAs
-
Virtual
4.00 Credits
The major topics covered in this class include:The theory of money launderingCommon money laundering statutesExamples from court cases of money laundering statutesCommon occurrences with CPAsPossible money laundering transactionsApplying the money laundering statutes in real life scenarios
The New Quality Management Standards - What Everyone Needs to Know
-
Online
2.00 Credits
Overview of the new quality management standards Focus on the most important elements of a quality management system Implementation tips that everyone in the firm should know Audit and attest standards impacted
2024 PCAOB and SEC Update
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Developments at the PCAOB.Recent trends in SEC comment letters.Enforcement actions and administrative proceedings.Conclusions and predictions for the future.
Budget Mastery: The Human Side of Budgeting-Navigating People's Issues with 360 Insight
-
Online
2.00 Credits
Understanding your own leadership tendencies and applying them to your strengths? Understanding core personality types Learning what type of person you are? Managing and coping with the budget team Effectively dealing with the A, B, C and other players?
Analyzing Financial Statements
-
Virtual
2.00 Credits
The major topics that will be covered in this class include:Balance sheet analysisIncome statement analysisCash flow statement analysisClues in the notes and MD&AIndustry nuances
2025 Not-for-Profit GAAP Update
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Accounting Standard Updates issued by the FASB.Not-for-Profit Advisory Committee (NAC) and the projects they are advising the FASB on.
Surgent's Forms 7217 and 7203
-
Virtual
2.00 Credits
Tax treatment of partnership distributions to partners of cash and property other than cash Basis of property received in a partnership distribution IRS’s new regulations regarding basis shifting in favor of high-marginal tax rate related partners Organization and structure of the new Form 7217 Who must file Form 7203 Determining the S corporation shareholder’s initial basis in his or her stock Basis limitations on partnership losses and deductions Organization and structure of Form 7203 — understanding the three parts of Form 7203 Filing criteria for Form 7203 Calculating an S corporation shareholder’s share of S corporation deductions and credits Understanding stock and debt basis
Surgent's Virtual Currency: Keeping Up with the Tax Code
-
Virtual
2.00 Credits
Overview of virtual currency Property transactions with virtual currency Receiving virtual currency as payment Paying using virtual currency Charitable donations with virtual currency Gifting of virtual currency Form 8300 reporting
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
Coping With the Growth of Online Fraud
-
Virtual
4.00 Credits
The major topics covered in this course include:The actuation of online and other cyber fraudsFraudulent acts that are initiated electronicallyAutomated and employee driven methods that can reduce cyber-fraud risk
Ethics: Avoiding the Slippery Slope of Ethical Pressures
-
Virtual
4.00 Credits
Benefits of ethical behavior Six steps to creating and maintaining an ethical culture Example of unethical behavior in ethical companies
Taxation of the Cannabis Industry
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Industrial hemp vs. marijuana.Income definitions under I.R.C. §61.Tax code restrictions: §280E and §471.State-specific marijuana laws.Cash management in cannabis businesses.Federal court case analysis.
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
Topic 842: FASB's Lease Accounting Standard Update
-
Online
2.00 Credits
What is a lease? Recognition and measurement of lease assets and liabilities Impact on lessors and lessees Disclosures and transition rules Effective dates
