microsoft excel training 2017 - Excel - Business Intelligence with Dashboards -By Compliance Global Inc

OVERVIEW:
This Excel training focuses on what you need to know to create an interactive professional-looking dashboard using Excel.
No matter what business you are in, a dashboard is a critical tool in your communication armoury and as with any communication tool, presentation is everything. Although there are many tools that can be used to create a dashboard, Excel is commonly used due to it’s power, it’s flexibility and the fact that most people have it installed on their computer.
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.
AREAS COVERED:
Best practice for setting up data sources
Using Pivot Tables to summarize data
Visual communication using charts
Creating a rolling 30-day summary
Using formulas to create KPI summaries
Creating interactive filters with Slicers
Automating the dashboard with a simple macro
Using protection to prevent accidental changes
LEARNING OBJECTIVES:
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.
WHO WILL BENEFIT:
This webinar is for any user of Excel who wants to learn how to create Excel dashboards.
For more Details Please visit: http://bit.ly/2sHcsqA
Email: support-AT-complianceglobal.us
Toll Free: +1-844-746-4244
Tel: +1-516-900-5515
Fax: +1-516-900-5510
SPEAKER:
Mike Thomas has worked in the IT training business since 1989. His expertise and experience covers creating and delivering training courses, writing training materials and recording and editing video-based tutorials.
He is a subject matter expert in a range of Microsoft technologies and has also worked extensively with Mac OSX and Mac-related software since 2006, however, his passion is for all-things-Excel.
Mike is a Fellow of ‘The Learning and Performance Institute’ and has worked with and for a large number of global and UK-based companies and organizations across a diverse range of sectors.
In addition to training, he designs and develops Microsoft Office-based solutions that automate key business tasks and processes.