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.

Glantz and Associates is pleased to offer "Ethics Based Leadership for Women," a webinar designed to empower any woman who wishes to consider the privileges, responsibilities and challenges of holding leadership positions. We believe that leadership and ethics are intrinsically connected and will explore women in leadership through an ethics-based lens. The reality is, despite women representing approximately half of our world's population, they are significantly underrepresented in the workforce and most notably in leadership positions. In fact, not only do women have to cross more hurdles to advance into leadership positions, but when they do, they are burning out at a much faster rate than their male counterparts. In this course, we will discuss both the external societal barriers as well as the internal barriers that sabotage women from moving into leadership positions. We will examine common believes ("I should be nice," "I am an imposter", etc.) as well as behaviors that can hold women back and then offer suggestions for moving forward. We will provide tools to enhance one's self-awareness, create openings for self-reflection as well as provide opportunities to take on new perspectives. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

This intensive 2-hour course 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. This course delves into Microsoft Power Query, a potent tool within Excel and Power BI Desktop, known for its robust data processing capabilities. This course is designed to take participants from the basics of Power Query to exploring its more sophisticated features. It is an ideal blend of theoretical knowledge and practical application, centered around diverse data scenarios encountered in multiple industries. The aim is to ensure that the skills and techniques learned are universally applicable and beneficial in any professional context. Structured to be participant-focused, the course encourages active learning through a series of practical exercises, live demonstrations, and illustrative case studies. This approach not only deepens the understanding of Power Query's features but also demonstrates how to turn complex data sets into actionable insights. While the course is broad in its application, it remains detailed in its instruction, catering to both the novice and the seasoned professional. It is particularly beneficial for those who regularly interact with data, such as business analysts, project managers, and financial professionals, providing them with the tools to streamline data processes and enhance data analysis capabilities. Additionally, the course underscores best practices in data management. Participants will learn strategic approaches to data challenges, ensuring that their data processes are efficient, scalable, and sustainable. This is not just a course about mastering a tool; it's about empowering professionals with the skills to transform data into a strategic business resource. By the end of the course, participants will be equipped to leverage Power Query in Excel or Power BI desktop to its full potential, turning data into a powerful driver for business success and innovation. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

With governments worldwide pushing the automotive industry towards electric vehicles (EVs), there might be an EV in your future or for your corporate fleet. Today, some vehicles are all gas, all electric or hybrid. How much do EVs cost to purchase, maintain and charge? Most EV owners charge at home but need public charging when venturing beyond their vehicle's range. Not all EVs can use every public charger and various charger types recharge at different speeds. This session will simplify the issues and tell you what you'll want to know if there is an EV in your future. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Automating the tax practice is – or should be – a major initiative of almost all public accounting firms today. From ingesting data, processing returns, distributing draft and final copies, and billing and collecting fees, practitioners have outstanding opportunities to automate their tax practice. Those that choose to automate will experience the benefits of reduced staff turnover, increased productivity and efficiency, fewer errors, and improved cash flow. Participate in this session to learn the “how’s and why’s” of automating your tax practice. This session includes critical topics such as hardware and software options, workflows, and security and privacy issues. Plan to join us in this session to position your tax practice for greater success! 

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.

Audit Quality Control - Avoiding Peer Review Deficiencies highlights the most important considerations for those at all levels of the engagement team with quality control responsibilities on audit engagements. Upper-level reviewers have significant responsibilities for ensuring high-quality audit engagements. Unfortunately, deficient audits have serious negative consequences for both the CPA firm and the profession as a whole. 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 quality control responsibilities. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

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.

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.

Team development and performance are critical to leadership success. In this session, participants will examine team formation, learn about the balance between team performance and team health, develop team agreements, and understand the latest tips from Google's Perfect Team research to strengthen team experience. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Practitioners need to exercise caution to ensure they maintain independence as they assist their clients with reviews, audits, and compilation engagements. This course provides a roadmap to best practices and guidance provided by the AICPA's Code of Professional Conduct and analyzes and applies it to actual scenario-based case studies, providing accounting professionals with ethical standards to integrate into their practices. This event may be a rebroadcast of a live event and the instructor will be available for questions during the event.

