CPE Catalog & Events
K2’s Excel Best Practices
-
Online
8.00 Credits
Member Price: $250
In the ever-evolving world of spreadsheets, staying ahead means mastering the latest and best techniques. Join our comprehensive program and dive deep into the best practices for creating, editing, and auditing Excel workbooks. You'll learn how to secure your workbooks, collaborate seamlessly with others, and effectively report data. Today's Excel best practices are a far cry from those of the past. This "must-see" CPE program will equip you with the knowledge to work smarter, not harder. Our course materials are packed with relevant examples to enhance your learning experience. Don't miss out on this opportunity to fully utilize Excel and elevate your skills to new heights. Delivery Method: Individual webcast CPE Credit: 8Program Level: Advanced
Comprehensive Estate Planning: Administration & Postmortem Strategies
-
Online
8.00 Credits
Member Price: $250
Navigating the complexities of estate and trust administration is a vital skill for professionals, who play an integral role in the administration team. This comprehensive course is designed to equip professionals with a thorough understanding of their responsibilities and the processes involved in estate administration, enhancing their ability to address estate settlement issues effectively. Participants will be provided with a detailed overview of the professional’s role in estate and trust administration, emphasizing practical insights and strategies for managing assets, addressing the legitimacy of debts and creditors, and ensuring the proper distribution of assets. **Please Note: If you need credit reported to the IRS for this IRS approved program, please download the IRS CE request form on the Course Materials Tab and submit to kori.herrera@acpen.com. Delivery Method: Individual webcast CPE Credit: 8Program Level: Intermediate
Leaders Eat Last. Why? 1 Hour Session
-
Online
1.00 Credits
Member Price: $39
Trust is essential, because without trust, there can be no teamwork. Trust is like oxygen, when it is gone - we suffocate. This session provides a 15-step action plan to gain commitment from your team members, build trust, hold each person accountable and create results for your organization. Delivery Method: Individual webcast CPE Credit: 1Program Level: Intermediate
Numbers to Narrative: Storytelling in Business Communication
-
Online
1.00 Credits
Member Price: $55
Information becomes influential when it is structured. In this 1-CPE session (Professional Development), participants explore narrative frameworks presented in the course materials, including situation-complication-resolution and hero-based narrative arcs. Using business-oriented examples, the session demonstrates how structured storytelling enhances clarity and impact without sacrificing rigor. Participants will examine how to define context, introduce tension, present evidence, and guide audiences toward resolution. The emphasis is on logical flow and disciplined narrative construction rather than dramatization. The course concludes with application of a structured storytelling model to a professional scenario. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.This course is being offered by a learning partner and will not be accessible on your My CPE page. Access information will be emailed directly to you by CPA Crossings.
K2’s Expense Reporting Automation
-
Online
2.00 Credits
Member Price: $89
Managing and auditing employee spending on personal and corporate credit cards is a challenge everywhere. Legacy manual expense reporting preparation and approval processes are tedious and repetitive and are an excellent place to start your company's use of business process automation solutions. This session will cover a variety of expense workflow tools which use technologies and features like bank feeds, mobile receipt capture, OCR data extraction/filling, automated policy enforcement, and artificial intelligence-based validation to automate and eliminate the tedium. Attend this session and learn how to use automation and cure the expense reporting blues for you and your employees. Delivery Method: Individual webcast CPE Credit: 2Program Level: Intermediate
Common Sense CFO: Decoding and Mitigating Internal and External Risks
-
Online
2.00 Credits
Member Price: $89
Do you get bored with similar rubrics’ cube COSO risk model courses? They are important and great, but this course is intended to offer a fresh approach on the view of risk using the dynamic landscape of modern business; CFOs are charged with navigating an array of external and internal risks that can impact organizational performance and sustainability. This seminar will empower finance professionals with the foresight and practical tools needed to understand, anticipate, and mitigate both external and internal risks. We must be aware and anticipate. If we do not adequately prepare, we will be exposed to avoidable and onerous risk. Essential for leaders and organizations that want to survive and thrive. This seminar stands on its own but is also part of the Common Sense CFO series. Delivery Method: Individual webcast CPE Credit: 2Program Level: Intermediate
Accounting Update in a Post COVID-19 World
-
Online
2.00 Credits
Member Price: $89
The COVID-19 pandemic has altered corporate and public accounting in ways we could never have imagined. This broad-based course will discuss accounting and auditing implications that have arisen as a result of the pandemic. Delivery Method: Individual webcast CPE Credit: 2Program Level: Basic
Accounting for the Gig Economy
-
Online
2.00 Credits
Member Price: $89
Freelance work and other non-permanent employment arrangements are becoming increasingly popular ways for people to earn a living. Although these non-traditional activities offer novel, flexible ways to earn income from diverse sources, they also introduce nuanced recordkeeping, reporting, and attestation issues. We investigate characteristics of the gig economy, employee-versus-contractor considerations, bookkeeping, regulatory compliance, and external reporting considerations. We also explore best practices for CPAs who fulfill the role of trusted advisor for gig economy clients. Delivery Method: Individual webcast CPE Credit: 2Program Level: Intermediate
Fiduciary Accounting Part 4: The New Frontier—Total Return Trusts 26-27
-
Online
2.00 Credits
Member Price: $99
Because fiduciary accounting has not kept up with the times in relation to finance and economics, it's often tricky for the fiduciary to provide a level of benefit to the income beneficiary without negatively impacting the remainder beneficiaries. In order to modernize fiduciary accounting, new provisions provide for a more modern approach using either the "trustee's power to adjust" or "unitrusts." We will explore these new frontier trusts and their application to your fiduciary clients. Be sure to register for all four parts: Fiduciary Accounting Part 1: Fiduciary Duty Basics & Authority Fiduciary Accounting Part 2: Tools, Rules and Relationship to Tax Fiduciary Accounting Part 3: Special Accounting Elections & Distributions from Entities Fiduciary Accounting Part 4: The New Frontier (Total Return Trusts)Delivery Method: Individual webcastCPE Credit: 2Program Level: Intermediate
How AI Fits into the Accounting World 26-27
-
Online
2.00 Credits
Member Price: $99
This session is designed as a primer to introduce artificial intelligence (AI) and to discuss how it will impact accountants as they work. The material will briefly explain what AI is and then focus on ways that it is already serving those in the accounting realm. It will close with a look at future AI-centric developments that will have great potential to positively impact on the accounting profession. Those wishing to gain an understanding of what artificial intelligence is and how it will be used by accountants should consider attending this session.Delivery Method: Individual webcastCPE Credit: 2Program Level: Basic
Smart Formula Selection in Excel: What to Use When
-
Online
2.00 Credits
Member Price: $89
Excel gives you multiple ways to solve the same problem - but which formula is the right one? This course teaches a decision-based approach to function selection, helping you confidently choose between similar and competing functions. Through real-world examples and side-by-side comparisons, you'll learn when IFS or SWITCH is cleaner than nested IFs, how SUMPRODUCT can help with complex summarizing data, how to use LET in place of defined names, and much more. Ideal for professionals who want to make smarter, faster formula choices that are easier to maintain and audit. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.This course is being offered by a learning partner and will not be accessible on your My CPE page. Access information will be emailed directly to you by CPA Crossings.
Surgent's Annual Update for Defined Contribution Plans
-
Online
2.00 Credits
Member Price: $99
This course will provide a general understanding of the current and prospective reporting and disclosure requirements for employee benefit plans. Participants will be provided with an insight into the common errors and mistakes made by auditors and plan administrators. Results from the Department of Labor's ("DOL") audit quality study will be discussed and reviewed. This material will provide auditors and plan administrators with up-to-date information regarding defined contribution plans auditing, reporting and disclosure requirements.Delivery Method: Individual webcastCPE Credit: 2Program Level: IntermediateThis course is being offered by a learning partner. You may access the Surgent platform through the My CPE page on vscpa.com after purchase.
Surgent's Section 754 Step-Up in Basis: Understanding the Tax Issues for Partnerships and LLCs
-
Online
2.00 Credits
Member Price: $99
When a purchaser buys an existing partner's partnership interest or the interest of a member of a limited liability corporation (LLC) taxed as a partnership, the amount paid becomes the basis for the purchaser's partnership interest (outside basis). If the partnership's assets have appreciated sufficiently, the difference between the new partner's inside and outside basis can be substantial. This disparity can deprive the new partner of depreciation deductions and inflate his or her share of the gain from subsequent property dispositions unless a Section 754 election is in effect. The Section 754 election can also apply when a partnership makes a distribution of property and the basis of the distributed property to the partnership and the basis the partner/distributee will take in the distributed property are not equal. In this case, a partnership can recover basis it would otherwise lose if the 754 election were not in effect.Delivery Method: Individual webcastCPE Credit: 2Program Level: IntermediateThis course is being offered by a learning partner. You may access the Surgent platform through the My CPE page on vscpa.com after purchase.
Mastering Rapport Skills for Fun and Profit
-
Online
4.00 Credits
Member Price: $149
You only have one chance to make a good first impression. In the fast paced world we live in, being able to create immediate rapport and a sense of trust with people is more important than ever. Fortunately, this is an easily learnable skill that can serve you in both business and in life. People who can master the one minute relationship end up making more money, being better liked, and enjoying their clients more. Delivery Method: Individual webcast CPE Credit: 4Program Level: Basic
Create Measures in Power BI that Define Your Metrics
-
Online
4.00 Credits
Member Price: $149
Unlock the full potential of your data with our specialized course, "Create Measures in Power BI that Define Your Metrics". Designed for professionals who aspire to excel in the dynamic world of data analysis, this 4-hour intensive training delves deep into the advanced functionalities of Microsoft Power BI. You'll embark on a journey to master the art of Data Analysis Expressions (DAX), a powerful tool in the Power BI suite to create metrics. This course is meticulously crafted to transform you into a proficient user, capable of harnessing complex DAX calculations to bring your data to life. The course content is thoughtfully structured to ensure a comprehensive learning experience. Starting with the foundational elements of DAX, you'll rapidly progress to tackle advanced formulas and time-intelligent functions, essential for nuanced data analysis. The highlight of the course is the emphasis on the DAX calculation process, a crucial aspect for validating measures in Power BI. Additionally, the practical application of PivotTables for measure validation will equip you with the skills to confirm the accuracy and effectiveness of your data measures. These advanced techniques are not just theoretical concepts but are presented through engaging, real-world scenarios, enabling you to apply your learning immediately to your daily tasks. This course is an invaluable step towards mastering Power BI and making data-driven decisions with confidence. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.This course is being offered by a learning partner and will not be accessible on your My CPE page. Access information will be emailed directly to you by CPA Crossings.
K2’s Excel Essentials For Staff Accountants
-
Online
8.00 Credits
Member Price: $250
Staff accountants often face unique challenges when working with Excel, and their existing knowledge might not always meet their needs. This comprehensive eight-hour session is designed to bridge that gap and empower you with the essential skills to maximize efficiency and accuracy. Participate in this dynamic and engaging session, and you will learn how to: • Summarize data quickly and accurately • Generate stunning, professional reports • Create essential accounting calculations for depreciation, amortization, and interest We start with a quick overview of Excel best practices and dive into advanced topics like PivotTables, sophisticated formulas, Tables, formatting, and working with dates. Our course is packed with accounting-centric examples to reinforce key learning points. Plus, you'll enjoy a "laptop-friendly" environment with access to all demonstration files. This seminar is a must for all staff accountants eager to enhance their Excel skills and transform their workflow. Don't miss out on this opportunity to elevate your Excel expertise and take the first step towards mastering Excel today! Delivery Method: Individual webcast CPE Credit: 8Program Level: Intermediate
Microsoft 365 Application Lightning Round Review-Updated
-
Online
1.00 Credits
Member Price: $55
Do you use Microsoft (Office) 365? Are you satisfied that you are getting the most that you can from it? If you answered yes then no, this course will provide a really high return on your investment of time and money in this application suite. John Higgins, one of the profession's leading experts on the integration of Microsoft 365 into business, will explain and demonstrate the depth and breadth of the Microsoft 365 ecosystem. The course is designed to raise your awareness of all that you can do with Microsoft 365 and substantially increase your monthly subscription ROI. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.This course is being offered by a learning partner and will not be accessible on your My CPE page. Access information will be emailed directly to you by CPA Crossings.
How AI Fits into the Accounting World
-
Online
2.00 Credits
Member Price: $89
This session is designed as a primer to introduce artificial intelligence (AI) and to discuss how it will impact accountants as they work. The material will briefly explain what AI is and then focus on ways that it is already serving those in the accounting realm. It will close with a look at future AI-centric developments that will have great potential to positively impact the accounting profession. Those wishing to gain an understanding of what artificial intelligence is and how it will be used by accountants should consider attending this session. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.This course is being offered by a learning partner and will not be accessible on your My CPE page. Access information will be emailed directly to you by CPA Crossings.
A Strategic Approach to Understanding Compensation Structures
-
Online
1.50 Credits
Member Price: $79
Understanding the principles and practices of compensation is essential for creating a motivated and satisfied workforce. In this webinar, we'll explore how these crucial elements drive fairness and engagement in HR practices. This program is designed for HR professionals and business leaders seeking to enhance their compensation strategies. Delivery Method: Individual webcast CPE Credit: 1.5Program Level: Intermediate
Benford’s Law and Other Digital Analysis Techniques
-
Online
1.80 Credits
Member Price: $79
Numbers and especially the digits within those numbers can conceal a lot of information. Benford's Law and other digital analysis techniques can be the keys to unlocking that information. This session will explain what Benford's Law is, how it works, and how it can be used to reveal bogus information and made-up data. Accountants and auditors should understand how to use this valuable audit tool as well as other digital analysis techniques. But, if you attend this session, you must promise not to reveal the secret behind these techniques to any fraud perpetrators. Delivery Method: Individual webcast CPE Credit: 1.8Program Level: Basic