Professional Development and Event Catalog

Embark on a journey to master Power BI, a powerful tool for data analysis and business intelligence, in our comprehensive course, "Get Started with Power BI." This course is meticulously designed for professionals who seek to understand the full spectrum of Power BI capabilities, including its integration with Excel's Power BI features like Power Pivot and Power Query, and its comparison with standalone Power BI tools such as Power BI Desktop, Power BI Service, and Power BI Report Server. In the first part of the course, participants will be introduced to the fundamentals of Power BI. This includes an overview of Power BI's interface, key features, and its seamless integration with Excel. The course will cover Excel's Power BI tools - Power Pivot, for advanced data modeling, and Power Query, for efficient data transformation and preparation. This segment is essential for understanding how Power BI extends and enhances the data processing and analytical capabilities of Excel. The second section of the course delves into the standalone Power BI tools. Here, participants will explore Power BI Desktop for creating complex data models and sophisticated reports, Power BI Service for cloud-based collaboration and sharing, and Power BI Report Server for on-premises report deployment. This part of the course will focus on the unique features and strengths of these standalone tools, providing attendees with the skills to leverage Power BI in a variety of business contexts. 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 will provide an overview of the work and impact of the Treasury Inspector General for Tax Administration (TIGTA) on the US tax system, regulatory ethics, and accounting profession. TIGTA is an independent organization that provides oversight of the Internal Revenue Service (IRS) and conducts audits, investigations, and inspections and evaluations to promote integrity, economy, and efficiency in the administration of the nation's tax system. The course will explore the role of TIGTA in improving the efficiency and effectiveness of the IRS, identifying opportunities to improve the administration of tax laws, and upholding ethical standards in the accounting profession. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Supervisor Skills - Coaching Staff to Stay on the Right Track provides tips and techniques for critical coaching responsibilities. Being a successful coach requires tackling various responsibilities, including motivating, providing positive and constructive feedback, and otherwise getting the best performance out of engagement team members in the given situation. Note: This course is recommended as a part of a 16-hour audit skills curriculum for supervisory or managerial auditors, while it is also appropriate for anyone who has responsibilities for coaching others. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

The QuickBooks ecosystem of accounting tools remains the most widely-used set of accounting applications small businesses use. Yet, many of these organizations struggle because of inadequate internal controls. In this seminar, you will learn options for improving internal controls in small businesses running QuickBooks Pro, Premier, Enterprise, or Online. Participate in this program to understand how you can create a robust system of internal controls in a small business environment, including businesses using QuickBooks accounting solutions. In this session, you will also learn about the four common types of internal controls and how to assess the relative condition of the internal control structure of a small business. With this background in place, the focus then shifts to discovering the opportunities to enhance internal controls in QuickBooks-based environments using features found in the application. In addition, you will learn about additional internal control procedures for situations where you cannot establish adequate controls in QuickBooks. While many believe that QuickBooks-based organizations will forever face weak internal control structures, participating in this session will teach you how QuickBooks-based businesses can benefit from strong internal controls.

This course presents an overview of blockchain and the tax implication of cryptocurrency transactions. The IRS has provided some recent guidance, but potentially conflicting pronouncements by other regulatory agencies have created uncertainty on reporting issues. The practitioner will be helped to understand when a taxable transaction has occurred and what reports to file to satisfy IRS requirements. We will also identify tax traps for the unwary. This information is suitable for Corporate tax and finance executives, directors, managers and staff, CPAs, Enrolled Agents, accountants, attorneys and business/financial advisors who work with and advise individuals or businesses that use or invest in cryptocurrency. All in-house and public practice professionals involved with tax compliance and planning will benefit from this timely and insightful seminar. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Introductory Session of Borenstein's Form 990 Foundational Series: This "initiation and introduction to" the Form 990's mechanics and importance will prevent you from drowning in the Form 990's force-field! More than 80% of the Form's inputs and relevant definitions are NOT found in the statutes and Regulations that apply to the exempt sector, a reality that can be overwhelming for both novices and more advanced preparers. This session provides an easy-to-digest synopsis of the entirety of the Form's key definitions as well as the mechanics that preparers need embrace from the moment they first approach preparing a 990. Packed with practical tips and perspectives on data gathering, this class is a "must" gateway for beginning (and even more experienced) preparers to learn "how to befriend Form 990 preparation." This webinar will vault preparers past all the initially confounding problems of the Form 990, providing baseline info on the critical nuances the form uses. 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 focuses on the power of pivot tables within Microsoft Excel. We initially discuss the creation of pivot tables and various ways to summarize information. Then we explore ways to utilize summarized pivot table data. The course uses several practical examples that should inspire participants to find their own creative uses for pivot tables. 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 provides an overview of compilation, review, and audit engagements. We will explore major considerations regarding each type of engagement in addition to contrasting and comparing these three major professional services provided by certified public accountants. 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 an extension of the Power BI series of courses that specifically explores using OLAP formulas and advanced time intelligent functions. OLAP formulas provide the ability to create a calculation in a cell that is based upon the measure in the data model. This powerful tool provides the ability to create calculations in an Excel worksheet without using a PivotTable to perform the calculation. Gone are the days of creating a PivotTable, then using those values in the PivotTable for additional calculations. When using Power BI to build a data model that connects to data files, you may want to know the date of these files. This class teaches you how to create a measure based upon the refresh date of your data. In the class "Power BI - Use Advanced Calculations with DAX Formulas," you learned the basics of time intelligent functions, the ability to calculate measures based upon dates. In THIS course, we will take it to the next step and teach you how to perform many more date-based calculations. 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.

