CPE Catalog & Events
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
GASB 96 –SBITA, GASB 94 P3, and GASB 87 Leases (Year 2)
-
Online
2.00 Credits
Member Price: $89
This is a 2 hour webcast that will focus on the similarities between all three of these GASB accounting standards that deal with contractual arrangements such as leases, Subscription-Based Information Technology Arrangements (SBITA) and P3s. Compare and contrast these standards as you prepare for implementation this year of GASB 94 and GASB 96, and review the implementation efforts of Leases in Year 2. Delivery Method: Individual webcast CPE Credit: 2Program Level: Basic
HR’s Role in Business Evolution: Strategy, Finance, and Growth
-
Online
2.00 Credits
Member Price: $89
This course is tailored for business leaders and HR professionals who want to enhance their strategic management skills and create actionable plans for success. You’ll learn the overall strategic management process, how to develop both simplified and detailed business and strategic plans, and the crucial role of corporate culture, leadership, and staff development in driving or hindering strategic outcomes. Additionally, you’ll explore how to leverage ChatGPT (Generative AI) as a powerful tool to improve your performance as a key business partner to the management team, helping you make data-driven decisions and enhance organizational effectiveness. Delivery Method: Individual webcast CPE Credit: 2Program Level: Intermediate
Navigating IRS : Responding to IRS Notices & Letters
-
Online
2.00 Credits
Member Price: $89
This 2-hour course gives tax professionals the tools to understand, interpret, and respond appropriately to IRS correspondence. Whether the letter involves audits, collection notices, missing information, or discrepancies, participants will walk away with practical tips for communication, compliance, and resolution. Using real-world examples, the session covers common notices like CP2000, CP14, CP75, CP504, and audit letters, as well as IRS timelines and what they expect in a reply. We’ll also talk about avoiding missed deadlines, maintaining documentation, and using AI tools where appropriate to manage responses efficiently and accurately. *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 terri.storer@acpen.com Delivery Method: Individual webcast CPE Credit: 2Program Level: Intermediate
The Current and Future Landscape of Audit Technology
-
Online
2.00 Credits
Member Price: $89
Explore the transformative impact of technology on the audit profession in this forward-looking course. Gain practical insights into cutting-edge tools and trends, including data analytics, artificial intelligence (AI), and automation, and discover how these advancements are revolutionizing audit methodologies and improving audit quality. Through engaging demos, case studies, and actionable tips, you'll learn how to navigate the evolving audit landscape with confidence and adaptability. This session is designed to equip CPAs with the knowledge to embrace innovation and stay ahead in a rapidly changing profession. 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.
Global Internal Audit Standards (GIAS) Domain IV - Part 1
-
Online
2.40 Credits
Member Price: $99
The new Global Internal Audit Standards were released on January 9, 2024, and will become effective January 9, 2025. The previous version, the International Standards for the Professional Practice of Internal Auditing, released in 2017, remains approved for use during a one-year transition period. The Global Internal Audit Standards guide the worldwide professional practice of internal audit. They serve as a basis for evaluating and elevating the quality of the internal audit function. The Standards use 15 guiding principles with five separate domains that enable effective internal audit implementation and examples of evidence of conformance. The Global Standards are organized into five domains. Domain I: Purpose of Internal Auditing Domain II: Ethics and Professionalism Domain III: Governing the Internal Audit Function Domain IV: Managing the Internal Audit Function Domain V: Performing Internal Audit Service Delivery Method: Individual webcast CPE Credit: 2.4Program Level: Update
Data Analytics & Journal Entry Testing for Auditors
-
Online
3.00 Credits
Member Price: $109
This course provides a practical understanding of IT controls and SOC reporting within financial audits. Participants will learn how to interpret SOC reports, evaluate control effectiveness, and determine reliance strategies. Real-world examples will demonstrate how IT controls tie directly to relevant financial statement areas and alignment with Complementary User Entity Controls (CUECs). Delivery Method: Individual webcast CPE Credit: 3Program Level: Intermediate
The Essential Guide to Understanding Private Company Financial Statement Disclosures with Renee Rampulla
-
Online
4.00 Credits
Member Price: $149
This course addresses frequently encountered disclosures associated with the preparation of private company financial statements prepared in accordance with generally accepted accounting principles (GAAP) issued by the Financial Accounting Standards Board (FASB), or a "Special Purpose Framework"; (SPF), such as cash or tax basis. Learn to research presentation and disclosure requirements and examples using the FASB Codification and other resources. Understand frequent disclosure requirements such as contingencies, risks and uncertainties, accounting policies, revenue recognition, leases, credit losses, impairment, fair value, and much more. Know the additional disclosure requirements needed when preparing private company financial statements using a special purpose framework, such as cash or tax basis. Delivery Method: Individual webcast CPE Credit: 4Program Level: Update
Comprehensive Accounting and Financial Reporting Update
-
Online
4.00 Credits
Member Price: $149
This course covers recently issued accounting and financial statement reporting standards from the Financial Accounting Standards Board. Key implementation challenges and experiences from public company filings will be identified. 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.
Common Sense CFO: Crisis Management, Innovation, and Other Expectations Put on CFOs
-
Online
2.00 Credits
Member Price: $89
The role of today's financial leader, including CFO, transcends traditional financial stewardship; it demands agility, innovation, crisis management, and strategic foresight. This seminar will discuss the new, multifaceted skills and insights needed to excel in the dynamic role of modern finance. Through a blend of theory, research, and practical exercises, participants will explore the diverse roles of a CFO as innovation champions, technology evangelists, crisis managers, and change agents - leveraging practical principles to drive organizational success. Financial leaders can adapt or be left behind. Whether you are a seasoned CFO or aspiring to step into a leadership position, this seminar will discuss the essential tools and insights to navigate the newer demands of financial managers with confidence and competence. Delivery Method: Individual webcast CPE Credit: 2Program Level: Intermediate
Advanced Excel: Hidden Secrets and Gems
-
Online
2.00 Credits
Member Price: $89
This course dives into the powerful, but potentially under-utilized, capabilities of Microsoft Excel. Designed for sophisticated users willing to approach spreadsheets from a unique perspective, this program encourages users to challenge the status quo by considering opportunities to take acceptable spreadsheets to a new level. Delivery Method: Individual webcast CPE Credit: 2Program Level: Intermediate