Skip to main content

Excel VBA MIS Training

EXCEL DASHBOARD & DATA ANALYSIS –  COURSE OUTLINE

 

  • Data summarization with Pivot Table Charts
  • Extranal Pivot Power Pivot
  • Logical formulas
  • Data Summarization with Formulas Database Information with formula
  • Macros VBA Macros Fundamenta
  • VBA Codes Concept Workbooks Calling Worksheet Sheet Calling Range Calling

LEARN IN DASHBOARD & REPORTING

DVANCED FORMULAS

Advanced Lookup Method

Data Summrication with Formulas

Array Formulas

Dynamic Chart for Dashboard

 

INDRODUCTION OF VBA FOR DASHBOARD

VBA Code Concept

Event Code Concept

Charts & Button use of Chart

 

DASHBOARD WITH EXCEL 2007-13 PIVOT

Data Summrization with Pivot

Calculation with Pivot Table

Extranal Pivot Table

VBA Pivot Report Automation

SAMPLE REPORTING ON EXCEL DASHBOARD

Learn More then 10 Sample Dashboard Creation