Home
Videos uploaded by user “Deepak EduWorld”
pivot table for beginners in excel in Hindi || Microsoft excel 2007,2010,2016
 
14:09
How to insert pivot table in excel 2007/2010/2013/206 in Hindi showing with pivot table example in Hindi - i show you How to make pivot table - Summarize Data using pivot table |in Microsoft excel 2007/ excel 2010/ excel 2016 and excel 2013. Don't worry if you have never created a Pivot Table before, i show you how to insert a pivot table in excel in hindi. n this video you will learn how to insert Pivot Table Works with Excel 2003, 2007, 2010, 2013 for Windows & Excel 2011 for Mac Pivot Table 2nd Video https://youtu.be/TVcH_Zs-hIs Excel 👉 create automatic Employee id cards in excel Hindi 👍 ID Cards बनाना सीख लो 👌बहुत आसान है https://youtu.be/_DvNohLLY9k How to Maintain Attendance Sheet in MS excel in Hindi https://www.youtube.com/watch?v=S_0REAjrtjg Create Fantastic Fully Automated 👌Attendance Sheet in Excel https://www.youtube.com/watch?v=zr6T2UoLPs4 how to make payroll sheet in excel | in Hindi https://www.youtube.com/watch?v=yHHiV_hsyp4 pivot table for beginners in excel in Hindi || Microsoft excel 2007,2010,2016 https://www.youtube.com/watch?v=4A6hjD-61gM how to automatically transfer & Save data from one sheet to another in excel || HINDI https://www.youtube.com/watch?v=8Hys7si1gBQ how to create automated invoice in excel || in hindi https://www.youtube.com/watch?v=cs_zD5hh9xs how to link data between two (multiple) workbooks in excel | Hindi https://www.youtube.com/watch?v=--h6xmaCK6M INVOICE PART 1: How To Create Fully Automatic Multi Rate GST invoice in excel Hindi || Auto Save Invoice Entries https://www.youtube.com/watch?v=iKyekwYSOAc INVOICE PART 2:How To Automatically Save Invoice Entries in another worksheet For Future Reference in Excel | HINDI https://youtu.be/qE_HcOUxl8I INVOICE PART 3: How To Auto Save Excel Invoice Back Up in PDF With Invoice Number automatically -HINDI https://youtu.be/OeJfvvE-R0Y How to Insert Pivot Charts in Excel https://youtu.be/RPwInuv-V_Q How to Insert Charts in Excel 2007 2010 2013 2016 in hindi https://youtu.be/akZBShNCj7g How to insert / create / use Pivot tables 2007 2010 2013 2016 in hindi https://youtu.be/4A6hjD-61gM how to use averageif formula in hindi https://youtu.be/7Etgj4X8_Vo how to use sumif formula in hindi https://youtu.be/QcDv6Vvrcsg how to use sumifs formula in hindi https://youtu.be/rDaTTrW6N_0 how to use countif formula in hindi https://youtu.be/HgFHx17PPcc HLOOKUP formula In Hindi https://youtu.be/DyH3PY3qbIE VLOOKUP formula In Hindi https://youtu.be/S2rF6bHIbdA Equipment Used In This Video [You Can Buy] AMAZON OFFERS: 1. TO BUY - Marantz Professional MPM-1000 Large Diaphragm Condenser Microphone click https://goo.gl/NdjSQK 2. TO BUY - Generic 57000928MG Silica Gel Professional Condenser Microphone Sound Studio Recording Dynamic (Works With Phantom Power Supply Or Sound Card Only) https://goo.gl/sRd7RX 3. TO BUY - Blue Yeti USB Microphone, Satin Red Full HD Recording https://goo.gl/1zSaJ8 Hope you will like the video. Thanks for watching. ------------------------------------------------------------------- ------------------------------------------------------------------- Subscribe to my channel: https://www.youtube.com/deepakeduworld ------------------------------------------------------------------- ------------------------------------------------------------------- like my facebook page: https://www.facebook.com/deepakeduworld ------------------------------------------------------------------- ------------------------------------------------------------------- my facebook profile: https://www.facebook.com/nehra92 ------------------------------------------------------------------- ------------------------------------------------------------------- follow on linkedin: https://www.linkedin.com/in/deepakeduworld Deepak EduWorld के दुआरा publish की हुई playlist इस प्रकार हैं _____________________________________________________________ MS WORD के videos के लिए ये playlist देखे https://www.youtube.com/playlist?list=PLVevUWkXP6J3lZyL-Kj823ODQg1KCipzZ _____________________________________________________________ ADVANCED MS EXCEL के videos के लिए देखे ये playlists https://www.youtube.com/playlist?list=PLVevUWkXP6J1kCWdOZof-htD4CbFRjvrT _____________________________________________________________ HTML5 & CSS3 के videos के लिए ये playlist देखे https://www.youtube.com/playlist?list=PLVevUWkXP6J31sl4Crvx-RUiJcIMw7p3C _____________________________________________________________ COMPUTER के TECHNICAL videos के लिए ये playlist देखे https://www.youtube.com/playlist?list=PLVevUWkXP6J3qcZy11BxbUNRVTMBvzdwe _____________________________________________________________ _____________________________________________________________
Views: 625083 Deepak EduWorld
How To Hide Formulas in Excel HINDI
 
06:37
How To Hide Formulas in Excel Hindi - Hide formulas in a worksheet so that they are not displayed in the formula bar. Formulas in an Excel worksheet are hidden by protecting the worksheet with the hidden property applied to the required cells. Work in all ms excel versions 2007 2010 2013 2016 The steps to Hide Formula in Excel are 1) Right click on the cells containing the formula 2) Click on the Protection Tab 3) click on the Hidden Button 4) Uncheck the Locked Tab 5) Click OK 6) Click on the Review Tab 7) Click on Protect sheet 8) enter a password 9) reenter the password 10 ) You are done How to UnProtect Excel sheet without knowing password In Hindi || If Forgot https://youtu.be/M51S0-kqoKg Hope you will like the video. Thanks for watching. ------------------------------------------------------------------- ------------------------------------------------------------------- Subscribe to my channel: https://www.youtube.com/deepakeduworld ------------------------------------------------------------------- ------------------------------------------------------------------- like my facebook page: https://www.facebook.com/deepakeduworld ------------------------------------------------------------------- ------------------------------------------------------------------- follow on linkedin: https://www.linkedin.com/in/deepakeduworld Deepak EduWorld के दुआरा publish की हुई playlist इस प्रकार हैं _____________________________________________________________ MS WORD के videos के लिए ये playlist देखे https://www.youtube.com/playlist?list=PLVevUWkXP6J3lZyL-Kj823ODQg1KCipzZ _____________________________________________________________ ADVANCED MS EXCEL के videos के लिए देखे ये playlists https://www.youtube.com/playlist?list=PLVevUWkXP6J1kCWdOZof-htD4CbFRjvrT _____________________________________________________________ ADVANCED MS EXCEL FORMULAS के videos के लिए देखे ये playlists https://www.youtube.com/playlist?list=PLVevUWkXP6J2jsiIpCRjtOQvcMecQ49kw _____________________________________________________________ HTML5 & CSS3 के videos के लिए ये playlist देखे https://www.youtube.com/playlist?list=PLVevUWkXP6J31sl4Crvx-RUiJcIMw7p3C _____________________________________________________________ COMPUTER के TECHNICAL videos के लिए ये playlist देखे https://www.youtube.com/playlist?list=PLVevUWkXP6J3qcZy11BxbUNRVTMBvzdwe _____________________________________________________________ Thanks for Watching Happy Learning DEEPAK NEHRA ____________________________________________________________
Views: 61773 Deepak EduWorld
Index Formula in Excel - Vlookup से भी Powerful कैसे है ये index function - देखिये
 
07:18
Index Formula in Excel - See how to use the INDEX function to lookup something in a table based on given a row position and column position. Yes, it's true: You can look something up at the intersecting cell given a row number and a column number! Understand how to use INDEX formula, what is its syntax, how it can help you extract and analyze any data. and index is very powerfull with match function. and also its very powerfull than vlookup. VLOOKUP VIDEO SERIES: 1. vlookup in excel with example in Hindi https://youtu.be/S2rF6bHIbdA 2. How to use vlookup for multiple values || Trick to use vlookup for large data https://youtu.be/oSE4wSy02s8 3. Vlookup in multiple sheets in excel || In Hindi https://youtu.be/fpslxPp3_Cw 4. How To Use Double VLookup in Excel-Nested vlookup https://youtu.be/REBdKbbvwG0 5. Dynamically Updated Vlookup Formula in Excel https://youtu.be/IHD6XIDrCfk 6. How To Use Vlookup With Multiple Excel Workbooks https://youtu.be/CiHIbsRM3cg 7. VLOOKUP With MATCH Function In Excel https://youtu.be/O19XraNl9ZQ 8. HLOOKUP in excel with example in Hindi https://youtu.be/DyH3PY3qbIE 9. Hlookup With Match Function in Excel in Hindi https://youtu.be/JIN0NBVuEsg Hope you will like the video. Thanks for watching. Deepak EduWorld के दुआरा publish की हुई playlist इस प्रकार हैं ________________________________________________ ADVANCED MS EXCEL ► https://goo.gl/A6LdZA ADVANCED MS EXCEL FORMULAS ► https://goo.gl/bbHYu2 MS WORD ► https://goo.gl/B4TeSA HTML5 & CSS3 ► https://goo.gl/2PFgs8 COMPUTER Tips & Tricks ► https://goo.gl/paZmpn --------------------------------------------------------------------------- --------------------------------------------------------------------------- Subscribe to my channel ► https://www.youtube.com/deepakeduworld Like my Facebook page ► https://www.facebook.com/deepakeduworld Follow on LinkedIn ► https://www.linkedin.com/in/deepakeduworld Facebook Group ► https://www.facebook.com/groups/cse92/ ********************************************** Thanks for Watching Happy Learning ER DEEPAK NEHRA [ M.Tech. ] **********************************************
Views: 73776 Deepak EduWorld
vlookup in excel with example in Hindi
 
08:42
excel vlookup formula [ function ] in hindi -Hlookup and vvlookup are very similar- in this video i explained how vlookup formula work in excel 2007/2010/2013/2016. its very easy to work with lookup formulas in excel such as vlookap and hlookup are most usable formulas. i explaining how to use vlookup formula in excel with examples watch in Hindi. vlookup in excel with example in hindi The formulas are the power of excel. The more formulas you remember the more proficient you become in excel. Watch this video to learn how to use Hlookup and Vlookup formula in hindi. Microsoft word 2010 2007 2013 2016. how to use averageif formula in hindi https://youtu.be/7Etgj4X8_Vo how to use sumif formula in hindi https://youtu.be/QcDv6Vvrcsg how to use sumifs formula in hindi https://youtu.be/rDaTTrW6N_0 how to use countif formula in hindi https://youtu.be/HgFHx17PPcc VLOOKUP VIDEO SERIES: 1. vlookup in excel with example in Hindi https://youtu.be/S2rF6bHIbdA 2. How to use vlookup for multiple values || Trick to use vlookup for large data https://youtu.be/oSE4wSy02s8 3. Vlookup in multiple sheets in excel || In Hindi https://youtu.be/fpslxPp3_Cw 4. How To Use Double VLookup in Excel-Nested vlookup https://youtu.be/REBdKbbvwG0 5. Dynamically Updated Vlookup Formula in Excel https://youtu.be/IHD6XIDrCfk 6. How To Use Vlookup With Multiple Excel Workbooks https://youtu.be/CiHIbsRM3cg 7. HLOOKUP in excel with example in Hindi https://youtu.be/DyH3PY3qbIE Hope you will like the video. Thanks for watching. Deepak EduWorld के दुआरा publish की हुई playlist इस प्रकार हैं ________________________________________________ ADVANCED MS EXCEL के लिए ये playlists देखे ► https://goo.gl/A6LdZA ADVANCED MS EXCEL FORMULAS के लिए ये playlists देखे ► https://goo.gl/bbHYu2 MS WORD के लिए ये playlist देखे ► https://goo.gl/B4TeSA HTML5 & CSS3 के लिए ये playlist देखे ► https://goo.gl/2PFgs8 COMPUTER के TECHNICAL videos के लिए ये playlist देखे ► https://goo.gl/paZmpn --------------------------------------------------------------------------- --------------------------------------------------------------------------- Subscribe to my channel ► https://www.youtube.com/deepakeduworld Like my Facebook page ► https://www.facebook.com/deepakeduworld Follow on LinkedIn ► https://www.linkedin.com/in/deepakeduworld Facebook Group ► https://www.facebook.com/groups/cse92/ ********************************************** Thanks for Watching Happy Learning ER DEEPAK NEHRA [ M.Tech. ] **********************************************
Views: 327741 Deepak EduWorld
Advanced Excel 5 Magical Hidden Tips & Tricks To Make You Excel Expert || Best Time Saving Tricks
 
10:33
Advanced Excel 5 Magical Hidden Tips & Tricks - learn MS Excel 5 Fantastic Magical Hidden super time saving secrates Tips & Tricks which make you the master of excel. i will show you excel Best Time Saving Tips and tricks for all ms excel versions 2007 2010 2013 2016. 1. copy data automatically to another worksheet/ best hidden shortcut key we can very easily copy the data from one excel sheet to another sheet. 2. How to add numbers containing text such as 10kg 20kg 30kg 20pcs 12pcs etc. 3. how to add blank rows in large existing record. 4. how to remove blank records. 5. using excel camera. taking screenshoot using excel camera. this is the best excel hidden trick. Hope you will like the video. Thanks for watching. Deepak EduWorld के दुआरा publish की हुई playlist इस प्रकार हैं ________________________________________________ ADVANCED MS EXCEL के लिए ये playlists देखे ► https://goo.gl/A6LdZA ADVANCED MS EXCEL FORMULAS के लिए ये playlists देखे ► https://goo.gl/bbHYu2 MS WORD के लिए ये playlist देखे ► https://goo.gl/B4TeSA HTML5 & CSS3 के लिए ये playlist देखे ► https://goo.gl/2PFgs8 COMPUTER के TECHNICAL videos के लिए ये playlist देखे ► https://goo.gl/paZmpn --------------------------------------------------------------------------- --------------------------------------------------------------------------- Subscribe to my channel ► https://www.youtube.com/deepakeduworld Like my Facebook page ► https://www.facebook.com/deepakeduworld Follow on LinkedIn ► https://www.linkedin.com/in/deepakeduworld Facebook Group ► https://www.facebook.com/groups/cse92/ ********************************************** Thanks for Watching Happy Learning ER DEEPAK NEHRA [ M.Tech. ] **********************************************
Views: 271582 Deepak EduWorld
How To Create Dependent  Drop Down List In Excel || Best Video || Hindi || HD
 
