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.

Behavioral insights (BI) PrimerHow and why BI are used by the IRSIRS and individual decision-makingIRS and environmental and design considerationsIRS and social normsIRS "top of mind" issues BI and Implementation of tax reform legislation BI and private debt collectionBI and online taxpayer accountsBI and taxpayer rights in "real" vs. "unreal" auditsBI and the tax-exempt approval processBI and passport renewal and revocationHow to use BI to more mindfully interact with the IRS to improve outcomes

Accounting analysis and methodology Factors influencing the quality of accounting-based financial reports Impact of emerging business models on balance sheets Introduction to the Instructor's Open Balance Sheet

The major topics that will be covered in this course include:Appreciate the full potential of Microsoft 365 to drive efficiency in your businessLearn best practices for harnessing the power of Microsoft 365 Design your Teams app setup to meet the unique attributes of your businessUse SharePoint and OneDrive to organize your files and share them securely internally and externallyOrganize your thoughts, meeting notes and other content centrally in OneNoteManage your projects, large and small, with the Planner appDeploy the Stream app to document processes efficiently and effectively Bonus Content: Understand how to harness the power of AI with Microsoft Copilot

Introduction to single audits Preparation of the schedule of expenditures of federal awards and determining major programs Understanding, assessing, and testing internal control Testing compliance with federal statutes and regulations and applicable compliance requirements Auditor reporting in a Uniform Guidance compliance audit Program-specific audits Administrative requirements and cost principles in a single audit

Taking a strategic perspective relative to risk management and crisis management Reviewing the impact uncertainty and risk at the operational level relative to short- and intermediate-term decision making Determining the safety and soundness of the financial plans for your organization in an uncertain economic climate specifically as it relates to capital adequacy and strategic direction Managing the debt and equity mix for your organization in a rapidly changing economic landscape Determining the impact that competing in a global marketplace has on an organization and how to take steps to become more competitive globally Evaluating the impact of federal, state, and municipal deficits and unfunded mandates as it relates to tax planning Evaluating retirement programs with Social Security funding for your employees Determining the safety and soundness of your credit and collections processes and selection of customers in an uncertain environment Influencing growth through acquisition of distressed organizations The economic way ahead for the CFO/Controller 

The major topics that will be covered in this course include:Understanding Cost Behavior and Its Impact on Decision-MakingContribution Margin and Break-Even AnalysisMargin of Safety and Its Role in Risk ManagementOperating Leverage and Financial SensitivityAnalyzing Asset Turnover for Operational EfficiencyCash Conversion Cycle and Working Capital InsightsFree Cash Flow Yield as a Valuation Tool

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

Recourse debt allocations Constructive liquidation scenarios Nonrecourse debt allocations Minimum gains and nonrecourse deductions Section 704(c) gains Allocations under 704(c)

The causes of burnout in the accounting profession Effects of burnout on employee well-being Strategies to protect employee well-being in a highly demanding profession Organizational costs associated with employee burnout Tools used to measure employee well-being

The major topics that will be covered in this class include:Does it pay for a company to have strong ethics?Can you measure the financial impact of ethics?Does ethics make a difference in financial performance?Can ethics be used as a competitive advantage?What sets the CPA designation apart?AICPA Code of Professional Conduct & the Conceptual Framework ApproachEthics as a marketing toolPersonalizing your Code of EthicsFour building blocks of ethical cultureWhat influences employee behavior?Ethical researchBuilding trust in organizationsMaintaining objectivity in difficult situations

The major topics that will be covered in this course include:Fundamentals of GPT Builder and AI agent customization techniquesIntegration of specialized knowledge bases and domain-specific expertiseSecurity and privacy considerations in AI chatbot deploymentCustom GPT development without coding expertiseImplementation of AI agents for customer support and workflow automationMulti-bot interactions and content creation strategiesBest practices for maintaining and scaling AI assistants

The major topics that will be covered in this course include:The urgency of leading change now & the steps in leading changeThe power of crafting a vision that encourages buy-inThe art and science of building strong partnershipsAccelerating change through relationship networksCommunication strategies for changeEstablishing a feedback culture for successful changeManaging self in times of changeCase studies and real-world scenarios

The major topics that will be covered in this course include:Ways in which data and information can be misleadingCommon pitfalls when encountering dataHow to re-evaluate the data to avoid those pitfalls

The major topics that will be covered in this class include:Tour of the Power BI Desktop Interface: Understand the layout, tools, and features of Power BI Desktop.Tour of PowerBI.com Interface: Familiarize with the online environment of Power BI for report creation.Importing Power Pivot Data Model: Understand how to integrate Power Pivot models into Power BI for more complex data analysis.Building Visuals: Learn the step-by-step process to create compelling visuals and understand the importance of visual context in data storytelling.Review of Available Visuals: Explore the variety of visuals available in Power BI and their appropriate applications.Power BI Desktop Features: Delve into the advanced features of Power BI Desktop, enhancing data manipulation and visualization capabilities.Building Interactivity into Visuals: Learn to create dynamic and interactive reports that engage and inform.Publishing Reports to PowerBI.com: Gain skills in uploading and managing reports on PowerBI.com for wider access and collaboration.

The major topics that will be covered in this course include:Introduction to Financial Statement ForecastingOverview of the importance and benefits of forecasting for strategic planning and investment attraction.The Forecasting Process: Steps to project future income, expenses, and resources using historical data and market trends.Analyzing Historical Data: Methods for leveraging past financial data to inform future projections.Incorporating Market Trends: How to integrate market insights into financial forecasts.Forecasting Profitability: Techniques for predicting future earnings and their implications for budgeting, cash flow management, and investment planning.Forecasting the Balance Sheet: Approaches for predicting future financial positions, including growth potential, solvency, and capital structure

Each week’s topics will change based on the most critical issues affecting financial professionals

The major topics that will be covered in this course include:Overview of current cybersecurity threats and how to mitigate data breach risk.Describe how to avoid malware and other security threats

The major topics covered in this class include:CECL for nonfinancial institutions.Accounting for Paycheck Protection Program loans.Accounting for web-hosting services.Revenue recognition.Leases.FASB projects in progress.