This Practical, Hands-on Excel Dashboard Masterclass will help you Learn How to:
· Create Pivot Tables & Pivot Charts for Data Visualisation.
· Data Manipulation using Advanced Functions like Vlookup, SumIF, CountIF and more!
· Organize worksheets and tables data using Various Advanced techniques
· Work with Multiple Worksheets & Workbooks to Consolidate Information
· Create and modify charts & graphs for faster Data Interpretation.
· Record Macros to Automate Routine Tasks
Who Will Benefit: Sales, Marketing, Finance, IT Executives, Engineers, Project Managers, Directors, CXOs, Managing Directors, General Managers, will Benefit from this Excel Dashboard Masterclass in Jakarta.
Our Training will be conducted in Central Jakarta. (9am-5pm on both days)
Detailed Course Outline
Advanced Charting Techniques, Thermometer Chart, Doughnut Chart, Pareto Chart, Simple and Complex Macros, Dashboard Design, Creating Sales Dashboard, Service Dashboard, HR Dashboard, Advanced Formatting, Advanced LookUp Technique, Working with Multiple Data Source, Grouping, Sorting and much More !
You must bring your own laptop with Excel Software Installed.
Our Trainer are Mr. Vinai Prakash 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 and is extremely patient & passionate about sharing his Knowledge, tip, tricks & Techniques.
Dashboard Trainings in Other Countries:
Singapore : 23, 24 Jul 2019
Kuala Lumpur, Malaysia: 27, 28 June 2019
To Know More: https://www.intellisoft.com.sg/excel-pivots-charts-dashboards-masterclass.html
Feel Free to Contact us
Tel: (65) 9877 3485 (Call/WhatsApp)
Email : [email protected]
29/05/2019 4:00 pm
Hotel In Central Jakarta