Rajasthan Royal Institute Computer Lab
office

Advanced Excel

Learn Microsoft Excel from beginner to advanced level including formulas, dashboards, Pivot Tables, Power Query concepts, Data Analysis, MIS Reporting, automation techniques and industry-level projects

Duration6 Months (2 Hours Daily)

Course Overview

Learn Microsoft Excel from beginner to advanced level including formulas, dashboards, Pivot Tables, Power Query concepts, Data Analysis, MIS Reporting, automation techniques and industry-level projects. Students will gain practical skills required for office jobs, MIS Executive roles, Data Analyst careers and reporting automation.

This course is specially designed with a core focus on practical hands-on coaching at Rajasthan Royal Institute, Lalsot. Students perform lab sessions on dedicated computer workstations to build industry-ready skills.

Tools & Technologies Covered

MS ExcelPower QueryPower Pivot

Syllabus Highlights

Excel Basics

Excel Introduction
Data Entry
Basic Formulas
Conditional Formatting
Advanced Conditional Formatting
IF Formula
Data Formatting
Sheet Options
Practice Assignment

Data Handling

Sorting
Filtering
Advanced Filter
Paste Special
Go To Special
Find & Replace
Practical Assignment

Data Transformation

Flash Fill
Text to Columns
Remove Duplicates
Consolidate
Data Validation
What-if Analysis
Scenario Manager
Goal Seek
Group & Ungroup
Subtotal
Practical Assignment

Pivot Table Mastery

Pivot Table
Pivot Chart
Slicer
Timeline
Top Bottom Analysis
Pivot Analyze Options
Calculated Field
Dynamic Range
Auto Refresh
Multiple Pivot Tables
Show Values As
Recommended Pivot
Pivot Assignment
Power Pivot

Lookup Formulas

VLOOKUP
Large Data Lookup
VLOOKUP + MATCH
Approximate Match
Double VLOOKUP
INDEX + MATCH
XLOOKUP
Practical Assignment

Advanced Formulas

COUNT
COUNTA
COUNTIF
SUMIF
SUMIFS
AVERAGEIF
MAXIFS
MINIFS
SORT
FILTER
TAKE
TEXT Functions
DATE Functions
Financial Functions

Projects

Industry Level Dashboard
MIS Dashboard
Sales Dashboard
HR Dashboard
Financial Dashboard
Interactive Reports

Interview Preparation

Excel Interview Questions
Practical Assessment
Mock Interview
Resume Guidance

Real Business Projects Included

Admission Open

Join the upcoming batch in Lalsot

Duration6 Months (2 Hours Daily)
Eligibility10th Pass or Above, Basic Computer Knowledge
Course Fee₹6,000
CertificationRajasthan Royal Institute
LanguageHindi + English
Faculty SupportKailash Yadav & Team
Enroll NowEnquire on WhatsApp

Career Opportunities

  • Data Analyst
  • MIS Executive
  • Reporting Executive
  • Office Administrator
  • Excel Automator

Certification Details

Students will receive a premium certification from Rajasthan Royal Institute after successful completion.