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 Practice Files
- Lifetime Access
- New update
Access on Mobile Computer
Course Features
- Lectures 22
- Quiz 1
- Duration 07+ Hours
- Skill level All levels
- Language Hindi
- Students 778
- Certificate Yes
- Assessments Self
Curriculum
- 1 Section
- 22 Lessons
- Lifetime
Expand all sectionsCollapse all sections
- Excel MIS Beginners to Advanced23
- 1.0Excel Shortcuts PDF & Practice File for Download
- 1.11 MIS – Pivot Table & Chart20 Minutes
- 1.22 MIS – Slicer & Settings42 Minutes
- 1.33 MIS – Slicer & Pivot Table Tips11 Minutes
- 1.44 MIS – Search Box in Slicer Function9 Minutes
- 1.55 MIS – Create Pivot Table from Multiple Sheets9 Minutes
- 1.66 MIS – Conditional formatting for Dashboard32 Minutes
- 1.77 MIS – Transfer Data from Master Sheet to Multi Sheets42 Minutes
- 1.88 MIS – Sparklines27 Minutes
- 1.99 MIS – Dynamic Target Line28 Minutes
- 1.1010 MIS – Info-Graphics Male Female Chart33 Minutes
- 1.1111 MIS – Gantt Chart in Excel13 Minutes
- 1.1212 MIS – Comparison Chart of a Company (Line Chart)40 Minutes
- 1.1313 MIS – Save All Charts As Image2 Minutes
- 1.1414 MIS – Thermometer Chart11 Minutes
- 1.1515 MIS – Trends Arrow in Chart for Dashboard10 Minutes
- 1.1616 MIS – Important Tips for XL Chart13 Minutes
- 1.1717 MIS – Progress Circle Chart (Doughnut Chart)26 Minutes
- 1.1818 MIS – Dynamic MIS Report27 Minutes
- 1.1919 MIS – Dynamic MIS Report & Dashboard46 Minutes
- 1.20Excel MIS Final Quiz15 Minutes10 Questions
- 1.21How to Use ChatGPT for Excel Work
- 1.22How to Use ChatGPT for Excel Work 10230 Minutes
2 Comments
I wanted to do this course
Hi sir My name is Aquib Ali from Mumbai Maharashtra