1. Home
  2. Course
  3. Excel Dashboards MasterClass

Excel Dashboards MasterClass

  

About this Course

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/2013. 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.

Course Outline

1. Understanding Management Dashboards

  • What is a Dashboard?
  • Principles of Great Dashboard Design

2. Using Advanced Formulas & Functions in Excel 2010/2013

  • Referencing & Ranges
  • Advanced Lookup
  • Advanced Formatting

3.  Advanced Pivot Table Techniques in Excel 2010

  • 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

5.  Dashboard Macros

  • Simple & Complex Macros
  • Dynamic Dashboards using Macros

6,  Creating Dynamic Dashboards with Excel 2010 / Excel 2013 for Management Reporting

  • Complete Management Dashboard for Sales & Services
  • Best Practices in Dashboard Design

Target Audience

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.

Pre-Requisites

You should have knowledge of the basics of using Microsoft Excel 2010/2013 and using simple functions and formulas.

*This course is not suitable for Absolute Beginners in Microsoft Excel. 

Apple Mac is not supported for this training.

You should bring your Windows laptop with Excel pre-loaded, to use in the Microsoft Excel master class. you can use Excel 2010 or Excel 2013.

Logistics

This 2 Day Excel Pivots, Charts, Dashboards Masterclass will be held at a Central hotel in Singapore. 

Tea/Coffee,  Light Snacks and Lunch are provided in this training.

Rate this course:

Comments

Course Rating

  • /5 from users

Course Enquiry

Course Info

Similar Courses Provided By Other Premium Providers

  • ICDL Module 5: ES WSQ - Perform Advanced Database Functions (Microsoft Access 2010) Fast Track

    Information and Communications  

    This course provides the basis for the practice-based test for ICDL Module 5 Perform Advanced Database Functions exam.The exam requires the candidate to operate effectively at more than a basic level of competence and be able to realize much of the potential of the database application. The candidate shall be able to use the database to organize, extract, view and report on data using what are dee...


    Provider:

  • ICDL Module 5: ES WSQ - Perform Advance Database Functions (Microsoft Access 2013 Fast Track)

    Information and Communications  

    This course provides the basis for the practice-based test for ICDL Module 5 Perform Advanced Database Functions exam.This course enables the participant to operate effectively at more than a basic level of competence and be able to realize much of the potential of the database application. The participant shall be able to use the database to organize, extract, view and report on data using what a...


    Provider:

  • Mobile App Creation for End User

    Information and Communications  

    No programming skills required. Come and join us in this one day workshop and learn how you can create a cross platform mobile application in just ONE day.COURSE OUTLINEModule 1.Introduction To The Mobile App IndustryModule 2.Different Kinds of App Marketing ModelsModule 3.Researching & planning your first appModule 4.Publishing Apps Golden RulesModule 5.How to get Images for your appsModule ...


    Provider:

  • Cross-platform Mobile Applications Development

    Information and Communications  

    HTML5 provides developers with tools such as Offline Web Storage, GeoLocation API, Canvas Drawing, CSS3, and many more. HTML5 applications run on Firefox OS, Tizen, Ubuntu Touch, and WebOS without a browser.COURSE OUTLINEModule 1. Mobile Applications OverviewModule 2. Apache Cordova (PhoneGap)Module 3. Cordova apps with EclipseModule 4. jQuery FundamentalsModule 5. jQuery MobileModule 6. Working w...


    Provider:

  • MCSD Web Applications

    Information and Communications  

    Today's customers need high-quality, interactive line-of-business and consumer web solutions. Get recognized for your expertise in creating and deploying modern web applications and services by earning the Microsoft Certified Solutions Developer (MCSD): Web Applications certification. COURSE OUTLINEProgramming in HTML5 with JavaScript and CSS3Developing ASP.NET 4.5 MVC Web ApplicationsDeveloping ...


    Provider: