CPE & Event Calendar

How do you pull a value from a cell into another cell? Do you use a direct cell reference, like =G10? If so, you are probably missing out on some efficiency gains that could be achieved by using a variety of Excel's lookup functions. Veteran Excel users, who are aware of the VLOOKUP function, are also painfully aware of its limitations--especially that it cannot go left. We will explore how to bypass VLOOKUP's limitations by nesting functions and by moving beyond VLOOKUP altogether.

*** This subscription includes two individual sessions for a total of 4 CPE. You receive significant savings when purchasing these webinars as a subscription. Each of the courses runs live once a month beginning May 1, 2024 through April 30, 2025. Register for these scheduled courses as your schedule allows - at no extra cost to you. Once registered for this subscription, log in instructions will be emailed to you separately for each individual course. *** Managing projects happens every day in accounting firms, but few people are educated on the principles from the field of project management. Take advantage of this project management subscription to learn best practices and then apply the lessons to enhancing ongoing client engagements. Sign up for both webinars and save 20% while having the flexibility to choose the date and time that works best for you! Leverage tips that lead project managers to achieving higher project success rates.

*** This subscription includes three individual sessions for a total of 6 CPE. You receive significant savings when purchasing these webinars as a subscription. Each of the three courses runs live throughout the year beginning May 1, 2024 through April 30, 2025. Register for these scheduled courses as your schedule allows - at no extra cost to you. Once registered for this subscription, log in instructions will be emailed to you separately for each individual course. *** No matter what your role is in an organization, your ability to collaborate and develop others is key to the scalability of your practice. In this year's Talent Development subscription, you can learn how to: Be a more powerful and effective delegator, Develop a culture of ownership and accountability, Deliver transformative feedback. By learning and practicing these skills you not only develop yourself, but you build a stronger, more confident team. Take advantage of this subscription to save 20% off each webinar and choose the session dates that work best for you!

*** This subscription includes four individual sessions for a total of 8 CPE. You receive significant savings when purchasing these webinars as a subscription. Each of the four courses runs live once a month beginning May 1, 2024 through April 30, 2025. Register for these scheduled courses as your schedule allows - at no extra cost to you. Once registered for this subscription, log in instructions will be emailed to you separately for each individual course. *** This subscription consists of an 8-hour audit skills curriculum for managers, while it is also appropriate for anyone who has responsibilities for interacting with others. This series covers advanced management skills and proper engagement techniques to deliver success for your team.

*** This subscription includes four individual sessions for a total of 8 CPE. You receive significant savings when purchasing these webinars as a subscription. Each of the four courses runs live once a month beginning May 1, 2024 through April 30, 2025. Register for these scheduled courses as your schedule allows - at no extra cost to you. Once registered for this subscription, log in instructions will be emailed to you separately for each individual course. *** This series is comprised of the most practical fraud investigation courses you will ever take. Rather than learning only the theory of fraud, you will learn how a forensic accountant actually investigates fraud from the beginning to the end. We focus on forensic accounting techniques used in the field to prove what happened, who was involved, how much money was stolen, and where the money went. Each course is a stand-alone class that may be taken individually, but for comprehensive instruction on completing a fraud investigation from start to finish, take all four.

This course fills an important need for both financial managers and accountants in the practice of public accounting by offering the tools to help ensure the future success of a business. Practical guidance for the effective use of benchmarking and analytical procedure is also provided. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

*** This subscription includes four individual sessions for a total of 9 CPE. You receive significant savings when purchasing these webinars as a subscription. Each of the four courses runs live once a month beginning May 1, 2024 through April 30, 2025. Register for these scheduled courses as your schedule allows - at no extra cost to you. Once registered for this subscription, log in instructions will be emailed to you separately for each individual course. *** Join us for a 4-course subscription featuring John Higgins, a renowned technology advisor to the CPA profession, who has assisted many firms with Microsoft 365 deployment. Discover how to leverage the M365 suite of apps to unlock new efficiencies and opportunities within your firm. Don't miss this chance to supercharge your practice with cutting-edge tools! Whether you are a solo practitioner or larger firm, this series will provide you with an ROI many times greater than your investment to attend.

*** This subscription includes six individual sessions for a total of 12 CPE. You receive significant savings when purchasing these webinars as a subscription. Each of the six courses runs live once a month beginning May 1, 2024 through April 30, 2025. Register for these scheduled courses as your schedule allows - at no extra cost to you. Once registered for this subscription, log in instructions will be emailed to you separately for each individual course. *** Payroll is among the most common tasks an employer undertakes while running their business. At its most basic level, payroll consists of an agreement between an employer and employee related to compensation for services. Once you look under the hood, there is so much more to payroll, including various kinds of compensation, payroll taxes and required reporting on government forms. Strengthen your expertise in providing client payroll services with one of the nation's foremost authorities, and a practitioner herself, Elizabeth Bystrom.

