CPE Catalog & Events

Using ChatGPT with Excel

The major topics that will be covered in this class include:Introduction to ChatGPT and other AI (Artificial Intelligence) language modelsDiscussion of best practices for using ChatGPT with ExcelUse ChatGPT to create, debug and explain formulasUse ChatGPT to learn how to use Excel featuresUse ChatGPT to automate repetitive tasks in ExcelUse ChatGPT to easily create macros

How to Get a Better Return on Financial Statement Audits - Avoiding the Most Misapplied Risk-Based Audit Concepts

Properly assessing inherent, control, and fraud risk on an engagement, and linking the results to an appropriately tailored detailed audit plan based on risk assessment and client service goals, regardless of entity type (for-profit, nonprofit, governmental) Leveraging strong substantive analytic procedures as audit evidence to cut back on tests of details The most common efficiency opportunities for tailoring your audit approach based on risk How to use the workpaper review process as a tool for producing a more effective and efficient engagement Using audit documentation to enhance audit quality, while ensuring every workpaper has a purpose How to use the client to your advantage in planning and performing the audit Learn how to get the engagement out the door – on time and on budget! 

Audit & Attest Quality Matters that Should be on Your Radar - Avoiding Common Deficiencies in SAS, SSARS and SSAE Engagements

Applying professional skepticism to ensure quality work Meaningful risk assessment when designing work programs for various levels of services Proper planning and supervision of all engagements Accountant responsibilities for evaluating internal control Strengthening analytic procedures to support conclusions Complying with the Code of Professional Conduct and quality management standards 

CPA to CFO

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.

Business Communication Essentials (Dynamic Communication in the Workplace)

Communication Feedback Management Leadership

Audit 501: Personality Styles - Improving Your Interactions

The major topics covered in this course include:Defining primary personality style characteristicsDetermining your own primary personality style and the style of othersEffectively adapting for improving interactions with various personality stylesLeveraging strengths and minimizing the negative impact of personality weaknessesApplying personality style analysis to real-life situations involving clients, staff, peers and superiors

CyberPsychology: Conquering Insider Threat 2024

Exploiting control gaps and control weaknesses Psychological tactics used in attacks A review of robust controls Data access observables, changes in network patterns A review of the audit, HR, IT and management relationships Proactive approaches to recognize evolving risks and avoid breaches

Family Law 101 2024

Lifestyle issues: Does the client's lifestyle reflect the level of reported income? Undisclosed income Transfers of cash between multiple bank accounts, related party transactions and mortgage refinancing Owner perks Tax deductions vs. family law deductions Business entity-related issues such as partnerships, S corps and corporations

Coping With the Growth of Online Fraud

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

Revenue: ASC Topic 606 in Depth 2024

FASB ASC 606, Revenue from Contracts with Customers FASB ASC 340-40, Other Assets and Deferred Costs All recently released updates to FASB ASC 606, Revenue from Contracts with Customers

Tax Collection Defense 2024

Assessment and attachment rules-tax assessment procedures and attachment of the assessment lien to property, including community property Tax liens-perfection and priority rules in general and for specific assets and relief from liens Tax levies and seizures-taxpayer rights and defenses; third party rights Dealing with the collection officers and representatives Collection appeals and resolutions Judicial actions: collection due process (CDP), injunctions and IRS suits.

How To Use Microsoft 365 Forms to Create Online Surveys

The major topics covered in this course include:Overview of the Microsoft 365 Forms app features and capabilitiesStep-by-step review and demonstration of the Forms appDesigning your form or surveyCreating form questionsUsing branching to eliminate unnecessary questions based on form input dataCustomizing the form theme / styleManage form response settingsDistribute forms via link, website or emailReview of the completed forms response reportExporting forms data to Excel for further analysis

Talk This Way - Communication Skills for the CPA

The major topics covered in this course include:Pervasive best practices for effective communicationSpecific strategies for written materialsUnique considerations for verbal presentationsThe importance of recursive revisionTips for successPitfalls to avoid

The Controllership Series - The Financial Close Process

Accounting Finance Financial Statements

Preparing to be a Forensic Accountant - Focus on Digital Forensics

Forensic Accounting Accounting Auditing Finance

Streamlined Excel Reporting Series Session 4: External Data and PivotCharts

The Leadership Skills of Tomorrow: Delegate and Listen

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

Unlocking Deep Secrets: Case Studies in Financial Analysis

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

Critical Tax Procedural Issues for CPAs 2024

Key compliance procedures concerning return preparation of original and amended returns Understanding key procedures about IRS examination Understanding key relief provisions for oversight, errors and later discovered facts or information

Business Consulting for CPAs

What is Business Consulting? Identify the types of Management services your firm could offer. How to become the trusted advisor – identification of client’s needs? Learn how client expectations may create different performance and understanding levels for CPAs in business consulting engagements. Know what it takes to create a valuable outcome for the client. Understand the competitive advantages/disadvantages that your firm has versus non-CPA business consultants. Learn techniques to become a more effective consultant. Professional standards application