10:10
Create dependent drop down lists in Excel to select items based on another list selection. Drop-down lists are very common in the web world and you can also create it easily in Excel. In this video, I will show you how to create a dependent drop-down list in Excel (also known as a conditional drop-down list). What is a Dependent Drop-down List in Excel? While a drop down list allows you select an item from a list, a dependent drop-down list allows you to change the items in a drop down based on what you have already selected. Here is simple example. You have two drop down lists with the first one showing countries and the second one showing cities. cities dropdown indirectly depend on country dropdown. when You select the US from country list, and all the cities in the US appear in the adjacent drop down. And when you select India, all the cities in India appear. DATA VALIDATION DROPDOWN VIDEO SERIES: 1. how to create drop down list from another sheet in excel || Hindi | using data validation https://youtu.be/-IDqfwby5MM 2.Data Validation Auto Updating DropDown List In Excel Hindi || Dynamic DropDown List https://youtu.be/EX2ZahZ3pHo 3. How To Create Searchable Drop Down List In Excel || Hindi || HD https://youtu.be/HwVbH_x6nMk Hope you will like the video. Thanks for watching. Deepak EduWorld के दुआरा publish की हुई playlist इस प्रकार हैं ________________________________________________ ADVANCED MS EXCEL के लिए ये playlists देखे: https://goo.gl/A6LdZA ADVANCED MS EXCEL FORMULAS के लिए ये playlists देखे: https://goo.gl/bbHYu2 MS WORD के लिए ये playlist देखे: https://goo.gl/B4TeSA HTML5 & CSS3 के लिए ये playlist देखे: https://goo.gl/2PFgs8 COMPUTER के TECHNICAL videos के लिए ये playlist देखे: https://goo.gl/paZmpn ------------------------------------------------------------- ------------------------------------------------------------- Subscribe to my channel: https://www.youtube.com/deepakeduworld Like my Facebook page: https://www.facebook.com/deepakeduworld Follow on LinkedIn: https://www.linkedin.com/in/deepakeduworld Facebook Group : https://www.facebook.com/groups/cse92/ ********************************************** Thanks for Watching Happy Learning ER DEEPAK NEHRA [ M.Tech. ] **********************************************
Views: 98707 Deepak EduWorld
😮 EXCEL में  Boss को करना है Impress 😎 तो Macro का ये Magic सीखो
 
04:22
Boss को करना है Impress तो Macro का ये Magic सीखो - VBA MACRO very short code to do smart work and its very useful while maintaing and print data in excel. its all about autofit column width automatically using smart macro. just keep entering data in excel and columns width will be automatically adjusted. Hope you will like the video. Thanks for watching. Deepak EduWorld के दुआरा publish की हुई playlist इस प्रकार हैं _____________________________________________________________ ADVANCED MS EXCEL के लिए ये playlists देखे: https://goo.gl/A6LdZA ADVANCED MS EXCEL FORMULAS के लिए ये playlists देखे: https://goo.gl/bbHYu2 MS WORD के लिए ये playlist देखे: https://goo.gl/B4TeSA HTML5 & CSS3 के लिए ये playlist देखे: https://goo.gl/2PFgs8 COMPUTER के TECHNICAL videos के लिए ये playlist देखे: https://goo.gl/paZmpn --------------------------------------------------------------------------- ---------------------- --------------------------------------------------------------------------- ---------------------- Subscribe to my channel: https://www.youtube.com/deepakeduworld Like my Facebook page: https://www.facebook.com/deepakeduworld Follow on LinkedIn: https://www.linkedin.com/in/deepakedu... Facebook Group : https://www.facebook.com/groups/cse92/ *********************************************************** Thanks for Watching Happy Learning DEEPAK NEHRA ***********************************************************
Views: 22908 Deepak EduWorld
How To Protect Cells That Contain Formulas In Excel HINDI
 
06:53
How To Protect Cells That Contain Formulas In Excel Hindi - Dont allow formula editing by protecting cells containing formulas, but allow other cells to be edited. we can easily restrict user to edit in formulas. use this trick in excel 2007 2010 2013 2016 and peoples cant play with your formulas. By default, all cells on a worksheet are locked; however, this has no effect unless worksheet protection has been applied. Here is a very easy way to apply worksheet protection so that only formula cells are locked and protected. To handle cell protection differently then you have change the default settings for the required cells. Here is a scenario to protect formula cells but allow access to data cells: 1. Select all cells in the worksheet by clicking on the top left corner or using [ ctrl + a ] of the sheet. 2. Right click anywhere in sheet and select format cell option. 3. Click on the Protection tab. 4. Uncheck the Locked and Hidden check boxes, then click OK. 5. Now select all cells that contain formulas.. you can select multiple range of cells by pressing CTRL key. 6. Right click on any selected cell and select Format cell option again. 7. Go to review tab.. select protect sheet option... put any password... save file... 8. all the selected cells is locked . and protected.. WATCH THE VIDEO TUTORIAL FOR DETAIL Hope you will like the video. Thanks for watching. ------------------------------------------------------------------- ------------------------------------------------------------------- Subscribe to my channel: https://www.youtube.com/deepakeduworld ------------------------------------------------------------------- ------------------------------------------------------------------- like my facebook page: https://www.facebook.com/deepakeduworld ------------------------------------------------------------------- ------------------------------------------------------------------- follow on linkedin: https://www.linkedin.com/in/deepakeduworld Deepak EduWorld के दुआरा publish की हुई playlist इस प्रकार हैं _____________________________________________________________ MS WORD के videos के लिए ये playlist देखे https://www.youtube.com/playlist?list=PLVevUWkXP6J3lZyL-Kj823ODQg1KCipzZ _____________________________________________________________ ADVANCED MS EXCEL के videos के लिए देखे ये playlists https://www.youtube.com/playlist?list=PLVevUWkXP6J1kCWdOZof-htD4CbFRjvrT _____________________________________________________________ ADVANCED MS EXCEL FORMULAS के videos के लिए देखे ये playlists https://www.youtube.com/playlist?list=PLVevUWkXP6J2jsiIpCRjtOQvcMecQ49kw _____________________________________________________________ HTML5 & CSS3 के videos के लिए ये playlist देखे https://www.youtube.com/playlist?list=PLVevUWkXP6J31sl4Crvx-RUiJcIMw7p3C _____________________________________________________________ COMPUTER के TECHNICAL videos के लिए ये playlist देखे https://www.youtube.com/playlist?list=PLVevUWkXP6J3qcZy11BxbUNRVTMBvzdwe _____________________________________________________________ Thanks for Watching Happy Learning DEEPAK NEHRA ____________________________________________________________ _
Views: 28692 Deepak EduWorld
SUMIF formula in excel | Hindi || Excel sumif formula examples in hindi
 
09:48
how to use SUMIF Formula in excel 2007/2010/2013/2016 with example in hindi / english - In this video of SUMIF formula we show you proper use of SUMIF formula with 5 different SUMIF formula examples in hindi . We can Calculate the the Sum of a range based on a specific criteria using the Sumif formula in Excel Hindi. The SUMIF Formula in Excel is a worksheet function that adds all numbers in a range of cells based on one criteria (for example, is equal to any day,any date,number, text etc). Sumifs Formula https://youtu.be/rDaTTrW6N_0 Learn the Sumif formula to do additions based on a condition. English / urdu Parameters or Arguments of Sumif Formula 1. range The range of cells that you want to apply the criteria against. 2. criteria The criteria used to determine which cells to add. 3. sum_range Optional. It is the range of cells to sum together. If this parameter is omitted, it uses range as the sum_range. All thee parameters is explained in this sum formula video in hindi. To learn SUMIF formula must watch this video... we explained this sumif formula with five examples. Hope you will like the video. Thanks for watching. ------------------------------------------------------------------- ------------------------------------------------------------------- Subscribe to my channel: https://www.youtube.com/deepakeduworld ------------------------------------------------------------------- ------------------------------------------------------------------- like my facebook page: https://www.facebook.com/deepakeduworld ------------------------------------------------------------------- ------------------------------------------------------------------- my facebook profile: https://www.facebook.com/nehra92 ------------------------------------------------------------------- ------------------------------------------------------------------- follow on linkedin: https://www.linkedin.com/in/deepakeduworld Deepak EduWorld के दुआरा publish की हुई playlist इस प्रकार हैं _____________________________________________________________ MS WORD के videos के लिए ये playlist देखे https://www.youtube.com/playlist?list=PLVevUWkXP6J3lZyL-Kj823ODQg1KCipzZ _____________________________________________________________ ADVANCED MS EXCEL के videos के लिए देखे ये playlists https://www.youtube.com/playlist?list=PLVevUWkXP6J1kCWdOZof-htD4CbFRjvrT _____________________________________________________________ HTML5 & CSS3 के videos के लिए ये playlist देखे https://www.youtube.com/playlist?list=PLVevUWkXP6J31sl4Crvx-RUiJcIMw7p3C _____________________________________________________________ COMPUTER के TECHNICAL videos के लिए ये playlist देखे https://www.youtube.com/playlist?list=PLVevUWkXP6J3qcZy11BxbUNRVTMBvzdwe _____________________________________________________________ _____________________________________________________________
Views: 75550 Deepak EduWorld
WoW Excel की 5 और Magical Hidden Secrete Tips & Tricks To Make You Smart || Hindi
 
07:58
Advanced Excel 5 Magical Hidden Secrete Tips & Tricks [Hindi] you don't know. which Make You Smart excel user - learn MS Excel 5 Fantastic Magical Hidden super time saving secretes Tips & Tricks which make you the master of excel. i will show you excel Best Time Saving Tips and tricks for all ms excel versions 2007 2010 2013 2016. 1. Change the direction of move cell selection on pressing enter key 2. Repeate last command by using f4 function key 3. automatically add country calling code before phone number while entering data. by using custom number format 4. paste the data using enter key 5. Use speak cells feature in excel. excel will speak the selected data by using speak cells feature Hope you will like the video. Thanks for watching. Deepak EduWorld के दुआरा publish की हुई playlist इस प्रकार हैं ________________________________________________ ADVANCED MS EXCEL ► https://goo.gl/A6LdZA ADVANCED MS EXCEL FORMULAS ► https://goo.gl/bbHYu2 MS WORD ► https://goo.gl/B4TeSA HTML5 & CSS3 ► https://goo.gl/2PFgs8 COMPUTER Tips & Tricks ► https://goo.gl/paZmpn --------------------------------------------------------------------------- --------------------------------------------------------------------------- Subscribe to my channel ► https://www.youtube.com/deepakeduworld Like my Facebook page ► https://www.facebook.com/deepakeduworld Follow on LinkedIn ► https://www.linkedin.com/in/deepakeduworld Facebook Group ► https://www.facebook.com/groups/cse92/ ********************************************** Thanks for Watching Happy Learning ER DEEPAK NEHRA [ M.Tech. ] **********************************************
Views: 84186 Deepak EduWorld
how to link data between two (multiple) workbooks in excel | Hindi
 
07:49
how to link data between two (multiple) workbooks in excel in hindi - In this video i show you how to make data connections [link data] between excel workbooks in hindi. its very easy to make a link or data connection between excel workbooks. linking excel workbooks to another workbook. i am showing how to link two excel workbooks together using data menu in excel ( connections in excel ) Hope you will like the video. Thanks for watching. ------------------------------------------------------------------- ------------------------------------------------------------------- Subscribe to my channel: https://www.youtube.com/deepakeduworld ------------------------------------------------------------------- ------------------------------------------------------------------- like my facebook page: https://www.facebook.com/deepakeduworld ------------------------------------------------------------------- ------------------------------------------------------------------- my facebook profile: https://www.facebook.com/nehra92 ------------------------------------------------------------------- ------------------------------------------------------------------- follow on linkedin: https://www.linkedin.com/in/deepakeduworld Deepak EduWorld के दुआरा publish की हुई playlist इस प्रकार हैं _____________________________________________________________ MS WORD के videos के लिए ये playlist देखे https://www.youtube.com/playlist?list=PLVevUWkXP6J3lZyL-Kj823ODQg1KCipzZ _____________________________________________________________ ADVANCED MS EXCEL के videos के लिए देखे ये playlists https://www.youtube.com/playlist?list=PLVevUWkXP6J1kCWdOZof-htD4CbFRjvrT _____________________________________________________________ HTML5 & CSS3 के videos के लिए ये playlist देखे https://www.youtube.com/playlist?list=PLVevUWkXP6J31sl4Crvx-RUiJcIMw7p3C _____________________________________________________________ COMPUTER के TECHNICAL videos के लिए ये playlist देखे https://www.youtube.com/playlist?list=PLVevUWkXP6J3qcZy11BxbUNRVTMBvzdwe _____________________________________________________________ _____________________________________________________________
Views: 225827 Deepak EduWorld
excel shortcut keys in hindi
 
03:15
excel, new shortcut key of excel IN HINDI, all excel shortcut key IN HINDI, excel shortcut keys 2017, excel shortcut keys, excel shortcut keys in hindi, download, excel shortcut keys for windows 10,, excel shortcut keys 2007, excel shortcut keys 2013, keyboard shortcut key, pivot table, pivot tables, microsoft excel, excel tips, learn ms excel 2007 in hindi, 20 excel shortcuts in hindi, ms excel important shortcut key, top 20 excel shortcut in hindi, top 10 excel formulas, vlookup,hindi,english top 24 excel shortcut keys in hindi https://youtu.be/DO7VwQQXxf4 Subscribe my channel : http://www.youtube.com/deepakeduworld Facebook page: http://www.facebook.com/deepakeduworld
Views: 58019 Deepak EduWorld
How To Use Double VLookup in Excel In Hindi || Nested vlookup  || Multiple Vlookup
 
07:51
double vlookup in excel 2016 2010 2013 2007 - Nested Vlookup formula in excel Hindi - Multiple Vlookups with iferror function - Deepak EduWorld presents a wonderful video “how to double vlookup formula in excel Hindi. This excel tutorial explains you double vlookup function [ nested vlookup || Multiple vlookups togather ] in excel with iferror and with examples How to use IFERROR formula in excel || HINDI https://youtu.be/TF_JAqcPA5w How To Fix Excel Formula Errors #NAME? | #VALUE! | #REF! | #DIV/0! | ###### In Hindi https://youtu.be/CajffOjtjGo how to use averageif formula in hindi https://youtu.be/7Etgj4X8_Vo how to use sumif formula in hindi https://youtu.be/QcDv6Vvrcsg how to use sumifs formula in hindi https://youtu.be/rDaTTrW6N_0 how to use countif formula in hindi https://youtu.be/HgFHx17PPcc VLOOKUP VIDEO SERIES: 1. vlookup in excel with example in Hindi https://youtu.be/S2rF6bHIbdA 2. How to use vlookup for multiple values || Trick to use vlookup for large data https://youtu.be/oSE4wSy02s8 3. Vlookup in multiple sheets in excel || In Hindi https://youtu.be/fpslxPp3_Cw 4. How To Use Double VLookup in Excel-Nested vlookup https://youtu.be/REBdKbbvwG0 5. Dynamically Updated Vlookup Formula in Excel https://youtu.be/IHD6XIDrCfk 6. How To Use Vlookup With Multiple Excel Workbooks https://youtu.be/CiHIbsRM3cg 7. HLOOKUP in excel with example in Hindi https://youtu.be/DyH3PY3qbIE Hope you will like the video. Thanks for watching. Deepak EduWorld के दुआरा publish की हुई playlist इस प्रकार हैं ________________________________________________ ADVANCED MS EXCEL के लिए ये playlists देखे ► https://goo.gl/A6LdZA ADVANCED MS EXCEL FORMULAS के लिए ये playlists देखे ► https://goo.gl/bbHYu2 MS WORD के लिए ये playlist देखे ► https://goo.gl/B4TeSA HTML5 & CSS3 के लिए ये playlist देखे ► https://goo.gl/2PFgs8 COMPUTER के TECHNICAL videos के लिए ये playlist देखे ► https://goo.gl/paZmpn --------------------------------------------------------------------------- --------------------------------------------------------------------------- Subscribe to my channel ► https://www.youtube.com/deepakeduworld Like my Facebook page ► https://www.facebook.com/deepakeduworld Follow on LinkedIn ► https://www.linkedin.com/in/deepakeduworld Facebook Group ► https://www.facebook.com/groups/cse92/ ********************************************** Thanks for Watching Happy Learning ER DEEPAK NEHRA [ M.Tech. ] **********************************************
Views: 80615 Deepak EduWorld
sumifs formula in excel in Hindi || sumif and sumifs excel functions
 
