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 2010, Excel 2013 or Excel 2016.
Two Day Excel Dashboard Training in Jakarta – Conducted by Master Trainer Vinai Prakash, MBA, PMP, GAP – noted speaker, author, consultant and principal business analyst.
Vinai has over 28 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, Singapore )
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.
Tea/Coffee, Light Snacks are provided in this training.
This course is not suitable for Absolute Beginners in Microsoft Excel. Apple Mac is not supported for this training.
1. Understanding Management Dashboards
- What is a Dashboard?
- Principles of Great Dashboard Design
- Referencing & Ranges
- Advanced Lookup
- Advanced Formatting
- 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
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
Call us at +65 6392-4590 or Send an email to [email protected]