Sohan Singh Smriti Kaushal Vikas Kendra

Laghu Udyog Bharati

Course Catalog

Advanced Excel MIS Reporting

Master Data Analysis & Management Information System Reporting

About Course

This course contains a practical understanding of Microsoft EXCEL software. We designed it as per industry requirement on data analysis. It also helps in analyzing data, and presenting it to management for better understanding of business.

Learn to transform raw data into meaningful insights through advanced Excel features, dynamic dashboards, and automated reporting systems.

Advanced Formulas

Pivot Tables

Data Visualization

VBA Macros

Dynamic Dashboards

Data Analysis

⏱️

Duration

60 Hours of Practical Training

📊

Key Deliverables

Dynamic Dashboards & Reports

💼

Career Outcome

MIS Analyst / Data Analyst

🎯

Industry Focus

Business Analytics & Reporting

Excel MIS Reporting Course

Comprehensive Training Program with 16 Modules

Module 1: Introduction to Excel Environment

Module 02 : Explanation about data calculation in Excel

▼

Module 3 : Use of Shortcuts

Module 4 : Formatting and Conditional Formatting

Module 5 : Working with Formulas - Logical and Text Functions

Module 6 :Understanding about Sorting, Filtering and Data Validation

Module 7 :Data Analysis using Pivot Tables

Module 8 :INTRODUCTION TO CHARTS AND FUNCTIONS

Understaing of Mathematical, Statistical Functions
Worksheet and Workbook Protection and Security
Understanding of Name Ranges

1 Section Estimated time: 1 hour

Module 9 :Introduction of Charts

Module 10 :Introduction of Form Controls

Module 11 :Understanding of Data Tools Panel

Module 12 :Basics of Macro Recording

Module 13 :DASHBOARD DESIGNING

Module 14 :Overview of Dashboards

Module 15 :Deciding on Dahsboards

Module 16 :Trends and Scenarios usng charts

Batch Starting

December 2024

Mon-Fri, 9:00 AM - 5:00 PM

Book Your Seat Now

₹ 1100 /course

The Laghu Udyog Bharati Skill Development Centre is a multi-skilling centers. These Centre's have state of the art labs with spacious classrooms. Equipped with modern amenities, these centres are the destination of our innovation activities. New courses, processes, capabilities are piloted in these centres.

Get In Touch

Near Bombay Hospital, 200, Feet Mahal Road, Sitapura Industrial Area, Sitapura, Jaipur, Shri Kishanpura, Rajasthan 302022

+91-9829068865

+91-7425865190

info@skillhub.com

rajasthan.lubindia@gmail.com

Our Courses

Apparel & Fashion Account & Finance Digital Skill Artificial Intelligence Entrepreneurship Development Center Handicraft