CPE Catalog & Events
Excel for Accounting Professionals Session 2: Data Validation and Conditional Formatting
-
Virtual
2.00 Credits
Data validation Conditional formatting Subtotal function Reduce formula errors Skinny row
Everyday Ethics at Work: Don't be the Next News Story!
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Discuss ethics from an every-day real-world perspectiveHow to prevent an ethical lapse that can turn your business into the next news story
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
ACPEN: How to Make Difficult People Disappear...Without Breaking the Law
-
Online
1.00 Credits
Conflict Management Interpersonal Relationships Personality Styles
NOCLAR: Ethics, Audit & Yellow Book Considerations
-
Virtual
1.00 Credits
The major topics that will be covered in this course include:Participants will review the scope of the interpretationsThe responsibilities of members in public practice and members in businessConsiderations involving confidentiality, communication, documentation, withdrawal, and further action in the public interest. Related requirements under SAS No. 147 and the 2024 Yellow Book, including how auditors must handle communications related to NOCLAR.
Surgent's Bankruptcy Basics: Understanding the Reorganization and Liquidation Process in These Uncertain Economic Times
-
Virtual
2.00 Credits
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
ACPEN: Big Picture Mega-Trends, Big Data, and World We Now Face
-
Online
2.00 Credits
On-going world economic trends Demographic changes and their impact on the economy Global technology influences Post Covid workplace Big data understanding and where is it going Learn to adapt to changing situations
Mastering the Excel Lookup Functions
-
Virtual
2.00 Credits
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
ACPEN: Triple Your Memory, Prevent Dementia and Halve Your Stress - Part 1
-
Online
4.00 Credits
Why the brain can remember some things a hundred times better than others Why we typically forget names and faces, and what can be done about it How our emotions follow the motion of our body, and how that can be used to instill instant confidence How to tap into a completely relaxed and/or confident state of mind in 10 seconds or less using advanced hypnotic conditioning and Neuro-Linguistic Programming techniques How to prevent dementia and brain “fog” using specific supplements and exercise How to stay motivated to use the methods outlined in this course to advance your career and achieve a higher quality of life How to use the concept of constant learning to help you maintain a balanced and fulfilling
ACPEN: Federal Tax Update for Individuals with Doug Van Der Aa
-
Online
4.00 Credits
"Tax-mageddon" - the all-important impending expiration/extension/renewal of the TCJA Recent legislative, judicial, and IRS developments impacting individual taxpayers 2025 Tax rates and inflation-adjusted figures Cryptocurrency reporting and new Form 1099-DA Form 1099-K and previously unreported income Review of significant changes in individual tax forms Recent federal tax legislation, cases and rulings affecting income of individual taxpayers
ACPEN: Preparing and Reviewing Workpapers for Higher Quality Audits
-
Online
4.00 Credits
The primary purpose of workpaper documentation, and minimum documentation requirements for workpaper preparers Best practices for documenting complex and subjective procedures and conclusions, such as estimates, substantive analytic procedures, etc. that impact the nature and extent of audit documentation needed to support audit conclusions Discussing the financial statement audit risk concept, including how proper application better ensures a higher quality audit Tips for an efficient workpaper review process that complies with relevant standards
Mastering SSARS: From Compilation to Preparation Engagements
-
Virtual
4.00 Credits
The major topics that will be covered in this course include:The SSARS landscapeReview engagementsCompilation engagementsPreparation engagementsSelecting from the menu of SSARS engagementsAICPA quality management standardsIndependence and other ethical considerationsConsiderations when changing the level of servicePitfalls to avoidBest practices to adopt
ChatGPT for Accountants: 50+ Use Cases
-
Virtual
2.00 Credits
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
-
Virtual
1.00 Credits
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
ACPEN: Unleashing Creativity in the Workplace
-
Online
1.00 Credits
The Power of Creativity in the Workplace The Three Types of Creativity: Imagination, Creativity, Innovation Benefits of Creativity: Purpose, Productivity, Performance Applications of Creativity: Individual, Team, Organizational Culture Creative Problem-Solving Techniques (Mind Mapping, Visual Thinking) Whole Brain Thinking: Integrating Left & Right Brain Functions Creating a Culture of Innovation Measuring and Implementing Creativity for Growth
Ethics: How to Give and Receive Criticism the Right Way
-
Virtual
2.00 Credits
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
-
Virtual
2.00 Credits
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
-
Virtual
0.00 Credits
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
ACPEN: Shorten Month-End - Closing Best Practices
-
Online
4.00 Credits
Trends in financial statement closings including the Quick Close, Soft Close and Virtual Close Review and discuss information systems headaches that slow you down Work through examples of close cycle "time killers" and how to resolve them Get inventory and cost of sales under control Identify the improvement projects that will yield the biggest benefit
Create Measures in Power BI that Define Your Metrics
-
Virtual
4.00 Credits
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.
