Excel MIS & Dashboard (Basic to Advanced)



What you’ll learn

  • How to approach an Excel dashboard project from idea to delivery
  • Learn Pivot Table, Slicer and Timeline in full depth
  • How to add interactivity to your Excel reports
  • Impress management with reports that make the decision-making process faster
  • Clever use of Excel core functionality for responsive spreadsheets
  • Learn how to create a professional KPI dashboard from scratch
  • Create impressive, non-standard Excel charts using smart techniques
  • Build Pivot Table-based dashboards for easy interactivity
  • Use powerful visual techniques so your content has more effect
  • Make fully automatic Dynamic MIS Report and Dashboard

This course includes:

  • 7+ Hours Course Duration
  • Course Completion Certificate
  • Downloadable Video
  • Practice Files
  • Lifetime Access
  • New update
  • Access on Mobile TV Computer


Table of Content

Beginners to Advanced

Chapter – 01                  Introduction

Chapter – 02                  Pivot Table & Chart                            

Chapter – 03                  Slicer & Settings                                  

Chapter – 04                  Slicer & Pivot Table Tips                               

Chapter – 05                  Search Box in Slicer Function                      

Chapter – 06                  Create Pivot Table from Multiple Excel Sheets                          

Chapter – 07                  Conditional formatting for Dashboard                             

Chapter – 08                  Transfer Data from Master Sheet to Multi Sheets         

Chapter – 09                  Sparklines         

Chapter – 10                  Dynamic Target Line              

Chapter – 11                  Info-Graphics Male Female Chart              

Chapter – 12                  Gantt Chart in Excel                                       

Chapter – 13                  Comparison Chart of a Company (Line Chart)                

Chapter – 14                  Save All Charts as Image within 1 second            

Chapter – 15                  Thermometer Chart                           

Chapter – 16                  Trends Arrow in Chart for Dashboard                  

Chapter – 17                  Important Tips for XL Chart             

Chapter – 18                  Progress Circle Chart  (Doughnut Chart)                          

Chapter – 19                  Dynamic MIS Report                                     

Chapter – 20                  Dynamic MIS Report & Dashboard                  


Most Important :

Course Language – Hindi

Course Validity – Lifetime

Course Duration – 7+ Hours

File Size for All Videos & Practice File – 3 GB

Access – TV Mobile Computer

Delivery Method – Online

Video Quality – Full HD

Refund – Money not refunded to you if you purchase this course

*Certificate – We will conduct Online Exam, if you qualify in the exam than course completion certificate will be provided

Excel MIS & Dashboard (Basic to Advanced)


There are no reviews yet.

Be the first to review “Excel MIS & Dashboard (Basic to Advanced)”

Your email address will not be published. Required fields are marked *

Scroll to top