Learn Advanced Excel, VBA Macros or MS Access

Buy DVD and Learn Self

Excel Dashboard Report Automation with Excel or VBA

If you kwon Excel and VBA well then you shuld be Learn Dashboard Report Automation. In this Course Cover Dynamic Chart, and 25 Powerfull Dashboard Sample and Automation using Powerfull Excel Formulas and Fantastic Excel Chart and Amazing VBA Event Code

Buy DVD Now


     1. Dashboard with Pivot Table

         Data summarization with Pivot Table Charts

        Extranal Pivot

        Power Pivot

        SQL in Pivot Table

         Pivot Table whith 2 Data Sheet

        Dashboard with Slicer

        Dashboard with Data Table

     2. Formulas for Dashboard

        Logical Formulas

        Data Summerization Formulas

        Array Formulas

        Dashboard Formulas Triks

     3. Dashboard Report Automation

        Chart Creation

        Chart Triks

         use Button on chart

         Dynamic Chart with Offset Formulas

         Dashboard Example

         Live Project

     4. VBA Macros Method for Dashboard

        Macros Creation

        Function Creationn

         UserForm Methos

         Event Handling

         Format Handling with VBA

         File & Folder Handling with VBA for Dashboard

     5. Formatting for Dashboard Automation

        Freming for Dashboard Formate

         Color Triks for Dashboard

         Image and Object

         Picture Linking For Dashboard

         Border and Outline

         Live Project

     6. Dashboard Example

        Manufacturing Dashboard

        Human Resource Dashboard

         Financial Dashboard

         Performance Dashboard Customer Care Center

         Dashboard - Sales Performance

         Sales Analysis-region-product-wise

         Geographical Sales Report

         Project Status Report

         Team Performance Dashboard

         5 Dashboard as per Your Requirement

     Course Duration & Fees

         Around 15 Hours Video

         Live Online Class Video

         Fees : - 2500/-

Buy DVD Now

Sample Videos

Advanced Excel & MIS Training Institute

Part of IPT (Institute of Professional of Training)
This is Group of Working Professianal Do Frelance with Us you can join our Class from your Computer using Gotomeeting

Operational Office : - Dakshinpuri, New Delhi - 110062
E-Mail - Kumar@iptindia.com, sujeetkumar.ipt@gmail.com, Skype ID - AdvExcel1

Mobile - +91 8802579388, +91 8826828093, +91 9968811487


Live Online Class