CPE Catalog & Events
The Successful Family Business
-
TBD
4.0 Credits
Member Price: $129
Business Management Organization
Complete Guide to Analyze Data with Excel PivotTables
-
TBD
4.0 Credits
Member Price: $149
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.
Walter Haig's Business Financial Health Checkup
-
TBD
8.0 Credits
Member Price: $239
The major topics that will be covered in this class include:How to use analytical procedures as a management tool to identify areas hindering the profitability of the entityHow to use analytical procedures to identify misstatements in financial informationTechniques for developing a "workable" business planRecasting GAAP financial statements into powerful management toolsDeveloping and using benchmarks to identify profitability problemsIdentifying profitability key factorsThe relationship of internal controls and the health of an entityCommon weaknesses in the internal controls of SMEs using the guidelines in the COSO Report on Internal Controls and common internal controls to address those weaknessesHow to create "goal" statements that achieve results
CPA to CFO
-
TBD
1.0 Credits
Member Price: $55
The major topics that will be covered in this course include:The steps necessary to effectively transform a tax or accounting practice into an advisory service.What it means to be a CFO/advisor to small-to-medium sizes businesses.What qualifications are necessary to offer an advisory service.How to find and convert leads and how to price and package services, including combining advisory services with the firm’s current offerings.
Excel Tips & Tricks for the Non-Accountant
-
TBD
2.0 Credits
Member Price: $79
Understanding the workbook and worksheet environment Obtaining and utilizing data Editing and formatting The “Insert” Menu The “Page Layout” Menu The “View” Menu Selecting and using formulas Shortcuts and tricks
Synchronize Your Files to the Cloud with SharePoint -Updated
-
TBD
2.0 Credits
Member Price: $89
The major topics covered in this course include:Overview of the OneDrive Sync app functionalityStep-by-step review and demonstration of how to deploy this appInstalling the Sync app on your local devicesConfiguring the files and folders to synchronize toy your local deviceManage the locally stored filesBest practice tips for using the Sync app and avoiding common mistakes
Accommodation Requests - Substance Abuse - Contagious Infections
-
TBD
1.0 Credits
Member Price: $39
Accommodation requests - religious practices Accommodation requests - disabilities Substance Abuse - constructive confrontation Substance Abuse - duty to accommodate as a disability Disclosures of potentially contagious infections
Making Culture A Competitive Advantage
-
TBD
1.0 Credits
Member Price: $39
Talent Strategy Culture Employee Engagement Employee Retention Leadership Leadership Strategy
Global Internal Audit Standards (GIAS) - Overview and Contrast to 2017 International Professional Practices Framework (IPPF)
-
TBD
1.6 Credits
Member Price: $79
Accounting Internal Controls Internal Audit Standards
Ethical Intelligence for Artificial Intelligence
-
TBD
2.0 Credits
Member Price: $79
Benefits and pitfalls of artificial intelligence in the accounting profession Selecting and utilizing artificial intelligence resources Applying professional skepticism to results Maintaining independence while utilizing artificial intelligence Upholding client confidentiality Data security and retention Citation of sources and related reporting considerations
Introduction to Yellow Book
-
TBD
2.0 Credits
Member Price: $79
AICPA Code of Professional Conduct Accounting & Auditing Yellowbook
Accounting and Disclosure Issues After a Natural Disaster
-
TBD
2.0 Credits
Member Price: $89
The major topics that will be covered in this course include:Current and noncurrent asset impairment. Insurance claims and related recoveries. Debt and liquidity issues. Government assistance and relief. Subsequent Events. Lease modifcations. Other matters.
Common Sense CFO: Balance Sheet Issues Walk through to Understand and Build Value
-
TBD
2.0 Credits
Member Price: $79
Typical accounting issues that impact the balance sheet Where are the hidden issues in unrecorded liabilities? What are unrecorded assets and why they matter? Identification of and resolution of balance sheet challenges and changes Communicating to your audience and stakeholders
Surgent's Excel Budgeting Ideas
-
TBD
2.0 Credits
Member Price: $99
Set up an in-cell drop-down list of budget methods Change the calculations in the cells based on the selected budget method Use names in worksheets
Surgent's Food, Beverage, and Entertainment Expensing
-
TBD
2.0 Credits
Member Price: $99
The 50% deduction for meals that are ordinary and necessary in carrying on a trade or business Elimination of the temporary rules that applied for 2021 and 2022 which allowed for 100% deductibility for ordinary and necessary business-related meals When meals are still 100% deductible IRS rules relating to the nondeducibility of activities considered entertainment or amusement What constitutes entertainment/amusement for tax purposes? When employers may deduct food and beverages provided to employees 50% deductibility for occasional employee meals and for overtime meals 50% deductibility for business meals during business meetings Business meals incurred during business travel Invoice meals separately from entertainment
SAS No. 122, AU 315, Understanding the Entity and Its Environment and Assessing the Risks of Material Misstatement
-
TBD
3.0 Credits
Member Price: $99
How the effect of a misstatement due to error effects the scope of our audit vs a misstatement due to fraud Inquires of management …….. and others The audit planning process; when we start and when we stop The importance of brainstorming and what two things should a talk about Revisions of our risk assessment Determining materiality
Dashboard and Report Design Principles Using Excel
-
TBD
4.0 Credits
Member Price: $129
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
Critical Technical Skills for CFOs and Controllers
-
TBD
4.0 Credits
Member Price: $129
A methodical approach to business and strategic planning Overview of The Balanced Scorecard approach to creating key performance metrics Common metrics for analyzing financial statements and trends Accounting and finance role in Enterprise-wide Risk Management (ERM)
K2's Excel Best Practices
-
TBD
8.0 Credits
Member Price: $225
Best practices associated with creating Excel workbooks, including managing workbooks How to secure Excel workbooks Collaboration options and best practices in Excel Effective reporting techniques in Excel
Federal Tax Update - Individual & Business Current Developments
-
TBD
8.0 Credits
Member Price: $300
Discuss the most recent individual and business income tax legislation passed to date Walk through major tax changes to corporations, partnerships and/or individuals and any changes to the income tax forms and other related schedules 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, retirement plans, fringe benefits and entertainment expenses Brush up on the individual and business income tax rates (e.g., income tax rates, capital gain tax rates, self-employment tax and alternative minimum tax (AMT), 3.8% net investment income tax) Discuss other individual income tax topics and changes to filing status, personal exemptions, itemized deductions, exclusions from income, adjustments to income and income tax credits (e.g., child tax credit and dependent care credit) Walk through the NEW final required minimum distribution (RMD) regulations Review other important IRS audit areas such as basis and at-risk limitations for S shareholders and partners, passive activity losses and real estate professionals and self-employment taxes