Girijashankar Ray

I am a seasoned MIS Professional with 7+ years of hands-on industry experience in Advanced Excel, Google Sheets, Google Looker Studio, AppScript, AppSheet, Automation, Data Analysis, and Interactive Dashboard Reporting. I have worked across Manufacturing, Logistics, IT, and BPO/KPO sectors, where I have created automated reporting systems, performance dashboards, KPI trackers, and powerful business intelligence tools used by management teams.

I specialize in teaching Advanced Excel & Google Sheets with a practical, job-oriented approach. My training focuses on real-world scenarios, corporate reporting standards, complex formulas, data cleaning techniques, dashboards, automation, and best practices used by companies. I also guide learners in mastering Google Workspace tools like Google Forms, Drives, and automation workflows.

With strong domain expertise, step-by-step guidance, and hands-on practice files, I help students and working professionals become job-ready and confident in MS Excel, Google Sheets, and modern data tools.
If you want to master Excel/Sheets for career growth—connect with me and I will personally guide and train you.
Thank You!

📘 Detailed Course Description (Job-Ready Program)

This course is designed for students, job seekers, working professionals, and freelancers who want to master Advanced Excel and Google Sheets for real corporate use.
You will learn everything from the basics to the most advanced tools, techniques, and automation workflows used in MIS Reporting, Data Analysis, and Business Intelligence.

The program includes:

Step-by-step lessons with practice files

Live explanations + real company case studies

Dashboard building from scratch

Real-time doubt solving

Assignment-based learning

Interview preparation for MIS/Data roles

Hands-on automation using formulas, AppScript & AI-based tools

How to build professional reports & trackers like companies use

By the end of the course, you will be able to independently manage MIS work, build dashboards, automate sheets, create trackers, and deliver insights like a professional analyst.

📚 Skills & Syllabus (Detailed Breakdown)
1️⃣ MS Excel – Beginner to Advanced
✔ Basic to Intermediate

Excel Interface & Shortcuts

Data Entry & Cleaning

Formatting & Conditional Formatting

Data Validation

Filters, Sorting, Flash Fill

✔ Formulas & Functions (Deep Training)

Lookup Functions (VLOOKUP, HLOOKUP, XLOOKUP)

Logical Functions (IF, AND, OR, IFS)

Text Functions (LEFT, RIGHT, MID, TRIM, TEXTSPLIT)

Date & Time Functions

Math & Statistical Functions

Error Handling & Nested Formulas

✔ Data Analysis & Reporting

Pivot Tables & Pivot Charts

Slicers & Dynamic Filtering

KPI Reports

MIS Reports

Business Dashboards

✔ Excel Automation

Advanced Formulas

Power Query Basics

Data Cleaning Automation

Business Intelligence View

Dashboards from scratch

2️⃣ Google Sheets – Beginner to Advanced
✔ Core Concepts

Interface, Collaboration Tools

Google Drive & Workspace Integration

Formulas & Functions

✔ Advance Functions

QUERY Function (Full Mastery)

IMPORTRANGE, IMPORTXML, IMPORTDATA

ARRAYFORMULA

REGEX Functions

FILTER, UNIQUE, SORT

VLOOKUP, XLOOKUP Alternatives

✔ Automation & Workflows

Connected Sheets

AppScript Basics (Automation Scripts)

Automated Email Alerts

Automated Report Generation

Connecting Google Forms → Sheets → Dashboard

✔ Data Visualization

Dynamic Charts

KPI Dashboards

Real-time dashboards for management

3️⃣ Google Looker Studio

Data Sources

Blending Data

Filters & Controls

KPI Cards

Interactive Dashboards

Publishing & Sharing Reports

4️⃣ Google AppSheet (Optional Module)

No-code app creation

Creating forms & views

Data automation

Deployment basics

5️⃣ Interview + Career Support

MIS/Data Analyst interview preparation

Resume improvement

Corporate reporting standards

Practical case studies