This webcast is part of the 2020 Power BI Series. Please see below for the suggested viewing order.

This webcast focuses on using the Power Pivot features to enhance data analysis. We will review the 4 features of Power Pivot (data model, calculations, hierarchies and KPI's) and you will learn how you can use each of these features. Although, the majority of the time will be spent on building the data model and using calculations.

You will learn how to add data to your data model either directly into Power Pivot or from Power Query. We will discuss the benefits of the data model relationships versus using the VLOOKUP function to access data in different tables.

One of the strengths of Power Pivot is the formula language called DAX (Data Analysis eXpressions). We will introduce DAX so that you can use basic DAX formulas to build various calculations in the data model. You will learn the difference between calculated columns and measures as we build these various calculations into our data model.

This series is presented using Excel 2019/Office 365. Regardless of the version you are using, most concepts covered in this webcast series apply to all versions of Excel.  (bold) *However, in order to follow along and apply concepts being taught during this session, you need to have the Power Pivot add-in installed.

Explore the other webcasts in the 2020 Power BI Series:

Power BI - Introduction to MS Power BI Tools

Power BI - Prepare Your Data Efficiently for Excel Analysis

Power BI - Analyze Your Data With Excel Pivot Tables

Power BI - Create Excel Dashboards for Maximum Impact

Power BI - Use Power Query to Transform Your Data

Power BI - Use Advanced Calculations with DAX Formulas

Power BI - Use PBI Desktop to Create Reports and Dashboards

Power BI - Share Your Data Analysis using PowerBI.com

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.

* This course is #3 in the Microsoft Power BI series of webinars. Click button in Program Content section below to see suggested viewing order. * Excel is a popular tool for data analysis, yet most users have never learned the basics of data analysis using Excel or the tools that Excel offers to help with data analysis. This session is designed to teach participants the importance of PivotTables for analyzing data. We will demonstrate how PivotTables can make data analyzation an easy task for all accountants. Participants will learn the step-by-step process to create PivotTables and PivotCharts. We will also cover all the setup options and features. 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.

This course will review the Accounting Standard Updates issued by the FASB that impact nonprofit entities. We will also look at the work of the Not-for-Profit Advisory Committee (NAC) and the projects they are advising the FASB on. 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 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.

NOTE – This ethics course has not been approved by the Accountancy Board of Ohio therefore does not count towards your mandatory 3 Hours of Professional Standards & Responsibilities credit per renewal period. This course does count towards your 120 CPE Hours.

Retaining Talent in a Competitive Marketplace -Creating a Benefits Program Employees Care About In today's competitive marketplace, retaining talented employees is becoming increasingly difficult. A solid benefits program can make a difference in the fight for talent - but only if those benefits matter to the employees you are trying to hire! Through statistics and case studies, this course will explore what benefits are most valuable to employees. We will also explore the basic types of retirement and health insurance plans and discuss what financial leaders should consider before adopting a benefits package. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

The right tools Change can be difficult if you do not have the right tools. You can gain those tools through this course, which includes case studies that provide more insight into the changes in the auditor’s report and key areas to focus on during your audits.

Are you comfortable giving presentations and feel good about your performance, or does the experience make you anxious and leave you feeling dissatisfied? In this session, learn how to let your best self shine during interactions with your staff, the auditee, and the governing board. Jim Comer is an accomplished speechwriter and presentations skill coach for executives. Leita Fanta has led over 1500 full-day seminars. Let Jim and Leita help you establish genuine and comfortable professional relationships and avoid mistakes that will detract from your message. *Qualifies for Yellowbook credit This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Think about how much time you spend reviewing and creating PDF files. This course teaches you how to take advantage of a multitude of features and functions available in Adobe Acrobat to create, review, organize, edit and secure your PDF files more effectively and efficiently. Like many personal productivity software applications, it is very likely that you are using only a fraction of the potential of Adobe Acrobat when working with your PDF files. For many CPAs, a PDF file is the final presentation of your work product, whether it is a tax return, financial statement, audit report or other financial reports. This course will teach you how improve the quality of those report presentations. The tips you learn in this course will save you time on a daily basis. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

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.