09:12
sumifs formula in excel in hindi 2007/ 2010/ 2016/ 2013 - In this tutorial, I teach you how to use sumifs formula in excel. Sumif VS Sumifs. This formula comes into the advance excel category. we use this formula when we want to sum with more than one condition. Adds the total of cells in a range based on multiple criterion. SUMIFS formula in Excel sums cells in a range that match supplied criteria. Unlike the SUMIF function, SUMIFS function in excel can apply more than one set of criteria, with more than one range. The first range is the range to be summed. The criteria is supplied in pairs (range/criteria) and only the first pair is required. For each additional criteria, supply an additional range/criteria pair. in Sumifs formula in Excel Up to 127 range/criteria pairs are allowed. Note that the order of arguments is different between the SUMIFS formula and SUMIF functions. Sum_range is the first argument in SUMIFS function in excel but the third argument in SUMIF. Learn How sumif and sumifs function work in excel 2007/2010/2013/2016 how to use averageif formula in hindi https://youtu.be/7Etgj4X8_Vo how to use sumif formula in hindi https://youtu.be/QcDv6Vvrcsg how to use sumifs formula in hindi https://youtu.be/rDaTTrW6N_0 how to use countif formula in hindi https://youtu.be/HgFHx17PPcc HLOOKUP formula In Hindi https://youtu.be/DyH3PY3qbIE VLOOKUP formula In Hindi https://youtu.be/S2rF6bHIbdA SUMIF formula video link https://youtu.be/QcDv6Vvrcsg ------------------------------------------------------------------- ------------------------------------------------------------------- Subscribe to my channel: https://www.youtube.com/deepakeduworld ------------------------------------------------------------------- ------------------------------------------------------------------- like my facebook page: https://www.facebook.com/deepakeduworld ------------------------------------------------------------------- ------------------------------------------------------------------- follow on linkedin: https://www.linkedin.com/in/deepakeduworld
Views: 79757 Deepak EduWorld
How To Use VLOOKUP With MATCH Function In Excel || 2D Lookup || Hindi
 
09:23
How To Use VLOOKUP With MATCH Function In Excel Hindi - 2D Lookup This technique [ Vlookup + Match ] is useful when you have to look up a value in a table with both vertical and horizontal co-ordinates. We basically, select the table using VLOOKUP and select the relevant column using the MATCH function. This technique can be used which analyzing sales data, logistics, employees data etc. The Match is a Junior formula. and i have given match formula link below in this description. if you dont know about match function you can watch the video. and VLookup is a Senior formula which is very powerful. i have given vlookup videos series below. watch all vlookup videos to become an expert in vlookup. Match Formula In Excel https://youtu.be/yx_pBagPvnw VLOOKUP VIDEO SERIES: 1. vlookup in excel with example in Hindi https://youtu.be/S2rF6bHIbdA 2. How to use vlookup for multiple values || Trick to use vlookup for large data https://youtu.be/oSE4wSy02s8 3. Vlookup in multiple sheets in excel || In Hindi https://youtu.be/fpslxPp3_Cw 4. How To Use Double VLookup in Excel-Nested vlookup https://youtu.be/REBdKbbvwG0 5. Dynamically Updated Vlookup Formula in Excel https://youtu.be/IHD6XIDrCfk 6. How To Use Vlookup With Multiple Excel Workbooks https://youtu.be/CiHIbsRM3cg 7. HLOOKUP in excel with example in Hindi https://youtu.be/DyH3PY3qbIE Hope you will like the video. Thanks for watching. Deepak EduWorld के दुआरा publish की हुई playlist इस प्रकार हैं ________________________________________________ ADVANCED MS EXCEL ► https://goo.gl/A6LdZA ADVANCED MS EXCEL FORMULAS ► https://goo.gl/bbHYu2 MS WORD ► https://goo.gl/B4TeSA HTML5 & CSS3 ► https://goo.gl/2PFgs8 COMPUTER Tips & Tricks ► https://goo.gl/paZmpn --------------------------------------------------------------------------- --------------------------------------------------------------------------- Subscribe to my channel ► https://www.youtube.com/deepakeduworld Like my Facebook page ► https://www.facebook.com/deepakeduworld Follow on LinkedIn ► https://www.linkedin.com/in/deepakedu... Facebook Group ► https://www.facebook.com/groups/cse92/ ********************************************** Thanks for Watching Happy Learning ER DEEPAK NEHRA [ M.Tech. ] **********************************************
Views: 55695 Deepak EduWorld
how to create drop down list from another sheet in excel || Hindi | using data validation
 
07:43
how to make | insert |create drop down list from another sheet in excel in hindi- It is quite easy to create a data validation drop down list among worksheets within a workbook. if the list data you need for the data validation locates in another worksheet, what would you do? In this tutorial, you will learn how to create a drop fown list from another worksheet in Excel in details. its easy to make drop down list in excel 2010 2013 and 2016 because Microsoft office 2010 2013 and 2016 has added some new feature to data validation in excel 2010 2013 and 2016 you can easily navigate from sheet to sheet while selecting data range in data validation to create drop down list. but in ms excel 2007 you cant select data range from another worksheet here is the step by step procedure how to use data validation to create a drop down list from different sheet inside the whole workbook. Must watch this video Excel Formula Tab in Hindi - How To Use Name Manager And Define Name in EXCEL | In Hindi https://youtu.be/FyHyEm40OgM protect sheet & Lock Cell excel in Hindi 2007 | 2010 | 2016 | 2013 https://youtu.be/AN1JEk8MHZk ____________________________________________ Data Validation Part 1: https://youtu.be/U3XdCUmNaBg * Data Validation to allow only whole numbers between an upper and lower limit * Data Validation to allow only decimal numbers below or equal to an upper limit * Create an Input Message for your Data Validation * Error alert Message with "Stop" * Error alert Message with "Warning" * Error alert Message with "Information" ____________________________________________ Data Validation Part 2: https://youtu.be/-IDqfwby5MM * Data Validation drop down list using a range of cells * Data Validation drop down list using a Defined Name * Make data validation list from another worksheet in excel 2007 ____________________________________________ Data Validation Part 3: https://youtu.be/VjVpMVO8Jq0 * Data Validation to allow only dates between an upper and lower limit * Data Validation to allow only times above or equal to a lower limit * Data Validation to allow a certain text length ____________________________________________ Data Validation Part 4 : https://youtu.be/ZTlymO0uug4 * Allow only numbers in cell & Set limit of digits to accept. * Allow only text in cell & set character limit to accept. * Allow only 10 digit mobile number in cell ____________________________________________ Data Validation Part 5 :https://youtu.be/vzeWlggal88 * Prevent Duplicate Entries In Column * Allow Only Unique Entries - Avoid duplicate entries in excel using custom data validation. ____________________________________________ Data Validation Part 6: https://youtu.be/EX2ZahZ3pHo Auto Updating DropDown List In Excel Hindi || Dynamic DropDown List ____________________________________________ Data Validation Part 7:https://youtu.be/Ig245IO7lPs How To Create Data Validation Dependent Drop Down List In Excel || Best Video || Hindi || HD ____________________________________________ Data Validation Part 8:https://youtu.be/tn4ShvcvBls EXCEL ये विडियो जरूर देखें - Allow Only Entries Starting With Specific Alphabet / Text /Number ____________________________________________ Data Validation Part 9:https:https://youtu.be/WULhnIsKguU Custom Data Validation- To Allow only Uppercase Text Entries In Excel ____________________________________________ Data Validation Part 10:https:https://youtu.be/HwVbH_x6nMk How To Create Searchable Drop Down List In Excel || Hindi || HD ____________________________________________ Data Validation Part 11:https:https://youtu.be/-IDqfwby5MM how to create drop down list from another sheet in excel || Hindi | using data validation ____________________________________________ Data Validation Part 13:https://youtu.be/e6R4zZdlxHY EXCEL में Data Entry करने वाले जरूर देखे 👍 5 Cool Custom Data validation Tips Everyone should know Hope you will like the video. Thanks for watching. Deepak EduWorld के दुआरा publish की हुई playlist इस प्रकार हैं _____________________________________________________________ ADVANCED MS EXCEL के लिए ये playlists देखे: https://goo.gl/A6LdZA ADVANCED MS EXCEL FORMULAS के लिए ये playlists देखे: https://goo.gl/bbHYu2 MS WORD के लिए ये playlist देखे: https://goo.gl/B4TeSA HTML5 & CSS3 के लिए ये playlist देखे: https://goo.gl/2PFgs8 COMPUTER के TECHNICAL videos के लिए ये playlist देखे: https://goo.gl/paZmpn --------------------------------------------------------------------------- Subscribe to my channel: https://www.youtube.com/deepakeduworld Like my Facebook page: https://www.facebook.com/deepakeduworld Follow on LinkedIn: https://www.linkedin.com/in/deepakedu... Facebook Group : https://www.facebook.com/groups/cse92/ *********************************************************** Thanks for Watching Happy Learning
Views: 49426 Deepak EduWorld
Vlookup Magic  😮 Trick -  Vlookup नहीं Smart Vlookup 👌 सीखो अब..
 
10:56
Vlookup Magic Trick - Vlookup नहीं Smart Vlookup सीखो अब... excel vlookup formula [ function ] in hindi -Hlookup and vlookup are very similar- in this video i explained a magical trick to use vlookup formula work in excel 2007/2010/2013/2016. its very easy to work with lookup formulas in excel such as vlookap and hlookup are most usable formulas. i explaining how to use vlookup formula in excel with multiple columns by using a columns formula to make vlookup dragable in Hindi. vlookup in excel with example in hindi. The formulas are the power of excel. The more formulas you remember the more proficient you become in excel. Watch this video to learn how to use Hlookup and Vlookup formula in hindi. Microsoft word 2010 2007 2013 2016. Vlookup In Excel - VLOOKUP VIDEO SERIES: 1. vlookup in excel with example in Hindi https://youtu.be/S2rF6bHIbdA 2. How to use vlookup for multiple values || Trick to use vlookup for large data https://youtu.be/oSE4wSy02s8 3. Vlookup in multiple sheets in excel || In Hindi https://youtu.be/fpslxPp3_Cw 4. How To Use Double VLookup in Excel-Nested vlookup https://youtu.be/REBdKbbvwG0 5. Dynamically Updated Vlookup Formula in Excel https://youtu.be/IHD6XIDrCfk 6. How To Use Vlookup With Multiple Excel Workbooks https://youtu.be/CiHIbsRM3cg 7. VLOOKUP With MATCH Function In Excel https://youtu.be/O19XraNl9ZQ 8. HLOOKUP in excel with example in Hindi https://youtu.be/DyH3PY3qbIE 9. Hlookup With Match Function in Excel in Hindi https://youtu.be/JIN0NBVuEsg Hope you will like the video. Thanks for watching. Deepak EduWorld के दुआरा publish की हुई playlist इस प्रकार हैं ________________________________________________ ADVANCED MS EXCEL ► https://goo.gl/A6LdZA ADVANCED MS EXCEL FORMULAS ► https://goo.gl/bbHYu2 MS WORD ► https://goo.gl/B4TeSA HTML5 & CSS3 ► https://goo.gl/2PFgs8 COMPUTER Tips & Tricks ► https://goo.gl/paZmpn --------------------------------------------------------------------------- --------------------------------------------------------------------------- Subscribe to my channel ► https://www.youtube.com/deepakeduworld Like my Facebook page ► https://www.facebook.com/deepakeduworld Follow on LinkedIn ► https://www.linkedin.com/in/deepakedu... Facebook Group ► https://www.facebook.com/groups/cse92/ ********************************************** Thanks for Watching Happy Learning ER DEEPAK NEHRA [ M.Tech. ] **********************************************
Views: 139107 Deepak EduWorld
Data Validation Auto Updating DropDown List In Excel Hindi || Dynamic DropDown List
 
04:45
Data Validation Auto Updating DropDown List In Excel Hindi - How to easily create dynamically updated drop down list in excel how to make your data validation drop down list or menu dynamic. This means that every time you add something to the list the drop down menu will automatically include that item in its list and updated. data validation in excel - Learn how to use Data Validation tools in Excel 2007 2010 2013 2016 Hindi to improve the accuracy of the data in your spreadsheets. ignore invalid data using data validation ... here is step by step videos to learn... Full detailed explanation for data validation Data Validation Part 1: https://youtu.be/U3XdCUmNaBg * Data Validation to allow only whole numbers between an upper and lower limit * Data Validation to allow only decimal numbers below or equal to an upper limit * Create an Input Message for your Data Validation * Error alert Message with "Stop" * Error alert Message with "Warning" * Error alert Message with "Information" ____________________________________________ Data Validation Part 2: https://youtu.be/-IDqfwby5MM * Data Validation drop down list using a range of cells * Data Validation drop down list using a Defined Name * Make data validation list from another worksheet in excel 2007 ____________________________________________ Data Validation Part 3: https://youtu.be/VjVpMVO8Jq0 * Data Validation to allow only dates between an upper and lower limit * Data Validation to allow only times above or equal to a lower limit * Data Validation to allow a certain text length ____________________________________________ Data Validation Part 4 : https://youtu.be/ZTlymO0uug4 * Allow only numbers in cell & Set limit of digits to accept. * Allow only text in cell & set character limit to accept. * Allow only 10 digit mobile number in cell ____________________________________________ Data Validation Part 5 :https://youtu.be/vzeWlggal88 * Prevent Duplicate Entries In Column * Allow Only Unique Entries - Avoid duplicate entries in excel using custom data validation. ____________________________________________ Data Validation Part 6: https://youtu.be/EX2ZahZ3pHo Auto Updating DropDown List In Excel Hindi || Dynamic DropDown List ____________________________________________ Data Validation Part 7:https://youtu.be/Ig245IO7lPs How To Create Data Validation Dependent Drop Down List In Excel || Best Video || Hindi || HD ____________________________________________ Data Validation Part 8:https://youtu.be/tn4ShvcvBls EXCEL ये विडियो जरूर देखें - Allow Only Entries Starting With Specific Alphabet / Text /Number ____________________________________________ Data Validation Part 9:https:https://youtu.be/WULhnIsKguU Custom Data Validation- To Allow only Uppercase Text Entries In Excel ____________________________________________ Data Validation Part 10:https:https://youtu.be/HwVbH_x6nMk How To Create Searchable Drop Down List In Excel || Hindi || HD ____________________________________________ Data Validation Part 11:https:https://youtu.be/-IDqfwby5MM how to create drop down list from another sheet in excel || Hindi | using data validation ____________________________________________ Data Validation Part 12:https://youtu.be/EX2ZahZ3pHo Data Validation Auto Updating DropDown List In Excel Hindi || Dynamic DropDown List ____________________________________________ Data Validation Part 13:https://youtu.be/e6R4zZdlxHY EXCEL में Data Entry करने वाले जरूर देखे 👍 5 Cool Custom Data validation Tips Everyone should know Hope you will like the video. Thanks for watching. Deepak EduWorld के दुआरा publish की हुई playlist इस प्रकार हैं _____________________________________________________________ ADVANCED MS EXCEL के लिए ये playlists देखे: https://goo.gl/A6LdZA ADVANCED MS EXCEL FORMULAS के लिए ये playlists देखे: https://goo.gl/bbHYu2 MS WORD के लिए ये playlist देखे: https://goo.gl/B4TeSA HTML5 & CSS3 के लिए ये playlist देखे: https://goo.gl/2PFgs8 COMPUTER के TECHNICAL videos के लिए ये playlist देखे: https://goo.gl/paZmpn --------------------------------------------------------------------------- ---------------------- --------------------------------------------------------------------------- ---------------------- Subscribe to my channel: https://www.youtube.com/deepakeduworld Like my Facebook page: https://www.facebook.com/deepakeduworld Follow on LinkedIn: https://www.linkedin.com/in/deepakedu... Facebook Group : https://www.facebook.com/groups/cse92/ *********************************************************** Thanks for Watching Happy Learning DEEPAK NEHRA ***********************************************************
Views: 12903 Deepak EduWorld
HLOOKUP in excel with example in Hindi
 
