CPE & Event Calendar

This fast-paced course focuses on using Excel Power Pivot features to enhance data analysis. One of the strengths of Power Pivot is the formula language DAX (Data Analysis eXpressions). We will spend considerable time using the power of DAX to create meaningful calculations that add new dimensions to our data. We will also review the use of a date or calendar table that allows us to perform date analysis that was never possible before. This will allow us to use the new time-intelligent functions to perform complex calculations on our data such as: month-to-date, quarter-to-date, year-to-date, last year same period, last year-to-date, etc. We will also demonstrate the hottest tips and tricks that will take your data analysis to the next level. Although our focus will be on using Power Pivot, we will review some of the other Power BI Tools including: Power Query (Get & Transform), Power BI Desktop and Power BI Services (PowerBI.com). NOTE: If you want to apply the concepts presented, you will need Excel 2013, 2016 or 2019/Office 365 AND the Power Pivot add-in pre-installed. To see our full prerequisite recommendations, see PROGRAM CONTENT section below. This session is presented using Excel 2019/Office 365. Regardless of the version you are using, most concepts covered in this course apply to all versions of Excel. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

How grateful are you? In this critically important webinar, we will explore exactly what gratitude is and why it is a crucial component of your work as a CPA. Even if you believe you're already a deeply grateful person, you'll still learn some new strategies for expressing gratitude effectively. Forbes Contributor Bruce Weinstein, The Ethics Guy, will show you how to use LinkedIn in a novel way to say "thank you." You'll also find better and worse ways of letting clients, team members, family members and friends know that you care about them. You'll understand why gratitude is a matter of ethics and not merely etiquette. Finally, you'll discover how to use questions about gratitude in job interviews and performance reviews. Why not hire and promote people who are not only knowledgeable and skilled but also grateful? You will be thankful for having taken this valuable webinar! This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Please join us for a discussion on like-kind exchanges (LKE), known as one of the last great tax legal "shelters" available to those buying and selling real property. We cover the basic structure of a LKE, and ways a taxpayer can utilize qualified third-party intermediaries (QI), and tenancy-in-common structures including Delaware Statutory Trusts (DST). We also explore creative solutions to sticky situations a taxpayer may find itself in obtaining replacement property. This course is ideal for CPAs, EAs, lawyers, real estate professionals, accountants or other tax professionals. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Part of one's duty as a CPA working in industry is to safeguard the assets of the organization. Cost cutting is one way to preserve assets and maintain a company's competitive position in the industry. However, what keeps us from ridding our organizations of unnecessary costs? In this course, we will look at the factors that prevent our companies from being as streamlined as they could be. By using statistics and survey data, we will attempt to show how to better negotiate and navigate budgeting and contracting decisions. We will also discuss financial statement analysis techniques, benchmarking, and cash flow management in an effort to better cut costs and maintain the long-run viability of an organization.

Managing a strong network is one of the most important things you can do to grow professionally. Yet despite its importance, maintaining an effective network is often not taught in undergraduate and graduate schools. The good news is that managing and growing a network is easier than it sounds. In fact, most professionals have some level of basic networking skills simply from helping someone find a job, attending an industry conference, or seeking professional connections through social media. Effective networking involves more than simply collecting contacts. Strong networks should be relevant to your career and consist of people you trust. Personal networks are just as important as professional networks and the two often overlap. In this course, we explore ways to strengthen and grow networks by examining proven strategies that have helped individuals meet their personal and professional goals.

Tax advisors often receive questions concerning all facets of Medicare. How does Medicare work? How do I apply? How much does it cost? Is Medicare optional or required? This program provides a basic introduction to the Medicare program and covers many of the areas of the Medicare program that clients are most interested in. If you, or some of your clients, have questions relating to Medicare, this program is a must for you.

The globalization of business, ongoing changes in technology, increased attention of shareholders and stakeholders and the continuing demands of the Audit Committee and senior management require a dynamic framework for managing today's internal audit department. This session, designed by a past Chief Audit Executive with significant exposure to a multitude of industries and internal audit frameworks, explores the key competencies and responsibilities of today's internal audit management and methods for meeting the requirements of the internal audit profession. We will also discuss some of the greatest challenges of the role and how to address those challenges.

Seismic changes in tax legislation is currently taking place, and the well-informed tax practitioner will want to attend this two hour monthly program in order to stay abreast of these developments! Approximately one-half of the program is devoted to individual tax issues, and the remaining time is spend on business entity taxation, IRS procedure, tax legislation and other issues. Due to the changing nature of the topic, learning objectives, course descriptions and program content will vary and will be provided in more specificity closer to presentation time. This course provides a concise look at the hottest topics affecting every tax practitioner. 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 course you will learn how to create presentations that look professional and clearly deliver your message to your audience. You'll benefit from a step-by-step guide for building a presentation, including understanding the PowerPoint interface. We will also dive into topics such as using themes and layouts; adding graphics, photos and other objects to engage the viewer; and tips & tricks for delivering your PowerPoint presentation. 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 session, participants will delve into a comprehensive exploration of what Diversity, Equity, and Inclusion (DEI) truly entails. Often met with resistance due to its perceived condemnatory nature, this session aims to provide a more nuanced definition of DEI, fostering a better understanding among attendees. By demystifying the language surrounding DEI, participants will be equipped with straightforward approaches to seamlessly integrate these principles into their perspectives. This session will spotlight the distinctive features of our DEI model in comparison to other systems. Attendees will gain valuable insights into the model, understanding its unique perspective on achieving DEI success. At its core, our approach is grounded in the simple premise that we are all human beings sharing the common human experience. The goal is to convey to participants the importance of embracing DEI through this paradigm, effectively humanizing the DEI experience. One of the most remarkable DEI experiences unfolded during my son's 18th birthday celebration in our backyard. The event brought together individuals from diverse backgrounds, spanning various walks of life and races, who interacted in a profoundly humanistic manner— an encounter unlike any I had witnessed before. In this session, we will deconstruct this experience and draw parallels to its relevance in workplace dynamics.