*** This subscription includes five individual sessions for a total of 14 CPE. You receive significant savings when purchasing these webinars as a subscription. Each of the five courses runs live once a month beginning May 1, 2024 through April 30, 2025. Register for these scheduled courses as your schedule allows - at no extra cost to you. Once registered for this subscription, log in instructions will be emailed to you separately for each individual course. *** This Power BI intensive series is designed specifically for those aiming to master data management skills in the modern business environment. As data becomes increasingly central to accounting and financial analysis, the ability to effectively manage, clean, and transform this data is critical. These five courses delve into Microsoft Power BI, a tool known for its robust data processing capabilities. This series will take you from an entry-level overview of Power BI and lead you through building an actual data model for analysis. Once you have completed the courses in this series, consider taking the advanced subscription, "Taking Power BI to the Next Level".

*** This subscription includes five individual sessions for a total of 14 CPE. You receive significant savings when purchasing these webinars as a subscription. Each of the five courses runs live once a month beginning May 1, 2024 through April 30, 2025. Register for these scheduled courses as your schedule allows - at no extra cost to you. Once registered for this subscription, log in instructions will be emailed to you separately for each individual course. *** This advanced Power BI series is designed specifically for those aiming to master data analysis skills in the modern business environment. As data becomes increasingly central to accounting and financial analysis, the ability to effectively manage, clean, and transform this data is critical. These five courses delve into Microsoft Power BI, a tool known for its robust data processing capabilities. After learning how to build a data model in the previous series, this series will take you through using advanced calculations to create, manage and effectively use your data analysis. This is an advanced subscription and if you are new to Power BI or not confident using the tool, consider taking the basic series, "Getting Started With Microsoft Power BI".

Based on real life experiences! This program addresses the many issues impacting CPA practice with a world in crisis. The unique challenges facing practitioners are related through actual practice situations - and then analyzed for their ethical implications. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Clients often ask their tax advisors whether they have the "best" pension plan and whether they are using it to its maximum advantage. This program explains how various pension plans work and analyzes why a small or medium-sized business owner would choose one plan over another.

This course uses the lives of the rich and famous as a template to better understand the realm of estate planning. With stories ripped from the headlines, we will examine pitfalls and best practices. Did you know that Prince died without a will, opening the door for 45 people claiming to be his beneficiaries? Or that Michael Jackson was not careful in properly funding his trust, leading to delays and legal battles in the administration of his estate? Even Abraham Lincoln, it turns out, did not have a will. In discussing an array of celebrities, from Jackie Kennedy, Joan Rivers, Jimi Hendrix, and Whitney Houston to Aretha Franklin, Barry White, Leona Helmsley, and Florence Griffith Joyner, the course is designed as an enjoyable learning experience with tips for all levels of expertise. We may not have their fame or fortune, but we can certainly walk the red carpet when it comes to estate planning.

Modern technology solutions have enabled people to operate more effectively from home using cloud-based technologies and services. This course will cover cybersecurity best practices to help CPAs protect their data and devices while using internet-based cloud technologies. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

The field of accounting is undergoing rapid evolution in response to a complex interplay of technological advancements, regulatory reforms, economic fluctuations, and shifting societal dynamics. In this course, we will explore the major challenges and opportunities currently facing accountants, and we will equip you with the knowledge and skills needed to excel in this dynamic environment.

Today's senior executives use LinkedIn to impress hiring managers, find talent, develop opportunities, and build relationships. This interactive session is for the financial executive who wants to position themselves internally and externally for career success by leveraging the #1 professional digital platform. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

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.

AICPAs Code of Professional Conduct - Exploring the Foundational Principles Underlying the CPA Profession as a whole will provide an overview of the basic principles of the AICPA's Code of Professional Conduct with practical implementation examples. CPAs must seamlessly transition to a profession that relies heavily on conformance with technical and ethical standards. It is critical for CPAs to seek to serve the public interest with a strong sense of character, integrity, competence, and due professional care. In addition, CPAs must appropriately safeguard any threats to independence and objectivity. Note: This course is recommended as a part of a 16-hour audit skills curriculum for beginning auditors, while it is also appropriate for anyone who has public accounting responsibilities. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Ready to make radical leaps in your critical thinking? In a world of rapid change and unreliable information, we need the ability to separate fact from fiction, recognize flawed assumptions, and have clarity under pressure. This course will teach you how to audit your thinking and build effective reasoning strategies for all types of situations. You will achieve dramatic improvements in judgement, problem solving, memory, and learning. This course will make you more flexible, adaptable, creative and resilient, and provide a cognitive toolkit you can carry for life. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

In this webinar we will explore the powerful concept of splitting data from reports and dig into the mechanics that enable this technique. The key feature discussed is the Tables feature, and the key function discussed is the multiple-condition summing function. We will illustrate these items in a variety of ways, including building crosstab style reports and mapping tables.