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 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.
SDF Funding is available to Singapore Companies (For company sponsored candidates). Call +65 6296-2995 for Details. SkillsFuture credits ready for Singaporeans.
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.
Logistics
This 2 Day Excel Pivots, Charts, Dashboards Masterclass will be held in Singapore.
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
- Percentage
- Computed Columns
- Grouping & Sorting
- Top Views
- Multiple data sources
- Pivot Charts & VIsual Dashboarding Techniques
4 Advanced Power Charting 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
Click here to Register for the 2 Day Excel Dashboard MasterClass
PRACTICAL * HANDS-ON * FULL OF EXAMPLES & CASE STUDIES * GREAT VALUE FOR MONEY
You should have knowledge of the basics of using Microsoft Excel 2016 / 2013 / 2010 and using simple functions and formulas.
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.
Logistics
This 2 Day Excel Pivots, Charts, Dashboards Masterclass will be held in Singapore.
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
- Percentage
- Computed Columns
- Grouping & Sorting
- Top Views
- Multiple data sources
- Pivot Charts & VIsual Dashboarding Techniques
4 Advanced Power Charting 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
Click here to Register for the 2 Day Excel Dashboard MasterClass
PRACTICAL * HANDS-ON * FULL OF EXAMPLES & CASE STUDIES * GREAT VALUE FOR MONEY
You should have knowledge of the basics of using Microsoft Excel 2016 / 2013 / 2010 and using simple functions and formulas.
Claim SDF & PIC Grant
Companies sponsoring their staff for training can claim from the Skills Development Fund.
Further, they can claim 40% of training fee or 400% Tax Rebate from IRAS With PIC scheme.
SkillsFuture Ready
Singaporeans can use $500 SkillsFuture Credits for this training to offset the course fees.
Contact us for advise on how to go about claiming your SkillsFuture.
Get Started Today!
Learn By Doing
You learn best when you Do It Yourself.
We teach you, step by step, how you can learn new skills, build your knowledge and enhance your career prospects quickly & easily, with Practical Tips & Tricks!
Do You Have a Question or Need a Quotation?
Simple. Just tell us what you need below. We’ll be glad to help you!
Some of the companies that experienced our trainings
How To Register
Register for the 2 Days of Dashboard training today by simply clicking on the chosen course date available at the top of this page.
Need Help?
- Call us at +65 6296-2995, SMS / WhatsApp: +65 9066 – 9991
- Send an email to training@intellisoft.com.sg OR
- Submit an online enquiry if you have any questions regarding Dashboard Masterclass training.
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.