Excel - Business Intelligence with Dashboards

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.
Email: [email protected]
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.

Others Details

For more details and updates please visit website.