11:34
HLOOKUP in excel in Hindi इस विडियो में आप जानेगे Hlookup Formula [ function ] का उपयोग करना Hlookup and vvlookup are very similar - in hindi with Examples in MS excel 2007/2010/2016/2013. hlookup vs vlookup In this video you will learn how to use Hlookup formula in MS Excel in hindi. HLOOKUP() function in Excel. Also Explains how it works and teaches you how to use it. Also compare it to the VLOOKUP() function and explaine the difference between hlookup and vlookup. how to use hlookup in excel 2007 step by step with example The formulas are the power of excel. The more formulas you remember the more proficient you become in excel. Watch this video to learn how to use Hlookup and Vlookup formula in hindi. Microsoft word 2010 2007 2013 2016. ADVANCED MS EXCEL के videos के लिए देखे ये playlists https://www.youtube.com/playlist?list=PLVevUWkXP6J1kCWdOZof-htD4CbFRjvrT VLOOKUP formula video link : https://youtu.be/S2rF6bHIbdA how to use averageif formula in hindi https://youtu.be/7Etgj4X8_Vo how to use sumif formula in hindi https://youtu.be/QcDv6Vvrcsg how to use sumifs formula in hindi https://youtu.be/rDaTTrW6N_0 how to use countif formula in hindi https://youtu.be/HgFHx17PPcc Hope you will like the video. Thanks for watching. ------------------------------------------------------------------- ------------------------------------------------------------------- Subscribe to my channel: https://www.youtube.com/deepakeduworld ------------------------------------------------------------------- ------------------------------------------------------------------- like my facebook page: https://www.facebook.com/deepakeduworld ------------------------------------------------------------------- ------------------------------------------------------------------- my facebook profile: https://www.facebook.com/nehra92 ------------------------------------------------------------------- ------------------------------------------------------------------- follow on linkedin: https://www.linkedin.com/in/deepakeduworld Deepak EduWorld के दुआरा publish की हुई playlist इस प्रकार हैं _____________________________________________________________ MS WORD के videos के लिए ये playlist देखे https://www.youtube.com/playlist?list=PLVevUWkXP6J3lZyL-Kj823ODQg1KCipzZ _____________________________________________________________ ADVANCED MS EXCEL के videos के लिए देखे ये playlists https://www.youtube.com/playlist?list=PLVevUWkXP6J1kCWdOZof-htD4CbFRjvrT _____________________________________________________________ HTML5 & CSS3 के videos के लिए ये playlist देखे https://www.youtube.com/playlist?list=PLVevUWkXP6J31sl4Crvx-RUiJcIMw7p3C _____________________________________________________________ COMPUTER के TECHNICAL videos के लिए ये playlist देखे https://www.youtube.com/playlist?list=PLVevUWkXP6J3qcZy11BxbUNRVTMBvzdwe _____________________________________________________________ _____________________________________________________________
Views: 221648 Deepak EduWorld
Excel 10 Fantastic Hidden Tips & Tricks To Make You PRO Hindi || Best Time Saving Excel Tips
 
10:11
learn MS Excel 10 Fantastic Hidden super secrates Tips & Tricks which make you the master of excel. i will show you excel Best Time Saving Tips and tricks for all ms excel versions 2007 2010 2013 2016 1. Sort Left to Right 2. Save Excel Document as PDF 3. Format only Non-blank cells in Excel 4. Quickly Delete Data 5. Adding Multiple Rows or Columns At Once 6. Compose text with “&” 7. create your own shortcuts! 8. Transpose your values 9. Quickly Fit Column Width 10. Add '0' before number Hope you will like the video. Thanks for watching. Deepak EduWorld के दुआरा publish की हुई playlist इस प्रकार हैं ________________________________________________ ADVANCED MS EXCEL के लिए ये playlists देखे ► https://goo.gl/A6LdZA ADVANCED MS EXCEL FORMULAS के लिए ये playlists देखे ► https://goo.gl/bbHYu2 MS WORD के लिए ये playlist देखे ► https://goo.gl/B4TeSA HTML5 & CSS3 के लिए ये playlist देखे ► https://goo.gl/2PFgs8 COMPUTER के TECHNICAL videos के लिए ये playlist देखे ► https://goo.gl/paZmpn --------------------------------------------------------------------------- --------------------------------------------------------------------------- Subscribe to my channel ► https://www.youtube.com/deepakeduworld Like my Facebook page ► https://www.facebook.com/deepakeduworld Follow on LinkedIn ► https://www.linkedin.com/in/deepakeduworld Facebook Group ► https://www.facebook.com/groups/cse92/ ********************************************** Thanks for Watching Happy Learning ER DEEPAK NEHRA [ M.Tech. ] **********************************************
Views: 150381 Deepak EduWorld
How To Use SUMPRODUCT formula in excel - Hindi
 
04:54
SUMPRODUCT formula in excel- Hindi - The Microsoft Excel SUMPRODUCT function multiplies the corresponding items in the arrays and returns the sum of the results. The SUMPRODUCT function is a built-in function in Excel that is categorized as a Math/Trig Function. It can be used as a worksheet function (WS) in Excel. As a worksheet function, the SUMPRODUCT function can be entered as part of a formula in a cell of a worksheet. Returns :: The SUMPRODUCT function returns a numeric value. If all arrays provided as parameters do not have the same number of rows and columns, the SUMPRODUCT function will return the #VALUE! error. Note :: If there are non-numeric values in the arrays, these values are treated as 0's by the SUMPRODUCT function. Applies To :: Excel 2016, Excel 2013, Excel 2011 for Mac, Excel 2010, Excel 2007, Excel 2003, Excel XP, Excel 2000 Example (as Worksheet Function): Let's look at some Excel SUMPRODUCT function examples and explore how to use the SUMPRODUCT function as a worksheet function in Microsoft Excel: =SUMPRODUCT({1,2;3,4}, {5,6;7,8}) Result: 70 The above example would return 70. The SUMPRODUCT calculates these arrays as follows: =(1*5) + (2*6) + (3*7) + (4*8) Result: 70 Hope you will like the video. Thanks for watching. ------------------------------------------------------------------- ------------------------------------------------------------------- Subscribe to my channel: https://www.youtube.com/deepakeduworld ------------------------------------------------------------------- ------------------------------------------------------------------- like my facebook page: https://www.facebook.com/deepakeduworld ------------------------------------------------------------------- ------------------------------------------------------------------- my facebook profile: https://www.facebook.com/nehra92 ------------------------------------------------------------------- ------------------------------------------------------------------- follow on linkedin: https://www.linkedin.com/in/deepakeduworld Deepak EduWorld के दुआरा publish की हुई playlist इस प्रकार हैं _____________________________________________________________ MS WORD के videos के लिए ये playlist देखे https://www.youtube.com/playlist?list=PLVevUWkXP6J3lZyL-Kj823ODQg1KCipzZ _____________________________________________________________ ADVANCED MS EXCEL के videos के लिए देखे ये playlists https://www.youtube.com/playlist?list=PLVevUWkXP6J1kCWdOZof-htD4CbFRjvrT _____________________________________________________________ HTML5 & CSS3 के videos के लिए ये playlist देखे https://www.youtube.com/playlist?list=PLVevUWkXP6J31sl4Crvx-RUiJcIMw7p3C _____________________________________________________________ COMPUTER के TECHNICAL videos के लिए ये playlist देखे https://www.youtube.com/playlist?list=PLVevUWkXP6J3qcZy11BxbUNRVTMBvzdwe _____________________________________________________________ _____________________________________________________________
Views: 10198 Deepak EduWorld
how to protect word document with password in Hindi |  word 2007 2010 2013 2016
 
03:49
how to protect word document with password in hindi microsoft word 2007 2013 2010 2016 adding password to existing file documents or new documents . you can secure & lock your persnol documents by adding password. watch this video to learn how to secure protect and lock word documents in hindi Hope you will like the video. Thanks for watching. ------------------------------------------------------------------- ------------------------------------------------------------------- Subscribe to my channel: https://www.youtube.com/deepakeduworld ------------------------------------------------------------------- ------------------------------------------------------------------- like my facebook page: https://www.facebook.com/deepakeduworld ------------------------------------------------------------------- ------------------------------------------------------------------- my facebook profile: https://www.facebook.com/nehra92 ------------------------------------------------------------------- ------------------------------------------------------------------- follow on linkedin: https://www.linkedin.com/in/deepakeduworld Deepak EduWorld ?? ????? publish ?? ??? playlist ?? ?????? ??? _____________________________________________________________ MS WORD ?? videos ?? ??? ?? playlist ???? https://www.youtube.com/playlist?list=PLVevUWkXP6J3lZyL-Kj823ODQg1KCipzZ _____________________________________________________________ ADVANCED MS EXCEL ?? videos ?? ??? ???? ?? playlists https://www.youtube.com/playlist?list=PLVevUWkXP6J1kCWdOZof-htD4CbFRjvrT _____________________________________________________________ HTML5 & CSS3 ?? videos ?? ??? ?? playlist ???? https://www.youtube.com/playlist?list=PLVevUWkXP6J31sl4Crvx-RUiJcIMw7p3C _____________________________________________________________ COMPUTER ?? TECHNICAL videos ?? ??? ?? playlist ???? https://www.youtube.com/playlist?list=PLVevUWkXP6J3qcZy11BxbUNRVTMBvzdwe _____________________________________________________________ _____________________________________________________________
Views: 14023 Deepak EduWorld
pivot table in excel in Hindi | summarize data using pivot table
 
15:07
pivot table in excel - How to insert pivot table in excel 2007/2010/2013/206 in Hindi -Have you ever Summarize Data using pivot table & Createb a Best Pivot Table Report ?? Don't worry if you have never created a Pivot Table & Report before, Deepak EduWorld showing you how to insert a pivot table in excel in hindi- You can also learn how to use pivot charts . the link for pivot charts is given below and In this video i show you How to make pivot table How to Create a Pivot Table report How to prepare a pivot table report using row and column labels. How to sort data in pivot table report in Microsoft excel 2007/ excel 2010/ excel 2016 and excel 2013. Pivot Table Works with Excel 2003, 2007, 2010, 2013 for Windows & Excel 2011 for Mac Pivot Table for beginners [ pivot table 1st video ] https://youtu.be/4A6hjD-61gM How to Insert Pivot Charts in Excel https://youtu.be/RPwInuv-V_Q How to Insert Charts in Excel 2007 2010 2013 2016 in hindi https://youtu.be/akZBShNCj7g How to insert / create / use Pivot tables 2007 2010 2013 2016 in hindi https://youtu.be/4A6hjD-61gM HLOOKUP formula In Hindi https://youtu.be/DyH3PY3qbIE VLOOKUP formula In Hindi https://youtu.be/S2rF6bHIbdA Hope you will like the video. Thanks for watching. ------------------------------------------------------------------- ------------------------------------------------------------------- Subscribe to my channel: https://www.youtube.com/deepakeduworld ------------------------------------------------------------------- ------------------------------------------------------------------- like my facebook page: https://www.facebook.com/deepakeduworld ------------------------------------------------------------------- ------------------------------------------------------------------- my facebook profile: https://www.facebook.com/nehra92 ------------------------------------------------------------------- ------------------------------------------------------------------- follow on linkedin: https://www.linkedin.com/in/deepakeduworld Deepak EduWorld के दुआरा publish की हुई playlist इस प्रकार हैं _____________________________________________________________ MS WORD के videos के लिए ये playlist देखे https://www.youtube.com/playlist?list=PLVevUWkXP6J3lZyL-Kj823ODQg1KCipzZ _____________________________________________________________ ADVANCED MS EXCEL के videos के लिए देखे ये playlists https://www.youtube.com/playlist?list=PLVevUWkXP6J1kCWdOZof-htD4CbFRjvrT _____________________________________________________________ HTML5 & CSS3 के videos के लिए ये playlist देखे https://www.youtube.com/playlist?list=PLVevUWkXP6J31sl4Crvx-RUiJcIMw7p3C _____________________________________________________________ COMPUTER के TECHNICAL videos के लिए ये playlist देखे https://www.youtube.com/playlist?list=PLVevUWkXP6J3qcZy11BxbUNRVTMBvzdwe _____________________________________________________________ _____________________________________________________________
Views: 105773 Deepak EduWorld
Vlookup in multiple sheets in excel || In Hindi - Very Easy
 
08:25
vlookup in multiple sheets in excel 2016 2013 2010 2007 Hindi - Vlookup - lookup a value based on a single criteria across multiple sheets - How to use Vlookup from another sheet [ Across multiple different sheets ] , in Hindi - vlookup from one sheet to another in hindi vlookup from 2 different sheets Vlookup in different sheets with example how to use vlookup in hindi, How to create drop down list from another sheet in excel || Hindi | using data validation https://youtu.be/-IDqfwby5MM How To Fix Excel Formula Errors #NAME? | #VALUE! | #REF! | #DIV/0! | ###### In Hindi https://youtu.be/CajffOjtjGo how to use sumif formula in hindi https://youtu.be/QcDv6Vvrcsg how to use sumifs formula in hindi https://youtu.be/rDaTTrW6N_0 how to use countif formula in hindi https://youtu.be/HgFHx17PPcc VLOOKUP VIDEO SERIES: 1. vlookup in excel with example in Hindi https://youtu.be/S2rF6bHIbdA 2. How to use vlookup for multiple values || Trick to use vlookup for large data https://youtu.be/oSE4wSy02s8 3. Vlookup in multiple sheets in excel || In Hindi https://youtu.be/fpslxPp3_Cw 4. How To Use Double VLookup in Excel-Nested vlookup https://youtu.be/REBdKbbvwG0 5. Dynamically Updated Vlookup Formula in Excel https://youtu.be/IHD6XIDrCfk 6. How To Use Vlookup With Multiple Excel Workbooks https://youtu.be/CiHIbsRM3cg 7. HLOOKUP in excel with example in Hindi https://youtu.be/DyH3PY3qbIE Hope you will like the video. Thanks for watching. Deepak EduWorld के दुआरा publish की हुई playlist इस प्रकार हैं ________________________________________________ ADVANCED MS EXCEL के लिए ये playlists देखे ► https://goo.gl/A6LdZA ADVANCED MS EXCEL FORMULAS के लिए ये playlists देखे ► https://goo.gl/bbHYu2 MS WORD के लिए ये playlist देखे ► https://goo.gl/B4TeSA HTML5 & CSS3 के लिए ये playlist देखे ► https://goo.gl/2PFgs8 COMPUTER के TECHNICAL videos के लिए ये playlist देखे ► https://goo.gl/paZmpn --------------------------------------------------------------------------- --------------------------------------------------------------------------- Subscribe to my channel ► https://www.youtube.com/deepakeduworld Like my Facebook page ► https://www.facebook.com/deepakeduworld Follow on LinkedIn ► https://www.linkedin.com/in/deepakeduworld Facebook Group ► https://www.facebook.com/groups/cse92/ ********************************************** Thanks for Watching Happy Learning ER DEEPAK NEHRA [ M.Tech. ] **********************************************
Views: 199912 Deepak EduWorld
Excel - 4 Smart 👌Advanced Custom Conditional Formatting Tips [ New Rules ] To Make You 😎Smart
 