ESG, environmental, social, and governance, is a buzzword that is not only gaining traction but will be mandatory for a company's continued success. So what is ESG? What does it mean? Why is ESG important? What is the ROI of adopting ESG? Who should lead our ESG initiatives? How do we get started? These questions and more will be answered in this fast-paced session that will explain the ABCs of ESG. We will also outline a framework to begin your ESG journey. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

With the rapid pace of change, change now happens daily in business and our personal lives. It can be difficult to navigate change when right and wrong get a bit fuzzy. New processes, new technology, new circumstances and new impacts to people must be measured and decisions made as the change evolves. Change always becomes something different than what was originally planned or imagined. In this session, learn how to measure your ethics through change. You will learn how to filter everything you do during change through a simple litmus test. Through the power of story, you will learn from the lessons of other organizations and their ethical mistakes. Lastly, you will take away what is required to manage yourself so that when ethical decisions arise, you have the mental capacity to manage through it well. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

In the fight against global corruption, accountants are being asked to be more forthcoming when they discover information or evidence that points to illegal or prohibited activities. This ethics workshop considers new international professional ethics proposals for responding to non-compliance with laws and regulations (NOCLAR). This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

You are likely familiar with and/or have experience with IRS summonses. BUT - Did you know there's a lot of procedure and decorum that goes into issuing a summons that you can leverage to help your client? This program will focus on the basics of an administrative summons, what the IRS can summons for, how you should comply with a summons, summons referral criteria, and common errors and misnomers the IRS can make in generating/serving a summons. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Conflict is often avoided, or dealt with in a passive manner. When ignored, conflict often escalates and can become polarizing. In this session, participants will gain insights for enhancing their natural responses to conflict, learn healthy communication styles, and build constructive behaviors to manage conflict. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Unlock the full potential of your data with our specialized course, "Create Measures in Power BI that Define Your Metrics". Designed for professionals who aspire to excel in the dynamic world of data analysis, this 4-hour intensive training delves deep into the advanced functionalities of Microsoft Power BI. You'll embark on a journey to master the art of Data Analysis Expressions (DAX), a powerful tool in the Power BI suite to create metrics. This course is meticulously crafted to transform you into a proficient user, capable of harnessing complex DAX calculations to bring your data to life. The course content is thoughtfully structured to ensure a comprehensive learning experience. Starting with the foundational elements of DAX, you'll rapidly progress to tackle advanced formulas and time-intelligent functions, essential for nuanced data analysis. The highlight of the course is the emphasis on the DAX calculation process, a crucial aspect for validating measures in Power BI. Additionally, the practical application of PivotTables for measure validation will equip you with the skills to confirm the accuracy and effectiveness of your data measures. These advanced techniques are not just theoretical concepts but are presented through engaging, real-world scenarios, enabling you to apply your learning immediately to your daily tasks. This course is an invaluable step towards mastering Power BI and making data-driven decisions with confidence. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

We are now officially in the era of digital communications, collaboration and knowledge sharing. Is your organization prepared to embrace it? This course will show you how to do just that by strategically deploying the Microsoft Office 365 ecosystem of applications with the Teams app at the core. Office 365 provides the tools to digitally transform your workflows to increase efficiency, as well as to provide the ability for your team to work from anywhere, at any time, on any device. We will review how you can leverage specific Office 365 apps to foster online communication, collaboration and knowledge sharing among your team members, as well as externally with clients, customers and service providers. You will leave this course with a solid understanding of how to tap into Office 365 to take your business digital. 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 dives into the powerful, but potentially under-utilized, capabilities of Microsoft Excel. Designed for sophisticated users willing to approach spreadsheets from a unique perspective, this program encourages users to challenge the status quo by considering opportunities to take acceptable spreadsheets to a new level. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

What actions can financial professionals take to increase the odds of a successful system implementation? This session will show you how to be a key player on the team by focusing on specific areas in the project planning and delivery process that improve results. Learn how to use components of a project plan to transparently manage a project from the planning phase through embedment. These actions can be applied to small system changes, system upgrades, or large ERP systems. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.