Advanced Excel Course by Rashi Sharma

The Advanced Excel Course by Rashi Sharma is designed for students, professionals, and data enthusiasts who want to master Microsoft Excel, data analysis, and MIS reporting. This course focuses on advanced formulas, data management, pivot tables, dashboards, and automation, giving learners the practical skills needed to handle real-world data efficiently.

The course is fully online, combining theory, hands-on exercises, and practical projects to ensure students gain confidence in managing, analyzing, and reporting data effectively.

What Students Will Learn

Module 1: Excel Revision & Fundamentals (4 Hours)

• Excel Interface & Shortcuts

• Data Formatting

• Basic Formulas Revision (SUM, AVERAGE, COUNT)

• Relative & Absolute Cell Reference

Module 2: Advanced Formulas & Functions (12 Hours)

• IF, Nested IF

• VLOOKUP & HLOOKUP

• XLOOKUP (Latest Version)

• INDEX & MATCH

• COUNTIF, SUMIF, AVERAGEIF

• TEXT Functions (LEFT, RIGHT, MID, LEN)

• DATE & TIME Functions

• Logical Functions

🎯 Practical: Salary Sheet & Marksheet Automation

Module 3: Data Management Tools (8 Hours)

• Data Validation

• Conditional Formatting

• Remove Duplicates

• Text to Columns

• Sorting & Filtering (Advanced Filter)

Module 4: Pivot Table & Data Analysis (8 Hours)

• Creating Pivot Tables

• Pivot Charts

• Slicers

• Grouping Data

• Dashboard Creation

🎯 Practical: Sales Report Dashboard

Module 5: MIS Reporting (6 Hours)

• Monthly Report Format

• Data Cleaning Techniques

• Chart Creation

• Dynamic Reports

Module 6: Excel Automation & Protection (4 Hours)

• Protect Sheet / Workbook

• Basic Macros Introduction

• Recording Macro

• Print Setup & Page Layout

Teaching Method

This online course is hands-on and project-based, with live guidance from the tutor:

• Step-by-step demonstrations of Excel features

• Real-world exercises and practical projects

• Interactive problem-solving and doubt-clearing sessions

• Focus on professional data handling and reporting skills

Why This Tutor

Rashi Sharma specializes in Excel training for professional and academic applications. She emphasizes practical learning, clarity, and project-based teaching, ensuring students are ready to create dashboards, analyze data, and prepare MIS reports confidently.

Course Outcomes:

After completing this course, students will be able to:
✔ Create professional MIS reports
✔ Handle large data efficiently
✔ Prepare dashboards
✔ Use advanced formulas confidently