10:56
Advanced Excel - 4 Smart Amazing Advanced Custom Conditional Formatting Tips [ New Rules ] To Make You Smart. Custom Conditional formatting is really easy to use once you understand the rule behind it. This video shows you how how you can use your custom formulas in conditional formatting rules in Excel and conditionally format them to change color depending whether a condition is met or not. In this lecture you will learn how you can use conditional formatting smartly to highlight - 1. Highlight column values 2. Highlight Entire Row 3. Highlight Entire Column 4. Highlight Entire Row Learn how to use conditional formatting to change the look of cells in your sheet when they meet certain conditions. Download Training File https://drive.google.com/file/d/1e8nGEhtYeostc20mcs_aCs3kzq3HuPiq/view?usp=sharing Advanced Excel 5 Super Hidden Secrets & Data Hiding Tips & Tricks To Make You SmArT https://youtu.be/TGsaIpDQPkA Vlookup In Excel - VLOOKUP VIDEO SERIES: 1. vlookup in excel with example in Hindi https://youtu.be/S2rF6bHIbdA 2. How to use vlookup for multiple values || Trick to use vlookup for large data https://youtu.be/oSE4wSy02s8 3. Vlookup in multiple sheets in excel || In Hindi https://youtu.be/fpslxPp3_Cw 4. How To Use Double VLookup in Excel-Nested vlookup https://youtu.be/REBdKbbvwG0 5. Dynamically Updated Vlookup Formula in Excel https://youtu.be/IHD6XIDrCfk 6. How To Use Vlookup With Multiple Excel Workbooks https://youtu.be/CiHIbsRM3cg 7. VLOOKUP With MATCH Function In Excel https://youtu.be/O19XraNl9ZQ 8. HLOOKUP in excel with example in Hindi https://youtu.be/DyH3PY3qbIE 9. Hlookup With Match Function in Excel in Hindi https://youtu.be/JIN0NBVuEsg Hope you will like the video. Thanks for watching. Deepak EduWorld के दुआरा publish की हुई playlist इस प्रकार हैं ________________________________________________ ADVANCED MS EXCEL ► https://goo.gl/A6LdZA ADVANCED MS EXCEL FORMULAS ► https://goo.gl/bbHYu2 MS WORD ► https://goo.gl/B4TeSA HTML5 & CSS3 ► https://goo.gl/2PFgs8 COMPUTER Tips & Tricks ► https://goo.gl/paZmpn --------------------------------------------------------------------------- --------------------------------------------------------------------------- Subscribe to my channel ► https://www.youtube.com/deepakeduworld Like my Facebook page ► https://www.facebook.com/deepakeduworld Follow on LinkedIn ► https://www.linkedin.com/in/deepakedu... Facebook Group ► https://www.facebook.com/groups/cse92/ ********************************************** Thanks for Watching Happy Learning ER DEEPAK NEHRA [ M.Tech. ] **********************************************
Views: 43582 Deepak EduWorld
😮 Master Trick 👉 Excel में हजारो लाखो  Blank Cells को Seconds में fill करना सीख लो
 
05:36
MS Excel Master Trick: How to fill in empty cells using data from above just in seconds, so you don't have any gaps left.... Let's assume that you have excel sheet contain a lot of blank cells under the heads in a particular column. Now you want to pick up these blank cells from the range, and select them. Of course, you can select each blank cell one by one manually, which may be time-consuming and tedious.... Here in this video I will introduce a Magic trick to quickly select all blank cells using Go-To Special and fill these up with their headers within seconds. Hope you will like the video. Thanks for watching. Deepak EduWorld के दुआरा publish की हुई playlist इस प्रकार हैं _____________________________________________ ADVANCED MS EXCEL के लिए ये playlists देखे: https://goo.gl/A6LdZA ADVANCED MS EXCEL FORMULAS के लिए ये playlists देखे: https://goo.gl/bbHYu2 MS WORD के लिए ये playlist देखे: https://goo.gl/B4TeSA HTML5 & CSS3 के लिए ये playlist देखे: https://goo.gl/2PFgs8 COMPUTER के TECHNICAL videos के लिए ये playlist देखे: https://goo.gl/paZmpn --------------------------------------------------------------- -------------------------------------------------------------- Subscribe to my channel: https://www.youtube.com/deepakeduworld Like my Facebook page: https://www.facebook.com/deepakeduworld Follow on LinkedIn: https://www.linkedin.com/in/deepakedu... Facebook Group : https://www.facebook.com/groups/cse92/ **************************************************************** Thanks for Watching Happy Learning DEEPAK NEHRA ****************************************************************
Views: 20714 Deepak EduWorld
Excel Trick To SUM Numbers Containing Text Like 10kg 20kg 12 pcs 14 pcs Etc In HINDI
 
10:09
Excel fentestic Trick To SUM Numbers Containing Text Like 10kg 20kg 12 pcs 14 pcs Etc In HINDI learn how add / sum units in excel kg pecies dozones. here in this microsoft excel video i will show you how we can calculate numbers contains tex or stored as text in excel 2007 2010 2013 2016. i will show you by two methods. first one is by using array formula with substitute formula. the substitute formula is use to replace the give text string from a selected text string. also we have to use same substitute formula to convert text into numbers. we can apply this first method if we have already a big data stored in excel sheet. but if you are going to maintain data haing units such as kg pecies dozons. then the 2nd method is very intresting .. and very easy.. without any excel formula so watch complete video Hope you will like the video. Thanks for watching. Deepak EduWorld के दुआरा publish की हुई playlist इस प्रकार हैं ________________________________________________ ADVANCED MS EXCEL के लिए ये playlists देखे ► https://goo.gl/A6LdZA ADVANCED MS EXCEL FORMULAS के लिए ये playlists देखे ► https://goo.gl/bbHYu2 MS WORD के लिए ये playlist देखे ► https://goo.gl/B4TeSA HTML5 & CSS3 के लिए ये playlist देखे ► https://goo.gl/2PFgs8 COMPUTER के TECHNICAL videos के लिए ये playlist देखे ► https://goo.gl/paZmpn --------------------------------------------------------------------------- --------------------------------------------------------------------------- Subscribe to my channel ► https://www.youtube.com/deepakeduworld Like my Facebook page ► https://www.facebook.com/deepakeduworld Follow on LinkedIn ► https://www.linkedin.com/in/deepakeduworld Facebook Group ► https://www.facebook.com/groups/cse92/ ********************************************** Thanks for Watching Happy Learning ER DEEPAK NEHRA [ M.Tech. ] **********************************************
Views: 41721 Deepak EduWorld
How To Use Match Formula In Excel in Hindi
 
06:00
Match Formula In Excel in hindi In this Excel video you will learn match formula one of the most important Excel function using Microsoft Excel 2016, 2013, 2010 or 2007 - for Beginners or Advanced users. this is very simple function which return the position of a lookup value from an array. but its very powerful when we use this match formula with vlookup, hlookup,index formulas. its very intresting to use match with index,vlookup,hlookup function. i will publish many more videos on this match function with other formulas shortly. Hope you will like the video. Thanks for watching. Deepak EduWorld के दुआरा publish की हुई playlist इस प्रकार हैं ________________________________________________ ADVANCED MS EXCEL ► https://goo.gl/A6LdZA ADVANCED MS EXCEL FORMULAS ► https://goo.gl/bbHYu2 MS WORD ► https://goo.gl/B4TeSA HTML5 & CSS3 ► https://goo.gl/2PFgs8 COMPUTER Tips & Tricks ► https://goo.gl/paZmpn --------------------------------------------------------------------------- --------------------------------------------------------------------------- Subscribe to my channel ► https://www.youtube.com/deepakeduworld Like my Facebook page ► https://www.facebook.com/deepakeduworld Follow on LinkedIn ► https://www.linkedin.com/in/deepakeduworld Facebook Group ► https://www.facebook.com/groups/cse92/ ********************************************** Thanks for Watching Happy Learning ER DEEPAK NEHRA [ M.Tech. ] **********************************************
Views: 23741 Deepak EduWorld
countif formula in excel in hindi
 
04:26
countif formula in excel in hindi - excel formula & functions 2007 2010 2013 & 2016 in detail with 5 different examples on date days text etc. countif is very similar to sumif excel function formula and countifs is very similar to sumifs function [ formula] the working of these formulas count counta countif countifs sunif sumifs etc is same in any of microsoft excel version 2007 2010 2013 & 2016. how to use countif formula in excel in hindi - Countif Formula can help you Count the number of cells which contain any specific data defined by you . With countif formula [ function ] of excel we can easily count the no of records that match a specific condition. the name itself "countif" tells that count the records for a condition. countif formula is one of most ever usefull formula in excel. and In this video i explained the Countif formula of Excel [ countif function in excel in hindi ]with practical example in Hindi. countif in excel 2007 with example [ for text and multiple criteria ] i have already published a video on sumif sumifs vlookup hlookp formulas in excel in hindi. to watch sumif sumifs vlookup hlookp formula in excel please visit our Advanced Excel Playlist Sumif video link https://youtu.be/QcDv6Vvrcsg Sumifs video link https://youtu.be/rDaTTrW6N_0 VLOOKUP formula video link : https://youtu.be/S2rF6bHIbdA Hope you will like the video. Thanks for watching. ------------------------------------------------------------------- ------------------------------------------------------------------- Subscribe to my channel: https://www.youtube.com/deepakeduworld ------------------------------------------------------------------- ------------------------------------------------------------------- like my facebook page: https://www.facebook.com/deepakeduworld ------------------------------------------------------------------- ------------------------------------------------------------------- my facebook profile: https://www.facebook.com/nehra92 ------------------------------------------------------------------- ------------------------------------------------------------------- follow on linkedin: https://www.linkedin.com/in/deepakeduworld Deepak EduWorld के दुआरा publish की हुई playlist इस प्रकार हैं _____________________________________________________________ MS WORD के videos के लिए ये playlist देखे https://www.youtube.com/playlist?list=PLVevUWkXP6J3lZyL-Kj823ODQg1KCipzZ _____________________________________________________________ ADVANCED MS EXCEL के videos के लिए देखे ये playlists https://www.youtube.com/playlist?list=PLVevUWkXP6J1kCWdOZof-htD4CbFRjvrT _____________________________________________________________ HTML5 & CSS3 के videos के लिए ये playlist देखे https://www.youtube.com/playlist?list=PLVevUWkXP6J31sl4Crvx-RUiJcIMw7p3C _____________________________________________________________ COMPUTER के TECHNICAL videos के लिए ये playlist देखे https://www.youtube.com/playlist?list=PLVevUWkXP6J3qcZy11BxbUNRVTMBvzdwe _____________________________________________________________ _____________________________________________________________
Views: 10109 Deepak EduWorld
How to convert excel , word, powerpoint to PDF | Hindi  | offline without software | within 5 second
 
02:42
How to convert excel to PDF word to PDF powerpoint to PDF in hindi. without software | offline without internet MS OFFICE HIDDEN Feature easily conver any excel 2007,2010,2013 and 2016 file into pdf - convert excel to pdf, convert word to pdf, convert power point to pdf, convert pdf to word, convert pdf to excel. easy convert any file format just in 5 seconds. Window 7, window 8, window xp, window 10 Hope you will like the video. Thanks for watching. ------------------------------------------------------------------- ------------------------------------------------------------------- Subscribe to my channel: https://www.youtube.com/deepakeduworld ------------------------------------------------------------------- ------------------------------------------------------------------- like my facebook page: https://www.facebook.com/deepakeduworld ------------------------------------------------------------------- ------------------------------------------------------------------- my facebook profile: https://www.facebook.com/nehra92 ------------------------------------------------------------------- ------------------------------------------------------------------- follow on linkedin: https://www.linkedin.com/in/deepakeduworld Deepak EduWorld के दुआरा publish की हुई playlist इस प्रकार हैं _____________________________________________________________ MS WORD के videos के लिए ये playlist देखे https://www.youtube.com/playlist?list=PLVevUWkXP6J3lZyL-Kj823ODQg1KCipzZ _____________________________________________________________ ADVANCED MS EXCEL के videos के लिए देखे ये playlists https://www.youtube.com/playlist?list=PLVevUWkXP6J1kCWdOZof-htD4CbFRjvrT _____________________________________________________________ HTML5 & CSS3 के videos के लिए ये playlist देखे https://www.youtube.com/playlist?list=PLVevUWkXP6J31sl4Crvx-RUiJcIMw7p3C _____________________________________________________________ COMPUTER के TECHNICAL videos के लिए ये playlist देखे https://www.youtube.com/playlist?list=PLVevUWkXP6J3qcZy11BxbUNRVTMBvzdwe _____________________________________________________________ _____________________________________________________________
Views: 13513 Deepak EduWorld
How To Easily Find and Delete Duplicate Data Entries In Excel HINDI
 
08:31
How To Easily Find and Delete Duplicate Data Entries In Excel HINDI - 2007 2010 2013 2016 its very easy to find duplicate records & delete duplicate records from excel data. Find and Remove Repeated Data Entries. Hope you will like the video. Thanks for watching. ------------------------------------------------------------------- ------------------------------------------------------------------- Subscribe to my channel: https://www.youtube.com/deepakeduworld ------------------------------------------------------------------- ------------------------------------------------------------------- like my facebook page: https://www.facebook.com/deepakeduworld ------------------------------------------------------------------- ------------------------------------------------------------------- my facebook profile: https://www.facebook.com/nehra92 ------------------------------------------------------------------- ------------------------------------------------------------------- follow on linkedin: https://www.linkedin.com/in/deepakeduworld Deepak EduWorld के दुआरा publish की हुई playlist इस प्रकार हैं _____________________________________________________________ MS WORD के videos के लिए ये playlist देखे https://www.youtube.com/playlist?list=PLVevUWkXP6J3lZyL-Kj823ODQg1KCipzZ _____________________________________________________________ ADVANCED MS EXCEL के videos के लिए देखे ये playlists https://www.youtube.com/playlist?list=PLVevUWkXP6J1kCWdOZof-htD4CbFRjvrT _____________________________________________________________ ADVANCED MS EXCEL FORMULAS के videos के लिए देखे ये playlists https://www.youtube.com/playlist?list=PLVevUWkXP6J2jsiIpCRjtOQvcMecQ49kw _____________________________________________________________ HTML5 & CSS3 के videos के लिए ये playlist देखे https://www.youtube.com/playlist?list=PLVevUWkXP6J31sl4Crvx-RUiJcIMw7p3C _____________________________________________________________ COMPUTER के TECHNICAL videos के लिए ये playlist देखे https://www.youtube.com/playlist?list=PLVevUWkXP6J3qcZy11BxbUNRVTMBvzdwe _____________________________________________________________ Thanks for Watching Happy Learning DEEPAK NEHRA ____________________________________________________________
Views: 33015 Deepak EduWorld
Index + Match Function in Excel - Father of Vlookup || Best Ever Explanation in Hindi
 
