👉ऑनलाइन एग्जाम देकर सर्टिफिकेट लेने के लिए और प्रैक्टिस फाइल को डाउनलोड करने के लिए आप नीचे दिए गए स्टेप्स को फॉलो करें: 1. हमारी वेबसाइट (OfficeBlog.in) पर विजिट करें। 2. इसके बाद आपको (Free Certificate Course) की (category) पर क्लिक करना है। 3. अब आप जिस भी कोर्स का एग्जाम देना चाहते हैं उस पर क्लिक करें। 4. आर्टिकल को पूरा पढ़ें और कोर्स की इंपॉर्टेंस को समझें। 5. आर्टिकल के लास्ट में आपको ऑनलाइन एग्जाम देने का लिंक मिलेगा (Download Button), उस पर क्लिक करें। 6. 2 मिनट वेट करने पर आपका ऑनलाइन एग्जाम का लिंक ओपन हो जाएगा, इसके बाद एग्जाम देकर सर्टिफिकेट ले सकते हैं। कई बार सर्टिफिकेट आपके ईमेल के दूसरे फोल्डर जैसे कि स्पैम या प्रमोशन में चला जाता है, तो एक बार ईमेल के सभी फोल्डर को जरूर चेक करें। 👉To take the online exam and download the practice file, follow these steps: 1. Visit our website (OfficeBlog.in). 2. Click on the Free Certificate Course category. 3. Select the course you want to take the exam for. 4. Read the article and click the exam link at the end. 5. Wait 2 minutes for the exam link to open, then take the exam to receive your certificate. 6. Check all email folders, including Spam and Promotions, for your certificate.
Thank you sir , maine aap ka excel ka fully course ka video dekha aur online exam bhi deye , mujhe certificat bhi mi gya . Sir aap ki jitna bhi शुक्रिया अदा करूं कम है.
Sir aap mere jaise middle class student ka bhut bada sahara ho .......jo kisi ka course buy nhi kr sakte financial problem ki wajah se ..........gareeb bachcho ka ek akela sahara ho aap .....itna kuch free de diya ..........sorry sir thankyou bhut kam rahega aapka shukria ada krne ka
Today a girl told me she spended 7000 to learn basic to advance excel And while practicing me usse jyada acche से कर रहा था and she was stucked Thank you sir because of u learned All this valuable knowledge for free
Sir main computer ka course kara hai wo bhi advance aur main job bhi karta hun CA Firm me. Main aapka video dekh I like sir.... I love you sir and thank you so much... Sir agar jinke pass paisa nahi ye offline course karne ka wo online sikh sakte hai aapka video dekh kar Infact sir mujhe aisi bahot si chije ek video se sikhne ko mili hai jo mere liye new thi. And one's again thank you so so much sir.🙏 Love you 🙏
Watch Video by Chapters : 00:00:00 Intro 00:02:50 What is MS Excel 00:04:36 Ways to Start MS Excel 00:06:08 Complete Structure of Excel 00:24:55 Write Delete Modify Select Value Text in MS Excel 00:36:12 How to Use File Menu All Function 00:57:33 How to Use Quick Access Toolbar in Excel 01:08:32 Cut Copy Paste Clipboard Format Painter in MS Excel 01:26:30 Font Group All Option in Excel 02:07:43 Alignment Group in MS Excel 02:36:46 Number Format in MS Excel 03:12:42 Conditional Formatting in Excel 03:45:15 Format As Table and Cell Style 03:59:55 Insert Delete Cells, Rows, Columns, Sheets 04:25:07 Format Command All Options 04:57:15 Autosum Fill and Clear Command 05:32:39 Sort Filter Find and Select Command 05:48:18 Illustrations 06:00:09 Charts in Excel 06:10:02 Insert Hyperlink Text Symbol in Excel 06:29:26 Page Setup & Sheet Print in Excel 07:09:05 Remove Duplicates Command in Excel 07:11:38 Goal seek function in MS Excel 07:24:26 Group Ungroup Subtotal in Excel 07:31:10 View Insert Delete Comments Excel 07:37:00 View Tab in MS Excel 07:50:06 Start New Line in Same Cell in Excel 07:54:48 Absolute References in Excel 08:06:42 Save Excel Charts As image 08:08:22 Flash Fill Function in Excel 08:12:04 Sort Data Row Wise 08:15:42 Filter Secret Tips & Tricks 08:25:42 Convert Excel Data to Image 08:28:48 Data Entry in Excel 08:35:08 Write Large Number in Excel 08:39:51 Sum, Subtract, Multiply, Divide, Percentage Formula in Excel 09:17:21 Vlookup Formula in Excel 09:25:00 Hllokup Formula in Excel 09:30:49 Sumif Formula in Excel 09:35:04 Sumifs formula in Excel 09:42:06 Concatenate Formula in Excel 09:49:43 Averageif Formula in Excel 09:56:01 MS Excel Tips & Tricks 10:07:46 Outro
I have seen many videos on you tube for basic excel but never came across such an organised and detailed video on it. This is a perfect guide for some1 who wants to start from begining and be confident on his learning. Thank you so much for uploading a great tutorial💐💐 you are a gem sirrr
I got my certificate live support but i appeared in test without watch this vedio and i cleared thank u so much sir you r great teacher here for computer courses
I am happy to inform you that I have successfully completed my Excel exam and have received my Excel certificate. Thank you for your support and guidance throughout this process.
Omg kitna detail me samghaya hai kisi bacche ko bhi samgh aajye expert ban jaye matlab bahut hi detail se koi kam padha likha bhi samgh jaye TQ very much
I Suresh Ram from Patiala Punjab has got my MS Excel certificate.Thanks for such a wonderful platform to provide us more computer knowledge online and that's also free, thanks 🙏🙏 again sir ji
This course is incredible❤ literally starting from zero to advance... I will recommended this course to beginners❤💫 I completed this course and got my certificate today with 28/30 marks
He is such a great person, providing knowledge and support for a bright career of the young generation. I got my certificate today by completing course. Thank you Chandan Sir 🙏🙏
Such a wonderful session you made for all , who are interested to learn Excel in length. You have lot of patience to make this video fruitful for all . Thank you so much..
You are a good teacher. I have never ever seen a teacher like you on youtube.You have been in the good book of mine ever since i saw your first video on youtube. May live long. 🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏❤️❤️❤️❤️❤️And also the way you explain is second to none.
Sir, Really, I thought Humanity is died as people begins business mentality in Learning or education system..but your video is witnessing that Humanity is still survive.. I have no word to express my gratitude toward u.. thank you sir..🙏😇.. Only One Suggestions Use Playback speed to multiply atleast 1.5..😅
Mera desh mahan uske insaan bht aali shaan jaise aap h hamarey ustaad dil se h aap ko salam umar me barkat ho uss maa ko jisney aise beta paida kiya 😍😍
Session was superb and teaching is commendable.....as I was poor in it but after completing the course I am feeling that i know everything....got Certificate too thanks sir
If there will be the option of liking 10 to 20 times then I definitely like the video thankyou for giving us this type of fully conceptual video and I APPRECIATES YOUR HARDWORK.
... now i have finally finished and watched this video fully... thank you sir... Mr Chandan Kumar ... thank you very much for providing step-by-step full knowledge of basic MS EXCEL... more over thank you for providing knowledge in easy and patience-ful language... 👍👍❤
@@saimsingh1122 वीडियो तो 10 घंटे का है सो 10 घंटे में खत्म हो जाएगा लेकिन अगर आप प्रैक्टिकल करते हुए साथ साथ विद्यार्थी की तरह सीखेंगे तो एक हफ्ता लग जाएगा
Thanks a lot from the bottom of my heart. Finally i got an ISO certificate from you after qualifying the basic excel course through your " My support live " youtube channel.
Row column 3:42 5:50 6:50 11:28 12:53 17:03 17:15 20:26 20:07 29:07 36:30 48:25 51:39 55:15 55:29 * 58:01 1:40:22 border 2:17:00 Format cell alignment 2:19:24 indent decrease increase 2:21:09 width auto adjust 2:21:51 auto edit by key board F2 2:27:07 merge 2:30:19 merge across 2:32:58 unmerge 2:34:07 unmerge and left 2:35:55 shrink to fit, text size reduced 2:40:03 convert to nornal value, change percentage sign in value 2:40:24 convert percentage or date in normal value 2:41:44 change currency in rupee 2:46:28 difference between currency and accounting 2:48:44 change date format in excel 2:49:45 long date short date 2:51:03 time 255:31 percentage 2:55:56 fraction 2:56:52 scientific format 2:59:09 accounting number format rupee symbol 2:59:42 accounting number format various currency symbols 3:02:03 comma full stop dot 3:03:38 increase decimal decrease decimal 03:05:01 more number format ( text format) 03:08:00 custom number format 3:08:49 automatic zero before number, five digit number etc 3:11:13 sum shown in status 3:11:40 general number format 3:13:21 conditonal formatting highlight conditional formatting 3:14:09 highlight conditioning colour selection 3:18:07 conditional formatting special feature highlight feature 3:18:40 remove conditional formatting 3:20:29 text that contains 3:23:12 date highlight 3:26:23 duplicate values and unique values ie values used only once 3:28:27 top bottom rules 3:31:48 above average below average 3:33:22 above percentage below percentage 3:35:38 data bars more colorful low colourfull 3:38:35 color scale colour scale different colors for different data 3:41:24 conditional formatting icon 3:45:46 format as table 3:48:10 create table shortcut is control plus T 3:48:26 table heading special point 3:50:03 benefit of converting data into table format 3:51:30 copy paste formula shortcut control plus D 3:53:53 benefit of using table in MS excel 3:58:33 cell style special function 4:52:11 format command in excel row height 4:29:26 auto fit row height, row height is in format in home 4:39:01 show unhide, rename is in format in home, move sheet copy sheet is in format in home 4:46:25 tab color sheet color 4:47:36 password protect sheet is in format in home 4:49:14 unprotect sheet 4:50:05 lock cell protect cell format home 4:50:58 formula protect formula password data password format home == select entire data - - right click - - choose format cell - - go in protection - - unclick locked - - 4:51:56 formula password 5:09:53 autofit special feature 5:19:36 text in same column 5:21:44 flash fill gst number me se pan number nikaalna 5:25:25 shri chandan kumar mr chandan kumar delhi 110039 5:29:11 home clear formatting data content cooments hyperlink 5:32:54 home data sort filter 5:45:24 go to cell 6:00:00 chart 6:12:00 insert link hyperlink, insert header footer 6:17:13 header footer not showing 6:24:35 manual mathematical equation write mathematical equation ink mathematical equation 6:28:31 symbol size special 6:30:45 print 6:32:08 return to file press escape in keyboard 6:42:46 collate print 6:52:27 heading on all pages 7:05:03 text to colum example rajesh, ram, shyam 7:09:23 remove duplicates 7:12:01 goal seek function data what if analysis target left target set 7:21:32 reduce decimal 7:26:06 data group ungroup 7:31:00 view insert delete comments 7:37:30 view tab 7:46:26 freeze panes 7:50:08 start new line in same cell shortcut alt+enter, edit in cell press F2 in keyboard 7:55:14 freeze keyboard key F4,, absolute range, conditional formatting ifcondition 7:59:57 special point range shifts below 8:02:37 special point double click to apply formula 8:05:32 freeze good way 8:07:07 save charts in image form keyboard key F12, save as shortcut F12 8:08:25 flash fill function shortcut ctrl + E, shortcut written in pop up 8:14:30 sort row 8:15:45 filter secret tips, shortcut ctrl + shift + L 8:28:20 convert excel data in image 8:29:40 data entry in ms excel 8:31:17 entire sheet automatically adjust 8:35:50 write large number value, shortcut format cell dialog box Ctrl + 1., convert number in text by using single cot 8:39:44 Basic formula, sum shortcut alt + = 8:46:22 shortcut F2, esc 8:55:40 freeze, dollar freeze, F4 freeze 09:03:00 double click to apply formula, 9:07:15 special knowledge, percentage, double click on cell corner 9:10:44 percentage calculation, 9:11:09 count counta count blank 9:16:54 vlookup hlookup sumif sumifs concatenate 9:19:09 select entire row ctrl + shift + side arrow, false zero true one 9:23:56 vlookup works left to write
@@letslearn1470 Bhai Description mein jaake FOR ONLINE EXAM likha hoga woh link pe click karo. Badme website open hua toh neeche jaake “Click here for MS Excel Online Exam - यहाँ क्लिक करें” ispe click karo aur google form open hoga apna details bharke EXAM DEDO aur certificate mail ✉️ pe aa jayega ✌🏼
Great work sir you should explain very nicely after watching this video i learn about excel perfectly but sir you do not provide the link of certificate and practice notes you should provide these both things so you will perfect in excel.
Very nice session and information. You have very nicely explained the basic concept of exel. I have given online exam today and received the certificate instantly. Thank you!
Tq very much sir you are the great teacher maine bahut dundha par aapke jaisa koi nahi bataya tq again abhi ek part dekha aapka video bada hai isko part me dekh raha hu 🙏🙏🙏🙏🙏🙏👌👌👌👌👌😊😊😊😊😊❤️❤️❤️❤️❤️❤️❤️
Sir thank you so much 🙏🙏.. U did lots of effort for making this video for us. God bless you sir.❤️🙏 Sir tomorrow is my interview of the related topic so sir please provide some material or pdf of important questions that can be asked in the interview regarding excel.
Thanks sir i attemt your online exam and clear i recived my certificate in just a few minutes after clear the exam very fast service you have thanks sir once again to give me this excell certificate
Nice session and information it would be much useful if the data sheets or the sheets used in the session available for practicing and for references thank you
@@MyLiveSupport @MyLiveSupport ... चंदन सर, ऑनलाइन एग्जाम की लिंक अभी तक अपडेट नहीं हुई. आपने बोला था कि आईएसओ सर्टिफिकेशन करवा रहा हूं एक हफ्ते में हो जाएगा. लेकिन आज 1 महीने से ज्यादा दिन बीत गए अभी तक लिंक अपडेट नहीं हुआ. मैं हमेशा चेक करता हूं. हमें और कितना इंतजार करना पड़ेगा कृपया सही कारण बताएं.... धन्यवाद
Hello Sir There are many students struggling with certificate exam link is pending from last 1 month So either provide some information regarding the same or remove the certification part
👉ऑनलाइन एग्जाम देकर सर्टिफिकेट लेने के लिए और प्रैक्टिस फाइल को डाउनलोड करने के लिए आप नीचे दिए गए स्टेप्स को फॉलो करें:
1. हमारी वेबसाइट (OfficeBlog.in) पर विजिट करें।
2. इसके बाद आपको (Free Certificate Course) की (category) पर क्लिक करना है।
3. अब आप जिस भी कोर्स का एग्जाम देना चाहते हैं उस पर क्लिक करें।
4. आर्टिकल को पूरा पढ़ें और कोर्स की इंपॉर्टेंस को समझें।
5. आर्टिकल के लास्ट में आपको ऑनलाइन एग्जाम देने का लिंक मिलेगा (Download Button), उस पर क्लिक करें।
6. 2 मिनट वेट करने पर आपका ऑनलाइन एग्जाम का लिंक ओपन हो जाएगा, इसके बाद एग्जाम देकर सर्टिफिकेट ले सकते हैं। कई बार सर्टिफिकेट आपके ईमेल के दूसरे फोल्डर जैसे कि स्पैम या प्रमोशन में चला जाता है, तो एक बार ईमेल के सभी फोल्डर को जरूर चेक करें।
👉To take the online exam and download the practice file, follow these steps:
1. Visit our website (OfficeBlog.in).
2. Click on the Free Certificate Course category.
3. Select the course you want to take the exam for.
4. Read the article and click the exam link at the end.
5. Wait 2 minutes for the exam link to open, then take the exam to receive your certificate.
6. Check all email folders, including Spam and Promotions, for your certificate.
Thnku mujhe certificate mil gya h🎉
Thank you sir , maine aap ka excel ka fully course ka video dekha aur online exam bhi deye , mujhe certificat bhi mi gya . Sir aap ki jitna bhi शुक्रिया अदा करूं कम है.
Sir certificate milega to use company job dene me allow kregi
Everyone should watch this video if you want to do something in life.
This is the best Excel video I have seen. I got my certificate. thanks for this.
YE SAB SIKHANE KE LIYE MUJE 5 SAL LAGE AUR TUMNE 10 HOURS SAB EK SAATH BATA DIYA. GOOD WORK BRO.
Sir aap mere jaise middle class student ka bhut bada sahara ho .......jo kisi ka course buy nhi kr sakte financial problem ki wajah se ..........gareeb bachcho ka ek akela sahara ho aap .....itna kuch free de diya ..........sorry sir thankyou bhut kam rahega aapka shukria ada krne ka
Bhai exam 2 type ka hota hai ek Microsoft ka Excel or ek ye dono me kon sa best hai
@@villagenetwork3167 or ek ye ...? Kon sa exam ke rhe ho aap ?
Today a girl told me she spended 7000 to learn basic to advance excel
And while practicing me usse jyada acche से कर रहा था and she was stucked
Thank you sir because of u learned All this valuable knowledge for free
Itna deeply samjhane vale teacher mene phli bar dekha h wahh sir man gye apko v supr
10 घण्टे का वीडियो बनाना आसान नही होता। आपके प्रयास को प्रणाम 🙏🙏🙏 हरे कृष्णा आपको अपना आशीर्वीद प्रदान करे ।
@@Bankinggirl5421 I seen the imp part by skipping the video.... Same day
@@Bankinggirl5421 mujhe 2 din lage
Dosto course bohot easy hai aur online exam ke bad turant certificate aa gaya.really good and usefull course
Mera to open hi nahi ho raha tumhara keise open hua
Sir main computer ka course kara hai wo bhi advance aur main job bhi karta hun CA Firm me.
Main aapka video dekh I like sir.... I love you sir and thank you so much...
Sir agar jinke pass paisa nahi ye offline course karne ka wo online sikh sakte hai aapka video dekh kar
Infact sir mujhe aisi bahot si chije ek video se sikhne ko mili hai jo mere liye new thi.
And one's again thank you so so much sir.🙏
Love you 🙏
Real m certificate bhi mail karta h, test m pass hone par, mere ko mila h bhai logo, awesome thanks bro
Watch Video by Chapters :
00:00:00 Intro
00:02:50 What is MS Excel
00:04:36 Ways to Start MS Excel
00:06:08 Complete Structure of Excel
00:24:55 Write Delete Modify Select Value Text in MS Excel
00:36:12 How to Use File Menu All Function
00:57:33 How to Use Quick Access Toolbar in Excel
01:08:32 Cut Copy Paste Clipboard Format Painter in MS Excel
01:26:30 Font Group All Option in Excel
02:07:43 Alignment Group in MS Excel
02:36:46 Number Format in MS Excel
03:12:42 Conditional Formatting in Excel
03:45:15 Format As Table and Cell Style
03:59:55 Insert Delete Cells, Rows, Columns, Sheets
04:25:07 Format Command All Options
04:57:15 Autosum Fill and Clear Command
05:32:39 Sort Filter Find and Select Command
05:48:18 Illustrations
06:00:09 Charts in Excel
06:10:02 Insert Hyperlink Text Symbol in Excel
06:29:26 Page Setup & Sheet Print in Excel
07:09:05 Remove Duplicates Command in Excel
07:11:38 Goal seek function in MS Excel
07:24:26 Group Ungroup Subtotal in Excel
07:31:10 View Insert Delete Comments Excel
07:37:00 View Tab in MS Excel
07:50:06 Start New Line in Same Cell in Excel
07:54:48 Absolute References in Excel
08:06:42 Save Excel Charts As image
08:08:22 Flash Fill Function in Excel
08:12:04 Sort Data Row Wise
08:15:42 Filter Secret Tips & Tricks
08:25:42 Convert Excel Data to Image
08:28:48 Data Entry in Excel
08:35:08 Write Large Number in Excel
08:39:51 Sum, Subtract, Multiply, Divide, Percentage Formula in Excel
09:17:21 Vlookup Formula in Excel
09:25:00 Hllokup Formula in Excel
09:30:49 Sumif Formula in Excel
09:35:04 Sumifs formula in Excel
09:42:06 Concatenate Formula in Excel
09:49:43 Averageif Formula in Excel
09:56:01 MS Excel Tips & Tricks
10:07:46 Outro
Thnks
Thank brother
Pivot table 🤔
@@VashistRohit5655Advance video alag uploaded hai isi channel per
09:11:15 pe bhi ak concept hai sayad vo rah gaya hai
I have seen many videos on you tube for basic excel but never came across such an organised and detailed video on it. This is a perfect guide for some1 who wants to start from begining and be confident on his learning.
Thank you so much for uploading a great tutorial💐💐 you are a gem sirrr
1:31:51 1:31:52 1:31:53
I got my certificate live support but i appeared in test without watch this vedio and i cleared thank u so much sir you r great teacher here for computer courses
How you get certificate can you share with me detailed process of this
@@PrernaBirla-oj3hw call
I am happy to inform you that I have successfully completed my Excel exam and have received my Excel certificate. Thank you for your support and guidance throughout this process.
How you got your certificate can u pls tell me
There is no link available
How you got your certificate
@@jaibairagi3481 did you guys find certificate?
Omg kitna detail me samghaya hai kisi bacche ko bhi samgh aajye expert ban jaye matlab bahut hi detail se koi kam padha likha bhi samgh jaye TQ very much
Isme formula advance Excel ke bhot Kam btaya gya hain 😢😢😢 but muche abhi 50 aate hain 😊
I Suresh Ram from Patiala Punjab has got my MS Excel certificate.Thanks for such a wonderful platform to provide us more computer knowledge online and that's also free, thanks 🙏🙏 again sir ji
This course is incredible❤ literally starting from zero to advance...
I will recommended this course to beginners❤💫
I completed this course and got my certificate today with 28/30 marks
How can i apply for exam and certificate? Can you help ?
@@rajnipandey9901 description check kro
@@rajnipandey9901description me link hai
Can you help with certificate link pls
बहुत कमाल का नॉलेज मिला एक एक टूल्स को निचोड़ दिया सर जी
He is such a great person, providing knowledge and support for a bright career of the young generation. I got my certificate today by completing course. Thank you Chandan Sir 🙏🙏
Give me certificate link
Where is the link for exam
@@sejalrenavikar9625
Have you got the link for exam?
@@sejalrenavikar9625 certificate link?
Tq so much sir mein pura course kar liya aap ka ye video mai 5 day mai complete kiya .... Tq so much sir ...❤️❤️❤️
Such a wonderful session you made for all , who are interested to learn Excel in length. You have lot of patience to make this video fruitful for all . Thank you so much..
Certificate kaise milega ?
@@Chapterwithjuhi PATA NHI
I would like to say thank for this you tube channel. Because I got full ms excel free certificate. So really appreciate for this channel
Hame bhi certificate mil Gaya hai
Bahut bahut shukriya sir ji
Exam ka link kahan h jise dekr certificate mil rha h
This is not possible complete full in 10 hours course you are salute sir❤❤
You are a good teacher. I have never ever seen a teacher like you on youtube.You have been in the good book of mine ever since i saw your first video on youtube. May live long. 🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏❤️❤️❤️❤️❤️And also the way you explain is second to none.
How to start this course and get certificate
Aap k sirf vidios dekhkr main excell expert ban gya aur job bhi lag gye thanks sir very much
Wow
Sir, Really, I thought Humanity is died as people begins business mentality in Learning or education system..but your video is witnessing that Humanity is still survive..
I have no word to express my gratitude toward u.. thank you sir..🙏😇..
Only One Suggestions
Use Playback speed to multiply atleast 1.5..😅
Apka excel padhane ka tarika itna achha hai ki kahi bahar jane ki jarurat nahi ,thank you so much sir
After 3 days i did complete full video and crack exam i got certificate instantly within in second.
I am so happy thank you Sir ❤️❤️
Thanx a lot sir
Maine exam di aur mujhe certificate bhi mila.
After how much time will we get the certificate
Thanks sir i received a certificate god bless u also ur family keep it up sir long live u
From Pakistan..
Thanks a lot :)
Telligram channel ka link send kariyee naa sir kaa
Search karne pe nahi milla sir kaa link
@@supriyabharati2429 t.me/mylivesupportofficial
Bhai questions send karo
Bhai Kahan enroll krna hai for the certificate?
Mera desh mahan uske insaan bht aali shaan jaise aap h hamarey ustaad dil se h aap ko salam umar me barkat ho uss maa ko jisney aise beta paida kiya 😍😍
This is very knowledgeable and interesting course. I completed this and found my certificate .Thanks sir ❤️
Thank you bhai aaj complete kar liya hai pura video...bahut acha padaya h ...naukri lag jayegi jab ..guru dakshina jarur bhejunga
Kaun kaun 2024 dosto dekh rahe hai... .like👍👆☝️
Iska pdf bhi hai kya
25
@@techbing2639 25?
@@techbing2639 apke pass hai kya
@@techbing2639apke pass hai kya pdf
Mujhe Ms word and Ms Excel ka certificate mil gaya....
Thanks sir
Session was superb and teaching is commendable.....as I was poor in it but after completing the course I am feeling that i know everything....got Certificate too thanks sir
It's my pleasure
From where did you get the certificate?
I got 23/30 how will i get certificate?
@@fahadaamer6105 certificate kha se milta h bro
@@fahadaamer6105 maine bhi...ye fake to nji😂😂😂
Thank you sir❤🙏i have successfully completed my excel exam and also received my excel certificate.
Thank you so much sir for your efforts❤
Link for online exam??
It's a first channel who provide certificate. Thanku sir
Thanks 😊
Exam kease de
Please iske bare mea datao sir je
Exam me kaun kaun sa question tha
I have got Ms Excel certificate with no charge. thanks Mr. Chandan Kumar for this initiative..🙏
Can u pls share me the Excel course certificate link
If there will be the option of liking 10 to 20 times then I definitely like the video thankyou for giving us this type of fully conceptual video and I APPRECIATES YOUR HARDWORK.
Thank 🙏 You so much sir. This video is very useful. I have completed MS Excel course and received my Certificate of MS Excel.
Thanks 🙏 again.
... now i have finally finished and watched this video fully... thank you sir... Mr Chandan Kumar ... thank you very much for providing step-by-step full knowledge of basic MS EXCEL... more over thank you for providing knowledge in easy and patience-ful language... 👍👍❤
Kitne hours Tak khtm ho jati hai ye video
@@saimsingh1122 वीडियो तो 10 घंटे का है सो 10 घंटे में खत्म हो जाएगा लेकिन अगर आप प्रैक्टिकल करते हुए साथ साथ विद्यार्थी की तरह सीखेंगे तो एक हफ्ता लग जाएगा
@@sdutt5384 ok sir thankyou
Aapne online exam kyse di
@@nargiskannoje9592 mene exam nhi diya. exam link update nhi hai. iske regarding mene trainer ko tag krke link update krne keliye request kr chuka hu
very helpul vedio without any cost..i had no idea of excel ..but after watching vedio.. i can work in excel without any doubt..so thanks very much sir
before this video I don't know about excel but when I saw this video I fully know about excel. thankyou chandan sir for providing this video.
Plz help me
This is the best Excel course Video on youtube..
Must watch ......For beginners....❤
I Got certificate from your site thanks @my live support
Thanks a lot from the bottom of my heart. Finally i got an ISO certificate from you after qualifying the basic excel course through your " My support live " youtube channel.
Certificate kese milega iska
@@thanvipresents493 link is given in the description box.
U r doing a great job teaching Thank you!
I also recieved certificate after clearing the assessment .
A promising video to teach you basics of Excel.
Hey there... can u please let me know if this is fraud or not???
We will get certificate or not after giving exam ??
I didn't get
today i got my certificate sir 👌, ❤❤❤❤❤❤❤❤❤❤❤❤unlimited love and respect for you sir 🙌🙌
How much time it take
how to take the exam and get the certificate?
Row column 3:42
5:50
6:50
11:28
12:53
17:03
17:15
20:26
20:07
29:07
36:30
48:25
51:39
55:15
55:29 *
58:01
1:40:22 border
2:17:00 Format cell alignment
2:19:24 indent decrease increase
2:21:09 width auto adjust
2:21:51 auto edit by key board F2
2:27:07 merge
2:30:19 merge across
2:32:58 unmerge
2:34:07 unmerge and left
2:35:55 shrink to fit, text size reduced
2:40:03 convert to nornal value, change percentage sign in value
2:40:24 convert percentage or date in normal value
2:41:44 change currency in rupee
2:46:28 difference between currency and accounting
2:48:44 change date format in excel
2:49:45 long date short date
2:51:03 time
255:31 percentage
2:55:56 fraction
2:56:52 scientific format
2:59:09 accounting number format rupee symbol
2:59:42 accounting number format various currency symbols
3:02:03 comma full stop dot
3:03:38 increase decimal decrease decimal
03:05:01 more number format ( text format)
03:08:00 custom number format
3:08:49 automatic zero before number, five digit number etc
3:11:13 sum shown in status
3:11:40 general number format
3:13:21 conditonal formatting
highlight conditional formatting
3:14:09 highlight conditioning colour selection
3:18:07 conditional formatting special feature highlight feature
3:18:40 remove conditional formatting
3:20:29 text that contains
3:23:12 date highlight
3:26:23 duplicate values and unique values ie values used only once
3:28:27 top bottom rules
3:31:48 above average below average
3:33:22 above percentage below percentage
3:35:38 data bars more colorful low colourfull
3:38:35 color scale colour scale different colors for different data
3:41:24 conditional formatting icon
3:45:46 format as table
3:48:10 create table shortcut is control plus T
3:48:26 table heading special point
3:50:03 benefit of converting data into table format
3:51:30 copy paste formula shortcut control plus D
3:53:53 benefit of using table in MS excel
3:58:33 cell style special function
4:52:11 format command in excel row height
4:29:26 auto fit row height, row height is in format in home
4:39:01 show unhide, rename is in format in home, move sheet copy sheet is in format in home
4:46:25 tab color sheet color
4:47:36 password protect sheet is in format in home
4:49:14 unprotect sheet
4:50:05 lock cell protect cell format home
4:50:58 formula protect formula password data password format home == select entire data - - right click - - choose format cell - - go in protection - - unclick locked - -
4:51:56 formula password
5:09:53 autofit special feature
5:19:36 text in same column
5:21:44 flash fill gst number me se pan number nikaalna
5:25:25 shri chandan kumar mr chandan kumar delhi 110039
5:29:11 home clear formatting data content cooments hyperlink
5:32:54 home data sort filter
5:45:24 go to cell
6:00:00 chart
6:12:00 insert link hyperlink, insert header footer
6:17:13 header footer not showing
6:24:35 manual mathematical equation write mathematical equation ink mathematical equation
6:28:31 symbol size special
6:30:45 print
6:32:08 return to file press escape in keyboard
6:42:46 collate print
6:52:27 heading on all pages
7:05:03 text to colum example rajesh, ram, shyam
7:09:23 remove duplicates
7:12:01 goal seek function data what if analysis target left target set
7:21:32 reduce decimal
7:26:06 data group ungroup
7:31:00 view insert delete comments
7:37:30 view tab
7:46:26 freeze panes
7:50:08 start new line in same cell shortcut alt+enter, edit in cell press F2 in keyboard
7:55:14 freeze keyboard key F4,, absolute range, conditional formatting ifcondition
7:59:57 special point range shifts below
8:02:37 special point double click to apply formula
8:05:32 freeze good way
8:07:07 save charts in image form keyboard key F12, save as shortcut F12
8:08:25 flash fill function shortcut ctrl + E, shortcut written in pop up
8:14:30 sort row
8:15:45 filter secret tips, shortcut ctrl + shift + L
8:28:20 convert excel data in image
8:29:40 data entry in ms excel
8:31:17 entire sheet automatically adjust
8:35:50 write large number value, shortcut format cell dialog box Ctrl + 1., convert number in text by using single cot
8:39:44 Basic formula, sum shortcut alt + =
8:46:22 shortcut F2, esc
8:55:40 freeze, dollar freeze, F4 freeze
09:03:00 double click to apply formula,
9:07:15 special knowledge, percentage, double click on cell corner
9:10:44 percentage calculation,
9:11:09 count counta count blank
9:16:54 vlookup hlookup sumif sumifs concatenate
9:19:09 select entire row ctrl + shift + side arrow, false zero true one
9:23:56 vlookup works left to write
thanks
Thank
Thanks a lot bhai
Thank you so much
Did u got certificate ?
Best you tube channel in education category one stop channel for computer education 👌
Sir i like your excel course video i have learned a lot here thank you for sharing your knowledge with us
My pleasure 🥰
Bohot hi informative video h. Saral bhasha me hoone ki vajah se samajhna bhi bohot aasan h ..... thank you very much 🙏
Sir thank you so much for providing such content. As a teacher, you have done a great job. Thanks, a lot sir ♥️
thanks sir ji, ajj mai full course comple kiya. bohot acche se explain kiya hai aap again thank you❤❤❤❤
thank you so much!Your way of explaining is very good, my experience was very good. Got the certificate shortly after the online exam
Result bhi mil gya sir aur snjh m bhi aa gya bht kch thnx alot sir jiii nd bht accha certificate thanx alot i am so happy 😊 😃 😀 ❤ 💙 💜 💖
Excellent training. Thanks for sharing. From: Saroj Parikh, Columbia, MO, USA
Thanks a lot pure you tube par apse achcha koi nahi excell sikha sakta hai
Sir thank u so much ,, these 10 hours i spent on this channel are so fruitful.loved ur content ❤️❤️
Sir, aapne itne easy way me padhaya hai, so much thankyou
Thank you very much sir for sharing this wonderful piece of knowledge with us. I completed the course and got the certificate today.
How we get a certificate ??
Certificate kaise milta hai mujhe bhi btado
Kya karna hota hai
when do we receive our certificates after exams. Its already been 9 days since I gave exam.
Thanku sir
I hv completed 10hr course and finally got cretificate
The way you explain is so easy to understand, I really appreciate your work sir, I gave the online test and got certificate also🔥
Right bro
Online test kha dena Hai???? Certificate kaise laina hai??
@@letslearn1470 Bhai
Description mein jaake FOR ONLINE EXAM likha hoga woh link pe click karo.
Badme website open hua toh neeche jaake “Click here for MS Excel Online Exam - यहाँ क्लिक करें” ispe click karo aur google form open hoga apna details bharke EXAM DEDO aur certificate mail ✉️ pe aa jayega ✌🏼
How can I get certificate.please tell me
@@DearStudent272 good
Best Excel course across UA-cam Channels👍🤘
Thanks for ❤️
Wow! Great information and knowledgeable video. Thank you so much for your great effort in the service of humanity. You are great Sir!
👹👹😈😠😠
thank you my live support, finally I have got certificate
Excellent teaching skill sir thank you🙏
Thanks sir . I score 29/30 and post completion of the exam I received the certificate in my email.
Jo jo mere comment ko padha Raha hai bhagawan kare uske maa baap ki umer labi ho jaye 🙏🏻🙏🏻
Thank you sir aapka video mene pura dekh liya hai ... Mujhe ab excel bahut acche se aane laga hai thank you so much sir 🥰🥰🥰
Fantastic sir. It's a pleasure for all students
Thanks, if this video get more attention of subscriber. I will upload more courses.
Thnku so much sir 🥰❤️ I got 23 marks nd received certificate ❤️🥰 lots of love sir 🥰❤️
Great work sir you should explain very nicely after watching this video i learn about excel perfectly but sir you do not provide the link of certificate and practice notes you should provide these both things so you will perfect in excel.
bhai certificate lene ka kya procedure h
@@thembaguy5537 There is one channel on youtube as a name of anil computers udaipur you can watch this video
Thankyou so much sir mujhe Excel ka cirtificate mil gaya hai muje 30 question me se 20 number mile the Thankyou so much sir
Sir Ek video Tally prime ki basic level se advanced level tak
U8i⁸⁸pi⁸88⁷⁸7 est en ⁷ avec ¹à
Plz sir tally ka b basic to advanced le kr aye all in one 🙏
3
Plz sir
Sir please
yehh !!!!
i have given the exam and i got the certificate
thankyou team
How can you tell me the process
Please help me I need the certificate
Go to the website and give the exam if you pass then you will surely get the certificate
@@helloashisramcan u share link
Really ,you are a great man sir ji🙏
Thanks 😊
Thank you for this video sir, we need powerpoint and photoshop full course video
Sir mai aap ka Excel ka full dhekh kr bahaut method sikhne kelie mila hai
Aap ka bahut bahut shukriya sirji
Ek video tally ka bhi apdate kijie sir
Aur mera ms Excel ka certificate kab milega sir
great explanation...really good session for beginers....thankyou so much sir.
Right maa'm
Hi hello how are you
Hello sir, aapne bhut ache se video mai excel easy tarike se sikhaya hai.
Very nice session and information.
You have very nicely explained the basic concept of exel. I have given online exam today and received the certificate instantly. Thank you!
Can you please tell me how we can give a exam
Fake certificate hai
Hi
Amazing video 🥰🥰 i scored 25 and got my certificate. Thank you sir 😊😊
How to get certificate?
Very nice sir, your method of teaching is great, thank you so much sir
ua-cam.com/channels/hr03sND5CL8MQT8_1AFc5g.html
The best class ever in the history of you tube 🙏🙏🙏
Me who watching on 1.75x speed 😂😂
I have got my certificate instantly after clearing test .Thanks a lot
Where to clear test ?
Just wow😍
Tq very much sir you are the great teacher maine bahut dundha par aapke jaisa koi nahi bataya tq again abhi ek part dekha aapka video bada hai isko part me dekh raha hu 🙏🙏🙏🙏🙏🙏👌👌👌👌👌😊😊😊😊😊❤️❤️❤️❤️❤️❤️❤️
Sir thank you so much 🙏🙏..
U did lots of effort for making this video for us.
God bless you sir.❤️🙏
Sir tomorrow is my interview of the related topic so sir please provide some material or pdf of important questions that can be asked in the interview regarding excel.
All the best, No PDF, watch video again for revision
@@MyLiveSupport ok sir thank you so much 🙏🙏
@@sakshikatiyar7091 hi hello
ua-cam.com/channels/hr03sND5CL8MQT8_1AFc5g.html
Hii
Thanks sir i attemt your online exam and clear i recived my certificate in just a few minutes after clear the exam very fast service you have thanks sir once again to give me this excell certificate
Great!!!
Keep it up
Thanks 😊
बहुत बहुत धन्यवाद गुरु जी.. आपने बहुत अच्छे से समझाया है ♥️♥️
Sir G aap bahut accha samjhate hai.
Thanks a lot for you.
Nice session and information it would be much useful if the data sheets or the sheets used in the session available for practicing and for references thank you
Thanks a lot 😊
ua-cam.com/channels/hr03sND5CL8MQT8_1AFc5g.html
@@MyLiveSupport @MyLiveSupport ... चंदन सर, ऑनलाइन एग्जाम की लिंक अभी तक अपडेट नहीं हुई. आपने बोला था कि आईएसओ सर्टिफिकेशन करवा रहा हूं एक हफ्ते में हो जाएगा. लेकिन आज 1 महीने से ज्यादा दिन बीत गए अभी तक लिंक अपडेट नहीं हुआ. मैं हमेशा चेक करता हूं. हमें और कितना इंतजार करना पड़ेगा कृपया सही कारण बताएं.... धन्यवाद
@@MyLiveSupport sir MIS kaha pe hai
P
Thank you Sir ji
Mujhe Certificate mil gya .
Dhanyawad sir ❤️
Hello Sir
There are many students struggling with certificate exam link is pending from last 1 month
So either provide some information regarding the same or remove the certification part
Mila bhai??
@@maheshrawat1030 yes..
@@iamindian9234 maine 1 month pehle message kara tha tumne itni late kaise dekh liya? Kyuki notification to shayad ussi time a jati h