CPE Catalog & Events
Shortcuts that Excel Users Love
-
Virtual
2.00 Credits
The major topics covered in this course include:The power of keyboard shortcutsOft used features with more capability than meets the eyeNew helpful featuresNote: This session is taught using 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.
Casualty Losses: Disaster Relief Act of 2024
-
Virtual
1.00 Credits
The major topics that will be covered in this course include:Federal Disaster Relief Act provisions enacted in December, 2024Comparison of personal use casualties with business/investment casualtiesWhen to claim casualty lossesHow to postpone casualty gainsBusiness casualty gains and depreciation recapture
Professional Ethical Considerations for CPAs
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Core principles of any Code of Professional Conduct applicable to all CPAs, including conflicts of interest, preparing and reporting information, competence, confidential information, and moreThe importance of maintaining independence for CPAs in public practice, especially when also performing nonattest services for the attest client Comparing and contrasting various ethical standards, including those promulgated by the AICPA, PCAOB, and international bodies
Surgent's Tax Research
-
Virtual
2.00 Credits
Tax code hierarchy Organization of an Internal Revenue Code section Special rules for IRC citation Citing other primary authority Private letter rulings Primary vs. secondary authority Secondary sources of authority Steps in the tax research process Research memoranda
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.
You Don't Know What You Don't Know About Microsoft Excel
-
Virtual
8.00 Credits
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.
How to Start a CFO Service
-
Virtual
1.00 Credits
The major topics that will be covered in this course include:What business owners really want from a CFO/business advisory service (it's not what you think).How to determine if you're qualified to provide CFO/business advisory services.Why now is the right time to be providing CFO/business advisory services.How to get new clients to your practice and how to approach existing clients.Why clients need you and why you need them.How much you should be charging for this type of service.How to provide a CFO/business advisory service in the most efficient way possible.
About the TIGTA: Who Watches the IRS?
-
Virtual
2.00 Credits
Major topics covered in this course include:The role of TIGTA in the US tax systemAuditing, investigating, and inspecting and evaluating IRS programs and operationsIdentifying opportunities to improve the administration of tax lawsPromoting integrity, economy, and efficiency in the tax systemResponding to requests from Congress and other external stakeholdersUpholding ethical standards in the accounting professionBuilding trust and confidence in the tax system
Adobe Acrobat Tips for Working with PDF Files
-
Virtual
2.00 Credits
The major topics that will be covered in this class include:Review of all that Adobe Acrobat has to offerOrganizing your PDFs with bookmarks, links, file attachments and moreFormatting the presentation of PDFs with headers, footers and watermarksCreating and processing fillable formsProcessing documents for e-signatureTips for converting email messages, documents and spreadsheets into PDF formatCombining multiple PDF files into a single binder Utilizing the security features of Adobe Acrobat to protect document confidentiality
Surgent's Section 754 Step-Up in Basis: Understanding the Tax Issues for Partnerships and LLCs
-
Virtual
2.00 Credits
How and why a partnership makes a 754 election The effect of the 754 election when an interest in a partnership is sold or inherited How the 754 election applies when a partnership makes a distribution of property to one or more of its partners How to make the 754 basis adjustment
Surgent's Strategies for Maximizing Social Security Benefits
-
Virtual
2.00 Credits
When is a person eligible to take Social Security benefits? Factors to consider when selecting an option for taking Social Security benefits Is there a best age to start taking Social Security benefits? How to maximize Social Security benefit payments for surviving spouses How can a divorced spouse collect Social Security benefits based on the work record of a former spouse? How minor children can collect Social Security benefits based on the work record of an older parent
Advanced Cybersecurity - Beyond the Basics
-
Virtual
4.00 Credits
The major topics that will be covered in this course include:Understanding Cyber Threats and Risks in FinanceCybersecurity Frameworks and Best Practices for Financial ProfessionalsFinancial Data Security and Encryption TechniquesCybersecurity Auditing and Forensic InvestigationsEmerging Technologies and Trends in Financial CybersecurityLeadership and Governance in Cybersecurity for Financial Executives
PPP Fraud and Financial Professionals
-
Virtual
2.00 Credits
The major topics covered in this class include:Ethical dilemmasJudicial proceedingsMitigation strategiesCreating tools to help make better decisionsAtonement and reconciliation
Mastering IRS Form 7217: Partnership Property Distributions
-
Virtual
1.00 Credits
The major topics that will be covered in this course include:Property distributions in liquidation of a partner’s interestSection 751 and its impact on property distributions from a partnershipMechanics of completing Form 7217 – new for 2024The Section 754 election and its role in partnership property distributions
Master the Art of CPA Communication: Boost Your Influence!
-
Virtual
4.00 Credits
The major topics that will be covered in this course include:Techniques for simplifying complex financial information for clients and stakeholdersPersuasive communication principles aligned with CPA rolesBuilding and maintaining trust and credibility with diverse stakeholdersCase studies and Interviews with Finance, Accounting and CPA professionalsDeveloping empathy and emotional intelligence in communicationsBest practices for active listening to strengthen client relationshipsApplication of Influencer principles for impactful change in communication
Advanced Cybersecurity - Beyond the Basics
-
Virtual
4.00 Credits
The major topics that will be covered in this course include:Understanding Cyber Threats and Risks in FinanceCybersecurity Frameworks and Best Practices for Financial ProfessionalsFinancial Data Security and Encryption TechniquesCybersecurity Auditing and Forensic InvestigationsEmerging Technologies and Trends in Financial CybersecurityLeadership and Governance in Cybersecurity for Financial Executives
Selected Ethics Topics - 2024 - 2025
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Stay in compliance with recent ethics standards changes that impact your practice.Learn about key regulatory changes and initiatives impacting CPAs and the future of the profession.Discuss emerging issues and standard-setting activity that could affect your practice in the future. Explore practical applications of the standards and hear about common practice issues and challenges. Examples include private equity, technology, tax planning, audit quality, regulatory enforcement and standard-setting environment.Learn how failure to follow the standards can result in unwanted regulatory actions and publicity.
Surgent's Marijuana: A Generalized Business Viewpoint
-
Virtual
2.00 Credits
An overview of current state and federal laws governing marijuana A review of state boards of accountancy regarding marijuana How some financial professionals are capitalizing on the marijuana industry Providing auditing and tax services within the marijuana industry How accountants and other financial professionals can manage risk within this industry IRC Section 280E’s prohibition of deductions involving controlled substances A summary of various state taxation laws on marijuana Ethical issues for accountants who work in the marijuana industry Relevant banking regulations Growth projections
The Ethical Management of Conflict
-
Virtual
2.00 Credits
The major topics covered in this class include:Professionalism, Conflict and EthicsSources and approaches to conflictManaging Conflict from the Inside: Awareness of human tendencies, human emotions, and gossipGuidelines for managing conflict collaboratively
Take Command of your Time
-
Virtual
2.00 Credits
The major subjects that will be covered in this course include:Identify time wasters and adopt strategies for eliminating themRecognize the variety of causes of procrastination and apply techniques to overcome themUse practical techniques for prioritizing workDelegation strategiesIncorporate wellness and stress management into your day in short incrementsUnderstand their energy cycles and use it to manage your scheduleLearn techniques to decrease stress in the moment (based on neuroscience)
