Excel – Beyond the Bar Chart – Data Visualization and Data Story Telling Techniques

07/05/2024
Live Webinar
10 day
6 hr
58 min
21 sec

Revolutionize the way you communicate data with this cutting-edge training on Excel visual storytelling. Discover the power of visual data representation to transform complex numerical information into compelling, insightful visual narratives.
The era of simple bar and pie charts has moved on. Today’s data-driven environment demands more dynamic visualizations and infographics. Our session will guide you through Excel’s innovative non-chart tools, empowering you to captivate your audience with data.

What You Will Master

  • Selecting impactful visualizations that resonate with your message
  • Crafting succinct Sparkline charts for at-a-glance data comparison
  • Utilizing shapes, symbols, and icons for infographic-inspired displays

Why you should Attend

  • Stay ahead of the curve by updating your Excel visualization toolkit
  • Learn to meet and exceed audience expectations with sophisticated data presentations
  • Excel is not just for spreadsheets anymore. Unlock its full potential for modern data
  • communication

Topics We’ll Explore

  • Constructing Sparklines for immediate data visualization
  • Pioneering with Waffle Charts to “Square the Pie.”
  • Designing vibrant infographics using shapes, images, and icons
  • Generating heat maps with Conditional Formatting for data intensity display
  • Symbolizing data trends with icon sets for clarity and impact
  • Mapping out the world with Excel’s 3D Map feature for geographical data storytelling

Who should Attend?

This intermediate-level training is perfect for Excel users eager to enhance their data visualization prowess. While we utilize the latest Excel version for demonstrations, the skills you’ll learn are applicable to Excel 2010 and beyond, ensuring broad relevance and applicability. Join us to elevate your data presentation from standard to standout.

Date: 07/05/2024

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

Reg. deadline: 07/04/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…

Related Events

Revenue Codes vs CPT/HCPCS Edits:  Does Your Chargemaster Reflect Best Matches?
Compliance Webinars
Live Webinar

Revenue Codes vs CPT/HCPCS Edits: Does Your Chargemaster Reflect Best Matches?

A hospital chargemaster is a comprehensive list of a hospital's products, procedures, and services. Everything from prescription drugs to supplies for diagnostic tests has a unique price listing in the chargemaster. Major components include revenue codes that reflect the site of service and applicable CPT/HCPCS codes that indicate the service provided/charged. Poor matches between these code sets may lead to distorted cost centers, lost revenue, charges bundled that should be separately reported and incomplete departmental charging. Webinar’s Goals Understand chargemaster code functions Understand revenue leakage resulting from poor chargemaster structure Understand why correct departmental charging is vital to revenue integrity Appropriate training for charge entry staff Billing attention to posted charges Who Should Attend Chargemaster Maintenance Staff Compliance staff Billers Coders Revenue Cycle Managers & Staff Risk Management Charge entry staff

Paying for Referrals: A Danger to Your Freedom
Compliance Webinars
Live Webinar

Paying for Referrals: A Danger to Your Freedom

The session will provide an overview of the Anti-Kickback Statute (AKS) and review what it prohibits, as well as review the Statute’s available safe harbors. It will also show how violation of the AKS can raise FCA concerns, and it will provide an assessment of enforcement activities, showing how participants may be at risk. In addition, the session will review recent cases and show how they potentially impact participants. We will provide an in-depth review of the AKS, focusing on what is prohibited under the Act and what the exceptions are. We will also review the case law, particularly the early case law that sets the stage and basis for how the courts interpret the law. Since one of the exceptions to enforcement under the Act is regulations promulgated by the Secretary, the “safe harbors,” payment practices that will not be subject to criminal prosecution and that will not provide a basis for civil monetary penalties or exclusion from the Medicare or Medicaid programs, we will examine these safe harbors, particularly those more frequently used, to show how protection from enforcement can be achieved. Specifically, we will review the investment, space and equipment rental, personal services/management contracts, and physician recruitment safe harbors. In addition, we will discuss the OIG’s Joint Venture Advisory Opinion, where a hospital expands into a related service line by contracting with an existing provider of that service. The OIG has significant problems with such an arrangement. We will also discuss the recent advisory opinion by the OIG regarding Physician-Owned Entities. OIG views PODs as inherently suspect under the AKS because the opportunity for a referring physician to earn a profit, including through an investment in an entity for which he or she generates business, could constitute illegal remuneration under the AKS. Finally, the webinar will review various cases to show how easy it is to run afoul of the Statute, and how the courts view compliance with it. Who Can Benefit Hospital executives, particularly CEOs, COOs, CFOs, CNOs, and CMOs; Nursing home executives; Physicians; Physician practice managers; and Other healthcare provider executives. Target Audience Hospital executives, particularly CEOs, COOs, CFOs, CNOs, and CMOs; Nursing home executives; Physicians; Physician practice managers; and Other healthcare provider executives. Background The AKS is currently the focus of law enforcement officials. The Statute provides that the offer or payment, as well as the solicitation or receipt, of “any remuneration” in exchange for referrals of any good, facility, service, or item for which payment may be made in whole or in part under Medicare/Medicaid is prohibited. Recent cases and/or enforcement actions involving the AKS, violation of which has been held to be the basis of an action under the Federal False Claims Act, (“FCA”) raise serious concerns regarding compliance issues with hospital, physician practices and other healthcare entities. Recoveries under the FCA are at an all-time high, and the percentage of actions involving healthcare organizations has been increasing at exponential rates. Areas Covered in this Presentation Federal Civil Anti-Kickback Statute, Safe Harbors providing protection under the AKS, Enforcement activities involving the AKS, The OIG’s Joint Venture Advisory Opinion, The OIG’s advisory opinion regarding Physician-Owned Entities, and The anti-fraud provisions of the Affordable Care Act.

