MIS & Advanced Excel

Are you aspiring to become an MIS Manager? Do you want to master of MIS and Advanced Excel , including Google Apps, Data Analysis, Reporting Management, VLOOKUP, Index + Match, Pivot Tables, Data Validation, Array Functions, and more?

Whether you’re learning these skills for the first time or need a quick refresher, this course is perfect for you! It’s the top MIS and Advanced Excel course equipping you with essential knowledge to provide critical business information to management for effective decision-making, playing a key role in the strategic planning of any company.

Course Contents

  • Vlookup
  • Hlookup
  • Scenario Manager
  • Pivot Table
  • Conditional Formatting
  • Sale Dashboard
  • Reporting Dashboard
  • Dashboard Planning
  • Chart & Slicers
  • Sale Tracker
  • Data Formatting
  • Data Base Management
  • Data Summorization
  • Introduction to Macro
  • Email Writing
  • Goal Seek Scenario
  • VBA Coding (Basic)
  • Data Driven Decision Making
  • Business Analystics
  • Various Matrix
  • Data Validation
  • Management Computing
  • Excel Worksheets & Workbooks
  • Logical Functions

Tools & Topics Covered

Reports

Business Analyst

Pivot Table

Dashboard

Pay Roll

Profit & Loss

 

Course Features:

  • Instant access to all videos and course content upon purchase
  • All videos are available in Hindi
  • 100+ in-depth video lessons
  • 150+ practice files for hands-on learning
  • Earn a Wipro DICE ID Certificate upon course completion
  • Videos can be downloaded exclusively via the app
  • No viewing restrictions – watch videos unlimited times.

 

Free Bonus (Worth ₹5000):

  • Microsoft Excel eBook (Available in both Hindi & English)
  • 1000+ Keyboard Shortcuts for MS Word, PowerPoint, Excel, Outlook, and more