AISkillWalaWhat you will be able to doTum kya kar paoge
You will handle everyday office data in Excel on your own: clean data entry, formulas, VLOOKUP/XLOOKUP, pivot tables, charts and a clear monthly MIS report.Office ka roz ka data Excel mein khud sambhal paoge: data entry, formulas, VLOOKUP/XLOOKUP, pivot table, chart aur ek saaf MIS report.
Final projectFinal project
Turn one month of a shop's sales sheet into a full MIS report: total sales, top products, a day-wise chart and a one-page summary you can show in an interview.Ek dukaan ki ek mahine ki sales sheet se poori MIS report banao: total sale, top products, din-wise chart aur ek summary page, jo interview mein dikha sako.
Course curriculumCourse mein kya hai
Every lesson has steps, an example, common mistakes, a practice task, a short quiz and a cheat sheet.Har lesson mein steps, example, aam galtiyan, practice task, chhota quiz aur cheat sheet.
Module 1: Getting comfortable with ExcelModule 1: Excel se dosti
- What Excel is and where to get it freeExcel kya hai aur free mein kahan milega · 15 minFreeFree
- Rows, columns, cells and clean data entryRows, columns, cells aur sahi data entry · 20 min
- Formatting: make your sheet look professionalFormatting: sheet ko professional banana · 20 min
Module 2: Formulas every office usesModule 2: Formulas jo har office mein chalte hain
- First formulas: SUM, AVERAGE, MIN, MAX, COUNTPehle formulas: SUM, AVERAGE, MIN, MAX, COUNT · 25 min
- Relative and absolute references (the $ sign)Relative aur absolute reference ($ ka jaadu) · 20 min
- IF, COUNTIF, SUMIF: formulas with conditionsIF, COUNTIF, SUMIF: shart wale formulas · 30 min
Module 3: Finding and cleaning dataModule 3: Data dhundhna aur saaf karna
- Sort, Filter and Freeze PanesSort, Filter aur Freeze Panes · 20 min
- VLOOKUP and XLOOKUPVLOOKUP aur XLOOKUP · 30 min
- Cleaning data: TRIM, PROPER, removing duplicatesData saaf karna: TRIM, PROPER, duplicates hatana · 25 min
Module 4: Building reportsModule 4: Report banana
- Pivot tables: a summary in one minutePivot Table: ek minute mein summary · 30 min
- Charts your manager understands at a glanceCharts jo boss ko turant samajh aayein · 20 min
- Final project: build an MIS reportFinal project: MIS report banao · 35 min
This course comes with the full AI kitIs course ke saath poori AI kit
- All 34 courses, in Hinglish and EnglishSaare 34 courses, Hinglish aur English mein
- Your personal plan: tools and prompts picked for your field and goalTumhara personal plan: field aur goal ke hisaab se tools aur prompts
- AI tutor, practice lab and mentor while you learnSeekhte waqt AI tutor, practice lab aur mentor
- 30-day challenge and verifiable certificates30-day challenge aur verify hone wale certificates
- No subscription. Try the first lesson free before you pay.Koi subscription nahi. Pay se pehle pehla lesson free try karo.
₹1999 ₹199 one-time · 90% off₹1999 ₹199 ek baar · 90% off
Questions about this courseIs course ke baare mein sawaal
Is the Excel for office jobs course free?Kya Office jobs ke liye Excel course free hai?
The first lesson is free after a short test (just your mobile number). The full course opens with the AI kit: a one-time ₹199 that opens all 34 courses. No subscription.Chhota test dene ke baad pehla lesson free hai (sirf mobile number chahiye). Poora course AI kit se khulta hai: ek baar ke ₹199 mein saare 34 courses. Koi subscription nahi.
Which language is it in?Kis bhasha mein hai?
Hinglish and English. Switch any time; every lesson exists in both.Hinglish aur English dono mein. Kabhi bhi badlo; har lesson dono mein hai.
How long does it take?Kitna time lagega?
12 lessons of 20-30 minutes, about 12 hours in all. One lesson a day finishes it in about 12 days.12 lessons, har ek 20-30 minute ka, kul lagbhag 12 ghante. Roz ek lesson karo toh lagbhag 12 din mein poora.
Do I get a certificate?Certificate milega?
Yes. Finish every lesson and you get a certificate with your name and a public verify link you can add to LinkedIn. It is not a government or university degree.Haan. Saare lessons poore karo, tumhare naam ka certificate milega jiska public verify link LinkedIn pe laga sakte ho. Ye sarkari ya university degree nahi hai.
Is a job or income guaranteed?Job ya kamai ki guarantee hai?
No. The course teaches the skill and makes you practise; results depend on your effort and the market.Nahi. Course skill sikhata hai aur practice karwata hai; nateeja tumhari mehnat aur market pe depend karta hai.
Related coursesIsse jude courses
Excel, SQL and dashboards to answer business questionsExcel, SQL aur dashboards se business ke sawaalon ke jawab
12 lessons · ~30 hoursghante →Build websites with codeCode se website bananaHTML, CSS and JavaScript from zero to a live siteHTML, CSS aur JavaScript, zero se live website tak
12 lessons · ~40 hoursghante →Digital marketingDigital marketingAds, SEO and social media that bring customersAds, SEO aur social media jo customers laaye
12 lessons · ~20 hoursghante →SEO: rank on GoogleSEO: Google pe rank karoKeywords, on-page, Search Console and local SEO that bring customers from GoogleKeywords, on-page, Search Console aur local SEO jo Google se customers laaye
12 lessons · ~12 hoursghante →Start with the free lessonFree lesson se shuru karo
Take the 5-minute test, then open the first lesson free. Your personal AI kit comes with it.5 minute ka test do, phir pehla lesson free kholo. Saath mein tumhari personal AI kit.