13:10
index match function in excel - Watch this video tutorial to find out how you can use Index & Match for more complex lookup problems which cant be solved by vlookup. when we use index match together its became more powerfull than vlookup. This video shows you how Index Match works with simple and to the point best explanation. It first shows you how Index works on it's own and then how Match works and then puts the two Excel functions together. watch this video to know about index match excel formulas in hindi in ms excel 2007 2010 2016 2013.Father of Vlookup Download Training File https://drive.google.com/open?id=1a_L9uu0D3gLtYXhc2AkcV69lpXEEk6Yw Index Formula in Excel - Vlookup से भी Powerful कैसे है ये index function - देखिये https://youtu.be/WhUo27TaWvg MATCH FUNCTION VIDEOS SERIES: 1. Match Formula In Excel https://youtu.be/yx_pBagPvnw 2. VLOOKUP With MATCH Function In Excel || 2D Lookup https://youtu.be/O19XraNl9ZQ 3. Hlookup With Match Function in Excel in Hindi https://youtu.be/JIN0NBVuEsg VLOOKUP VIDEO SERIES: 1. vlookup in excel with example in Hindi https://youtu.be/S2rF6bHIbdA 2. How to use vlookup for multiple values || Trick to use vlookup for large data https://youtu.be/oSE4wSy02s8 3. Vlookup in multiple sheets in excel || In Hindi https://youtu.be/fpslxPp3_Cw 4. How To Use Double VLookup in Excel-Nested vlookup https://youtu.be/REBdKbbvwG0 5. Dynamically Updated Vlookup Formula in Excel https://youtu.be/IHD6XIDrCfk 6. How To Use Vlookup With Multiple Excel Workbooks https://youtu.be/CiHIbsRM3cg 7. HLOOKUP in excel with example in Hindi https://youtu.be/DyH3PY3qbIE Hope you will like the video. Thanks for watching. Deepak EduWorld के दुआरा publish की हुई playlist इस प्रकार हैं ________________________________________________ ADVANCED MS EXCEL ► https://goo.gl/A6LdZA ADVANCED MS EXCEL FORMULAS ► https://goo.gl/bbHYu2 MS WORD ► https://goo.gl/B4TeSA HTML5 & CSS3 ► https://goo.gl/2PFgs8 COMPUTER Tips & Tricks ► https://goo.gl/paZmpn --------------------------------------------------------------------------- --------------------------------------------------------------------------- Subscribe to my channel ► https://www.youtube.com/deepakeduworld Like my Facebook page ► https://www.facebook.com/deepakeduworld Follow on LinkedIn ► https://www.linkedin.com/in/deepakedu... Facebook Group ► https://www.facebook.com/groups/cse92/ ********************************************** Thanks for Watching Happy Learning ER DEEPAK NEHRA [ M.Tech. ] **********************************************
Views: 81077 Deepak EduWorld
How to UnProtect Excel sheet without knowing password In Hindi || If Forgot
 
10:05
How to UnProtect Excel sheet without knowing password [ If Forgot ] 2007 | 2010 | 2016 | 2013 how to open password protected excel file [ sheet ] Here is Easy Steps to UnProtect Excel sheet if you forgot the password in Hindi. You can easily crack hack remove password from ms excel documents [ sheet ] workbook if you forgot the password . you can easily unlock excel sheet without password, How to unlock open password protected excel worksheet in hindi protect sheet & Lock Cell excel in Hindi 2007 | 2010 | 2016 | 2013 https://youtu.be/AN1JEk8MHZk Hope you will like the video. Thanks for watching. ------------------------------------------------------------------- ------------------------------------------------------------------- Subscribe to my channel: https://www.youtube.com/deepakeduworld ------------------------------------------------------------------- ------------------------------------------------------------------- like my facebook page: https://www.facebook.com/deepakeduworld ------------------------------------------------------------------- ------------------------------------------------------------------- my facebook profile: https://www.facebook.com/nehra92 ------------------------------------------------------------------- ------------------------------------------------------------------- follow on linkedin: https://www.linkedin.com/in/deepakeduworld Deepak EduWorld के दुआरा publish की हुई playlist इस प्रकार हैं _____________________________________________________________ MS WORD के videos के लिए ये playlist देखे https://www.youtube.com/playlist?list=PLVevUWkXP6J3lZyL-Kj823ODQg1KCipzZ _____________________________________________________________ ADVANCED MS EXCEL के videos के लिए देखे ये playlists https://www.youtube.com/playlist?list=PLVevUWkXP6J1kCWdOZof-htD4CbFRjvrT _____________________________________________________________ HTML5 & CSS3 के videos के लिए ये playlist देखे https://www.youtube.com/playlist?list=PLVevUWkXP6J31sl4Crvx-RUiJcIMw7p3C _____________________________________________________________ COMPUTER के TECHNICAL videos के लिए ये playlist देखे https://www.youtube.com/playlist?list=PLVevUWkXP6J3qcZy11BxbUNRVTMBvzdwe _____________________________________________________________ _____________________________________________________________
Views: 49967 Deepak EduWorld
How To Fix Excel Formula Errors #NAME? | #VALUE!  | #REF! | #DIV/0!  | ###### In Hindi
 
08:46
How To Fix Excel Formula Errors #NAME? | #VALUE! | #REF! | #DIV/0! | ###### In Hindi 2007 2010 2013 & 2016 - How to remove errors while working in Microsoft excel,Excel Formula Errors, fixing removing Errors in MS Excel in Hindi errors in excel and their meaning #VALUE! #DIV/0! #REF! #NAME? #### इस विडियो में आप जानेगे Microsoft Excel 2007 2010 2013 & 2016 में काम करते समय आने वाली गलतियों को सुधारना how to correct errors in excel 2007 2010 2013 & 2016 how to solve #value error in excel how to solve #Name error in excel how to solve #Ref error in excel how to solve ##### error in excel how to solve #DIV/0 error in excel how to solve #N/A error in excel दोस्तों sumif , sumifs , countif formula vlookup & Hlookup functions में पहले ही publish कर चूका हूँ sumif , sumifs , countif formula vlookup & Hlookup functions के लिंक निचे दिए हैं आप वहा से सीख सकते हो | दोस्तों ये sumif , sumifs , countif , vlookup & Hlookup formula functions बहुत अच्छे हैं जो advanced excel में आते हैं ये आपको जरुर सीखने चाइये How to use IFERROR Formula https://youtu.be/TF_JAqcPA5w how to use averageif formula in hindi https://youtu.be/7Etgj4X8_Vo how to use sumif formula in hindi https://youtu.be/QcDv6Vvrcsg how to use sumifs formula in hindi https://youtu.be/rDaTTrW6N_0 how to use countif formula in hindi https://youtu.be/HgFHx17PPcc HLOOKUP formula In Hindi https://youtu.be/DyH3PY3qbIE VLOOKUP formula In Hindi https://youtu.be/S2rF6bHIbdA Hope you will like the video. Thanks for watching. ------------------------------------------------------------------- ------------------------------------------------------------------- Subscribe to my channel: https://www.youtube.com/deepakeduworld ------------------------------------------------------------------- ------------------------------------------------------------------- like my facebook page: https://www.facebook.com/deepakeduworld ------------------------------------------------------------------- ------------------------------------------------------------------- my facebook profile: https://www.facebook.com/nehra92 ------------------------------------------------------------------- ------------------------------------------------------------------- follow on linkedin: https://www.linkedin.com/in/deepakeduworld Deepak EduWorld के दुआरा publish की हुई playlist इस प्रकार हैं _____________________________________________________________ MS WORD के videos के लिए ये playlist देखे https://www.youtube.com/playlist?list=PLVevUWkXP6J3lZyL-Kj823ODQg1KCipzZ _____________________________________________________________ ADVANCED MS EXCEL के videos के लिए देखे ये playlists https://www.youtube.com/playlist?list=PLVevUWkXP6J1kCWdOZof-htD4CbFRjvrT _____________________________________________________________ HTML5 & CSS3 के videos के लिए ये playlist देखे https://www.youtube.com/playlist?list=PLVevUWkXP6J31sl4Crvx-RUiJcIMw7p3C _____________________________________________________________ COMPUTER के TECHNICAL videos के लिए ये playlist देखे https://www.youtube.com/playlist?list=PLVevUWkXP6J3qcZy11BxbUNRVTMBvzdwe _____________________________________________________________ _____________________________________________________________
Views: 55563 Deepak EduWorld
IF AND Logical function in excel in Hindi
 
09:12
how to use IF AND function in excel in Hindi - if() formula में AND() Logical Function का उपयोग कैसे करें || इस वीडियो में full explanation के साथ देखें | MS Excel 2007 / 2013/ 2016 /2013 logical formula IF, AND in hindi - How to Use The IF and And Function in Excel. This excellent tutorial has been created by a professional Excel tutor. It demonstrates how to use both the IF and AND Excel functions in a single formula. IF formula पढ़ने के लिए इस लिंक पर क्लिक करें | https://youtu.be/l2RjYPd-CIo?list=PLVevUWkXP6J1kCWdOZof-htD4CbFRjvrT Hope you will like the video. Thanks for watching. ------------------------------------------------------------------- ------------------------------------------------------------------- Subscribe to my channel: https://www.youtube.com/deepakeduworld ------------------------------------------------------------------- ------------------------------------------------------------------- like my facebook page: https://www.facebook.com/deepakeduworld ------------------------------------------------------------------- ------------------------------------------------------------------- my facebook profile: https://www.facebook.com/nehra92 ------------------------------------------------------------------- ------------------------------------------------------------------- follow on linkedin: https://www.linkedin.com/in/deepakeduworld Deepak EduWorld के दुआरा publish की हुई playlist इस प्रकार हैं _____________________________________________________________ MS WORD के videos के लिए ये playlist देखे https://www.youtube.com/playlist?list=PLVevUWkXP6J3lZyL-Kj823ODQg1KCipzZ _____________________________________________________________ ADVANCED MS EXCEL के videos के लिए देखे ये playlists https://www.youtube.com/playlist?list=PLVevUWkXP6J1kCWdOZof-htD4CbFRjvrT _____________________________________________________________ HTML5 & CSS3 के videos के लिए ये playlist देखे https://www.youtube.com/playlist?list=PLVevUWkXP6J31sl4Crvx-RUiJcIMw7p3C _____________________________________________________________ COMPUTER के TECHNICAL videos के लिए ये playlist देखे https://www.youtube.com/playlist?list=PLVevUWkXP6J3qcZy11BxbUNRVTMBvzdwe _____________________________________________________________ _____________________________________________________________
Views: 41389 Deepak EduWorld
Excel में  Number /  Indian Rupees को  Words में Convert करने का Permanent Solution ये रहा
 
07:58
convert number to words in excel - Excel में Numbers या Indian Rupees को Words में Convert करने का Permanent Soluation ऐसे करे - अब बार बार आपको settings नहीं करनी पड़ेंगी How To Convert Number To Words in Excel Hindi. Easily convert a numeric value into english words [ indian rupees ]. MS Excel does't have any inbuilt feature to convert number to word [ text ] in excel - but we can convert any amount or number into word [ indian rupees ] in MS excel using spellnumber formula. and this is permanent soluation. numeric to figure, amount, rupee, indian ruppes, rupees, paise, paise, dollars, converting, automatically, Download Link : https://drive.google.com/open?id=1vTXdNezeiqchHTzdX1swvYtuhxMkuuZR If you are unable to download this excel file from above link then try this. download the zip file and extract it on your computer ans use Link is https://drive.google.com/open?id=1lQIWoKzErlh5I_xYl61bTIPaEbpNRXF2 Learn How to Use spellnumber formula to convert any number into words : Hope you will like the video. Thanks for watching. Deepak EduWorld के दुआरा publish की हुई playlist इस प्रकार हैं ________________________________________________ ADVANCED MS EXCEL के लिए ये playlists देखे ► https://goo.gl/A6LdZA ADVANCED MS EXCEL FORMULAS के लिए ये playlists देखे ► https://goo.gl/bbHYu2 MS WORD के लिए ये playlist देखे ► https://goo.gl/B4TeSA HTML5 & CSS3 के लिए ये playlist देखे ► https://goo.gl/2PFgs8 COMPUTER के TECHNICAL videos के लिए ये playlist देखे ► https://goo.gl/paZmpn --------------------------------------------------------------------------- --------------------------------------------------------------------------- Subscribe to my channel ► https://www.youtube.com/deepakeduworld Like my Facebook page ► https://www.facebook.com/deepakeduworld Follow on LinkedIn ► https://www.linkedin.com/in/deepakeduworld Facebook Group ► https://www.facebook.com/groups/cse92/ ********************************************** Thanks for Watching Happy Learning ER DEEPAK NEHRA [ M.Tech. ] **********************************************
Views: 33105 Deepak EduWorld
Excel Formula Tab in Hindi - How To Use Name Manager And Define Name in EXCEL | In Hindi
 
12:43
Excel formula tab menu in Hindi - How To Use Name Manager And Define Name in EXCEL 2016 2013 2010/2007/| in Hindi - You can define a name for range or cell on a worksheet and use the defined name in formula directly insted of selecting data range. you can manage all defined name by using the name manager option. name manager is use to edit the already defined names and to define new names and delete the existing defined names. you can define multiple names by using create from selection. How to define name in excel: Select the cells, you want to assign a name. Click the Define name at the upper left part of excel. Type the name that you want to give to your selection. now you can use the define name in any of formula. How to use name manager in excel: To change or edit the named range, go to Formula tab, in the defined names group, click Name Manager. Here you can changed or edit the existing named ranges. ___________________________ ___________________________ Subscribe to my channel: http://www.youtube.com/deepakeduworld ___________________________ ___________________________ Follow on Linkedin: https://www.linkedin.com/in/deepakeduworld ___________________________ ___________________________ Like on Facebook: http://www.facebook.com/deepakeduworld ___________________________ ___________________________
Views: 40125 Deepak EduWorld
How To Use Countifs Formula in Excel in Hindi | Best Ever Explanation
 
