WICPA CPE & Special Event Catalog
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.
Securing Your Data with a Password Management App: Updated
-
Online
2.00 Credits
Member Price: $89
Cybersecurity protection is one of the most important responsibilities of every CPA professional to protect the confidentiality of sensitive client information. While there are many aspects of cybersecurity that need to be addressed, the biggest vulnerability to protect against is unauthorized access to your application login credentials. Once your login credentials are breached, the cybercriminal essentially has the keys to your data kingdom. John Higgins, a national leader in the CPA technology, will demonstrate the ease with which you can protect all of your login credentials with maximum security with minimal expense. You will leave this course prepared to deploy this state of the art security tool in your organization. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Firm Ethics -- A Practical Approach 26-27
-
Online
4.00 Credits
Member Price: $175
In this course, you'll review what ethics means for a CPA firm and how to use the rules. The interactive workshop is designed for practitioners in small and medium-sized CPA firms and includes generous time for questions and case studies. Note: This course qualifies to count toward the WICPA membership Ethics CPE requirement.
Shorten Month-End: Closing Best Practices
-
Online
4.00 Credits
Member Price: $149
Surveys show that the average North American company completes its monthly financial statement closing in six (6) days. However, some companies can close their books in one day or less. You don't have to sacrifice accuracy for speed. This session will show you how to close month-end faster, better & cheaper. Yes, to all three.
Comprehensive Passive Activity Losses (PAL) 26-27
-
Online
8.00 Credits
Member Price: $329
Passive Activity Loss (PAL) rules have never been more critical in Federal tax reporting. This course provides a comprehensive and complete review of the laws and regulations impacting PALs, including the rules governing rental real estate, grouping and the 3.8% net investment income tax. Learn what qualifies as a passive activity and the rules governing its application by exploring several recent court cases and the existing regulations to know how the IRS views this critical area of the tax law. The IRS is actively auditing the failure to report passive losses properly. You and your clients can't afford to be left behind.
GAAP Update 26-27
-
Online
8.00 Credits
Member Price: $329
This course is designed to give you a clear and concise understanding of the latest FASB changes that impact nonpublic entities, perfect for professionals who prepare or audit GAAP financials. In the first section, we'll walk through every Accounting Standards Update (ASU) issued in 2023 to 2026 that take effect in 2026 and beyond. We'll focus on explaining what's changed, which topics are affected and the key provisions you need to know about. Additionally, we'll discuss how these updates impact financial reporting and disclosure and, when possible, we'll explore the reasons behind the changes. By the end of this section, you'll be able to identify which ASUs apply to your clients or your own practice and where you may need to dive deeper into further research. In the second section, we'll explore the FASB's technical project and agenda, including a discussion of proposed Accounting Standards Updates that were exposed for public comment in 2025 and 2026. This section will provide you with practical insights to help you navigate the evolving landscape of GAAP and ensure compliance.
Tax Planning for Sole Proprietors & Other Business Owners 26-27
-
Online
8.00 Credits
Member Price: $329
Individuals are leaving the workforce in droves due to retirement or resignation and many are choosing to start their own businesses. The One Big Beautiful Bill encourages this choice. This course explores the planning opportunities for those starting their own businesses or advising clients. Issues addressed include making sure you will be treated as a business, choice of entity, Schedule C deductions, depreciation, avoiding the self-employment tax, retirement plans, self-employed health insurance, employing family members and loss limitations.
Entertainment, Meals & Travel Expenses: Review & Update
-
Online
2.00 Credits
Member Price: $89
This program reviews the statutory and regulatory guidance as they relate to fringe benefits. There will be an emphasis on entertainment, meals and business transportation expenses, including qualified employer-provided parking, with a focus on planning opportunities. Recent federal tax legislation, cases and rulings will also be addressed. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
The Single Audit From Beginning to End Update
-
Online
8.00 Credits
Member Price: $250
This course is an updated overview of the single audit of state & local governments & not-for-profit organizations under the OMB Unified Circular, as well as the applicable AICPA standards for compliance audits.
Internal Controls Over Compliance versus Compliance
-
Online
1.00 Credits
Member Price: $55
Accurately identifying and testing controls over compliance is critical, yet it remains a common deficiency highlighted in peer reviews. This course offers a comprehensive overview of internal controls over compliance, with a focus on their application to Single Audits. Participants will learn how to effectively align internal controls with specific compliance requirements. Additionally, we will address one of the most frequent findings in audits of governmental entities receiving federal grants: the misidentification of controls and the confusion between compliance and control processes. This course will help clarify the distinction, equipping you with the tools to enhance audit quality and ensure compliance effectiveness. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Global Internal Audit Standards (GIAS) Domain V: Part II
-
Online
2.00 Credits
Member Price: $89
The new Global Internal Audit Standards were released on January 9, 2024 & 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 & elevating the quality of the internal audit function. The Standards use 15 guiding principles with five separate domains that enable effective internal audit implementation & examples of evidence of conformance. The Global Standards are organized into five domains. Domain I: Purpose of Internal Auditing Domain II: Ethics & Professionalism Domain III: Governing the Internal Audit Function Domain IV: Managing the Internal Audit Function Domain V: Performing Internal Audit Service
K2’s CRM: The Ultimate Business Automation Tool
-
Online
2.00 Credits
Member Price: $89
This course provides an in-depth exploration of Customer Relationship Management (CRM) systems as a critical tool for business automation. Designed for accounting professionals, it emphasizes CRM's role in streamlining workflows, organizing communications, enhancing client relationships & improving efficiency. Participants will learn about key CRM features, integration with accounting software & best practices for successful implementation. We will highlight practical applications with actionable insights to help attendees optimize their processes. This two-hour session ensures you walk away with a basic understanding of CRM's transformative potential for business & financial management.
Excelling at Excel: Tips, Tricks & Updates
-
Online
2.00 Credits
Member Price: $89
Unlock the full potential of Excel with our comprehensive training on shortcuts & formulas. This course is designed for CPAs & financial professionals who want to enhance their efficiency & accuracy in Excel. Learn how to navigate & utilize different versions of Excel, discover powerful new functions & master the art of creating effective tables & automations. With practical examples & hands-on exercises, you'll transform your Excel skills, making your daily tasks quicker & more precise. Plus, benefit From insider tips & tricks drawn From the instructor's extensive real-world experience. Whether it's mastering keyboard shortcuts that save you time or applying formulas that simplify complex calculations, you'll gain practical knowledge that you can immediately apply in your work. This course isn't just about learning Excel; it's about learning to excel at Excel.
Big Picture Mega-Trends, Big Data & 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 & 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 & the organization. This session is designed to review many of these current trends, while thinking & discussing how these trends can impact our organizations & us. This is a fun & 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.
Forgotten Managerial Accounting Tools for CPAs
-
Online
2.00 Credits
Member Price: $89
This session revisits managerial accounting techniques that you may not have considered for many years, even though they could be invaluable for CPAs in both business and public accounting. You will appreciate a fresh perspective of concepts you may not have considered since your college days. We will illustrate concepts with practical examples that you can immediately bring back to the office! This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Google Gemini Deep Dive Hands-on Bootcamp for CPAs 26-27
-
Online
2.00 Credits
Member Price: $99
Google Gemini has emerged as a top leader in the generative AI competition. Due to the extraordinary size of the Google user base, it a tool that every CPA should have a basic understanding of how to use it and apply it in business. This course will provide a comprehensive review and demonstration of how to put Google Gemini AI to work for you and your clients. It is designed as a "hands-on" course that facilitates you following along with the presenter to apply the features of Gemini on your computer. Practice files will be provided so that you don't have to expose your confidential data.
Fraud’s Greatest Hits!
-
Online
3.00 Credits
Member Price: $109
Fraud has always been a concern for anyone associated with financial statements. In this course, Jeff takes a unique approach to the study of this topic by looking at what are considered to be the top ten accounting fraud cases. In studying the cases, you will gain insight into what to look for in the future. In addition to the cases, Jeff will cover various aspects, both authoritative & guidance, related to fraud to further improve your awareness & skills. He will also cover a couple of other significant fraud cases as well as a couple of interesting historical notes. The entire presentation is packaged into Jeff's unique blend of teaching with humor. Each case has its own "Greatest hit", a song parody to help you remember the case as well as other surprises along the way to keep your interest. If you are looking for a course that will keep awake & engaged & will better prepare you for detecting fraud, then this course is a must.
K2’s Top PDF Features You Should Know
-
Online
4.00 Credits
Member Price: $149
Are you tired of struggling with PDFs? Unlock the full potential of Adobe Acrobat & other PDF tools to make working with PDF files a breeze. Join our course & discover how to use powerful features such as PDF forms, redaction, converting PDFs to Word & Excel files & electronic signatures. You'll also learn how to create & apply tick marks, build indices, catalogs & portfolios & secure your PDF documents to the fullest. As the popularity & usefulness of PDFs continue to grow, many users still haven't learned how to manipulate these documents effectively. Don't let this be you! Join us for this timely session & learn the top features necessary to optimize your work with PDF documents. Say goodbye to frustration & hello to efficiency!
Strategies for Guiding Clients Through Challenging Situations: Tax Insights
-
Online
8.00 Credits
Member Price: $250
This course equips practitioners with the knowledge needed to help clients navigate complex tax & financial challenges. It addresses difficult client situations including divorce, bankruptcy, debt issues & other personal & business matters that create significant tax consequences. The course provides key insights into the tax implications associated with these situations & highlights planning considerations practitioners should evaluate when advising clients. Participants will explore the tax treatment of divorce-related matters, including filing status, support obligations & property division. The course also examines bankruptcy, debt cancellation, business dissolution & other financial hardships that may affect a taxpayer's reporting & obligations. Through practical discussion & analysis, participants will gain strategies to help clients make informed decisions while understanding the related tax implications. 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 terri.storer@acpen.com
Supervision/Management Competencies: An Ethical Approach
-
Online
2.00 Credits
Member Price: $89
Job titles for individuals can vary in different organizations even though the work is the same. This webinar is designed for the individual whose role is to oversee the work of others. This webinar includes an overview of Aristotle's virtue ethics and its application to the responsibility and privilege of developing employees to be their best and for the success of the organization. We will also address issues such as going from "buddy to boss", how to manage if you are newly assigned to an existing employee that was previously supervised by someone else and critical skill sets necessary for supervisory/managerial positions. 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.
