Diploma Courses - Yash Skill Hub

Master Excel's most-used formulas in 60 minutes with AI & Chatgpt

The exact formulas used in offices, accounting and MIS reporting — taught practically, with real files, in one sitting.

~~₹1499~~

₹499

You save ₹1000 today

Offer ends in

Instant access · UPI, cards & netbanking · One-time payment

1,000+ students already enrolled

Why this course

Built for people who need Excel to work for their job today

Office-ready skills

Formulas pulled from real MIS, accounting and reporting work — not textbook examples.

Zero theory

Every concept taught by solving a real spreadsheet problem on screen, formula by formula.

Beginner friendly

No prior Excel experience needed — every formula is built up from first principles.

Learn AI In Excel

Understand the Use of Ai and chatgpt to automate your work in Excel

Real data practice

Work on the same sample datasets used in the videos — included free, yours to keep.

Certificate included

A completion certificate you can add directly to your resume or LinkedIn.

Curriculum

What you'll learn, lesson by lesson

Five short videos, 71 minutes total — each built around formulas you’ll use the same week.

1 IF, AND, Nested IF-ELSE

2 VLOOKUP, Nested VLOOKUP & IFERROR

3 COUNTIF, SUMIF & multi-criteria formulas

4 Text: UPPER, LOWER, PROPER, TRIM, LEFT, RIGHT, MID, LEN

5 Dates: DATEDIF, NETWORKDAYS, EDATE & more

6 How to use AI in Excel with Chatgpt

71 minutes total · self-paced

About us

One name behind every batch — Yash Skill Hub

East Delhi’s largest computer training center, now teaching students pan-India online.

Yash Skill Hub is an ISO Certified institute and an Authorized Tally Partner, running offline batches from our head office in Vishwas Nagar, Shahdara, Delhi — and online courses for students across India.

Every course follows the same standard we use in our in-person batches: practical training, placement support, and an internship certificate issued by a CA firm.

0 +

Students trained

0 %

Placement support

Included free

Four bonuses, no extra cost

Excel practice files

The exact datasets used in every lesson.

~~₹1,999~~

FREE

Top 50 shortcut keys PDF

Work noticeably faster without the mouse.

~~₹499~~

FREE

Formula cheat sheet PDF

One-page reference for every formula covered.

~~₹999~~

FREE

"How to Earn from Excel" e-book

Turn the skill into freelance or job income.

~~1,499~~

FREE

Total bonus value

₹4,996 → ₹0

Proof of completion

A certificate that holds up on a resume

Community

Learn beyond the course

Follow our creator community on Instagram, where our own students teach tips, shortcuts and behind-the-scenes from class.

Yash Skill Hub Creator Community

Short lessons, student wins and live Q&A — posted by the same students learning alongside you.

Student feedback

What students say

“I’d opened Excel for years but never understood VLOOKUP. After lesson 2 I used it the same day at work.”

Priya S.

MIS Executive

“Short and to the point. No filler — just the formulas I needed for my accounting job, explained properly.”

Rohit K.

Accountant

“Used the IF and COUNTIF lessons to rebuild a tracker for my shop in an afternoon. Worth far more than ₹199.”

Anita M.

Small business owner

Our Happy Learners

Not sure yet? Talk to us before you buy.

Call 8287775276 for free counselling — we'll help you decide if this course fits what you need.

After you buy

What happens right after payment

Get Course Access within 1 hr between 9 to 8pm working hours

Payment confirmed

You complete payment securely on the checkout page.

Confirmation email

Sent instantly to the email you entered at checkout, with a welcome link.

Your login ID & password

Included in the same email — this logs you into your course dashboard.

Start learning

Go to yashskillhub.com, log in, and your course is ready to watch.

FAQ

Before you buy

Is this course suitable for beginners?

Yes. No prior Excel knowledge is required — every formula is explained from first principles.

Will I get a certificate?

Yes, a downloadable certificate is issued once you finish all five lessons.

Can I watch on mobile?

Yes, the course works on any device — mobile, tablet or desktop.

Is access really lifetime?

Yes. No expiry — revisit any lesson whenever you need a refresher.

Are practice files included?

Yes, the exact spreadsheets used in the videos are included free.

Is this useful for job interviews?

Yes — VLOOKUP, IF and COUNTIF are among the most commonly tested formulas in Excel-based interview rounds.

Lock in ₹499 before it reverts to ₹1499

One-time payment. Lifetime access. Certificate & four bonuses included.