WICPA CPE & Special Event Catalog - Wisconsin Institute of Certified Public Accountants

Complete Guide to Analyze Data with Excel PivotTables

Jan 30, 2027 8:00am - 12:00pm

Online

4.00 Credits

Member Price: $149

Unlock the full potential of Microsoft Excel PivotTables with this comprehensive course. This training is designed to equip participants with the skills to effectively analyze and summarize data, transforming raw numbers into actionable insights. Whether you're a seasoned professional or new to data analysis, this course provides an in-depth understanding of PivotTables and their capabilities, helping you uncover patterns, compare data and make informed decisions. The program includes a step-by-step approach to creating and customizing PivotTables, focusing on how to use them to analyze data efficiently. Participants will learn how to group and filter data, identify trends and apply advanced features to solve real-world business challenges. Beyond technical knowledge, this course introduces data visualization through PivotCharts, teaching participants how to present their analysis effectively to stakeholders. By the end of the course, you'll not only master PivotTable fundamentals but also gain advanced techniques to streamline data analysis and support strategic decision-making in any context. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Accounting & Attestation for ESG

Jan 30, 2027 8:30am - 10:30am

Online

2.00 Credits

Member Price: $89

Environmental, Social and Governance (ESG) reporting has become an increasingly important area of focus for standard setters, regulators and stakeholders. This course provides an overview of how ESG considerations intersect with accounting and attestation services, with attention to developments affecting both preparers and assurance providers. Participants will review current ESG-related initiatives and projects underway at the Financial Accounting Standards Board, Governmental Accounting Standards Board and the AICPA. The course also explores the types of services CPAs may provide in connection with ESG reporting, including advisory and attestation engagements and discusses how these engagements differ in scope and responsibility. Designed for CPAs seeking to understand the evolving ESG landscape, this course helps participants recognize where ESG fits within existing professional standards and how CPAs can support organizations seeking credibility and assurance over ESG information. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Fundamentals of Form 1040: Individual

Jan 30, 2027 8:30am - 12:30pm

Online

4.00 Credits

Member Price: $149

This course introduces professionals to the fundamentals of individual tax preparation. Participants will learn the essentials of Form 1040, including filing requirements, income reporting and deductions. The session will also cover preparer responsibilities, due diligence and taxpayer rights under Circular 230. By the end, attendees will have a solid understanding of the foundation of personal tax returns. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Invest in Your Mental Health & Avoid Burnout

Jan 30, 2027 9:00am - 11:00am

Online

2.00 Credits

Member Price: $89

For the ambitious female finance professional, working hard and going above and beyond are necessary for success. Sadly, taking time to care for themselves can be seen as counter-productive to meeting their career goals. Over ninety percent of women executives are feeling significantly higher levels of stress that they attribute to increased responsibilities and priorities outside the workplace compared to life before the pandemic. Burnout is a syndrome resulting from chronic workplace stress that causes exhaustion, negativity toward one's job and reduced professional efficacy. It has become so pervasive that it's now recognized as an occupational phenomenon by the World Health Organization. To reignite your enthusiasm at work, you don't necessarily need to find a new job or time for a spa day or bubble bath. You need concrete strategies to invest in your mental health without compromising your ability to rise to the next level in your career. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Forensic Accounting: When The Office Is A Crime Scene

Jan 30, 2027 9:00am - 1:00pm

Online

4.00 Credits

Member Price: $149

Embezzlement happens often to many small businesses. Unfortunately, the lack of internal controls allow the embezzlement to remain undetected for years. But when it is discovered, the small business owner will most likely contact their CPA for advice. What should you do when your client contacts you about their employee embezzling money from their business? What options should you present to your client? How can your client protect themselves, while investigating the embezzlement? What steps need to be taken about preserving any documents, emails, texts, or phone calls? This course teaches how to engage the client, properly identify the evidence needed to prove the crime, how to write the report for civil and criminal trial and best practices in preserving electronic and paper evidence. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Cybersecurity: Protecting Your Firm's Data & Reputation

Jan 30, 2027 10:00am - 12:00pm

Online

2.00 Credits

Member Price: $89

Cybersecurity protection of digital data continues to be a top priority for CPAs. The cyber threats continue to increase and are becoming more sophisticated with the advent of AI technology. The first step is to understand what the primary threats are, the potential damage they can inflict and, most importantly, how to mitigate the risks. This course will prepare you have informed conversations with your IT service providers to ensure you are employing best practices in cybersecurity protection. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

The Ethic of Self-Esteem For Women

Jan 30, 2027 10:30am - 12:30pm

Online

2.00 Credits

Member Price: $89

Ethics is ultimately about our relationship to ourself, others and the world in which we live. Therefore, to enhance our relationships with those around us, we must first start with the regard we hold for ourselves. From an ethical vantage, it can be said that we have a moral obligation to work toward self-love, honor and respect. Matters of self-esteem are important in every aspect of life including goal setting, relationships, establishing boundaries, handling conflict, levels of productivity and expressing our needs in respectful and dignified ways. This course explores traps of low self-esteem and ways to minimize those traps. We also explore components of high self-esteem and actions to foster higher regard for self. 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.

Reasonable Compensation for S Corps

Jan 30, 2027 11:00am - 1:00pm

Online

2.00 Credits

Member Price: $89

Between 2010 and 2020 a parade of Court Cases, IRS Factsheets, Job Aids and Internal Memos, plus Heightened IRS scrutiny and Preparer Penalties has brought the issue of 'Reasonable Compensation for S Corp's out of the shadows and placed it forefront as a priority issue for CPA's, EA's, Tax and Financial advisors to cover with their clients. We will explore key court cases, IRS guidelines, preparer penalties and some of the obscure tools the IRS has put in place. We debunk common myths and fiction on how reasonable compensation should be calculated and replace it with facts and methodologies that the IRS relies on. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Calculating the Retirement Need

Jan 30, 2027 12:00pm - 1:00pm

Online

1.00 Credits

Member Price: $55

For most people, funding their own retirement is the largest expense they will ever have. Due to advances in medical technology and overall healthier lifestyles, it is not unusual for someone to live 30 years or more in retirement. In this course, we will discuss how to quantify and calculate the retirement needs of the client. We will talk about time value of money concepts, how to help clients quantify their retirement goals and even how to address risk perceptions. By doing this, we will allow practitioners to be able to better address client questions and frame trade-offs when necessary. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Introduction to Governmental Accounting

Jan 30, 2027 1:00pm - 3:00pm

Online

2.00 Credits

Member Price: $89

Governmental accounting differs significantly From other forms of accounting & requires a distinct approach to financial reporting. This course introduces the foundational principles of governmental accounting, including fund accounting concepts & the modified accrual basis of accounting. Participants will explore the structure & purpose of governmental fund financial statements & government-wide financial statements, gaining clarity on their objectives, layouts & key elements. The course also addresses essential topics such as component units, the role & structure of Management's Discussion & Analysis (MD&A) & the preparation & significance of the Annual Comprehensive Financial Report (ACFR). Designed for those new to governmental accounting-- or those seeking a refresher-this course provides a solid foundation for understanding & applying governmental financial reporting principles. The course has been updated to reflect recent guidance issued by the Governmental Accounting Standards Board, including GASB Statements 101-105.