How to Read This Book
Hello friends! I am Ravindra Bagale. This course is my Excel class, written down. I write the way I speak in class: technical words in English, with simple explanations, so that while reading you feel the trainer is sitting in front of you.
नमस्कार मित्रांनो! मी Ravindra Bagale. हा course म्हणजे माझा Excel class – फक्त लिहून ठेवलेला. Class मध्ये मी जसा बोलतो, तसंच इथे लिहिलंय: technical शब्द English मध्ये, आणि समजावणं सोप्या भाषेत, म्हणजे वाचताना "sir समोर बसलेत" असं वाटलं पाहिजे.
नमस्कार दोस्तों! मैं Ravindra Bagale. यह course मेरी Excel class है – बस लिखकर रखी हुई. Class में मैं जैसे बोलता हूँ, वैसे ही यहाँ लिखा है: technical शब्द English में, और समझाना आसान भाषा में, ताकि पढ़ते समय लगे कि "sir सामने बैठे हैं".
Ya book madhe kay kasa dila aahe, te aadhi samjun ghya:
- Technical content English madhech aahe. Ribbon paths (udaharanartha Data › Data Tools › Remove Duplicates), menu names, function names, formulas aani VBA code agdi jase Excel madhe distat tasech thevle aahet. Job madhe aani interview madhe tumhi hech shabd vaparnar aahat.
- Marathi arth (Devanagari madhe) fakt kathin shabdansathi. Jithe ekhada avghad kiwa abstract shabd pahilyanda yeto, tithe bracket madhe tyacha Marathi arth dila aahe – udaharanartha absolute reference (स्थिर संदर्भ), criteria (निकष), nested (एकात एक गुंफलेले). Filter, table, column, row, chart, sort, cell, sheet, formula, report, dashboard ase roj vaparle jaanare shabd English madhech vapra – tyanna arth dila nahi.
- Pratyek module chi suruvat aani shevat. Suruvatila chhoti olakh ("Chala mitrano, aaj aapan..."), aani shevti Thodkyaat sangaycha tar recap box. Exam chya aadhi fakt he recap boxes vachle tari revision hote.
- Pratyek section cha format same aahe: steps (ribbon path sobat), aaplya Blinkit data var worked example, ek jambhla (purple) Ravindra Bagale's Tip box – tya topic madhe khup students konti chuk kartat aani ti kashi talaychi – aani shevti chhota Practice task.
- Version labels. Kahi functions fakt navin Excel madhe aahet. Ase features Microsoft 365 / Excel 2021+ (kiwa jithe lagu aahe tithe Excel 2024 / Microsoft 365) ase mark kele aahet. Jithe ribbon cha layout version pramane badalto, tithe "may vary by version" lihila aahe. Ha book Microsoft 365 (Windows) var adharit aahe.
- Screenshots nahit. Muddam fake screenshots dile nahit. Tyachya aivaji tables aani simple diagrams aahet – te Excel madhe swatah karun bagha, tech khara shikna.
- Interview answers English madhe. Modules 17 aani 18 madhli model answers muddam clean professional English madhe aahet, karan interview English madhech hota.
- Glossary (Module 20) madhe pratyek term sobat Marathi arth column aahe. Standard English shabdansathi "— (English madhech vapra)" asa lihila aahe.
Conventions used in this book
| You see | Meaning |
|---|---|
| Home › Editing › Sort & Filter | Ribbon tab › group › command |
=SUMIFS(...) |
Type exactly this in a cell or the formula bar |
| Ctrl + Shift + L | Keyboard shortcut (Windows) |
| ₹1,25,000 | Indian comma style (lakh, crore) |
| 14-03-2026 | Dates in dd-mm-yyyy; times are IST |
| Microsoft 365 / Excel 2021+ | Feature not available in older versions such as Excel 2016/2019 |
Fictional data
Ya book madhla Blinkit aani Amazon Now cha sagla data (orders, stores, amounts, customers) fakt shikanyasathi banavlela fictional sample data aahe. To kontyahi company che khare aakde darshavat nahi. People names are also only for practice, and all e-mail addresses use the reserved example.com domain.
Chala tar mag, suru karuya! Ghabru naka – ek ek module, roj thoda practice, aani Excel nakki yeil.