10:50
how to use countifs formula in excel in hindi with 5 different examples - Countifs Formula can help you Count the number of cells which contain mupliple specific criterias defined by you . With countifs formula [ function ] of excel we can easily count the no of records that match multiple criterias conditions . the name itself "countifs" tells that count the records for multiple conditions. countifs is very similar to countif excel function [ formula]. in countif formula we can check only a single criteria and in countifs formula we can count the number of cells for multiple criterias.the working of these formulas count counta countif countifs sunif sumifs etc is same in any of microsoft excel version 2007 2010 2013 & 2016. i have already published a video on countif sumif sumifs vlookup hlookp formulas in excel in hindi. to watch sumif sumifs vlookup hlookp formula in excel please visit our Advanced Excel Playlist How to use countif in excel in hindi https://youtu.be/HgFHx17PPcc Sumif video link https://youtu.be/QcDv6Vvrcsg Sumifs video link https://youtu.be/rDaTTrW6N_0 VLOOKUP formula video link : https://youtu.be/S2rF6bHIbdA Hope you will like the video. Thanks for watching. ------------------------------------------------------------------- ------------------------------------------------------------------- Subscribe to my channel: https://www.youtube.com/deepakeduworld ------------------------------------------------------------------- ------------------------------------------------------------------- like my facebook page: https://www.facebook.com/deepakeduworld ------------------------------------------------------------------- ------------------------------------------------------------------- my facebook profile: https://www.facebook.com/nehra92 ------------------------------------------------------------------- ------------------------------------------------------------------- follow on linkedin: https://www.linkedin.com/in/deepakeduworld Deepak EduWorld के दुआरा publish की हुई playlist इस प्रकार हैं _____________________________________________________________ MS WORD के videos के लिए ये playlist देखे https://www.youtube.com/playlist?list=PLVevUWkXP6J3lZyL-Kj823ODQg1KCipzZ _____________________________________________________________ ADVANCED MS EXCEL के videos के लिए देखे ये playlists https://www.youtube.com/playlist?list=PLVevUWkXP6J1kCWdOZof-htD4CbFRjvrT _____________________________________________________________ HTML5 & CSS3 के videos के लिए ये playlist देखे https://www.youtube.com/playlist?list=PLVevUWkXP6J31sl4Crvx-RUiJcIMw7p3C _____________________________________________________________ COMPUTER के TECHNICAL videos के लिए ये playlist देखे https://www.youtube.com/playlist?list=PLVevUWkXP6J3qcZy11BxbUNRVTMBvzdwe _____________________________________________________________ _____________________________________________________________
Views: 18288 Deepak EduWorld
How To Calculate Loan EMI Using PMT Function in Excel || HINDI
 
08:48
How To Calculate Loan EMI Using PMT Function in Excel in Hindi In This Video You Will Learn About PMT Function. PMT Formula allows you to calculate the EMI for a loan. . Nowadays People Take A Loan For Buying Cars, Buying A House, Studies Of Children, And Giving Some Installments Every Month/every year/semi yearly/quarterly/weekly To Repay The Loan. If We Want To Know, How Much Interest Will Be Charged For Particular Loan Amount, And What Will Be Monthly/ yearly / semiyearly/ quarterly/ weekly Installment, Then, To Know The Amount Of Installments, The PMT Function Is Used in ms excel 2007 2010 2013 2016 Enter an interest rate, the number of payments, and the loan amount on the worksheet. Then, refer to those cells in the PMT formula. Download Training File : https://drive.google.com/open?id=1F-RAYrfFlugUURH8gVL7m6uFJzCj-10- Hope you will like the video. Thanks for watching. Deepak EduWorld के दुआरा publish की हुई playlist इस प्रकार हैं ________________________________________________ ADVANCED MS EXCEL ► https://goo.gl/A6LdZA ADVANCED EXCEL FORMULAS ► https://goo.gl/bbHYu2 MS WORD ► https://goo.gl/B4TeSA HTML5 & CSS3 ► https://goo.gl/2PFgs8 COMPUTER TIPS & TRICKS ► https://goo.gl/paZmpn --------------------------------------------------------------------------- --------------------------------------------------------------------------- Subscribe to my channel ► https://www.youtube.com/deepakeduworld Like my Facebook page ► https://www.facebook.com/deepakeduworld Follow on LinkedIn ► https://www.linkedin.com/in/deepakeduworld Facebook Group ► https://www.facebook.com/groups/cse92/ ********************************************** Thanks for Watching Happy Learning ER DEEPAK NEHRA [ M.Tech. ] **********************************************
Views: 15122 Deepak EduWorld
Create Dynamic Charts in Excel || Using Drop Down List || Best Video In Hindi
 
14:22
Create Dynamic Charts in Excel In Hindi - Its Really Very easy to make dynamic charts in excel 2007 2010 2013 & 2016. we can show our big data automatically in dynamic charts easily by using drop down list. This tutorial will show you how to make a Dynamic Chart in Excel Hindi. How to Create a Dynamic Chart in Excel 2007 and Excel 2010, 2013 2016 That Updates Automatically as Data Is Added or Removed... very intresting... must watch sumifs formula https://youtu.be/rDaTTrW6N_0 How to create drop down list from another sheet in excel || Hindi | using data validation https://youtu.be/-IDqfwby5MM How to use vlookup in hindi https://youtu.be/S2rF6bHIbdA How To Use Double VLookup in Excel In Hindi || Nested vlookup || Multiple Vlookup https://youtu.be/REBdKbbvwG0 How To Fix Excel Formula Errors #NAME? | #VALUE! | #REF! | #DIV/0! | ###### In Hindi https://youtu.be/CajffOjtjGo Hope you will like the video. Thanks for watching. ------------------------------------------------------------------- ------------------------------------------------------------------- Subscribe to my channel: https://www.youtube.com/deepakeduworld ------------------------------------------------------------------- ------------------------------------------------------------------- like my facebook page: https://www.facebook.com/deepakeduworld ------------------------------------------------------------------- ------------------------------------------------------------------- my facebook profile: https://www.facebook.com/nehra92 ------------------------------------------------------------------- ------------------------------------------------------------------- follow on linkedin: https://www.linkedin.com/in/deepakeduworld Deepak EduWorld के दुआरा publish की हुई playlist इस प्रकार हैं _____________________________________________________________ MS WORD के videos के लिए ये playlist देखे https://www.youtube.com/playlist?list=PLVevUWkXP6J3lZyL-Kj823ODQg1KCipzZ _____________________________________________________________ ADVANCED MS EXCEL के videos के लिए देखे ये playlists https://www.youtube.com/playlist?list=PLVevUWkXP6J1kCWdOZof-htD4CbFRjvrT _____________________________________________________________ HTML5 & CSS3 के videos के लिए ये playlist देखे https://www.youtube.com/playlist?list=PLVevUWkXP6J31sl4Crvx-RUiJcIMw7p3C _____________________________________________________________ COMPUTER के TECHNICAL videos के लिए ये playlist देखे https://www.youtube.com/playlist?list=PLVevUWkXP6J3qcZy11BxbUNRVTMBvzdwe _____________________________________________________________ _____________________________________________________________
Views: 48132 Deepak EduWorld
How To Change Case of Text in Excel Without Formulas || Convert Text In UPPER, LOWER & PROPER Case
 
06:37
Learn How To Change Case of Text in uppercase lowercase propercasein in Excel Without Formulas in Hindi. This is Big question how to change text case to upper case,lower case & Proper case in Microsoft Excel. You know very well change case feature is not available in Microsoft Excel.so In this situation we use excel formulas/functions such as UPPER function/formula is use to change case of text in uppercase. Similarly LOWER formula helps to convert text into lowercase and PROPER formula is use to capitalize each word. But in this video DEEPAK EDUWORLD teach you How to Change case of text in Lowercase, Uppercase, Proper case letters without using any formulas in MS-Excel 2007, 2010, 2013 & 2016. By using Macro code (VBA) DOWNLOAD VBA CODE: https://drive.google.com/open?id=1EZ_BGcQKOC-aB5sjWYh-gTfqM43lyBye Hope you will like the video. Thanks for watching. Deepak EduWorld के दुआरा publish की हुई playlist इस प्रकार हैं _____________________________________________________________ ADVANCED MS EXCEL के लिए ये playlists देखे: https://goo.gl/A6LdZA ADVANCED MS EXCEL FORMULAS के लिए ये playlists देखे: https://goo.gl/bbHYu2 MS WORD के लिए ये playlist देखे: https://goo.gl/B4TeSA HTML5 & CSS3 के लिए ये playlist देखे: https://goo.gl/2PFgs8 COMPUTER के TECHNICAL videos के लिए ये playlist देखे: https://goo.gl/paZmpn ------------------------------------------------------------------------------------------------- ------------------------------------------------------------------------------------------------- Subscribe to my channel: https://www.youtube.com/deepakeduworld Like my Facebook page: https://www.facebook.com/deepakeduworld Follow on LinkedIn: https://www.linkedin.com/in/deepakeduworld Facebook Group : https://www.facebook.com/groups/cse92/ *********************************************************** Thanks for Watching Happy Learning DEEPAK NEHRA ***********************************************************
Views: 29793 Deepak EduWorld
how to use pivot chart in excel in Hindi | Best Video With Many Examples
 
13:48
how to use | make | insert | create pivot chart in excel in hindi with many examples - Pivot Charts & Pivot Tables In Excel 2007 2010 2013 2016 are great time savers if you know how to use them. Both PivotTables and PivotCharts enable you to make informed decisions about critical data in your enterprise. You can use a PivotTable to summarize, analyze, explore, and present summary data. PivotCharts complement PivotTables by adding visualizations to the summary data in a PivotTable, and allow you to easily see comparisons, patterns, and trends. In this comprehensive video of excel 2007 2010 2013 2016 Deepak EduWorld teach you how to insert / create Pivot charts in the easiest possible manner. we have also published video on pivot tables in hindi if you dont know how to use / create / insert pivot table than must watch pivot table video. link is given below. How to Insert Charts in Excel 2007 2010 2013 2016 in hindi https://youtu.be/akZBShNCj7g How to insert / create / use Pivot tables 2007 2010 2013 2016 in hindi https://youtu.be/4A6hjD-61gM Hope you will like the video. Thanks for watching. ------------------------------------------------------------------- ------------------------------------------------------------------- Subscribe to my channel: https://www.youtube.com/deepakeduworld ------------------------------------------------------------------- ------------------------------------------------------------------- like my facebook page: https://www.facebook.com/deepakeduworld ------------------------------------------------------------------- ------------------------------------------------------------------- my facebook profile: https://www.facebook.com/nehra92 ------------------------------------------------------------------- ------------------------------------------------------------------- follow on linkedin: https://www.linkedin.com/in/deepakeduworld Deepak EduWorld के दुआरा publish की हुई playlist इस प्रकार हैं _____________________________________________________________ MS WORD के videos के लिए ये playlist देखे https://www.youtube.com/playlist?list=PLVevUWkXP6J3lZyL-Kj823ODQg1KCipzZ _____________________________________________________________ ADVANCED MS EXCEL के videos के लिए देखे ये playlists https://www.youtube.com/playlist?list=PLVevUWkXP6J1kCWdOZof-htD4CbFRjvrT _____________________________________________________________ HTML5 & CSS3 के videos के लिए ये playlist देखे https://www.youtube.com/playlist?list=PLVevUWkXP6J31sl4Crvx-RUiJcIMw7p3C _____________________________________________________________ COMPUTER के TECHNICAL videos के लिए ये playlist देखे https://www.youtube.com/playlist?list=PLVevUWkXP6J3qcZy11BxbUNRVTMBvzdwe _____________________________________________________________ _____________________________________________________________
Views: 53140 Deepak EduWorld
how to Make windows 7 genuine for free | without product key |Hindi
 
04:15
how to Make windows 7 genuine for free | without product key |Hindi] - Activate windows 7 permanently for free without product key, in this video i show you how to make windows genuine in hindi, and fix "this copy of windows is not genuine" problem, you can easily activate any window 7 versions without any product Key and can make your system window 7 genuine. Note: Disable your antivirus before installation. Download software link - http://winactivators.com/ Hope you will like the video. Thanks for watching. ------------------------------------------------------------------- ------------------------------------------------------------------- Subscribe to my channel: https://www.youtube.com/deepakeduworld ------------------------------------------------------------------- ------------------------------------------------------------------- like my facebook page: https://www.facebook.com/deepakeduworld ------------------------------------------------------------------- ------------------------------------------------------------------- my facebook profile: https://www.facebook.com/nehra92 ------------------------------------------------------------------- ------------------------------------------------------------------- follow on linkedin: https://www.linkedin.com/in/deepakeduworld Deepak EduWorld के दुआरा publish की हुई playlist इस प्रकार हैं _____________________________________________________________ MS WORD के videos के लिए ये playlist देखे https://www.youtube.com/playlist?list=PLVevUWkXP6J3lZyL-Kj823ODQg1KCipzZ _____________________________________________________________ ADVANCED MS EXCEL के videos के लिए देखे ये playlists https://www.youtube.com/playlist?list=PLVevUWkXP6J1kCWdOZof-htD4CbFRjvrT _____________________________________________________________ HTML5 & CSS3 के videos के लिए ये playlist देखे https://www.youtube.com/playlist?list=PLVevUWkXP6J31sl4Crvx-RUiJcIMw7p3C _____________________________________________________________ COMPUTER के TECHNICAL videos के लिए ये playlist देखे https://www.youtube.com/playlist?list=PLVevUWkXP6J3qcZy11BxbUNRVTMBvzdwe _____________________________________________________________ _____________________________________________________________
Views: 102363 Deepak EduWorld
😮 A Big Problem In Excel Is Easily Solved 👉 Insert Serial Number In Big Sorted Data
 
05:34
A big problem in ms excel is solved. insert serial number in large sorted data automatically just within 1 minute. Hope you will like the video. Thanks for watching. Deepak EduWorld के दुआरा publish की हुई playlist इस प्रकार हैं _____________________________________________ ADVANCED MS EXCEL के लिए ये playlists देखे: https://goo.gl/A6LdZA ADVANCED MS EXCEL FORMULAS के लिए ये playlists देखे: https://goo.gl/bbHYu2 MS WORD के लिए ये playlist देखे: https://goo.gl/B4TeSA HTML5 & CSS3 के लिए ये playlist देखे: https://goo.gl/2PFgs8 COMPUTER के TECHNICAL videos के लिए ये playlist देखे: https://goo.gl/paZmpn --------------------------------------------------------------- -------------------------------------------------------------- Subscribe to my channel: https://www.youtube.com/deepakeduworld Like my Facebook page: https://www.facebook.com/deepakeduworld Follow on LinkedIn: https://www.linkedin.com/in/deepakedu... Facebook Group : https://www.facebook.com/groups/cse92/ **************************************************************** Thanks for Watching Happy Learning DEEPAK NEHRA ****************************************************************
Views: 17231 Deepak EduWorld
Advanced Filter In Excel - Filter Unique Records Only  [ Hindi ]
 
05:22
Advanced Filter In Excel - Filter Unique Records Only [ Hindi ] - This is a quick way to filter and copy unique values in a range or area. In the Data Tab with the help of Advance Filter we can easily filter and copy unique records only in excel 2007 2010 2013 2016. ADVANCED FILTER VIDEOS SERIES: 1. Advanced Filter in excel in Hindi - Auto VS Advanced filter https://youtu.be/TAMoE_WwnhA 2. Filter Data To Another Sheet In Excel | Using Advanced Filter in Hindi https://youtu.be/vylX04ux9vY 3. How To Filter Data For Blank Cells In Excel | Using Advanced Filter In Hindi https://youtu.be/ZEmhvpy6gTA 4. Advanced filter unique records only in hindi https://youtu.be/HpigtvRMgC4 Hope you will like the video. Thanks for watching. ------------------------------------------------------------------- ------------------------------------------------------------------- Subscribe to my channel: https://www.youtube.com/deepakeduworld ------------------------------------------------------------------- ------------------------------------------------------------------- like my facebook page: https://www.facebook.com/deepakeduworld ------------------------------------------------------------------- ------------------------------------------------------------------- follow on linkedin: https://www.linkedin.com/in/deepakeduworld Deepak EduWorld के दुआरा publish की हुई playlist इस प्रकार हैं _____________________________________________________________ MS WORD के videos के लिए ये playlist देखे https://www.youtube.com/playlist?list=PLVevUWkXP6J3lZyL-Kj823ODQg1KCipzZ _____________________________________________________________ ADVANCED MS EXCEL के videos के लिए देखे ये playlists https://www.youtube.com/playlist?list=PLVevUWkXP6J1kCWdOZof-htD4CbFRjvrT _____________________________________________________________ ADVANCED MS EXCEL FORMULAS के videos के लिए देखे ये playlists https://www.youtube.com/playlist?list=PLVevUWkXP6J2jsiIpCRjtOQvcMecQ49kw _____________________________________________________________ HTML5 & CSS3 के videos के लिए ये playlist देखे https://www.youtube.com/playlist?list=PLVevUWkXP6J31sl4Crvx-RUiJcIMw7p3C _____________________________________________________________ COMPUTER के TECHNICAL videos के लिए ये playlist देखे https://www.youtube.com/playlist?list=PLVevUWkXP6J3qcZy11BxbUNRVTMBvzdwe _____________________________________________________________ Thanks for Watching Happy Learning DEEPAK NEHRA ___________________________________________________________
Views: 9991 Deepak EduWorld
How To Combine/Consolidate Multiple WORKBOOKS into one in Excel || HINDI
 
