CPE Catalog & Events
Complete Guide to Analyze Data with Excel PivotTables
-
Webinar
4.00 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.
AI Lessons Learned for Accountants
-
Webinar
2.00 Credits
Member Price: $89
The major topics that will be covered in this course include:Introduction to AI R&D in Accounting: Why internal AI research is essential for modern firms.Theory to Practice: Moving quickly from speculative AI concepts to actionable strategies.Managing Exponential Change: Understanding the urgency of adapting to AI’s rapid evolution.Proactive AI Engagement: Conducting in-house AI benchmarks, research, and hackathons.The Dual Role in AI Development: Balancing innovation with data security and ethical responsibilities.Internal AI Tools Creation: Encouraging accountants to develop AI solutions tailored to their needs.Data Security and Cyber Threats: Addressing AI-enabled cybercrime and protecting against internal risks.Mitigating AI Misuse: Recognizing abuse patterns and implementing safe practices.Challenges in AI Integration: Handling resistance, management concerns, and rapid technological shifts.Continuous Learning and Adaptation: Building a resilient, R&D-focused AI culture in accounting.
Surgent's Basics of Employment Law for Non-HR Professionals
-
Webinar
4.00 Credits
Member Price: $159
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
Coping With the Growth of Online Fraud
-
Webinar
4.00 Credits
Member Price: $149
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
ACPEN: The Ethics Hour: Dealing With Conflicts of Interest: Members in Business and Industry, featuring Don Minges
-
Webinar
1.00 Credits
Member Price: $39
The multi-step process to address conflicts of interest How to remedy threats Preparing to defend your actions or inactions Causes of conflicts of interest
Microsoft 365 Application Lightning Round Review-Updated
-
Webinar
1.00 Credits
Member Price: $55
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
ACPEN: HR Investigations – Episode 3 – Gathering-Analyzing-Reporting
-
Webinar
1.00 Credits
Member Price: $39
Documentary evidence gathering and analysis Site visits Surveillance Analysis by comparison and contrast Analysis by quantifying and connecting Analysis by identifying patterns Written reports Testifying
ACPEN: K2’s Formatting Excel Spreadsheets The Right Way
-
Webinar
2.00 Credits
Member Price: $89
Creating and using Styles in Excel The Accounting Format and why you should use it How to Create Custom Formats Formatting dates for maximum impact The advantages of storing formats in templates
ACPEN: K2’s Getting Started With Artificial Intelligence
-
Webinar
2.00 Credits
Member Price: $89
Understanding AI tools available today Creating accounts in AI platforms Querying data from AI platforms Customizing your AI subscriptions
ACPEN: Peeking Behind the Curtain: Exploring IRS Audit Technique Guides
-
Webinar
2.00 Credits
Member Price: $89
Overview of ATGs Best practices for utilizing ATGs Salient provisions of selected ATGs Insights auditors may obtain from analytical procedures Nuances associated with selected industries
ACPEN: Preparation, Compilation and Review Engagements
-
Webinar
2.00 Credits
Member Price: $89
Auditing Yellowbook
ACPEN: The Commonsense Approach to Auditing for Fraud
-
Webinar
3.00 Credits
Member Price: $89
Occupational Fraud Professional Skepticism Fraud Indicators Error vs. Fraud Fraud Risk Fraud Hypothesis Development Fraud Intent
The Ethics of Care in the Workplace
-
Webinar
2.00 Credits
Member Price: $89
The major topics that will be covered in this class include:Ethical Values and PrinciplesCompassionManaging ExpectationsRespect and HumilityAttribution Theory
ACPEN: The Essential A&A Update with Renee Rampulla
-
Webinar
4.00 Credits
Member Price: $149
Crypto Assets Governmental Grants Income Tax Disclosures Group Audits Fraud Quality Management
Forensic Accounting: Court Approved Methods of Proof
-
Webinar
4.00 Credits
Member Price: $149
The major topics that will be covered in this course include:The role of methods of proof in forensic accounting.The various types of methods of proof approved by the courts.The weakness and strengths of the methods of proof.The formulas in calculating methods of proof.Applying the formulas in various circumstances.
Navigating IRS Authorizations: Form 2848 & Form 8821
-
Webinar
2.00 Credits
Member Price: $89
The major topics that will be covered in this course include:Overview of IRS Power of Attorney (POA) rules.Form 2848: Authority to Represent Clients before the IRS.Form 8821: Accessing Tax Information Without Representation.Identifying errors and compliance risks in POA filings.Rules for revoking or updating POA authorizations.Managing authorizations through the CAF system.Electronic submissions and the IRS online authorization process.Ethical responsibilities when holding a POA.
ACPEN: PowerPoint: Tips & Tricks for Today's Accountant
-
Webinar
2.00 Credits
Member Price: $89
Exploration of tabs within PowerPoint’s ribbon Initial creation of a slide deck Using slide masters Utilization of external content SmartArt Alignments and layouts Tips and tricks for efficiency Best practices for effective presentation delivery Other creative uses for PowerPoint
Cybersecurity: Protecting Your Firm's Data and Reputation
-
Webinar
2.00 Credits
Member Price: $89
The major topics that will be covered in this course include:Assessment of the current cybersecurity threat level and vulnerabilitiesDeveloping your WISP (Written Information Security Program) Deploying a password management app (PMA) to fortify the security of your login credentialsImplementing an incident response plan to minimize the damage from a cybersecurity attackUnderstanding the role of cybersecurity insurance
What You Can Learn From the Statement of Cash Flows
-
Webinar
2.00 Credits
Member Price: $89
The major topics covered in this course include:Preparation of the statement of cash flowsImportance of identifying sources and uses of cash in financial reportingFinancial statement analysisCash-related financial statement disclosures
ACPEN: Fraud Assessment for Small and Medium Sized Businesses
-
Webinar
4.00 Credits
Member Price: $149
The fraud triangle The fraud savvy model Symptoms of fraud Benford's Law The net worth method The vulnerability chart 10 steps for action today