CPE Catalog & Events
Partnership/LLC Taxation: Tax Basis Capital Accounts
-
Online
2.00 Credits
Member Price: $89
This program addresses the most recent developments impacting partnerships operating as LLCs, with a focus on legislative, administrative, and tax form changes. Emphasis will be placed on partners "tax basis" capital accounts, now required for tax form reporting. 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.
Dashboard and Report Design Principles Using Excel
-
Online
4.00 Credits
Member Price: $149
Transform your data presentation skills with our comprehensive course on creating impactful dashboards and reports using Excel. This workshop is tailored for professionals who: Regularly produce or update dashboards and reports Struggle with confusing or overly complex reporting tools Seek to streamline varied reporting styles across their organization Aim to establish a consistent, replicable "house style" for reporting Want to impress stakeholders with clear, user-friendly data presentations Through a combination of theory and hands-on practice, you'll learn the fundamental principles that make reports and dashboards easy to understand. We'll distill these concepts into a set of practical rules and guide you through their application in Excel. Delivery Method: Individual webcast CPE Credit: 4Program Level: Basic
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
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
Hands-On Tax Return Workshop – Partnerships & LLCs (Form 1065)
-
Online
8.00 Credits
Member Price: $300
This case-driven training is designed to get the inexperienced accountant up to speed quickly in the most common areas of partnership, limited liability company (LLC) and limited liability partnership (LLP) taxation. A cornerstone of this course is the preparation of the Form 1065 using a fairly complex trial balance common to most partnership, LLP and LLC income tax returns. *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: 8Program Level: Basic
Resistance to Resilience: Strive for Tech Change Acceptance
-
Online
1.00 Credits
Member Price: $55
Technology adoption often comes with resistance, but it's possible to transform this challenge into an opportunity for growth. This course explores the journey from resistance to resilience in embracing new technologies, focusing on overcoming barriers and ensuring successful implementation. Participants will examine cutting-edge audit technologies, including AI, data analytics, and automation, and learn how to align these innovations with both organizational and personal goals. Through case studies, insights into the Technology Acceptance Model (TAM), and practical discussions, participants will gain the tools and strategies to foster acceptance, driving seamless integration of new technology into both individual tasks and team workflows. 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: Dealing with Ever Changing Accounting Standards and Strategy Demands
-
Online
2.00 Credits
Member Price: $89
GAAP is changing at an increasing rate. Every successful organization has a sound strategy. Financial leaders are faced with the dual challenge of navigating evolving accounting standards while strategically guiding their organizations toward sustainable growth and profitability. What are the newer accounting changes that will impact professional accounting? This seminar will equip finance professionals with the critical skills and practical insights needed to effectively manage the complexities of ever-changing accounting standards and upgrade your essential strategic planning skills. Strategic skills are mandatory today. Strategies that do not keep pace with the market are doomed to fail. If we do not keep up, our successor will. Delivery Method: Individual webcast CPE Credit: 2Program Level: Intermediate
Excelling at Excel: The Magic of Power Query
-
Online
2.00 Credits
Member Price: $89
Elevate your data analysis capabilities with our focused course on Power Query. Tailored for financial professionals, this training will show you how to get started using Power Query and teach you some of the ways to take advantage of its ability to handle messy data and automate repetitive tasks. Harness the efficiency of Power Query to revolutionize the way you work with data. Learn how to "program" your tasks once and set them on repeat, eliminating the need for repetitive, robotic work. This automation not only saves time but also ensures consistency and accuracy in your data processes. Whether you're dealing with complex datasets or simply looking to streamline your reporting processes, this course will equip you with the tools and knowledge to make Excel work for you like never before. 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
K2’s Taking Another Look At Power BI
-
Online
2.00 Credits
Member Price: $89
Although Power BI has been available for ten years, most business professionals don't fully appreciate all it can do and its easy use. Further, many are intimidated by the platform and continue to use less efficient and effective reporting practices. If this describes you, invest some time in this session to learn how to work with Power BI almost immediately. In this session, you will learn how to use Power BI to create compelling dashboard reports. You will also learn how to optimize these reports to enhance their effectiveness. If you want to improve financial and operational reporting processes, this session is for you! Delivery Method: Individual webcast CPE Credit: 2Program Level: Intermediate
Five Amazing Business Books in 100 Minutes
-
Online
2.00 Credits
Member Price: $89
If you are efficient and want to learn lessons from the best in a short time, this seminar is for you. Popular speaker Don Minges will review the key lessons from five fantastic business books that will help you become more effective. The topics are; leadership, how to create a valuable business, how to turnaround a business, how to make terrific presentations and how do humans think? These lessons are valuable for every business leader. Delivery Method: Individual webcast CPE Credit: 2Program Level: Intermediate
Making Effective Decisions When You Can’t Get Everything You Want
-
Online
2.00 Credits
Member Price: $89
Even if managers have incomplete information or constraints, they still must make choices. This session provides advice for navigating rocky decision-making terrain encountered by managers who must make choices despite imperfect information and/or constrained resources. We explore ways to leverage available information to make effective decisions when seemingly critical details cannot be obtained. We also illustrate managerial accounting techniques for optimizing profitability when inputs or resources are constrained by supply chain disruptions or other limitations. Delivery Method: Individual webcast CPE Credit: 2Program Level: Intermediate
Surgent's Excel Shortcuts for Accountants
-
Online
2.00 Credits
Member Price: $99
This webinar presents a variety of time-saving ideas, shortcuts, and tips that are sure to boost personal productivity. We discuss better summing, address one of the biggest pitfalls that Excel users have faced over the past 25 years, present the most important keyboard shortcuts, demonstrate a better alternative to hiding rows or columns, illustrate how to quickly navigate to other workbooks and files, and demonstrate using Excel with styles.Delivery Method: Individual webcastCPE Credit: 2Program Level: BasicThis 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 Guide to Calculating S Corporation Shareholder Stock and Loan Basis
-
Online
2.00 Credits
Member Price: $99
This program discusses, in a practical way, how an S corporation shareholder calculates their stock and loan basis on Form 7203. Form 7203 is the IRS Form on which a shareholder is sometimes required to calculate their stock and loan basis. This topic is particularly important when an S corporation has a loss and the shareholders wish to know whether they are entitled to fully utilize the loss that has been allocated to them against their other income.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.
Taxation of Business Entities
-
Online
2.50 Credits
Member Price: $99
This course will introduce you the different types of business entities and the tax implications of contributions, distributions and earnings, among other topics. **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: 2.5Program Level: Basic
Surgent's Understanding Partnership Taxation: Types of Basis, Contributions, and Distributions
-
Online
4.00 Credits
Member Price: $159
Calculating partnership basis is one of the most important things that we do as practitioners. However, it is also one of the most confusing. When we use the term "basis," we really could be referring to one of three different things. This course will explore the differences between inside basis, outside basis, and 704(b) basis. Through several examples and practice problems, we will show you how to easily distinguish among these terms. We will also explore the tax implications of initial contributions of property to a partnership as well as the different types of partnership distributions.Delivery Method: Individual webcastCPE Credit: 4Program 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.
How AI Is Automating Internal Control
-
Online
4.00 Credits
Member Price: $149
The term "artificial intelligence" (AI) has become mainstream and while most have a layperson's understanding of AI, few know the depth and breadth of this technology's capability. AI is affecting just about everything in business and in people's personal lives. The operation of an internal control system is also changing because of this incredible advancement. This session explains what AI is and how it works and then goes into detail about how it can be applied to a system of internal control. The material speaks about changes occurring in today's world as well as what's coming in the not-too-distant future. 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 PivotTables For Accountants
-
Online
8.00 Credits
Member Price: $250
Many business professionals consider PivotTables the most powerful feature in Excel, yet most accounting and financial professionals do not use them in their day-to-day activities. If you are ready to learn how to take advantage of PivotTables or extend your existing knowledge, then this course is for you! In this dynamic and engaging session, you'll master how to: • Build PivotTables from scratch • Group data inside PivotTables, including options for fiscal periods • Create user-defined calculations in your PivotTables We start with the fundamentals and quickly move to advanced techniques, including: • Building PivotTables that consolidate data from multiple ranges • Connecting PivotTables dynamically to external databases and financial accounting systems • Leveraging other Excel features associated with PivotTables, such as Slicers, Power Query, and Power Pivot This seminar is a must for anyone eager to enhance their Excel skills and transform their workflow. With guidance and coaching from your K2 instructor, you'll be ready to use PivotTables to analyze and report on extensive data sets in a fraction of the time you spend completing such tasks. Delivery Method: Individual webcast CPE Credit: 8Program Level: Advanced
Navigating IRS Collections: The Collection Process
-
Online
2.00 Credits
Member Price: $89
This course is designed for tax professionals seeking to understand and navigate the IRS collection process effectively. Participants will gain indepth knowledge of the various collection methods employed by the IRS, including liens, levies and wage garnishments. Additionall, participants will leand strategies to avoid or halt collection actions and the implications of the statute of limitations on tax collection. 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 Navigating Your Client Through the IRS Appeals Process
-
Online
4.00 Credits
Member Price: $159
Despite the fact that a client's tax matter may be taken directly to court, utilizing the IRS Independent Office of Appeals usually results in saving your client both time and money. Join us as we discuss the misunderstood process of navigating through the complex IRS Appeals.Delivery Method: Individual webcastCPE Credit: 4Program 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.