Microsoft Excel: Building Infographics, Dynamic Data Analytics and Visualization

    /Neil   /Malekspeaker of Training Doyensinvite
    Speaker: Neil Malek


    More Trainings by this Expert
    Duration: 60 Minutes
    Product Code: 50540
    Level: Intermediate
CEU Approved

Training Doyens is recognized by SHRM to offer Professional Development Credits (PDCs) for SHRM-CP or SHRM-SCP. This program is valid for 1 PDC for the SHRM-CP or SHRM-SCP. For more information about certification or recertification, please visit shrmcertification.org.


OVERVIEW

As we hurtle toward 2020, every list of essential job skills and core competencies contains the following ideas: Data Analytics, Data Visualization, and Communication. While there are certainly a host of new tools and technologies to help us with that, the tools we already know and use daily have vast untapped potential. Microsoft Excel, certainly, gets a bad rap when it comes to ‘data visualization,’ but that’s almost entirely because people don’t know how to use the tools in the box!

In this webinar, we’ll highlight a number of professional and compelling techniques for analyzing and visualizing data with Excel. These can be used to build Excel infographics, slide decks, reports, or any other sort of communication medium. You don’t need to invest money in new software – Excel can handle nearly anything.

When you can visualize and communicate the important insights in your business, you are far ahead in many different areas. Market your ideas to a new audience with beautiful and compelling visuals; get buy-in to fund your new business idea; sell clients on the effectiveness of your solutions. As people who live ‘close to the numbers,’ it can be very difficult to effectively communicate your message to people ‘outside the bubble.’ These tools will cut through the noise and create change.

WHY SHOULD YOU ATTEND

Unlike many webinars, Neil’s sessions are 100% hands-on real-world examples of the skills he’s presenting. After this session, you’ll have a screenshot-laden step-by-step guide to performing the techniques we cover. You’ll be able to apply these skills directly to your work with almost no adjustment, and with a very short learning curve.

AREAS COVERED

  • Data visualization tools in Excel and creating graphical charts with symbols, pictures, maps, and more
  • Highlighting relevant data dynamically with conditionally formatted charts
  • Isolating critical points with logical functions
  • Leveraging essential design skills to understand and deliver for your audience
  • Using obscure tools like the Camera and Pivot drill-downs to build incredible dashboards

LEARNING OBJECTIVES

Excel can create an incredible assortment of chart and visualization types, far beyond the bar charts and pie charts you’ve seen a thousand times. In this session, we’ll demonstrate how to create icon- and map-based visuals, as well as dynamic dashboards that update as your data changes.

WHO WILL BENEFIT

  • C-level Executives
  • Sales professionals
  • Marketing professionals
  • Educators and Trainers
  • Business Analysts
  • Consultants

… and anyone who needs to communicate numbers.

SPEAKER

Neil Malek is principal at Knack Training, a software training company specializing in Microsoft products. For nearly two decades, Neil has been working with non-profits, governments, and Fortune 500 companies to identify and address skills gaps. 

Neil is a Microsoft Certified Trainer, Adobe Certified Instructor, and CompTIA Certified Technical Trainer from Orlando, FL. His career, spanning from the Center from Instructional Technology and Training at the University of Florida to his current business, has led him to train on products from Microsoft Office, SharePoint, Teams, and OneDrive to Adobe Acrobat and Creative Cloud, to the Google Suite for Business, and includes professional development topics like presentation design and delivery.

Neil’s work currently focuses on using Office power tools to analyse information, present it effectively, and automate business processes that would otherwise rob us of time, energy, and enthusiasm.

View all trainings by this speaker

Purchase Options

Recorded Session

Get unlimited access to the link for six months. Login information will be shared 24 hours after the completion of Live webinar

$149

Training DVD or USB Flash Drive

Free shipment within 72 Hours, from the date of webinar completion

$249

refer friend

Approved Enablers of your
Continuing Education Credits

shrmhrci
View all CEU Approved Webinars  

View Similar Trainings

In Cross Industry Functions

  Bob Churilla Time: 01:00 PM EDT | 10:00 AM PDT
  Audrey Halpern Time: 01:00 PM EDT | 10:00 AM PDT
  Joel Garfinkle Time: 01:00 PM EDT | 10:00 AM PDT
  Tim Connor Time: 01:00 PM EDT | 10:00 AM PDT