• Call Us: +1 833 990 1500 (Toll Free) (Mon - Fri, 7am - 3pm EST)
  • Email Us: info@medical-webinars.com

Excel – Build Advanced Pivot Table Solutions Using the Data Model & Power Pivot

10/04/2024
Live Webinar
17 day
20 hr
16 min
56 sec
Excel - Build Advanced Pivot Table Solutions Using the Data Model & Power Pivot

NOTE: This course is not appropriate for Mac or iPad users as the functionality does not exist on those platforms.

Whilst Pivot Tables offer valuable data summarization features, they also have several limitations. They struggle with handling large datasets, they lack the ability to combine data from multiple datasets and the built-in calculation functionality is very simplistic.

This training focuses on the Data Model and Power Pivot, two of Excel’s hidden gems which help to overcome the built-in limitations. For example, using Power Pivot you can…

  • Create Pivot Tables from multiple lists/tables without the need to combine them into a single list first (goodbye LOOKUP and all the issues that it brings)
  • Create Pivot Tables from large datasets without worrying about file size, performance or needing more rows than an Excel worksheet contains
  • Create Pivot Tables from multiple data sources (Excel, database, text file etc)
  • Create powerful calculations on the data in your Pivot Tables
  • And more

For anyone who is serious about taking their Pivot Tables to the next level, this course is a must!

Objectives

In this training, you will learn, using practical examples, how Power Pivot provides Business Intelligence and reporting functionality within the familiar environment of Excel to provide you with better business insights and enable you to make more informed business decisions.

Why you should attend

Your data is only as good as the information you can derive from it. Power Pivot enables you to gain better business insights and make more informed business decisions.

If you want to take your reporting capabilities to the next level by learning how to leverage the functionality of Power Pivot, this is a must-attend training session!

Topics covered

  • What is The Data Model and why is it important?
  • Importing data into the Data Model – the why and how
  • Using the Data Model to create and manage relationships between tables
  • Creating a Pivot Table from related Excel tables
  • Creating a Pivot Table from related data sources (including external sources)
  • An introduction to the DAX formula language to create simple calculated columns

Who should attend?

This training is aimed at users of Excel (2010 and above for Windows) who wish to learn about Power Pivot & The Data Model. Attendees should have at least intermediate knowledge of Excel and be familiar with formulas and creating Pivot tables.

IMPORTANT NOTE: This course is NOT suitable for Mac users or iPad users as the functionality does not exist on those platforms. On Windows, Power Pivot may not be available for your version of Excel. If you are unsure whether this training is relevant for your version of Excel, please check with your IT department or see this link: https://support.microsoft.com/en-us/office/where-is-power-pivot-aa64e217-4b6e-410b-8337-20b87e1c2a4b

Date: 10/04/2024

Time: 1:00 pm - 2:30 pm (EDT)

Reg. deadline: 10/03/2024

Venue: Live Webinar

Enrollment option

Speaker

Mike Thomas
Mike Thomas have worked in the IT training business since 1989 and although he has a subject matter expert in a range of technologies, particularly Microsoft Office, my passion is for all-things-Excel-related with Power BI coming a close second. In a career spanning 30+ years, he has delivered training to thousands of people as well…
Show More

Related Events

How to Uncomplicate the Growing Demands of HIPAA Compliance
Compliance Webinars
Live Webinar

How to Uncomplicate the Growing Demands of HIPAA Compliance

Confused about HIPAA compliance requirements and how it applies to your organization? HIPAA can be complicated!! Knowing what an organization must have in place to meet regulatory requirements can be challenging. For anyone tasked with managing a HIPAA compliance program, understanding the HIPAA security and privacy management process is critical to implementing and maintaining a comprehensive compliance program. The webinar will look at specific challenges organizations face in meeting HIPAA compliance requirements. This will include risk management plans; risk assessments; and program management. A growing concern with healthcare data is cybersecurity threats. The webinar will review critical HIPAA related information security topics. After completing this webinar, a Covered Entity or Business Associate will have a clear understanding for how to meet the growing demands of HIPAA compliance. Webinar Objectives Definitions, Rules, CFR, & Acronyms Who Must Comply with HIPAA Requirements? What are the HIPAA Security and Privacy Rules? Challenges of HIPAA Compliance What is a HIPAA Risk Management Plan? Upcoming changes to the HIPAA Privacy Rule How to prevent HIPAA data breaches from occurring Q&A Webinar Highlights Learn from an expert on the implementation of the HIPAA rules Learn what the HIPAA management process requires Learn how to uncomplicate and be able to evaluate your organization’s HIPAA compliance program Who Should Attend Compliance Officer HIPAA Privacy Officer HIPAA Security Officer Medical/Dental Office Managers Practice Managers Information Systems Manager Chief Information Officer General Counsel/lawyer Practice Management Consultants Any Business Associates that access protected health information

