Advanced Excel and Management Information System

  • Home
  • Advanced Excel and Management Information System
Advanced Excel + MIS

Advanced Excel and Management Information System

Master advanced Excel formulas, data analysis, dashboards, and MIS reporting.

Trainer: Monu Sharma
Experience: 5+ Years
Description

The Advanced Excel + MIS Course is designed to help students learn advanced data management and reporting skills used in offices and businesses. In this course, students gain practical knowledge of advanced Excel formulas, data analysis tools, dashboards, and MIS reporting techniques required for professional work.

What You Will Learn
  • Module 1 : Introduction to Advanced Excel
  • Module 2 : Excel Formulas
  • Module 3 : Advanced Functions
  • Module 4 : Data Management Tools
  • Module 5 : Pivot Table & Pivot Chart
  • Module 6 : Charts and Data Visualization
  • Module 7 : MIS Reporting
  • Module 8 : Dashboard Creation & Project

Introduction to Advanced Excel
Workbook and Worksheet Management
Data Entry and Formatting

Basic Formulas
Logical Functions (IF, AND, OR)
Text Functions

VLOOKUP and HLOOKUP
COUNT, SUM, AVERAGE Functions
Nested Functions

Sorting and Filtering
Conditional Formatting
Data Validation

Creating Pivot Tables
Pivot Chart
Data Analysis using Pivot

Creating Charts and Graphs
Formatting Charts
Data Visualization Techniques

Introduction to MIS Reports
Creating MIS Reports in Excel
Data Analysis for Reporting

Creating Interactive Dashboards
Data Summary Reports
Practical Project Work
Free Demo Class Available
Book Free Demo Book Free Demo
  • Instructor: Monu Sharma
  • Lectures : 24 Lectures
  • Duration: 2 Months
  • Language: Hindi
Course Includes
  • Practical Lab Training
  • Live Projects
  • Study Material
  • Certificate Of Completion
  • Free Demo Class
  • Placement Assistance

Ready to Start Your Computer Training ?

Join Pragya Computer Academy today and learn practical computer skills with expert guidance and certification.

Book Demo Class Book Demo Class
Join Class!