Learn the Best Tricks to Transform Data into Information, and become an Excel Ninja 
Advanced Techniques for Using Formulas, Pivot Tables, Charts & Dashboards in Excel in a Sales, Marketing, Accounting or Service Department. 
You must have basic knowledge of Microsoft Excel.
Two Day Excel Dashboard Training – Conducted by Master Trainer Vinai Prakash, MBA, PMP, GAP – noted speaker, author, consultant and principal business analyst.
Vinai has over 35 years of experience in analyzing data and is an expert an Data Mining & Data Analysis using Microsoft Excel and many other business intelligence tools.
Click Here to Download The 8 Habits of Highly Effective Data Analysts (An Article Written by Vinai Prakash, published in the Straits Times NEWSPAPER, Singapore )
Course Objectives
Sales, Marketing, Finance, IT Executives, Engineers, Project Managers, Directors, CXOs, Managing Directors, General Managers, and Data Warriors who dabble with data and want to learn advanced techniques to convert Data into actionable Information.
October 22-23 – To register, click HERE or email to corporate@intellisoft.com.sg
Tea/Coffee, Light Snacks are provided in this training.
Target Audience
This course is not suitable for Absolute Beginners in Microsoft Excel. Apple Mac is not supported for this training.
Course Outline
1. Understanding Management Dashboards
- What is a Dashboard?
- Principles of Great Dashboard Design
- Referencing & Ranges
- Advanced Lookup
- Advanced Formatting
- Percentage
- Computed Columns
- Grouping & Sorting
- Top Views
- Multiple data sources
- Pivot Charts & Visual Dashboarding Techniques
- Thermometer Chart
- Doughnut Chart
- Pareto chart
- Versatile management dashboards
- Simple & Complex Macros
- Dynamic Dashboards using Macros
- Complete Management Dashboard for Sales & Services
- Best Practices in Dashboard Design
7 Practical Dashboard Creation: Hands-on Dashboard Creation in the Workshop
- Creating a Sales Dashboard
- Creating a Services Dashboard
- Creating a HR Dashboard
Pre-Requisites
You should have knowledge of the basics of using Microsoft Excel 2016 / 2013 / 2010 and using simple functions and formulas.
Testimonials : Comments from Past Participants of the Management Reporting with Excel MasterClass
It covered advanced techniques which I did not already know. – Mark Stephens, SRQ
I loved the Dashboard Training. It is like we are magicians. – Lim, Leo Pharma
I liked the simple methods to create amazing dashboards. It will help me better interpret and present the data. – Rena, Certis Cisco
This training will help me in creating management reports for presentation of financial data / KPIs to the management. – Ong, Keppel FELS
There were lots of exercises to better understand the various concepts. I liked the hands on training. – Nah, Asiawide Franchise
Need Help?
Call us at +65 98773485 or Send an email to support@excelchamp.net
