Business Intelligence And Data Insights With Dashboards


Training Format: Recorded Webinar

Format Type: DVD

Speaker(s): Mike Thomas

Supporting File(s) : Download Zip (94.24 KB)

Webinar Date: Tuesday, June 12, 2018

Training Duration : 90 minutes

Training Material Download : Conference Material (Password Required) (820.84 KB)

TRAINING DESCRIPTION


Untitled Document

Improve your visual communication using pivot table and excel charts

Do you often have to present data, charts and graphs in a visually appealing manner? Then you know better than anyone that presentation is everything. And to get a high-level overview of the business, dashboards are your best bet. Although there are many tools that can be used to create a dashboard, Excel is the most commonly used due to its power, its flexibility and the fact that most people have it installed on their computer.

Excel allows you make powerful dashboards that can provide analysis, insight and alert you in timely manner. But how do you create a dashboard that actually works? Join Microsoft Excel expert Mike Thomas in this webinar - Business Intelligence and Data Insights with Dashboards to learn all you need to know to create an interactive professional-looking dashboard using Excel.
In this webinar you'll learn how to make the dashboard maintenance-free when new data becomes available, create the pivot tables needed to drive the dashboard, create great looking visuals, add interactivity using slicers, automate elements of the dashboard with a macro and protect the cells containing critical formulas.

Learning Objectives

Here’s a look at what you will learn:

  • Best practices for setting up data sources
  • How to use Pivot Tables to summarize data
  • Improve your visual communication using charts
  • Learn to use formulas to create KPI summaries
  • Know how to create interactive filters with Slicers
  • Automate the dashboard with a simple macro
  • Use protection to prevent accidental changes

Why Should You Attend?

In this training session, you'll learn how to create a stunning, interactive professional-looking dashboard using Excel. This training will provide you with a solid foundation that you can use to build your own dashboards and reports.

Who Should Attend

This webinar is for any user of Excel who wants to learn how to create Excel dashboards. You should have an intermediate level of Excel knowledge and preferably know how to create a basic pivot table.

  • Data analysts
  • Finance professionals
  • Leaders
  • Human Resource Professionals
  • Office Managers
  • Staff
  • All Excel users


ABOUT TRAINER


MIKE THOMAS , ,

Mike Thomas has worked in the IT training business since 1989. He is a subject matter expert in a range of technologies including Microsoft Office and Apple Mac. In 2012 Mike founded theexceltrainer.co.uk where he has produced nearly 200 written and video-based Excel tutorials. He has recorded several Excel training courses for plural sight.com and .. Read More >>





TRAINING OPTIONS


Quantity  

( * ) Single User Price Only.

For Multiple Users/Group, Call 1-888-409-0777.

WE ALSO RECOMMEND


Mastering Microsoft Excel Pivot Tables & Pivot Charts
by Dennis Taylor