CPE Catalog & Events
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
Donating Cryptocurrency and Avoiding Traps for the Unwary
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Intro to digital assetsDifferences between cryptocurrency and non-fungible tokens (NFTs)IRS Notice 2014-12Tax implications of contributing digital assetsGift tax rules for donating, gifting or bequeathing cryptocurrency and NFTs.Substantiating charitable contributions of digital assetsTraps for the unwary.
Surgent's A Guide to Gig Economy Tax Issues
-
Virtual
2.00 Credits
Characteristics of a gig economy Who is an employee and who is an independent contractor? Form 1099-NEC and reporting of non-employee compensation Reporting on Form 1099-K Gig workers and the requirement to pay self-employment tax throughout the year State tax implications of remote work for the business owner and workers How remote work creates state tax nexus Tax implications of employee telecommuting for the employer The “convenience of the employer” rule Drivers of both people and of meals or other products Section 199A deduction Implications of the Vizcaino case
Surgent's A Guide to Nonqualified Deferred Compensation
-
Virtual
2.00 Credits
The basics of nonqualified deferred compensation (NQDC) NQDC compliance Taxation of NQDC plans Types of NQDC plans Financing/funding NQDC plans Planning strategies
Surgent's Employee Stock Options: What Financial Professionals Should Know When Advising Their Clients
-
Virtual
2.00 Credits
What stock options are and why they are growing in popularity How stock options work, including the process of conveyance and vesting How to exercise stock options and the implications from doing so The risks associated with stock options and how to manage exposure Tax consequences and updates regarding stock options Strategies for selecting the best time to exercise stock options The difference between the two types of stock options: non-qualified and incentive The basic terminology relevant to owning and exercising options
Best Practices: Conducting Meaningful Walkthroughs
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Review of audit procedures.Documentation requirements.Real world examples of red flags that may arise.
Fraud Case Studies: 21st Century Professional Misbehavior
-
Virtual
4.00 Credits
The major topics that will be covered in this course include:Salient provisions the AICPA Code of Professional ConductExamination of actual fraudsDiscussion of internal controls that could have prevented or mitigated actual fraudsContemplation of epiphanies for your own professional scenarios.Implications for professional conduct and compliance with professional standards
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
Microsoft Outlook "Must Know" Email Tips
-
Virtual
2.00 Credits
The major topics that will be covered in this class include:Using Quick Parts to streamline message composition.Eliminating inefficient back and forth appointment scheduling with the Bookings app.Using category codes and contacts to send bulk emails.Sending emails to Teams and OneNote.Organizing your inbox with custom views, rules and folders.Mastering the search tools to find emails quickly.Review of key option settings to maximize email productivity.
ChatGPT Vision for Financial Analysis
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Introduction to GPT Vision - Understanding the fundamentals of GPT Vision and its capabilities.Advantages of Vision Mode Research - Exploring the unique benefits of visual data analysis over traditional methods.Accessing GPT Vision - Guidance on how to access and utilize GPT Vision capabilities.Financial Screenshot Analysis - Techniques for analyzing financial documents and reports through screenshots.Operational Insights from Visual Data - Using images to gain insights into operational processes and asset management.Integration with Google Maps - Learning how to combine ChatGPT's vision capabilities with mapping technologies for enhanced spatial analysis.DDPP Analysis - Applying descriptive, diagnostic, predictive, and prescriptive analysis to visual data.Sentiment and Facial Expression Analysis - Techniques for interpreting emotions and sentiments in images to gauge client and employee feedback.Body Language Interpretation - Analyzing body language in images to understand non-verbal cues in business contexts.Effective Photo Capturing Techniques - Best practices for taking photos that provide optimal insights for financial analysis.
A Culture of Regulatory Ethics: A Competitive Advantage
-
Virtual
4.00 Credits
The major topics that will be covered in this class include:Does it pay for a company to have strong ethics?Can you measure the financial impact of ethics?Does ethics make a difference in financial performance?Can ethics be used as a competitive advantage?What sets the CPA designation apart?AICPA Code of Professional Conduct & the Conceptual Framework ApproachEthics as a marketing toolPersonalizing your Code of EthicsFour building blocks of ethical cultureWhat influences employee behavior?Ethical researchBuilding trust in organizationsMaintaining objectivity in difficult situations
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
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
A Working Parent's Guide to Prioritizing Mental Wellness
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Challenging Cultural Expectations and Managing Stress: Explore the impact of societal pressures and develop strategies to counter unrealistic expectations while managing stress effectively.Prioritizing Self-Care and Physical Well-Being: Learn the importance of self-care, including sleep, exercise, relaxation, and setting boundaries, as well as understanding the critical connection between physical and mental health.Seeking Support and Building Resilience: Recognize when to seek help -whether through therapy, friends, or family- and develop skills to build resilience, create flexible work arrangements, and identify when additional support, such as professional intervention, is needed.
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 The Accounting Leaders' Survival Guide - Strategies for Managing Organizational Change
-
Virtual
2.00 Credits
Learn the power of flexibility and adaptability Manage daily changes and stressors Avoid burnout and achieve work-life balance
Surgent's Unconscious Bias for Managers, Supervisors, and Executives
-
Virtual
2.00 Credits
Unconscious bias, including the five defining characteristics of unconscious bias The real-world impacts of unconscious biases, including impacts on racial minorities, women, and older workers The concept of microaggressions, with examples An effective strategy for adult learning that can be applied to change unconscious biases, which can also be used to learn other skills A framework for handling mistakes and using them to build trust and respect in the workplace. We call this the “oops, did I just say that?” section.
Surgent's Tax Planning for Rental Real Estate
-
Virtual
4.00 Credits
Rental activities and passive activities Material participation Real estate professional status Active participation status Depreciation recapture – Sections 1245, 1250, and 291 Vacation homes rented out QBI deduction and rental properties Section 1237 safe harbor for divided parcel sales Practitioner considerations
Mastering Partnership Basis: Inside and Outside Basis
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Explain the use of both "inside" and "outside” basis determination.How to calculate tax basis capital accounts, including when the entity is formed, including the impact of contributed property.Clarify the importance of partnership capital accounts and partnerships debt on partner's tax basis.Explanation of how basis is impacted distributions and by sale and/or liquidation of the partnership interest.Comprehensive example to illustrate the mechanics of the basis determination process.
How Fraud Can Affect Smaller Organizations
-
Virtual
4.00 Credits
The major topics included in this course include:The reasons for fraudFraudulent acts that are initiated against smaller organizationsMethods to stop fraud attempts against small businesses
