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. Bring your own laptop, and learn the advanced tips and tricks from our Excel Guru.
Two Day Excel Dashboard Training in Singapore – 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.
Funding For Excel VBA Macro: Individual Singaporeans can use their Skills Future Credits. Companies can claim SDF Grant.
Assessment: There is NO assessment or test for this training. Certificate of Attendance will be provided.
|23, 24 Jul 2020|
|17, 18 Sep 2020|
Excel Dashboards Course Outline
- Understanding Management Dashboards
- Using Advanced Formulas & Functions in Excel 2010/2013/2016
- Advanced Pivot Table Techniques in Excel 2010 or 2013 or 2013
- Advanced Power Charting Techniques
- Dashboard Macros
- Creating Dynamic Dashboards with Excel 2010 / Excel 2013 / Excel 2016 for Management Reporting
- Practical Dashboard Creation: Hands-on Dashboard Creation in the Workshop
To Register for Excel Pivots, Charts, Dashboards Masterclass, Simply Register Online, and reserve your seat today. Or send an online enquiry if you have any questions. You can call us at (65) 6296-2995 or email to firstname.lastname@example.org to register for the upcoming class of Dashboard Masterclass.
We also offer Corporate Trainings for this Advanced Excel Pivots, Charts & Dashboards Workshop, if you have a group of 10 or more people. We can arrange to conduct the Dashboards training at your office location.
Comments from Past Participants
It covered advanced techniques which I did not already know–Mark Stephens,
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.
There were lots of exercises to better understand the various concepts. I liked the hands on training –Nah, Asiawide Franchise