CPE Catalog & Events

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

The major topics that will be covered in this course include:Best practices for fraud prevention and detection.Common fraud schemes in nonprofit including cash misappropriation; payroll fraud; vendor fraud; falsified billings; improper use of credit cards or purchase cards; the redirection of cash and non-cash contributions; personal use of assets; the redirection of grant benefits; other grant related fraud; travel and expense reporting fraud; and much more!

The major topics covered in this class include:How is business changing.What is driving the change and how long will it last.How specifically is an organizations control system important.What steps are needed to “keep up” with the upheaval.

The major topics that will be covered in this course include:The need to fund for long-term care in AmericaClient's attitudes and misconceptionsInnovative long-term care solutions and funding

The major topics covered in this class include:Various types of penalties: Accuracy related, fraud, understatement of valuation, reporting requirement, failure to pay, and pay or deposit penaltiesRules on waiver of penalties and interestsVarious forms and procedures for requesting reliefFirst Time Abatement: Requirements and proceduresHow an individual taxpayer qualifies for Reasonable Cause abatementProcedures for requesting refund of paid penaltiesAvailable administrative options

Changing Role of Financial Professionals: Priorities Change in mission Valued-added actions Strategic Measurements: Common errors and guidelines for improvement Balanced scorecard Strategy development and implementation Budgeting basics and next steps Risk Management: Recent lessons, including Black Swan events Defining Enterprise Risk Management (ERM) Implementation Developing a Financial Leadership Pipeline: Changing employment environment Retaining the right employees Compensation Hiring process Capital Projects: Types of projects Factors affecting capacity Valuation techniques Cash management M&A Activity: Current environment Controller’s role Strategic questions Sample transactions Due diligence Implementation Introducing Improvements/Innovation: Getting started Establishing an environment Potential first projects Organizational structure

The major topics that will be covered in this class include:Overview of the Power BI Tools: Introduction to the Power BI ecosystem, including Excel’s Power BI features (Power Pivot and Power Query) and standalone tools (Power BI Desktop, Power BI Service, Power BI Report Builder and Power BI Report Server).Tour of the Tools: Introduction to the interfaces of Power Pivot, Power Query, Power BI Desktop and Power BI Services.Comparative Analysis: Understand the strengths and limitations of Excel’s Power BI features versus standalone Power BI tools.Strategic decision-making on when to use each tool for optimal efficiency and accuracy in data analysis tasks.

The major topics that will be covered in this course include:A look at the GASB standards that are effective this year.GASB 100, Accounting Changes and Error Corrections.GASB 101, Compensated Absences.The impact of the 2024 Compliance Supplement on Single Audits.Changes to the Uniform Guidance.Common deficiencies found in Single Audits.

The major topics covered in this course include:Introduction to the world of password management apps and what makes them so secureReview and demonstration of top selling password management appsSoftware features that will be reviewedPassword generationEmergency user accessEntity vs. individual password managementDesktop vs. cloud basedMulti device synchronizationPII (personally identifiable information) forms fillerCredit card storageDigital data vault

Technology and workstation arrangements Maximizing productivity Establishing procedures that can be implemented throughout the organization Understanding the relationship between remote work and employee retention Effective communication strategies for staying connected with colleagues and clients The productivity challenges unique to working from home Time management The importance of distinguishing between the “home office” and “home” Data privacy concerns Other ethical considerations that arise when working from home

The major topics covered in this course include:Securing individual documentsProtecting information resident in the CloudSecuring data stored on or accessed by mobile devices

The major topics covered in this class include:Examination of actual fraudsDiscussion of internal controls that could have prevented the fraudsContemplation of epiphanies for your own professional scenarios

Explore the function that sums better than the SUM function Discover a variety of time-saving features, functions, and techniques Learn the workaround to a major Excel pitfall

The major topics that will be covered in this course include:Overview of financial statement analysisThe impact of GAAP on financial analysisOverview of the Balance SheetOverview of the Income StatementThe importance of the Statement of Cash FlowsCommon Size AnalysisTrend AnalysisProfitability Ratio AnalysisLiquidity Ratio AnalysisSolvency Ratio Analysis

How the application of policies and employment laws within the workplace can reduce employee complaints, and protect your company from claims of discrimination or wrongful behavior Examining wage and pay practices, FMLA examples, and other challenging workplace questions, to insure actions are consistent with laws/policies Key functions of employment including recruitment, interviewing and selection

Automatic enrollment requirements for 401(k) plans Change in the credit for small employer pension plan startup costs $2,000 saver’s match Changes in pooled employer plans Multiple employer 403(b) plans Increase in age for required beginning date for mandatory distributions Indexing IRA catch-up limit Higher catch-up limit to apply at age 60, 61, 62, and 63 Treatment of student loan payments as elective deferrals for purposes of matching contributions Application of credit for small employer pension startup costs to employers who join an existing plan Small immediate financial incentives for contributing to a plan Withdrawals for certain emergency expenses Starter 401(k) plans for employers with no retirement plans Improving coverage for part-time workers Recovery of retirement plan overpayments Tax treatment of IRAs involved in a prohibited transaction Clarification of substantially equal periodic payment rule

The major topics that will be covered in this course include:AI-powered ideation and opportunity identification techniquesDigital asset creation workflows using generative AI toolsAudio and video content generation using AI avatars and synthesisE-commerce integration and product development strategiesAI-driven presentation and visual content creationSocial media content optimization and distributionMulti-format content transformation (articles, songs, comics, storyboards)

The major topics that will be covered in this course include:Yellow Book engagements.Independence requirements in GAGAS.Quality management in Yellow Book. Common deficiencies found in Yellow Book engagements.

The major topics that will be covered in this course include:Building Reports Workflow: Understand the steps for creating professional and functional reports.Gather and Organize Data: Learn best practices for compiling and cleaning data for accurate analysis.Set Calculations and Key Metrics: Apply formulas and functions to calculate meaningful insights. Format and Structure Report: Use formatting tools to create visually appealing and structured reports.Review and Validate: Verify data accuracy and troubleshoot potential errors.Share the Report: Learn methods for distributing reports effectively within your organization.

The major topics covered in this class include:AICPA Code of Conduct: Integrity and ObjectivityCase Study: Mortgage crisis of 2007-2010Case Study: World Com