09/17/2024
Enroll/Buy Now
Prepare for 2025 ICD-10-CM Code Updates
Compliance Webinars
Live Webinar

Prepare for 2025 ICD-10-CM Code Updates

ICD-10-CM updates for 2025 will become effective on October 1, 2024. These updates will include several guideline changes as well as multiple updates & additions to the specific chapters. This webinar will discuss the new guidelines as well as specific code categories in which you need to be alert to changes that may impact your code selection. All chapters will be included to ensure your specialty is covered. It is impoprtant that you be proactive and prepared when submitting your claims with discharge dates of October 1. Missed update information may cause a processing & reimbursement delay. Webinar’s Goals Be aware of guideline changes Learn about chapter specfic additions & updates Ensure you are prepared with new code information Align with your software vendors to implement any necessary changes Target Audience Revenue Cycle Managers & staff Billers Coders Clinical Documentation Staff Finance Managers Denial Management Staff Physicians Mid Level Providers Claims Follow Up Staff

09/20/2024
Enroll/Buy Now
Denials Management
Compliance Webinars
Live Webinar

Denials Management

One of the common functions in the medical revenue cycle for practices is adjudicating denials received from the insurance companies. Sometimes procedures or services are denied because they have been coded or billed incorrectly or in error, but it not uncommon that insurance companies will also deny claims in error. Whether the claim or the insurance company is in error contacting the insurance company in a timely manner is critical to ensure providers are reimbursed for services and procedures that were performed. Understanding the insurance companies’ rules and guidelines and knowing where to find them is also important when reviewing claim denials. Everyone in a revenue cycle department has good intentions of taking time to review denials received, and make corrections or write appeals when necessary, however, very often denials are put on the back burner for everything else that can come up in the office. This webinar will give proven tips on creating a process in handling denials by the types of the denials you maybe receiving efficiently. Session Highlights Reading denial and remark codes and understanding what they mean Know when billing a patient is the right thing to do Tips on processing denials in an efficient manner Applying insurance carrier policies to you claims to avoid denials References that can be used to defeat denials. Modifiers that can be used to avoid denials Documentation that is important to support your appeals The difference between a denial and remark code.

09/24/2024
Enroll/Buy Now
Hospital Outpatient Prospective System: Final Rule 2024
Compliance Webinars
Live Webinar

Hospital Outpatient Prospective System: Final Rule 2024

In addition to finalizing payment rates, the 2024 Final Rule includes promoting health equity, expanding access to behavioral health, improving transparency and promoting safe, effective and patient-centered care. The following areas will be covered in this webinar: Updates to OPPS & ASC Payment Rates Intensive Outpatient Program Scope of Benefits for Intensive Outpatient Program Physician Certification & Plan of Treatment Requirements Intensive Outpatient Program Payment Rates & Policies Opioid Treatment Program Settings Partial Hospitalization Program Changes to Community Mental Health Centers Conditions of Participation Remote Mental Health Services Payment for Dental Services Rural Emergency Hospitals Transitional Pass-Through Payment for Devices OPPS Payment for Dtrugs Acquired Through 340B Program Webinar’s Goals Provide clarity of Final Rule content and effects on your provision of services Advances Centers for Medicare & Medicaid Services’ commitment to strengthening Medicare Changes that will help address health inequities Use of lessons learned from COVID-19 PHE to inform approach to quality measures Target Audience Physicians Practice managers Medical assistants Nurses Compliance staff Billers Coders Revenue Cycle Risk Management Charge entry staff Finance Staff Therapists  

09/27/2024
Enroll/Buy Now

© 2024 Medical Webinar. All rights reserved