CPE Catalog & Events
Excel for Accounting Professionals Session 2: Data Validation and Conditional Formatting
-
Online
2.00 Credits
Member Price: $139
Which Excel function is your go-to? This session invites you to actively engage and practice with the instructor, exploring exercises demonstrated. In doing so, you'll gain a firmer grasp of common Excel functionalities, including: Data validation Conditional formatting Enhanced summing options Skinny rows Achieving proficiency in Excel features Gaining proficiency in Excel means learning to design workbooks that are both functional and streamlined. The facilitator will lead you through an array of formatting skills, formula functions, and beyond as we expand upon foundational Excel knowledge with topics such as: Managing data input for individual cells Using conditional formatting to prevent errors Enhancing productivity via the Subtotal feature Ensuring total formulas refresh automatically *Session 2 is one of eight sessions that is available as an individual session. Each session builds on the prior sessions, so you'll want to consider watching [Session 3: Workbook Design Principles and Organization] (https://www.aicpa-cima.com/cpe-learning/webcast/excel-for-accounting-professionals-session-3--workbook-design-principles-and-organization) to further prepare to tackle real-world issues and build powerful workbooks.*
Viewing A&A Through the Eyes of a Tax Practitioner
-
Online
2.00 Credits
Member Price: $89
This session offers insight for tax practitioners beyond merely checking a box to satisfy accounting and auditing requirements for license renewal. We devote significant attention to extracting utility from financial statements to support decision needs of both external financial statement users and internal stakeholders. We explore best practices for cross-functional support within firms that perform tax, accounting solutions, financial statement, and consulting services. We also highlight similarities and differences between U.S. GAAP and tax-basis accounting. 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.
Audit Skills for Beginners
-
Online
4.00 Credits
Member Price: $149
Learn the basic skills new staff need to hit the ground running and efficiently complete assigned tasks, including what new auditors are expected to know and do, including the nature, timing, and extent of common audit procedures. Focus on why certain procedures are performed and perform typical procedures. Delivery Method: Individual webcast CPE Credit: 4Program Level: Basic
The Essential Guide to Understanding Non-GAAP Financial Statements with Renee Rampulla
-
Online
4.00 Credits
Member Price: $149
Many entities prepare their financial statements using non-GAAP frameworks, such as tax and cash basis. Participants who attend this course will learn the unique reporting and disclosure requirements when preparing non-GAAP financial statements commonly referred to as special purpose frameworks (SPFs) or other comprehensive basis of accounting (OCBOA) financial statements. Delivery Method: Individual webcast CPE Credit: 4Program Level: Basic
Forensic Accounting: Investigating Divorce Cases
-
Online
4.00 Credits
Member Price: $149
With over 50% of marriages ending in divorce, forensic accountants are frequently used in uncovering hidden income and assets. It is not uncommon for one spouse to hide money from another, sometimes for nefarious reasons. As a CPA, your services are valued by high-net-worth individuals who hire attorneys in their divorce proceedings. In this course, you will learn the art of financial investigations and how to uncover the truth in divorce cases, whether from offshore accounts to lifestyle analysis. Step by step, the course will teach you the valuable skills necessary in finding, analyzing, evaluating, and presenting your findings to your client and if needed, ultimately in divorce court. 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.
Preparing and Reviewing Workpapers – Essential Tips for Avoiding Deficient Audit and Other Attest Engagements
-
Online
8.00 Credits
Member Price: $250
Workpapers are the primary support for findings, conclusions and opinions on any audit or other attest engagement. This course will provide the essential tips and techniques for ensuring workpaper documentation is of a high quality, yet efficient, nature. Delivery Method: Individual webcast CPE Credit: 8Program Level: Basic
You Don't Know What You Don't Know About Microsoft Excel
-
Online
8.00 Credits
Member Price: $239
Many Excel users have received little or no formal training to help them use the ubiquitous productivity application. This session can help users that wish to improve their Excel skills to increase their productivity. The material starts by covering basic topics such as time saving tips and keyboard shortcuts and then moves to more advanced areas like conditional formatting and complex formula building. Users that find themselves looking at the spreadsheets that others design and wishing they could do as much with Excel will benefit greatly by taking this course. 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 to Make Difficult People Disappear...Without Breaking the Law
-
Online
1.00 Credits
Member Price: $39
Have you ever found yourself wondering why people won't just listen to you? Or maybe you have found yourself surrounded by people that make your jaw clench...you know the people...the challenging people. Leaders walk a tightrope of being strong, but not aggressive, polite, but not a pushover. It is exhausting! In this session, you will uncover the secrets to working with (and overcoming) challenging people derived from the decades of experience Summer brings from her time on the frontlines and as an HR Professional working with companies such as Walt Disney World, H-E-B and even a dude ranch. Delivery Method: Individual webcast CPE Credit: 1Program Level: Basic
Behavioral Finance Biases
-
Online
1.00 Credits
Member Price: $55
If you have been a practitioner for any length of time, you know that there is often a difference between what clients should do and what they actually do. Have you ever wondered why that is? In this course, we will explore how we make decisions with less-than-perfect information. Through real-life examples and case studies, we will examine common behavioral biases and how to deal with them. 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.
Working Through Grief and Loss - How to Build a Supportive Workplace
-
Online
1.00 Credits
Member Price: $39
Now more than ever, navigating loss, grief and crisis in the workplace is a skillset that leaders must possess. Keeping the heart in human resources is so important, especially in this post-pandemic state we are living in. We will explore ways that you can show empathy to your employees while also balancing your business needs. Delivery Method: Individual webcast CPE Credit: 1Program Level: Basic
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 Bankruptcy Basics: Understanding the Reorganization and Liquidation Process in These Uncertain Economic Times
-
Online
2.00 Credits
Member Price: $99
Consumers and businesses file for bankruptcy to seek protection from creditors and to reorganize or liquidate debts. Bankruptcy filings rise and fall with the economy. Surveys show that loss of income is the leading cause of consumer bankruptcies, followed by medical expenses and foreclosure. Corporate bankruptcies, on the other hand, are often the result of several factors, including excessive debt, decreased demand, increased costs, lawsuits or poor accounting practices. It is no secret bankruptcy filings will see a tremendous uptick in the wake of the Covid-19 pandemic. As an accountant, CFP, attorney or other professional, you need to be able to discuss the process and different available courses of action with your clients. Both landlords and tenants will be influenced tremendously. Individuals will look to your advice for a discharge and new start. Businesses will do the same and will also need to advise loyal employees. Creditors will receive proofs of claim and look to you for your expertise. Take this course and make sure you can speak fluently to both creditors and debtors. As trusted advisors, then, professionals should have a basic understanding of the bankruptcy process. This course provides a thorough review of the consumer and corporate bankruptcy practice. Participants in this course will gain an understanding of how consumer and corporate bankruptcy proceedings begin and end, as well as learn about key issues that affect debtor and creditor rights during bankruptcy. This course provides information from the perspective of both debtor and creditor. Although bankruptcy concerns the debts of the debtor, the Bankruptcy Code provides substantial protections to creditors. Creditor rights, however, vary widely depending on the status afforded the creditor under the Bankruptcy Code. Do yourself, your clients and your profit margin a favor and sign up for this invaluable program. 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.
Fiduciary Accounting & Tax Planning for Estates & Trusts
-
Online
4.00 Credits
Member Price: $149
This course will review the fundamentals of fiduciary accounting and provide a reporting guide for determining whether receipts and expenditures are assigned to income or principal/corpus. Critical issues, rules, and special opportunities when preparing your clients' Form 1041 U.S. Income Tax Return for Estates and Trusts will be examined, including what is considered taxable income and allowable deductions. Planning and potential pitfalls will also be explored. This course only qualifies for 2 IRS credits. *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: 4Program Level: Intermediate
Planning for Small Business Success
-
Online
4.00 Credits
Member Price: $149
Strategic Planning for SMEs Delivery Method: Individual webcast CPE Credit: 4Program Level: Intermediate
What If Your Client Didn't Take Reasonable Compensation
-
Online
1.00 Credits
Member Price: $55
Are you a new advisor handling S Corp clients, or perhaps a seasoned professional facing this common scenario: "My S Corp client didn't take reasonable compensation last year. Now what?" Knowing that reasonable compensation isn't just a tax obligation, but a strategic financial decision, you need to be armed with expert knowledge to help your client navigate this situation. Join us to discuss IRS regulations, understand preventive measures, and address challenges within the year. 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.
Clear, Kind, and Accountable: A Leader’s Guide to Boundaries, Coaching, and Real Conversations
-
Online
1.00 Credits
Member Price: $39
Join us for a dynamic training session tailored for leaders seeking to cultivate a culture of accountability while fostering respect and trust within their teams. High morale is intrinsically linked to high accountability in today’s fast-paced work environment. Through this session, leaders will explore the intersection of accountability, psychological safety, boundaries, and trust, gaining practical insights and actionable strategies to effectively hold their employees accountable while maintaining a positive and supportive work environment. Delivery Method: Individual webcast CPE Credit: 1Program Level: Basic
Multiply Your Time: Tame Your To-Do List and Fight Distractions So You Can Get The Right Things Done
-
Online
1.00 Credits
Member Price: $39
You have more to do than time to do it. When you finally find the time, distractions steal it away again. As a leader with multiple layers of demands on your time, how can you possibly get it all done? In this course, I will help you learn practical productivity strategies so you can tame your to do list and multiply your time. It’s just wrong for a to-do list to rule your life. Learn how to take back your time…and your life. Delivery Method: Individual webcast CPE Credit: 1Program Level: Intermediate
Big Picture Mega-Trends, Big Data, and World We Now Face
-
Online
2.00 Credits
Member Price: $89
It is easy for us to get caught up in our work, but it is better to examine the ‘big picture’ by studying the outside factors that impact our business beyond our internal processes and day to day responsibilities. We are sometimes so busy with our tasks that we miss new developments until the developments have a profound impact on us and the organization. This session is designed to review many of these current trends, while thinking and discussing how these trends can impact our organizations and us. This is a fun and lively session that is intended to be interactive with participants either live, virtual or both. Our ever-changing world is evolving more than many realize. Delivery Method: Individual webcast CPE Credit: 2Program Level: Intermediate
Mastering the Excel Lookup Functions
-
Online
2.00 Credits
Member Price: $89
In today's data-driven world, Microsoft Excel has become an essential tool for professionals in any organization. To harness the full potential of Excel, it is crucial to understand and master its lookup functions. This course is designed to equip participants with the knowledge and skills needed to effectively utilize Excel's lookup functions and enhance their data analysis capabilities. Throughout this comprehensive course, participants will dive deep into the world of lookup functions and gain experience through practical exercises and real-world scenarios. Whether you're a seasoned Excel user looking to fine-tune your skills or a beginner eager to unlock Excel's full potential, this course is tailored to meet your learning needs. 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.
The Seven High Quality Questions that Lead to Success & Solutions
-
Online
2.00 Credits
Member Price: $89
“How will I EVER get this all done?" It’s a question I often hear from clients and on a particularly stressful day, I can hear myself saying these words! Instead of helping us focus, it's a question that leads to stress, anxiety and overwhelm! Regardless of where we are in business and in life, we will run into challenges and problems as we navigate business growth, leadership, work life balance and our quest for success and happiness. This workshop will explore the 7 HIGH QUALITY questions that lead to relief, enthusiasm and success. It will be an interactive exploration that will leave you with a game plan to use right away, as well as an opportunity to practice the mindset that the most successful and happiest people use daily. This program is for both the entrepreneur who wants to be more effective in their day as well as team leaders who want to stand out in their organization. For the business owner or staff member you can expect a new way to work with your day so that it's profitable, productive and happier. For leaders, you will learn new up- leveled skills to increase your efficiency, communication and productivity. You and your team will shine. Your staff will feel appreciated and connected to their value as well as the company's goals. Albert Einstein said 'we can't solve our problems with the same thinking we used when we created them'. The quality of your question will impact the quality of your solution. Learn the 7 questions that take you from confused and frustrated to creative and focused. Delivery Method: Individual webcast CPE Credit: 2Program Level: Basic