Strategic Planning for SMEs

Organizations of all sizes often fail to successfully install needed foundational components of an internal control system. Whether large or small, entities must view policies, procedures, and all controls in a wholistic manner in order to develop a system of controls that will keep the entity on its intended course. Moreover, those that design policies and procedures benefit by knowing why control measures are necessary. This session sets forth internal control concepts and explains the importance of strong internal control policies. It provides an understanding of the interrelated nature of all controls created by any organization. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Debt is a real problem for many clients, business owners, and the general public.  It can be ever increasing and causes financial, emotional and physical challenges that seem to spiral out of control. What if you could help your clients “do debt differently”? This strategy turns the game upside down and presents solutions from the inside out.  As a CPA, you are already a trusted advisor for your clients.  What if you could help your clients be free of this burden?  This is a tremendous resource you can offer to your clients, expanding the value of what you offer them by adding these processes to your packages.  Clients will be happy to pay for this kind of relief as you support them in doing debt differently.   If you are one of the many people who are personally burdened by this situation, these strategies, tools, mindsets and actions will personally help you get better results…so you can go back to the task of expanding and growing your business, sleeping better at night and gaining access to the creativity that will take you to your next level of financial fulfillment.  Paying off debt is an inside/outside job.  Successful strategies include the internal shifts to mindset and enhancing the inner qualities that are most helpful in paying off debt, and practical tools to help make the transition from thinking about paying off debt to actually doing it. This program combines both -- emotional support and dozens of tools and action steps to Do Debt Differently, including: An inventory process to objectively assess the situation and face it head on Guided mind/body processes to alleviate anxiety about the situation Creative exploration (writing and drawing) to gain clarity and specificity Stories and discussion to strengthen your access to the qualities that will be most helpful to your success Using a menu of options to create a personal action plan and an ongoing support team The techniques in this program are creative and easy, but immensely practical.   We will combine practical, nuts-and-bolts action steps with powerful tools for mindset-shifting. There is no reason to continue to suffer the burden and overwhelm of debt. Relief is here! Through discussion, interactive exercises, skill building, mindset shifting and powerful actions, you and your clients could be on your way to a debt free life. Please join me for this empowering approach to changing your financial situation.

This session will explore key aspects of getting more satisfaction out of the work you choose to do and how to find greater balance between the demands of work and other lifestyle choices in an ever more complex and changing world. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Auditing Cash - Applying Basic Skills to the Starting Point of Any Audit demonstrates how the approach to auditing different cash accounts may vary and how to strengthen inquiry which is an important audit procedure in this area. Cash tends to be one of the first areas assigned to new auditors, as there is typically little complexity and subjectivity involved. In addition, persuasive audit evidence from a third-party is generally available. However, research shows that around 80% of asset misappropriation relates to cash. Therefore, the audit of accounts and classes of disclosures related to cash and cash equivalents does tend to carry some level of risk of material misstatement. 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 responsibilities for auditing cash and cash equivalents. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

This session will focus on the most common types of fraud in the procurement and contracting arena, with a focus on fraud in construction.  The session will examine fraud vulnerabilities in the four key phases of the procurement process: Presolicitation. Negotiation. Performance. Closeout and Claims.  Within each phase, “red flags” will be discussed.  These are the indicia of possible fraud that managers should be alert for.  Also, within each phase, the most common fraud schemes will be highlighted and discussed.  Finally, the session will describe the generally accepted safeguards or controls that should be established to prevent the various fraud schemes that can occur.  This part of the program will make extensive use of actual fraud case studies designed to demonstrate fraud risks and fraud detection strategies.

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.

This course is designed to introduce CPAs to the concept of mental models and how they can be used to improve ethical, problem-solving and decision-making skills in the accounting profession. Participants will learn about a variety of mental models, including the Map is Not the Territory, First Principles, and the 80/20 Rule, and how to apply them to financial situations. The course will also cover the importance of building a "latticework" of mental models and the limitations of mental models. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

For HR and Business professionals, navigating the intricate dynamics of executive decision-making can often be a daunting task. Despite the meticulous hours invested in research, strategy formulation, and planning, the true challenge often lies in effectively communicating and gaining acceptance for these transformative ideas. A key aspect of this is the art of persuasion, ensuring that the merits of our proposals are not just understood but wholeheartedly embraced by decision-makers. This session is designed to empower leaders with the tools and insights needed to craft persuasive pitches, build a robust business case, and confidently communicate the ROI of their initiatives. Moreover, attendees will gain insights into the common pitfalls that can hinder their pitches and learn techniques to address objections frequently raised by executive leadership.

One of the biggest challenges, if not the most critical challenge in business, is attracting and keeping an engaged and productive workforce. Navigating the world of engagement and retention requires an understanding of human needs as well as deliberate and intentional actions to strengthen an employee's investment and connection to their place of work. For all the HGTV lovers out there, this session mirrors a television show where an individual/family must decide if they want to stay in their current home (after renovations and home improvements) or move to a new space. This webinar title seems apt in describing the current issues around engagement and retention. When an employee chooses to "love it" or stay with their current employer, it typically means they are engaged in their work and they feel seen, heard and valued- they are content. Conversely, the notion of "leaving it" typically symbolizes an employee who cannot wait to get out of their current job. These employees often have negative attitudes and/or behaviors at work. The purpose of this webinar is to recognize the significance of attracting and retaining employees, building your brand as an employer of choice and developing a culture where individual employees feel valued, cared for and ultimately engaged, all though an ethical lens. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.