CPE Catalog & Events

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.

What is the significance of the Retirement Plan Beneficiary? Primary vs. Contingent Beneficiaries Is a Trust a "Designated Beneficiary?" Is it an "Eligible Designated Beneficiary?" Why do people want to name a trust as the beneficiary? What happens when the trust beneficiary dies?

Ethics defined Are there business ethics? How to identify ethical issues Deciphering your ethical code Why ethical behavior is good for your business How to make ethical decisions

The major topics that will be covered in this class include:Overview of the key Teams appsEverything there is to know about composing messages in TeamsUsing Teams to manage files, email messages and other contentBest practices for structuring your teams and channelsHow to use "private" channelsHow to use Teams as your primary phone systemManaging your Teams settingsEstablishing links to other Microsoft 365 applicationsHosting a Teams meeting from A to Z

Business Management Organization

The major topics covered in this course include:Lightning round review of the following apps, with an explanation and demonstration of what each of them offersTeams - the foundation of all that you do in Microsoft 365SharePoint / OneDrive - secure cloud storagePower BI - the new financial reporting modelStream - the YouTube for your organizationBookings - streamline your appointment scheduling OneNote - get your content organized for quick retrieval Lists - create custom list tracking reportsTo Do - consolidate all your Outlook, Planner and general "to do's" in one appPlanner - manage simple and complex engagements and projects in an intuitive appA quick look at many of the remaining apps

The major topics covered in this class include:An analytical framework for analyzing and opining on reasonable replacement compensation for owner-employees of closely held businesses and professional practices in the context of tax planning, compliance, management consulting and business appraisal assignmentsExecutive compensation components, including the valuation of non-qualified plans and restricted stock units

Risk management Anticipatory leadership Leadership roles in risk management

The major topics covered in this course include:Overview of the Planner app features and functionalityStep-by-step review and demonstration of how to deploy Planner in your practiceCreating a plan from scratch or use a templateCreating tasks with checklistsAssigning tasksScheduling tasksSetup recurring tasksAttach files to a taskMaintain a task activity journalManage task views with buckets and tagsIntegrate plan schedules with your Outlook calendar.Detailed review of plan / task progress reporting featuresUsing plan templates for recurring engagements

What keeps companies from becoming streamlined?  Behavioral biases Information processing biases Emotional biases How to deal with behavioral biases  Connecting behavioral biases to cost cutting Creating a culture of cost cutting Rules of thumb for cost cutting  Managing headcount Post-COVID common areas of excess cost Budgeting techniques Budget variances Benchmarking Common size financial statements Horizontal analysis Negotiation and contracting techniques Cash flow and the business cycle

Types of partnership distributions Liquidating partnership distributions Basis of property distributed by a partnership Special basis adjustments under Section 732(d) Abandoned and worthless partnership interests Section 751(a) exchange Transactions between partners and their partnerships Disguised sales Section 736(a) and (b) payments

The major topics that will be covered in this course include:Defining your teams and channel structure - best practicesStep-by-step guide on how to create and manage teams and channelsHow to organize your Teams navigation panelConfiguring your notification settingsConnecting Teams to external appsUnderstanding how Teams integrates with SharePoint, OneNote and Planner appsTracking your Teams app usage analyticsArchiving and deleting Teams and related content

S corporation qualifications Election of S corporation status Termination or revocation of S corporation status Pass-through of income and loss items to the shareholder Distributions to S corporation shareholders Reporting and filing requirements Choice of year-end Shareholder basis

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

Comprehensive coverage of the Inflation Reduction Act, including: The Corporate Alternative Minimum Tax, The Clean Vehicle Credit, Credit for Previously Owned Clean Vehicles, and Credit for Qualified Commercial Clean Vehicles Comprehensive coverage of the SECURE 2.0 Act with a focus on provisions applicable to employers Retirements and redemptions: considerations for partnerships and S corporations Timely coverage of breaking tax legislation Schedules K-2 and K-3 reporting requirements, including the 2022 domestic filing exception and Form 1116 exemption Form 7203, S Corporation Shareholder Stock and Debt Basis Limitations, with examples of how to calculate stock basis Overview of the economics and tax consequences of crowdfunding campaigns  Selected Practice and Reporting Issues: What’s new? A review of recent cases and tax law changes and IRS guidance affecting S corporations, partnerships, limited liability companies, and limited liability partnerships New Form 1099-K reporting requirements Bonus depreciation  Section 163(j)  Section 174 Research & Experimental Expenditures New FinCEN reporting requirements in 2024 Employee vs independent contractor considerations that companies should be aware of A review of like-kind exchange transactions under §1031 State and local taxes: pass-through entity workarounds Special basis adjustments, including comprehensive examples

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.

Risk management Value stream and Plus/Delta techniques Cyber risks Black Swan events

The seven components of trust High standards, loyalty, doing the right thing, listen, empathy and accountability The value of trust How ethics relates to trust and how trust relates to ethics

Budget defining, Budget cultures Tacticle budget issues Ideas for budget solutions and process solutions Understanding people in the budget process Communicating your budget to non financial types

The Professional Skepticism "Mind Set"Recent PronouncementsProfessional Skepticism as DiligenceCases and ControversiesConclusion