CPE Catalog & Events
Excel for Accounting Professionals Session 2: Data Validation and Conditional Formatting
-
Webinar
2.00 Credits
Member Price: $89
Data validation Conditional formatting Subtotal function Reduce formula errors Skinny row
Viewing A&A Through the Eyes of a Tax Practitioner
-
Webinar
1.00 Credits
Member Price: $89
The major topics that will be covered in this course include:The role of financial reporting for a myriad of usersFundamentals conceptsSpecial Purpose FrameworksFinancial statement analysisCross-functional collaboration
Forensic Accounting: Investigating Divorce Cases
-
Webinar
4.00 Credits
Member Price: $149
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
You Don't Know What You Don't Know About Microsoft Excel
-
Webinar
8.00 Credits
Member Price: $239
The major topics covered in this course include:Excel shortcuts and time saversWorking with templates, formats, styles, and themesCustomizing and enhancing ExcelProtecting and securing workbooksFormula building and the Excel function libraryNote: This session is taught using a Hands-On methodology. We provide practice files that tie to the examples in the course materials so participants can undertake all the steps in unison with the instructor.
Yellow Book Ethics
-
Webinar
0.00 Credits
Member Price: $89
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
Behavioral Finance Biases
-
Webinar
1.00 Credits
Member Price: $55
The major topics that will be covered in this course include:Overview of biases and standard of living riskOverview of difference between emotional and processing biasesExamples of various real life examples and case studies
Navigating IRS Collections: The Collection Process
-
Webinar
2.00 Credits
Member Price: $89
The major topics that will be covered in this course include:Overview of the IRS collection process.Taxpayer rights and the Taxpayer Bill of Rights.Collection due process and appeals.Installment agreements and offers in compromise.Wage garnishments, levies, and liens.Penalties and interest.
Surgent's Bankruptcy Basics: Understanding the Reorganization and Liquidation Process in These Uncertain Economic Times
-
Webinar
2.00 Credits
Member Price: $99
Commencement of a bankruptcy proceeding Protections provided to debtors under the Bankruptcy Code Key procedural aspects of bankruptcy The automatic stay Differences between Chapters 7, 11, and 13 bankruptcy cases The bankruptcy discharge Proofs of claim Plans of reorganization Litigation that can arise during bankruptcy Creditor committees Bankruptcy trustees Avoidable preferences and fraudulent transfers Special rights afforded to landlords and secured creditors
Todd and Julie Chrisley Go to Prison
-
Webinar
2.00 Credits
Member Price: $89
Major topics covered in this course include:What is bank fraud?What is wire fraud?Role of financial service professionals in combating tax evasion and white-collar crimeRed flags indicating of white-collar crimesImportance of knowing customersCriminal justice proceedingsRelationship between victim impact and sentencingRelationship between loss amounts and sentencing
What If Your Client Didn't Take Reasonable Compensation
-
Webinar
1.00 Credits
Member Price: $55
The major topics that will be covered in this course include:Review best practices to help your client evaluate if an S election is an appropriate choiceHow to be proactive and head off common reasonable compensation issues before they happenExplore strategies for cash management if cash isn't available at year endExplore what’s at stake when reasonable compensation isn’t paid timely
Mastering the Excel Lookup Functions
-
Webinar
2.00 Credits
Member Price: $89
The major topics that will be covered in this class include:A review of the various lookup functions, beyond VLOOKUPLearn which lookup works best for your situationHow to apply the many lookup functionsDiscover advanced lookup techniques like nested lookups, approximate matching, and handling errors effectivelyAn in-depth review of the following functions:VLOOKUP / HLOOKUPXLOOKUPMATCH / INDEXXMATCHINDIRECTFILTERSORT / SORTBYUNIQUEAn overview of some newer functions
ChatGPT for Accountants: 50+ Use Cases
-
Webinar
2.00 Credits
Member Price: $89
Major topics covered in this course include:Introduction to ChatGPT and artificial intelligence chatbot technologiesAutomating frequently asked questions and the onboarding processVerifying and reviewing financial recordsProviding real-time support to clientsGenerating financial reportsAutomating tax return preparation and financial planningProviding guidance on financial decision making
CPA to CFO: Essential Competencies for Finance Leaders
-
Webinar
1.00 Credits
Member Price: $55
To purchase the report referenced in this presentation, or any of the research papers published by CPA Crossings, visit https://www.cpacrossings.com/research. The major topics that will be covered in this course include: Top competencies hiring executives seek in CFO candidates based on survey of 320+ CEOs and recruiters Critical thinking frameworks and strategy creation techniques for financial leadership Forward-looking financial skills including capital management, forecasting, and funding strategies Industry-specific requirements for high-growth companies and nonprofit organizations Practical career development strategies to build CFO-ready competencies
Ethics: How to Give and Receive Criticism the Right Way
-
Webinar
2.00 Credits
Member Price: $89
The major topics covered in this course include:Entertaining lecture by a professional presenter, illustrated with relevant video clips and photographs, to cover the main points of the webinarWriting exercises, so you can see how these lessons apply to your own CPA practice and personal lifeTrue stories about CPAs and other leaders to show what can happen when apologies and criticism are done right, and the pitfalls of doing them the wrong way
Risk Assessment Under SAS No. 145
-
Webinar
2.00 Credits
Member Price: $89
Risk assessment under SAS No. 145 Overview of the steps to perform during risk assessment Testing the design, implementation, and operating effectiveness of controls New concepts due to the issuance of SAS No. 145
Surgent's Workplace Harassment: How to Prevent Harassment and Reduce Liability Risks in Today’s Changing Environment
-
Webinar
2.00 Credits
Member Price: $99
An overview of workplace harassment and discrimination laws, including the intangible benefits that come with compliance An overview of sexual harassment and workplace retaliation The supervisor’s (or manager’s) role in preventing harassment and in reducing the company’s potential liability through good faith efforts at compliance Review a compliant procedure for handling harassment concerns
Create Measures in Power BI that Define Your Metrics
-
Webinar
4.00 Credits
Member Price: $149
The major topics that will be covered in this class include:Introduction to DAX: Understanding the fundamentals of DAX and its role in Power BI.Advanced DAX Formulas: Delving into complex DAX functions and formulas for creating sophisticated measures.Time Intelligence in DAX: Exploring time-based functions to analyze data over different periods.Validating Measures with DAX: Techniques for ensuring accuracy and reliability in your DAX measures.Using PivotTables for Measure Validation: Employing PivotTables in Power BI to test and confirm the effectiveness of DAX measures.
Fraud & Embezzlement: Case Studies from the Trenches
-
Webinar
0.00 Credits
Member Price: $89
The major topics that will be covered in this class include:How organizations can find themselves defrauded due to lax oversight and weak internal controls.How the existence of the "trusted advisor" creates situations where CPAs can drop their professional skepticism.Illustrations of the issues companies should look for in preventing fraud and embezzlement.
Operations Level Internal Control
-
Webinar
4.00 Credits
Member Price: $149
The major topics covered in this course include:An overview of controls that drive proceduresConsiderations for procedural control developmentUnderstanding and controlling risk that arises when organizations change
No Tax on Overtime: Payroll Compliance
-
Webinar
2.00 Credits
Member Price: $89
The major topics that will be covered in this course include:Overview of the Fair Labor Standards Act (FLSA) overtime provisionsDefinition of a “workweek” and the 40-hour thresholdTime-and-a-half requirement and exclusions from overtime payExempt vs. nonexempt employee classifications (executive, administrative, professional, and industry-specific exemptions)Excluded payments (discretionary bonuses, reimbursements, retirement contributions)Step-by-step calculation examples for different compensation structuresBest practices for documentation and payroll systemsCase studies illustrating misclassification and miscalculation issues