- Видео 15
- Просмотров 4 592
Excel Shala
Объединенные Арабские Эмираты
Добавлен 6 мар 2021
Welcome to the "Excel Shala" channel - a place where you can learn Excel in Hindi.
I am Sumit Bansal (11x Microsoft MVP) and I share practical Excel tricks and tips on this channel. If you like what you get here, do subscribe and share with others.
The videos on this channel are in Hindi (Hinglish) and are meant for Excel beginners as well as advanced users.
Let's learn and Excel together!
I am Sumit Bansal (11x Microsoft MVP) and I share practical Excel tricks and tips on this channel. If you like what you get here, do subscribe and share with others.
The videos on this channel are in Hindi (Hinglish) and are meant for Excel beginners as well as advanced users.
Let's learn and Excel together!
Write Text Vertically in Excel (Hindi) | Excel में Text को Vertically कैसे लिखें
In this video, I will show you how to write text vertically in Excel using the options available in the ribbon and in the Format Cells dialog box. I will show you how to write text vertically in excel in both directions top to bottom or bottom to top
इस वीडियो में, मैं आपको दिखाऊंगा कि ribbon और Format Cells डायलॉग बॉक्स में उपलब्ध विकल्पों का उपयोग करके एक्सेल में टेक्स्ट को vertically कैसे लिखा जाता है।
Subscribe to get awesome Excel Tips every week: www.youtube.com/@excel-shala?sub_confirmation=1
#exceltips #excelhindi #excelhinditips
इस वीडियो में, मैं आपको दिखाऊंगा कि ribbon और Format Cells डायलॉग बॉक्स में उपलब्ध विकल्पों का उपयोग करके एक्सेल में टेक्स्ट को vertically कैसे लिखा जाता है।
Subscribe to get awesome Excel Tips every week: www.youtube.com/@excel-shala?sub_confirmation=1
#exceltips #excelhindi #excelhinditips
Просмотров: 70
Видео
Show Negative Numbers in Red in Excel (Hindi) | Negative Numbers को Red में कैसे दिखाएँ
Просмотров 18428 дней назад
In this video, I will show you two ways to display negative numbers in red in Excel: conditional formatting and cell custom formatting. इस वीडियो में, मैं आपको Excel में Negative Values को लाल रंग में दिखाने के दो तरीके दिखाऊंगा - Conditional Formatting और Cell Custom Formatting Subscribe to get awesome Excel Tips every week: www.youtube.com/@excel-shala?sub_confirmation=1 #exceltips #excelhind...
Get Sheet Name in a Cell in Excel (Hindi) | Cell में Sheet का नाम कैसे ले कर आयें
Просмотров 14528 дней назад
In this video, I will show you how to use a simple formula to get the sheet name in a cell and make it dynamic so that whenever the sheet name changes the cell automatically updates to show the updated sheet name इस वीडियो में, मैं आपको दिखाऊंगा कि सेल में शीट का नाम प्राप्त करने और इसे गतिशील बनाने के लिए एक सरल सूत्र का उपयोग कैसे करें ताकि जब भी शीट का नाम बदले तो सेल स्वचालित रूप से अद्यतन ...
Excel में Cell को Diagonally कैसे Split करें | Split Cell Diagonally (Hindi)
Просмотров 435Месяц назад
In this video, I'll show you how to split a cell diagonally in Excel using a simple border trick. इस वीडियो में, मैं आपको दिखाऊंगा कि एक सरल बॉर्डर ट्रिक का उपयोग करके एक्सेल में सेल को तिरछे कैसे विभाजित किया जाए। Subscribe to get awesome Excel Tips every week: www.youtube.com/@excel-shala?sub_confirmation=1 #exceltips #excelhindi #excelhinditips
Excel में Blank Rows कैसे हटाएँ | Delete Blank Rows in Excel Hindi
Просмотров 166Месяц назад
In this video, I will show you four easy ways to delete blank rows in Excel. The methods include: Using Go To Special trick Using SORT trick Using Find and Replace trick Using VBA 👉 Download File - www.dropbox.com/scl/fi/8wy7be2abq7aqv3dj5kzm/Delete-Blank-Rows-ExcelShala.xlsx?rlkey=e9y22h8m19cq0yf2ntn7f3p7p&dl=1 👇 Below is the VBA code used in this video: Sub DeleteBlankRows() Dim EntireRow As ...
Excel में Left से Right SORT कैसे करें | SORT Left to Right in Excel in Hindi
Просмотров 121Месяц назад
In this video, I'll show you how to use an inbuilt option in Excel to sort your data from left to right. I'd also show how you can do a multi level sorting from left to right and Excel इस वीडियो में, मैं आपको बताऊंगा कि Excel में data को बाएं से दाएं कैसे sort करें। मैं यह भी दिखाऊंगा कि आप Excel में बाएं से दाएं multi-level sorting कैसे कर सकते हैं। Subscribe to get awesome Excel Tips every we...
Excel में Dependent Drop-Down List कैसे बनाएं | Dependent Drop Down List in Excel in Hindi
Просмотров 424Месяц назад
In this video, I will show you how to make a dependent drop-down list using simple Excel formulas. I will cover how to make a two-level and a three-level dependent drop-down list in Excel 👉 Download File - www.dropbox.com/scl/fi/18o9c52fwlhjuqlyq9y37/Dependent-Drop-Down-in-Excel.xlsx?rlkey=e110npynn6ua1v6sjsk63iucd&dl=1 इस वीडियो में, मैं आपको सरल एक्सेल फॉर्मूला का उपयोग करके एक Dependent Drop...
Excel में Multi-Level Sorting कैसे करें | Multi-Level Sorting in Excel
Просмотров 395Месяц назад
In this video, I will show you how to use multi-level sorting in Excel. There is an inbuilt feature in Excel that allows you to add multiple levels using which you can sort based on one column and then sort based on another column. इस वीडियो में, मैं आपको Excel में मल्टी-लेवल सॉर्टिंग का उपयोग करना सिखाऊंगा। Excel में एक अंतर्निहित सुविधा है जो आपको कई स्तर जोड़ने की अनुमति देती है, जिसका उपयोग...
Excel में ENGLISH को हिंदी में CONVERT कैसे करें? | Convert English to Hindi in Excel
Просмотров 203Месяц назад
In this video I'm going to show you how to convert any text in English to Hindi or any other language in Excel using the new TRANSLATE function इस वीडियो में मैं आपको दिखाने जा रहा हूं कि नए TRANSLATE फ़ंक्शन का उपयोग करके Excel में अंग्रेजी के किसी भी टेक्स्ट को हिंदी या किसी अन्य भाषा में कैसे परिवर्तित किया जाए। Subscribe to get awesome Excel Tips every week: www.youtube.com/@excel-shala?sub...
Excel में हर एक Row के बाद Blank Row कैसे डालें? | Insert Blank Row After Every Row (Hindi)
Просмотров 1,8 тыс.Месяц назад
In this video, I will show you two simple methods to insert a blank row after every row in your data set. This can easily be done using a simple sort trick and a simple VBA code 👉 File Download Link - www.dropbox.com/scl/fi/st74tkdznq3l4hnt58e6s/Insert-Blank-Row-After-Every-Row.xlsm?rlkey=q396qvokmoxqdkbkh5mpkk6v3&dl=1 Sub InsertAlternateRows() Dim rng As Range Dim CountRow As Integer Dim i As ...
Excel में Data Transpose करने के 3 सबसे आसान तरीके | 3 Super Easy Ways to Transpose Data in Excel
Просмотров 269Месяц назад
In this video, I'm going to show you how to transpose data in Excel using three different methods - the TRANSPOSE formula, the Paste Special technique, and the transpose option in Power Query. इस वीडियो में, मैं आपको Excel में Data को Transpose करने के तीन अलग-अलग तरीके दिखाने जा रहा हूं - TRANSPOSE फॉर्मूला का उपयोग, Paste Special तकनीक, और Power Query #exceltips #excelhindi #excelhinditips
1000 फाइलों का नाम बदलें 3 Seconds में | Rename 1000 Files in 3 Seconds (Rename Files in Bulk)
Просмотров 85Месяц назад
In this video, I'm going to show you how to use a very simple command in Windows to rename 1000 files in less than three seconds. For this, you need to have the list of old file names as well as the new file names that can then easily be used in an Excel file to generate all the commands in bulk. These commands then can easily be used in the command box. This is the easiest way to rename files ...
Filter Strikethrough in Excel (2 बहुत आसान तरीके)
Просмотров 89Месяц назад
In this video I'm going to show you how to use two simple tricks to filter cells with strike through formatting in Excel. This can easily be done using the Find and Replace dialog box and by creating your own User Defined Function with VBA. #exceltips #excelhindi #excelhinditips
Highlight Active Row and Column in Excel - Focus Cells (Hindi / हिंदी)
Просмотров 155Месяц назад
In this video I will show you how to use a new feature in Excel called focus cells to highlight active row and column whenever you select a cell. This feature is currently in beta and would soon be available for users of Excel with Microsoft 365 and Excel on the web. This is a pretty useful feature for people who are working with large datasets which involves a lot of scrolling back and forth. ...
Copy Visible Cells Only in Excel (Hindi / हिंदी)
Просмотров 659 месяцев назад
In this video, I will show you how to use a simple keyboard shortcut to copy only visible cells in Excel.