WICPA CPE & Special Event Catalog
Surgent's Use the Data Model to Build More Powerful PivotTables
-
Online
2.00 Credits
Member Price: $99
Do you love PivotTables? Of course, we all do! Traditional PivotTables are incredible, but they do have limitations. If you have ever encountered one of these limitations, you'll be excited to learn that by using the Data Model as the source for PivotTables, you'll be able to bypass many of the restrictions that exist with traditional PivotTables. The data model (also referred to as Power Pivot) is included in Excel 2016+ for Windows and available as a free download for previous versions (excluding Excel for Mac). Using the data model enables you to build PivotTables that were previously not practical. If you frequently build PivotTables and would like to do more with them, you'll want to understand how to use the data model (Power Pivot) to enhance your reports. Note about Excel versions: Power Pivot is not available in all versions of Excel, including Excel for Mac. If you would like to see if Power Pivot is available in your version of Excel, visit the Microsoft site.
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.
Just Ask Why: Searching for Answers: Generating Solutions
-
Online
4.00 Credits
Member Price: $149
Breaking the Wall of blind acceptance; avoiding habitual complacency & Yoking the dots between cause & effect.
Fraud, Controls & Ethics: Best Practices & Case Studies
-
Online
4.00 Credits
Member Price: $149
This course explores actual fraud circumstances through the lens of potential prevention. We will examine how selected frauds were accomplished and consider what internal controls may have prevented fraudsters from achieving their nefarious acts. Then we will switch gears to an interactive, case-based discussion that asks participants to reach their own conclusions by analyzing facts in concert with the AICPA Code of Professional Conduct and other sources of ethical guidance. This course ultimately provides practical, action-oriented insight that can be implemented by accounting professionals in both public practice and industry. This event may be a rebroadcast of a live event and the instructor will be available for questions during the event.
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.
Controls to Secure the Growing Digital Footprint
-
Online
4.00 Credits
Member Price: $149
The amount of electronic content that business organizations contend with is growing at incredible rates. Terms like "Big Data" and "Information Overload", are being used by overwhelmed information workers on a daily basis. Additionally, because of the move to a much larger telecommuter footprint, electronic data is now even more prevalently utilized. This session discusses the places that businesses keep digital information and addresses the importance of securing corporate electronic data. The material effectively shows ways to achieve high security standards for content stored in fixed locations, on mobile devices and in the cloud. Participants in this session will gain an understanding of the concepts needed to improve the way they and their companies secure digital information. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Becoming Conflict Competent
-
Online
2.00 Credits
Member Price: $89
Conflict is often avoided, or dealt with in a passive manner. When ignored, conflict often escalates and can become polarizing. In this session, participants will gain insights for enhancing their natural responses to conflict, learn healthy communication styles and build constructive behaviors to manage conflict. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Surgent's Social Security: Dispelling Common Myths with Essential Truths
-
Online
2.00 Credits
Member Price: $119
For roughly 90% of American retirees, Social Security income will be the foundation of their retirement income. Yet, many are ill-prepared and lack understanding of the critical aspects of making an informed claiming decision. Further challenged to separate fact from fiction, consumers crave accurate information from knowledgeable professionals to make the most out of these coveted monthly benefits. This course dispels common myths about Social Security that lead to confusion and replaces them with the truth to an empowered retirement. Help your clients navigate their claiming age decisions with greater confidence, equipped with the essential truths they should consider before pushing the Social Security "on" button.
The CFO Who Went to Prison
-
Online
2.00 Credits
Member Price: $89
Joshua, a CFO from Chicago, did not go to prison for stealing the $2 million in liquid cash he had access to on a daily basis. Instead, Joshua ended up in prison by rationalizing that he was entitled to a few small perks of the profession. This course explores Joshua's story and covers how and why executives with high annual incomes make short-sighted decisions that can cost them their job and freedom. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.Note: This course qualifies to count toward the WICPA membership Ethics CPE requirement.
Surgent's Advising a Client Regarding the Tax Consequences Associated with Buying or Selling a Business
-
Online
3.00 Credits
Member Price: $149
Buying and selling a business can be a complex transaction with many tax issues. These issues include whether the transaction is or should be a stock or an asset sale when the business involved is a corporation, as well as the tax consequences associated with the sale of a partnership or a C or S corporation. Accounting and finance professionals who advise clients who are buying or selling a business primarily focus on the tax issues that apply. This program explains and analyzes the tax issues practitioners must address in order to properly advise clients who are either buyers or sellers of businesses.
Excel Essentials for Today’s Accountant: How To Become an Expert in One Day
-
Online
4.00 Credits
Member Price: $149
This course explores the increasingly complex features of Excel that facilitate efficient data analysis. We will introduce numerous analytical methods & techniques by using practical examples to illustrate how to unleash the power of Excel when manipulating, analyzing & reporting information & dive 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.
Real Estate Tax Issues: Passive Activity, Self-Rental & Section 199A
-
Online
4.00 Credits
Member Price: $149
This program will provide a detailed analysis of the real estate professional passive activity rules, including forms reporting examples & integrates those rules with when real estate is considered a "business" under the Section 199A flow-through entity deduction. A detailed analysis of the self-rental passive activity rules will be given, including forms reporting examples & integrates them with the flow-through entity rules related to self-rental. 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 & submit to kori.herrera@acpen.com
Forensic Accounting: Finding Hidden Treasure in Tax Returns
-
Online
4.00 Credits
Member Price: $149
Almost every business and individual has to file tax returns, which can be a great treasure trove of information for forensic accountants. Whether in a divorce, partnership dispute, recreating books and records, or bankruptcy proceeding, analyzing tax return information should be an initial step in uncovering income and assets. The IRS retains a large amount of information, both from taxpayers and 3rd parties who report financial transactions. This course will be your guide in gathering, analyzing and evaluating tax return information, so that you have a full picture of the financial investigation. Your presenter is a 20 year veteran with IRS-Criminal Investigation, who used this information as a basis for his federal criminal investigations. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
What's Behind the Data?
-
Online
2.00 Credits
Member Price: $89
We are bombarded with information continually. So how do we determine what is valid and what isn't? This course points out common pitfalls inherent in data interpretation and gives practical tips to overcome those pitfalls by using real life examples. The course incorporates information from key thought leaders including Adam Grant, Alex Edmans and Hans Rosling. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Internal Control Frameworks for Single Audit
-
Online
1.00 Credits
Member Price: $39
The Uniform Guidance identifies COSO & the Green Book as best practices for internal controls in governmental audits. This course provides a comprehensive review of the COSO framework, including its 2013 update & explores its application to the Green Book. Attendees will learn to recall the five components & 17 principles of internal control, understand the benefits of adopting internal control frameworks & recognize the rationale behind the COSO 2013 update & its impact on auditing practices. Additionally, the course will cover how to leverage Part 6 of the Compliance Supplement to effectively document internal controls.
The Hardest Ethical Dilemma! Why Revenge Will Always Backfire, featuring Bob Mims & Don Minges
-
Online
1.00 Credits
Member Price: $39
We believe in fairness. When others do wrong & their action hurts us: the natural reaction is to fight back & seek retribution. Simple human nature & we are all human. We want fairness & want to fight back, but this is one of the toughest ethical dilemmas we all face. What should we do & what we do are not always the same. What if being nice, or specifically being a positive best version of yourself, makes you a more effective leader? Ethical leadership is effective leadership. That's what Dr. Cohen, noted psychologist, transformational speaker, executive coach & author of Be The Sun, Not The Salt, has been teaching organizations to do for years. Dr. Cohen's work is based on scientific studies of human behavior broken down into simple, easily digestible pillars structured around the Heliotropic Effect. In this webcast we will discuss Dr. Cohen's path to this work, what the Heliotropic Effect is & how Be The Sun, Not The Salt is the perfect reminder to Do More of That every day.Note: This course qualifies to count toward the WICPA membership Ethics CPE requirement.
Business Tax Update: OBBA & Recent Developments
-
Online
2.00 Credits
Member Price: $89
A discussion of the latest tax developments impacting business taxpayers, with a focus on important provisions, rules and concepts. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Financial & Tax Accounting for Partnerships & LLCs
-
Online
4.00 Credits
Member Price: $149
This program compares & contrasts the financial accounting for partnerships & LLCs, as well as discusses the tax accounting for these entities, with a thorough discussion of the important differences between financial accounting for partnership capital accounts & the tax accounting for partnership capital accounts. Financial accounting for operations of a partnership will also be addressed. This course does not qualify for IRS credit.
Navigating Mergers & Acquisitions With AI: The Future of Deals
-
Online
4.00 Credits
Member Price: $149
Mergers & acquisitions can be complex, risky & filled with unexpected challenges-- but they don't have to be overwhelming. This course provides a clear & practical overview of the M&A process, helping professionals understand the critical stages of evaluating opportunities, structuring deals, conducting due diligence & navigating post-transaction integration. Participants will learn practical techniques that help organizations avoid the common traps that derail many transactions while improving the likelihood of successful outcomes. The session also explores how emerging AI tools are beginning to enhance deal analysis, uncover deeper insights & support better decision-making throughout the M&A process.
Let's Play The 90 Day Money Game!
-
Online
4.00 Credits
Member Price: $149
The key to building a long-lasting relationship with your clients is to become more than just their accountant. Your clients already trust you with their tax & compliance work, but why not take it to the next level. By learning how to play the 90-day money game, you can help your clients elevate their income & take their earning power to the next level. Once you master the philosophy & practical tools for yourself, they can be easily shared with your own clients. Many clients silently suffer financially & are afraid to ask for help. By helping them play their own 90 day money game, you can support their financial wellbeing & turn good clients into GREAT ones! Here's how it works: Take your money challenges & turn them into money confidences by playing the 90-day money game. We will address three areas: INCOME: creating & working toward a Bold Money Goal IMPACT: expanding your reach in the world with clients & contacts INNER PEACE: turning the stress around income creation into a fun, peaceful experience. Reclaim your personal power around this important topic! Don't stay stuck in your story, waiting for the outside world to change before you claim your financial success. Action that is fueled by stress is inefficient & exhausting. Learn how to take action From inspiration. Discover a new way to think about money creation & nourish yourself in the process. Remember...You are you OWN economy. Learn how to create this reality now! The next 90 days will pass by one way or the other: let's decide to use that time in a clear & direct way to create a Money Breakthrough! Learn this winning philosophy for yourself & then use these principles & tools in your work with clients.