08:47
How To Combine/Consolidate Multiple WORKBOOKS into one in Excel Hindi- We might need to combine multiple excel workbooks into one workbook in order to analyse or present the information better.if there are a large number of workbooks/worksheets/excel files, then the problem is very bigger. How to easily combine data from multiple workbooks/files in one workbook. However, we have a solution to this and it would not take more than a few seconds to get all workbooks merged into one. link multiple workbooks into one. We can easily transfer data from multiple excel workbooks/files into a master workbook automatically by link them. Learn How To consolidate multiple worksheets to a single sheet in excel hindi https://youtu.be/OHNIiMib9D0 Equipment Used In This Video [You Can Buy] AMAZON OFFERS: 1.TO BUY - Marantz Professional MPM-1000 Large Diaphragm Condenser Microphone click https://goo.gl/NdjSQK 2.TO BUY - Generic 57000928MG Silica Gel Professional Condenser Microphone Sound Studio Recording Dynamic (Works With Phantom Power Supply Or Sound Card Only) https://goo.gl/sRd7RX 3.TO BUY - Blue Yeti USB Microphone, Satin Red Full HD Recording https://goo.gl/1zSaJ8 Hope you will like the video. Thanks for watching. ------------------------------------------------------------------- ------------------------------------------------------------------- Subscribe to my channel: https://www.youtube.com/deepakeduworld ------------------------------------------------------------------- ------------------------------------------------------------------- like my facebook page: https://www.facebook.com/deepakeduworld ------------------------------------------------------------------- ------------------------------------------------------------------- follow on linkedin: https://www.linkedin.com/in/deepakeduworld Deepak EduWorld के दुआरा publish की हुई playlist इस प्रकार हैं _____________________________________________________________ MS WORD के videos के लिए ये playlist देखे https://www.youtube.com/playlist?list=PLVevUWkXP6J3lZyL-Kj823ODQg1KCipzZ _____________________________________________________________ ADVANCED MS EXCEL के videos के लिए देखे ये playlists https://www.youtube.com/playlist?list=PLVevUWkXP6J1kCWdOZof-htD4CbFRjvrT _____________________________________________________________ ADVANCED MS EXCEL FORMULAS के videos के लिए देखे ये playlists https://www.youtube.com/playlist?list=PLVevUWkXP6J2jsiIpCRjtOQvcMecQ49kw _____________________________________________________________ HTML5 & CSS3 के videos के लिए ये playlist देखे https://www.youtube.com/playlist?list=PLVevUWkXP6J31sl4Crvx-RUiJcIMw7p3C _____________________________________________________________ COMPUTER के TECHNICAL videos के लिए ये playlist देखे https://www.youtube.com/playlist?list=PLVevUWkXP6J3qcZy11BxbUNRVTMBvzdwe _____________________________________________________________ Thanks for Watching Happy Learning DEEPAK NEHRA ____________________________________________________________
Views: 36639 Deepak EduWorld
How To  Create Searchable Drop Down List In Excel || Hindi || HD
 
18:28
Learn how to search data validation drop-down lists in Excel Hindi. In this Excel tutorial you will learn fantastic trick to make a searchable dropdown list with auto suggest feature in Excel 2007 2010 2013 2016. Formulas used to create this dropdown list are: 1 search Formula 2 Isnumber Formula 3 If Formula 4 max Formula 5 rows Formula 6 vlookup Formula 7 iferror Formula 8 offset Formula 9 Countif Formula Download Training file: https://drive.google.com/open?id=1dhIUwzFA1eHeFaP7Qoio4Noik5__rDRs vlookup in excel with example in Hindi https://youtu.be/S2rF6bHIbdA How to use IFERROR formula in excel || HINDI https://youtu.be/TF_JAqcPA5w Countif formula in excel https://youtu.be/HgFHx17PPcc If formula in excel https://youtu.be/l2RjYPd-CIo This a an amazing trick so go ahead and create a searchable dropdownlist in excel Data Validation Part 1: https://youtu.be/U3XdCUmNaBg * Data Validation to allow only whole numbers between an upper and lower limit * Data Validation to allow only decimal numbers below or equal to an upper limit * Create an Input Message for your Data Validation * Error alert Message with "Stop" * Error alert Message with "Warning" * Error alert Message with "Information" ____________________________________________ Data Validation Part 2: https://youtu.be/-IDqfwby5MM * Data Validation drop down list using a range of cells * Data Validation drop down list using a Defined Name * Make data validation list from another worksheet in excel 2007 ____________________________________________ Data Validation Part 3: https://youtu.be/VjVpMVO8Jq0 * Data Validation to allow only dates between an upper and lower limit * Data Validation to allow only times above or equal to a lower limit * Data Validation to allow a certain text length ____________________________________________ Data Validation Part 4 : https://youtu.be/ZTlymO0uug4 * Allow only numbers in cell & Set limit of digits to accept. * Allow only text in cell & set character limit to accept. * Allow only 10 digit mobile number in cell ____________________________________________ Data Validation Part 5 :https://youtu.be/vzeWlggal88 * Prevent Duplicate Entries In Column * Allow Only Unique Entries - Avoid duplicate entries in excel using custom data validation. ____________________________________________ Data Validation Part 6: https://youtu.be/EX2ZahZ3pHo Auto Updating DropDown List In Excel Hindi || Dynamic DropDown List ____________________________________________ Data Validation Part 7:https://youtu.be/Ig245IO7lPs How To Create Data Validation Dependent Drop Down List In Excel || Best Video || Hindi || HD ____________________________________________ Data Validation Part 8:https://youtu.be/tn4ShvcvBls EXCEL ये विडियो जरूर देखें - Allow Only Entries Starting With Specific Alphabet / Text /Number ____________________________________________ Data Validation Part 9:https:https://youtu.be/WULhnIsKguU Custom Data Validation- To Allow only Uppercase Text Entries In Excel ____________________________________________ Data Validation Part 10:https:https://youtu.be/HwVbH_x6nMk How To Create Searchable Drop Down List In Excel || Hindi || HD ____________________________________________ Data Validation Part 11:https:https://youtu.be/-IDqfwby5MM how to create drop down list from another sheet in excel || Hindi | using data validation ____________________________________________ Data Validation Part 12:https://youtu.be/EX2ZahZ3pHo Data Validation Auto Updating DropDown List In Excel Hindi || Dynamic DropDown List ____________________________________________ Data Validation Part 13:https://youtu.be/e6R4zZdlxHY EXCEL में Data Entry करने वाले जरूर देखे 👍 5 Cool Custom Data validation Tips Everyone should know Hope you will like the video. Thanks for watching. Deepak EduWorld के दुआरा publish की हुई playlist इस प्रकार हैं _____________________________________________________________ ADVANCED MS EXCEL के लिए ये playlists देखे: https://goo.gl/A6LdZA ADVANCED MS EXCEL FORMULAS के लिए ये playlists देखे: https://goo.gl/bbHYu2 MS WORD के लिए ये playlist देखे: https://goo.gl/B4TeSA HTML5 & CSS3 के लिए ये playlist देखे: https://goo.gl/2PFgs8 COMPUTER के TECHNICAL videos के लिए ये playlist देखे: https://goo.gl/paZmpn --------------------------------------------------------------------------- ---------------------- --------------------------------------------------------------------------- ---------------------- Subscribe to my channel: https://www.youtube.com/deepakeduworld Like my Facebook page: https://www.facebook.com/deepakeduworld Follow on LinkedIn: https://www.linkedin.com/in/deepakedu... Facebook Group : https://www.facebook.com/groups/cse92/ *********************************************************** Thanks for Watching Happy Learning DEEPAK NEHRA ***********************************************************
Views: 104410 Deepak EduWorld
Excel Magic - कैसे 10,000 PaySlip केवल 2 मिनट में बनाये || Make Thousands Payslips just in 2 minutes
 
13:26
how to make payslip in excel - Excel Magic - कैसे 10,000 PaySlip केवल 2 मिनट में बनाये || Make Thousands Payslips just in 2 minutes - yes friends we can easily create/generate/make thousands of payslips just within few minuts only. here in this video DEEPAK EDUWORLD will show you. To do this task we have to use the mailing feature of ms word also. you can do this in any of excel version 2007 2010 2013 & 2016. salary slip/salary sheet/payroll sheet/advanced excel/hindi Download Excel Training File https://drive.google.com/open?id=1uomGmbumCSTI_IMCHZjQrVwEsIM3Y7bX Download MS Word Training FIle https://drive.google.com/open?id=1D1VeIQe54DjnA2xCUS8EMR0LM58YFpZP MS Word Insert Menu In Hindi | How to Insert Table | Complete Design & Layout Tab of table in detail https://youtu.be/uLSH5vgvwnM Hope you will like the video. Thanks for watching. Deepak EduWorld के दुआरा publish की हुई playlist इस प्रकार हैं _____________________________________________________________ ADVANCED MS EXCEL के लिए ये playlists देखे: https://goo.gl/A6LdZA ADVANCED MS EXCEL FORMULAS के लिए ये playlists देखे: https://goo.gl/bbHYu2 MS WORD के लिए ये playlist देखे: https://goo.gl/B4TeSA HTML5 & CSS3 के लिए ये playlist देखे: https://goo.gl/2PFgs8 COMPUTER के TECHNICAL videos के लिए ये playlist देखे: https://goo.gl/paZmpn ------------------------------------------------------------------------------------------------- ------------------------------------------------------------------------------------------------- Subscribe to my channel: https://www.youtube.com/deepakeduworld Like my Facebook page: https://www.facebook.com/deepakeduworld Follow on LinkedIn: https://www.linkedin.com/in/deepakedu... Facebook Group : https://www.facebook.com/groups/cse92/ *********************************************************** Thanks for Watching Happy Learning DEEPAK NEHRA ***********************************************************
Views: 80067 Deepak EduWorld
Excel Trick - Extract  [ Separate ] Numbers From Text || Text से Numbers को  अलग करने की आसान Trick
 
04:47
Extract [ Seperate ] Numbers Fom Text in Excel If you need to separate numbers from a text string in Excel, you have quite a problem. because there is no inbuilt function in ms excel to seperate numbers from text. well i have created a function getnumber using vba to extract only numbers from a text string in excel. Download Link : https://drive.google.com/open?id=1AoiF-sveib1PQhmnVQ048BV93Qq-tqhI VLOOKUP VIDEO SERIES: 1. vlookup in excel with example in Hindi https://youtu.be/S2rF6bHIbdA 2. How to use vlookup for multiple values || Trick to use vlookup for large data https://youtu.be/oSE4wSy02s8 3. Vlookup in multiple sheets in excel || In Hindi https://youtu.be/fpslxPp3_Cw 4. How To Use Double VLookup in Excel-Nested vlookup https://youtu.be/REBdKbbvwG0 5. Dynamically Updated Vlookup Formula in Excel https://youtu.be/IHD6XIDrCfk 6. How To Use Vlookup With Multiple Excel Workbooks https://youtu.be/CiHIbsRM3cg 7. HLOOKUP in excel with example in Hindi https://youtu.be/DyH3PY3qbIE Hope you will like the video. Thanks for watching. Deepak EduWorld के दुआरा publish की हुई playlist इस प्रकार हैं ________________________________________________ ADVANCED MS EXCEL के लिए ये playlists देखे ► https://goo.gl/A6LdZA ADVANCED MS EXCEL FORMULAS के लिए ये playlists देखे ► https://goo.gl/bbHYu2 MS WORD के लिए ये playlist देखे ► https://goo.gl/B4TeSA HTML5 & CSS3 के लिए ये playlist देखे ► https://goo.gl/2PFgs8 COMPUTER के TECHNICAL videos के लिए ये playlist देखे ► https://goo.gl/paZmpn --------------------------------------------------------------------------- --------------------------------------------------------------------------- Subscribe to my channel ► https://www.youtube.com/deepakeduworld Like my Facebook page ► https://www.facebook.com/deepakeduworld Follow on LinkedIn ► https://www.linkedin.com/in/deepakedu... Facebook Group ► https://www.facebook.com/groups/cse92/ ********************************************** Thanks for Watching Happy Learning ER DEEPAK NEHRA [ M.Tech. ] **********************************************
Views: 15370 Deepak EduWorld
how to use concatenate formula in excel | Hindi | join data of different cells into a single cell
 
16:18
concatenate formula in excel 2007 2010 2016 2013 Hindi With UPPER LOWER PROPER - How to Combine Cells - Join text in one cell - combine excel formulas - join data of different cells into a single cell, combile cells data into a single cel - merge data from different columns into one column - using & sign And concatenate function in any of excel version 2007 2010 2016 2013 You can easily combine [ join ] cells data and also you can display the joined data in upper case , alower case , and proper case very easily . in this video tutorial i have explained concatenate formula with upper lower and proper formulas in hindi how to use countif formula in hindi https://youtu.be/HgFHx17PPcc Hope you will like the video. Thanks for watching. ------------------------------------------------------------------- ------------------------------------------------------------------- Subscribe to my channel: https://www.youtube.com/deepakeduworld ------------------------------------------------------------------- ------------------------------------------------------------------- like my facebook page: https://www.facebook.com/deepakeduworld ------------------------------------------------------------------- ------------------------------------------------------------------- my facebook profile: https://www.facebook.com/nehra92 ------------------------------------------------------------------- ------------------------------------------------------------------- follow on linkedin: https://www.linkedin.com/in/deepakeduworld Deepak EduWorld के दुआरा publish की हुई playlist इस प्रकार हैं _____________________________________________________________ MS WORD के videos के लिए ये playlist देखे https://www.youtube.com/playlist?list=PLVevUWkXP6J3lZyL-Kj823ODQg1KCipzZ _____________________________________________________________ ADVANCED MS EXCEL के videos के लिए देखे ये playlists https://www.youtube.com/playlist?list=PLVevUWkXP6J1kCWdOZof-htD4CbFRjvrT _____________________________________________________________ HTML5 & CSS3 के videos के लिए ये playlist देखे https://www.youtube.com/playlist?list=PLVevUWkXP6J31sl4Crvx-RUiJcIMw7p3C _____________________________________________________________ COMPUTER के TECHNICAL videos के लिए ये playlist देखे https://www.youtube.com/playlist?list=PLVevUWkXP6J3qcZy11BxbUNRVTMBvzdwe _____________________________________________________________ _____________________________________________________________
Views: 45213 Deepak EduWorld

Free basic cover letter template
Layout of a cover letter uk example
How to write application to school principal for job
Iti mallepally hyderabad admissions essay
Writing letter to judge uk