CPE Catalog & Events
Taking Advantage of Array Formulas in Excel
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Introduction to Array Formulas: This segment establishes the foundation by differentiating array formulas from regular Excel formulas and explaining their significance.Using Array Formulas: This section focuses on the practical application of array formulas, teaching participants how to effectively implement and utilize these formulas in a variety of common Excel tasks and scenarios.Dynamic Arrays and Spill Functions: This part covers the utilization of dynamic arrays and spill functions, highlighting their role in modern Excel data handling.Advanced Array Functions: Participants will delve into complex functions such as SUMPRODUCT, UNIQUE, SORT, and FILTER, focusing on multi-condition summing and data management.Using Array Constants: This section teaches how simplify the use of static values called Array Constants
SEC Case Studies: Ethical Dilemmas in Finance and Accounting
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Introduction to Ethics and Ethical DilemmasEthical Codes and Professional StandardsFraud and the Fraud TriangleEthical Decision-Making ModelsFinancial Statement Manipulation TacticsCash Flow and Key Metrics Misrepresentations
Learning to Teach "Tax" as a Second Language
-
Virtual
1.00 Credits
The major topics that will be covered in this course include:Accounting as a foreign languageCommonly misunderstood conceptsCommunicating tax mattersClient-practitioner interactionsInteracting with tax authorities
Yellow Book Ethics
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:The concept of public interestEthics, independence, and professional judgmentCompetence and continuing professional educationQuality control and peer reviewProper use of government information, resources, and positionProfessional behavior
Surgent's Business Law for Small Business Owners
-
Virtual
4.00 Credits
Contract principles Legal issues related to various types of business organizations Worker classification Employee rights and the duties of employers Real property law
Surgent's Ethical Considerations for the CPA
-
Virtual
4.00 Credits
Examine the CPA's role in today's economy Compare similarities and differences between individual and business ethics Explore the link between ethics, integrity and scruples Discuss the basic attributes of ethics and professional conduct Review the history of the CPA profession and the CPA's requirement to adhere to ethics policies and codes of conduct Review the AICPA's Code of Professional Conduct and a CPA's responsibilities to the public, clients and colleagues Discuss the common rules and statutes faced daily in the CPA profession. Case studies may also be utilized to present potential ethical dilemmas CPAs may face during their careers Review CPA Independence violations by current legal case examples
Coping With the Growth of Online Fraud
-
Virtual
4.00 Credits
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
Surgent's Audits of 401(k) Plans: New Developments and Critical Issues
-
Virtual
8.00 Credits
Proper planning of benefit plan audit engagements and developing audit strategy while improving overall efficiency Common pitfalls in planning and detailed audit procedures Changes affecting 401(k) plans, including recently issued SASs Common mistakes as noted in peer reviews and DOL inspections
Walter Haig's Personal Financial Health Checkup
-
Virtual
8.00 Credits
The topics that will be covered in this course include:Preparing a personal financial statement following U.S. GAAPRecasting U.S. GAAP personal financial statements into powerful management toolsIdentifying key financial factors that must be managed in order to achieve financial self-sufficiencyKey personal planning documents including HIPAA Medical Disclosure Document, Living Will, Medical Durable Power of Attorneys, and Letter of Instruction at DeathHow to create "goal" statements that achieve results
Installment sales: Maximize Tax Benefits and Stay Compliant
-
Virtual
1.00 Credits
The major topics that will be covered in this course include:Installment sale treatment eligibilityWhen to elect out of installment sale treatmentInstallment sale of business assetsInstallment sale default and the rules for personal property versus real propertyInstallment sales and depreciation recapture
Accountants and Malpractice: Can We Get Sued for This?
-
Virtual
2.00 Credits
The major topics that will be covered in this class include:How accountant liability is a very real threat in today's litigious society.A discussion of scenarios in which accounting professionals can find themselves inadvertently involved in a lawsuit.Pitfalls in which the accountant may find him- or her- self while dealing with clients.Real-life examples from the speaker's extensive experience as a practitioner and as an expert witness in accounting malpractice cases.
Surgent's Controllership Skills Update: Risk Management
-
Virtual
2.00 Credits
Rethinking Risk Management: Historic view Challenges Rules Recent lessons Required skills Sources of Risk: Economy Competitors Operations Investments Strategy Compensation Routine practices Unethical behavior. Enterprise Risk Management (ERM): Defining ERM Areas of focus Implementation Planning for disasters Business continuity Contingencies Analytical Tools: Post-completion evaluations Simulation Z-score Hedging Brainstorming Mind mapping Delphi technique
Using e-Signature Software to Process Agreements-Updated
-
Virtual
2.00 Credits
The major topics covered in this course include:Review of the digital document signing process.Key features to evaluate in selecting a solution.Review and distinguish top selling e-signature applications.Best practices for deploying e-signature software in your practice or business.
Navigating IRS Authorizations: Form 2848 & Form 8821
-
Virtual
2.00 Credits
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.
Best Non-Google Search Tools for Accountants
-
Virtual
2.00 Credits
The major topics that will be covered in this class include:Why Advanced Search Skills Are So Critical for AccountantsWhy You Need More than Google to Search the InternetGARP: Generally Accepted Research PrinciplesAlternatives to GoogleAdvisory SearchSocial SearchSpecialty searchSearch Engine resourcesWhat's Ahead in Search
Build a Data Model for Analysis in Power BI
-
Virtual
4.00 Credits
The major topics that will be covered in this class include:Data Modeling Essentials: Understanding the core concepts of data modeling in Power BI, including integration of various data sources.Building Relationships: Techniques to establish and manage relationships between different data sets.Calculated Columns and Basic DAX Measures: Introduction to DAX (Data Analysis Expressions) and its application in creating calculated columns and basic measures.Calculated Columns vs Measures: Insights into when to use calculated columns and when to opt for measures.Explicit vs Implicit Measures: Understanding the difference and appropriate application of explicit and implicit measures in data analysis.Hierarchies in Data: Creating and utilizing hierarchies to enhance data analysis and reporting.Using Pivot Tables to Validate Measures: Practical skills in using pivot tables within Power BI to validate and refine measures.
Financial Decisions that Led Two Businessmen to Prison
-
Virtual
2.00 Credits
The major topics covered in this class include:Career choicesEthical dilemmasJudicial proceedingsMitigation strategiesCreating tools to help make better decisionsAtonement and reconciliation
Forensic Accounting: Investigating Divorce Cases
-
Virtual
4.00 Credits
The major topics that will be covered in this course include:The role of a forensic accountant in divorce proceedingsThe marketing of forensic accounting services to family law attorneysHow to conduct a financial investigationCommon areas to uncover hidden assets or incomeThe basic calculations in evaluating marital assetsTestifying in depositions and divorce court
Retirement Planning: Next Stage for You or Your Client
-
Virtual
2.00 Credits
The major topics covered in this class include:Welcome to Your Next Stage -- Developing a new perspective on what this next stage is really all aboutIt's About Time -- Discovering a new sense of purposeMoney Matters -- Assessing your financial conditionsRelationships Matter Too -- Addressing needed or potential changes in your relationshipsHealthy Habits -- Examining new or renewed ways to stay healthyWho I Am -- Creating a new identity, and answering "So what do you do?"My Master Plan -- Figuring out what to do next
Accounting of the Soul: Making the World a Better Place
-
Virtual
1.00 Credits
The major topics covered in this course include:Overview of Virtue Ethics and the Common GoodProfessionalismThe Virtue of CompassionGossip in the WorkplaceGratitude