If you have ever had someone just read you the rules in an ethics class, you know there is a better way. Cases in Corporate Ethics reviews 10 real life cases and puts you in the position of someone in the middle of it all. You'll learn about conflicts that corporate financial professionals often encounter, you'll gain skills for dealing with a boss who is behaving badly and find out where to go for help. Once you have studied ethics using real world cases, you'll never want to do it any other way. 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 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 course provides a concise overview of the Dark Web, a part of the internet that isn't indexed by search engines, and is often associated with anonymous transactions and nefarious activities. Discover the leading threats and risks that the Dark Web poses to accounting firms. Explore how practitioners can effectively mitigate the risk of data breaches, ransomware attacks, financial fraud and other risks connected to the Dark Web. You'll walk away with a foundational understanding of leading cybersecurity strategies that can help you maintain client trust and protect your firm's sensitive data in this complex and ever-changing threat landscape. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Many Microsoft 365/Office 365 subscriptions include robust Cloud services for improving productivity. Foundational services, such as SharePoint Online, OneDrive for Business, and Exchange Online, join with other powerful tools such as Teams, Planner, Power Automate, Forms, and Power Apps to provide a productivity platform second to none. Unfortunately, most users will never benefit from working with these tools simply because they remain unaware of these features. Plan to attend this session to learn about the "rest of 365" and how these Cloud-based applications can enhance personal and team productivity while simultaneously facilitating remote working arrangements. Don't miss this opportunity to get all the knowledge and guidance necessary to leverage your investment in Microsoft 365/Office 365 fully.

A project doesn't just happen, it takes a dedicated person to help a team create something from nothing. The best project managers incorporate the art of people management and science of execution to guide an initiative from an idea to reality. Not everyone can hire a project manager, so the great news is these skills and techniques can be learned. This class will show how a project manager breaks down a concept and applies techniques needed to effectively lead a team through the visioning, scoping, testing and rolling out of an initiative. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

A detailed analysis of the calculations related to determining a partner's tax basis for a partnership interest. How to use the Form 1065 and Schedule K-1 information for basis determination will be reviewed. An illustrated example with filled in forms will demonstrate how the process works, including its many potential pitfalls. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

CPAs spend most of their working lives reviewing bank statements and books and records of businesses. They are experts in understanding how to prepare financial statements according to GAAP. But would a CPA know a possible money laundering transaction if they saw it? Would they know about a money laundering business? Money laundering is a subject of many action and thriller movies, but rarely understood. This presentation will educate the CPA in understanding the basics of money laundering and how to identify money laundering. This presentation will help the CPA know the truth about money laundering, how to identify it, the statutes that define it, and the court cases that interpret it. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

One of the most important aspect of transforming your practice or business to a digital model is to know how to prioritize the applications and initiatives that you focus on and invest in. There is an abundance of "low hanging fruit" initiatives that can provide useful benefits quickly and economically. Using Microsoft Teams meeting app is a perfect example. Chances are pretty good that you are already investing in Microsoft 365 subscriptions for your office. This course will show you how to use the Microsoft 365 subscription ROI by fully utilizing the meeting app and eliminate the unnecessary cost of a separate third-party meeting app. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Personality Styles - Adapting to Different Types of Personalities for Improved Relationships and Interactions provides guidance for effectively adapting to various personality styles. Every individual has a dominant personality style, which includes relevant strengths and weaknesses. Effective interactions require individuals to adapt behaviors to complement, balance or counteract the traits of others. Note: This course is recommended as a part of a 8-hour audit skills curriculum for managers, while it is also appropriate for anyone who has responsibilities for interacting with others. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Who creates and maintains ethics standards? Who is held to the standards? Who can file a complaint? How does a Peer Review complaint fit in? Who investigates and how? Can public information spur an investigation? Good questions? Hear the answers and all about cases that explain the issues when our expert fills in the back story. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

The COVID-19 pandemic has altered corporate and public accounting in ways we could never have imagined. This broad-based course will discuss accounting and auditing implications that have arisen as a result of the pandemic. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.