Excel - Beyond the Bar Chart - Data Visualization and Data Story Telling Techniques
Compliance Webinars
Live Webinar

Excel - Beyond the Bar Chart - Data Visualization and Data Story Telling Techniques

Revolutionize the way you communicate data with this cutting-edge training on Excel visual storytelling. Discover the power of visual data representation to transform complex numerical information into compelling, insightful visual narratives. The era of simple bar and pie charts has moved on. Today's data-driven environment demands more dynamic visualizations and infographics. Our session will guide you through Excel's innovative non-chart tools, empowering you to captivate your audience with data. What You Will Master Selecting impactful visualizations that resonate with your message Crafting succinct Sparkline charts for at-a-glance data comparison Utilizing shapes, symbols, and icons for infographic-inspired displays Why you should Attend Stay ahead of the curve by updating your Excel visualization toolkit Learn to meet and exceed audience expectations with sophisticated data presentations Excel is not just for spreadsheets anymore. Unlock its full potential for modern data communication Topics We’ll Explore Constructing Sparklines for immediate data visualization Pioneering with Waffle Charts to "Square the Pie.” Designing vibrant infographics using shapes, images, and icons Generating heat maps with Conditional Formatting for data intensity display Symbolizing data trends with icon sets for clarity and impact Mapping out the world with Excel's 3D Map feature for geographical data storytelling Who should Attend? This intermediate-level training is perfect for Excel users eager to enhance their data visualization prowess. While we utilize the latest Excel version for demonstrations, the skills you'll learn are applicable to Excel 2010 and beyond, ensuring broad relevance and applicability. Join us to elevate your data presentation from standard to standout.

Power BI - Getting Started - Transforming Data into Stunning Visuals
Compliance Webinars
Live Webinar

Power BI - Getting Started - Transforming Data into Stunning Visuals

Are you ready to embark on a journey that will revolutionize the way you work with data? Welcome to "Power BI Demystified: Transforming Data into Stunning Visuals” Discover the power of Microsoft's revolutionary application, Power BI. Designed for beginners, this comprehensive training session will introduce you to the world of data visualization and insights like never before. Say goodbye to the days of relying on IT departments for subpar reports – with Power BI, you take the reins, becoming a self-service reporting pro. Objectives Master the art of creating compelling reports using Power BI Desktop (Windows only). Learn how to design interactive, visually striking reports and effortlessly share your insights. Why You Should Attend The true value of your data is in the insights it can provide. Power BI empowers you to unlock the full potential of your data, helping you make informed, data-driven decisions that drive your business forward. If you're eager to elevate your reporting capabilities and harness the full potential of Power BI, this training session is an absolute must-attend event. Topics Covered Connect data sources (Excel, databases, text files, etc.) to Power BI Elevate your reports with engaging visual elements Apply professional formatting, including colours, fonts, and styles, to your reports Streamline report updates when the underlying dataset changes Create interactive filters to enhance report interactivity Automate data preparation Easily share your reports with colleagues Who should attend This training caters to a diverse audience, including business analysts, data professionals, and anyone with an interest in data analysis. It provides the foundational knowledge and skills needed to unlock the full potential of Power BI.   Please note that Power BI Desktop is exclusively available for Windows and is not compatible with Mac or mobile devices. Join us on this transformative journey, and let's demystify the world of data together! Your data has stories to tell – it's time to give them a voice with Power BI.