Sir you are better than many school teachers...... We definitely need a teacher like you to understand and utilise Information technology...... School teachers are only pressuring to do lab activities and record books, without understanding the mentality of students
@@gyanranjan_01 primary key is a field or column in a database that identifies each record in the table uniquely. And it cannot have NULL (empty values)
Thank u so much Sir .... I was searching the best channel to study computer and finally I Found this great and very knowledgeable channel on RUclips.... Even u are teaching better than my IT TEACHER.....THANKS SIR AGAIN CONTINUE UPLOADING VIDEOS.... AND PLZ MAKE VIDEOS FOR TERM 1 ALL POSSIBLE MCQS...
Thank you so much sir. For you only I was able to score good marks in my pre boards . ~Edit - term 1 over IT paper over~ not happy with the score :( *21/25* Was Expecting more.......
Thankuh so so so so so much sir... Bhgwann apko itni trrki aur khushi de... Apki wjh se hi mai kl conputer ka paper dene ke kabil bn paaugi.... Hat's off to ur teaching sirrr🧿.. Gby
Seriously sir aaappp jesa to hamare school wale sir bhi nhi padhate you are the best sir aapko vajah se mere achhe number aane ki probability bhad gayi he 😄😄😄😄🙏🙏🙏🙏🙏🙏😊😊😊 thanks sir
If you are also watching this video. I prey to God for you that you will get 💯💯✅✅🎉🎉🎉🎉🎉😂😂 But if you ignored this msg then you will fail😂😂😂😂😂😂😂😂😂😂😂 Don't take risk it's IT
Due to online classes I didn't even knew the basics well and can't even ask others about the basics cuz they will tease obviously but because of you I learnt everything, Thankyou so much Sir :)♡
00:03 Introduction to the new unit, Prince, in the electronic spreadsheet 00:51 Introduction to subscribing to the computer software 03:22 Customize formatting options in spreadsheet 04:34 Utilize background colors and alignment options for effective spreadsheet formatting 07:19 Functions can be used for various tasks 08:59 Learn how to use functions in spreadsheets 12:14 Discussing the concept of mixed reference in Excel spreadsheets. 14:04 Explaining right-click paste function and its relevance. 17:10 Learn to subscribe and utilize the subscribe button effectively 18:22 Exploring various options after right-clicking 21:10 Drag and drop to move and apply values in a spreadsheet 22:23 How to subscribe to the channel and change selection 24:40 Understanding product quantity and placement 26:33 Creating a new sheet for data consolidation 28:20 Consolidate data for advanced functions 29:05 Introduction to automatic January sheet 30:41 Automatically update and consolidate data in Excel spreadsheets. 31:20 Total charges and simple total calculation 32:58 Understanding the total in a particular category 33:42 Advanced spreadsheet functions for inventory management 36:31 Renaming files and using functions in Excel 37:17 Learn about advanced spreadsheet functions 39:08 Understanding total of specific cells and ranges in spreadsheets. 39:55 Subscribe for access to advanced spreadsheet functions. 42:06 Using functions and buttons for simple tasks 42:48 Tips for using front spoch in Friends City recording 44:17 Understanding the definition and practical aspects of electronic spreadsheets. 45:33 Learning about advance features of electronic spreadsheets 48:36 Explaining the process of comment inserting and rating 49:49 Change cell color and value in the electronic spreadsheet 52:11 Understanding multiple operations in electronic spreadsheets 53:57 Understanding quantity and profit calculation in spreadsheet 56:30 Understanding the maximum profit potential based on quantity and price 57:16 Perform multiple operations on selected cells 59:27 The video covers advanced operations on electronic spreadsheets. 1:00:37 Demonstrating practical handling of spreadsheets 1:04:06 Understanding application of profit percentage in spreadsheets 1:05:15 Understanding subscription percentages and benefits 1:08:05 Selecting intuitive cells in an electronic spreadsheet. 1:09:33 Understanding Simple Interest Calculation 1:11:39 Calculating maximum price and expenses for products 1:12:33 Understanding Profit and Unit Price Calculation 1:15:20 Understanding the changing prices and values of products. 1:17:03 Learn to apply pricing in an engaging calculator style. 1:19:20 Subscribing to the channel and creating, transferring data across sheets 1:21:03 Selecting and changing options in electronic spreadsheet 1:24:09 Guide on subscribing and managing subscriptions 1:25:57 Subscribe for further updates 1:29:11 Advanced techniques in spreadsheet operations 1:30:49 Exploring advanced features of electronic spreadsheets 1:33:33 Learn to link Twitter handle on Instagram 1:34:48 Using basic options to navigate and utilize the system efficiently 1:37:51 Demonstrating how to subscribe and save a PowerPoint presentation 1:39:19 Sharing and securing spreadsheets online 1:42:03 Explaining how to change and save a file 1:43:45 Understanding share options before formation 1:46:03 Understanding permissions and sharing in Excel 1:46:50 Updating files for class 10 exam results 1:49:51 Learn to comment, edit, track changes, and save files 1:51:15 Learn how to make time entries in a spreadsheet 1:53:40 Creating and managing passwords for advanced spreadsheet functions 1:54:49 Creating and recording command sequences in spreadsheets 1:57:38 रूबी क्या करना मुझे सबसे पहले अपने मैक्रो को रिकॉर्ड करना बिल्कुल जरूरी 1:58:45 Data recording process in electronic spreadsheets 2:01:00 Understanding Special Symbols in Spreadsheets 2:02:03 Creating a folder and a module in Excel macros. 2:04:32 Changing marks and modes in electronic spreadsheet 2:05:52 Understanding color coding in spreadsheets 2:08:45 Learn about different options and where to go without wasting time. 2:09:56 Understanding how to change the name and subscribe 2:12:37 Using different colors in electronic spreadsheets for better visualization. 2:13:18 Creating and using functions in a spreadsheet 2:15:36 Covering various advanced topics in Electronic Spreadsheet
Very very very very very very very very very very very very very very very very very very very very very very very very very very very very very very very very very very very good 👍🏻
Sir you are really a very great teacher yesterday our IT board exam was there yesterday and I want you to know that my exam went extremely well because of you. At first I became very nervous after seeing the ques paper because not even a single mcq was there which I had studied but because of you all my concepts were clear and I was able to ans each and every ques. Thank you very much sir❤❤
Thank you so much sir.....i can't express my special thanks to you .....i was finding video on open office calc and here you are .......thank you so much sir ....
Sir please explain in English .. As I was speaking Tamil but I know little bit of Hindi so I can understand ... But you are a good teacher... Please try to explain in English
Sir linking data from different file jab aap Bta rhe thy 1:31:25 pe to Jo file apne dousre file se link kiye tha (Quantity wala) to ousme cell ki value change Q nhi hui?? 😢😢 Agar link hai to ousme change karne per isme bhi to change Hota na??😢😢😢😢
(Basics) - @ - 00:00:00
Spreadsheet (Consolidation) - 00:23:55
Spreadsheet (Subtotal) - 00:32:39
Spreadsheet (scenario) - 00:44:22
Spreadsheet (multiple opreation) - 00:51:30
Spreadsheet (Goal seek) - 01:00:26
Spreadsheet (Solver) - 01:10:52
Spreadsheet (Link Spreadsheet data) - 01:17:47
Spreadsheet (HyperLink Spreadsheet ) - 01:32:16
Spreadsheet (Share and Review) - 01:39:20
Spreadsheet (Track Changes) - 01:46:08
Spreadsheet (Macros) - 01:54:35 (Consolidation)
Thanku 🙏🙏🙏
@@pw.followers4207 discription me pehle se diya hua tha !!😂usne copy kiya
(Basics) - @ - 00:00:00
Spreadsheet (Consolidation) - 00:23:55
Spreadsheet (Subtotal) - 00:32:39
Spreadsheet (scenario) - 00:44:22
Spreadsheet (multiple opreation) - 00:51:30
Spreadsheet (Goal seek) - 01:00:26
Spreadsheet (Solver) - 01:10:52
Spreadsheet (Link Spreadsheet data) - 01:17:47
Spreadsheet (HyperLink Spreadsheet ) - 01:32:16
Spreadsheet (Share and Review) - 01:39:20
Spreadsheet (Track Changes) - 01:46:08
Spreadsheet (Macros) - 01:54:35 (Consolidation)
@@MGcric7 ?
Kyu diya ha Video me diya hua ha pehle se hi nub
Sir you are better than many school teachers...... We definitely need a teacher like you to understand and utilise Information technology...... School teachers are only pressuring to do lab activities and record books, without understanding the mentality of students
Remember you are special: no one play your role better than you
All the best for your IT exam 👍👍
Right
50 ka ppr hota h bhai
Spreadsheet (Basics) - 00:00:00
Spreadsheet (Consolidation) - 00:23:55
Spreadsheet (Subtotal) - 00:32:39
Spreadsheet (scenario) - 00:44:22
Spreadsheet (multiple opreation) - 00:51:30
Spreadsheet (Goal seek) - 01:00:26
Spreadsheet (Solver) - 01:10:52
Spreadsheet (Link Spreadsheet data) - 01:17:47
Spreadsheet (HyperLink Spreadsheet ) - 01:32:16
Spreadsheet (Share and Review) - 01:39:20
Spreadsheet (Track Changes) - 01:46:08
Spreadsheet (Macros) - 01:54:35
ty
Thank you 😊
Thanx Sir..It was just Amazing no one has given this type of simple explanation
Thanku so much sir because of you I scored 40/40 in my PT 1 IT exam ...
Spreadsheet (Basics) - 00:00:00
Spreadsheet (Consolidation) - 00:23:55
Spreadsheet (Subtotal) - 00:32:39
Spreadsheet (scenario) - 00:44:22
Spreadsheet (multiple opreation) - 00:51:30
Spreadsheet (Goal seek) - 01:00:26
Spreadsheet (Solver) - 01:10:52
Spreadsheet (Link Spreadsheet data) - 01:17:47
Spreadsheet (HyperLink Spreadsheet ) - 01:32:16
Spreadsheet (Share and Review) - 01:39:20
Spreadsheet (Track Changes) - 01:46:08
Spreadsheet (Macros) - 01:54:35
Thank u❤
I scored _24 /25__ in my IT paper
I will be editing this after giving my IT paper which is on 25 Nov😁😁
Finally edited this comment😎👽 with a good score
MERA BHI PAPER HAI BHAI EK DOUBT THA KI MS OFFICE PE BASED QUES AAINGE KI LIBRE OFFICE PR BASED?
@@trrigeredinsaan3943 libre office aaj hi hamare teacher ne bataya tha ki libre office based hoga.
But inn dono ko itna kuch difference nahi he.
Bhai aapko primary key ke bare me pta hai kya?
@@gyanranjan_01 primary key is a field or column in a database that identifies each record in the table uniquely. And it cannot have NULL (empty values)
@@gyanranjan_01 ye defination tho mcq me nahi aayega but unique word he tho wo primary ki hi he.
2:07:20 phir seh toh bola parh video cut karnah bhul gaye 🤣🤣🤣🤣🤣🤣🤣🔥👍
Very good video sir .today is my board it exam and I am watching your video because sir you teach very good or best .
A big salute to you sir for working hard for us. ❤️❤️❤️❤️❤️❤️❤️👍👍👍👍
The feeling ☺️ of completing the chapter is awesome 😎
Yo are you here for boards 2022
@@sevoualbotgaming9255 yes bro..... 🙄
Tomorrow is my exam and sir you made me doubt free thanku sir also RUclips recommended me your channel ,so thanx to them also.
Thank u so much Sir ....
I was searching the best channel to study computer and finally I Found this great and very knowledgeable channel on RUclips.... Even u are teaching better than my IT TEACHER.....THANKS SIR AGAIN
CONTINUE UPLOADING VIDEOS.... AND PLZ MAKE VIDEOS FOR TERM 1 ALL POSSIBLE MCQS...
Thanking you sir tommarow is my it exam once again thanks if i can se this video my all things are recall and revised
Spreadsheet (Basics) - 00:00:00
Spreadsheet (Consolidation) - 00:23:55
Spreadsheet (Subtotal) - 00:32:39
Spreadsheet (scenario) - 00:44:22
Spreadsheet (multiple opreation) - 00:51:30
Spreadsheet (Goal seek) - 01:00:26
Spreadsheet (Solver) - 01:10:52
Spreadsheet (Link Spreadsheet data) - 01:17:47
Spreadsheet (HyperLink Spreadsheet ) - 01:32:16
Spreadsheet (Share and Review) - 01:39:20
Spreadsheet (Track Changes) - 01:46:08
Spreadsheet (Macros) - 01:54:35
*given in description*
Legends are watching 1 day before exam for 10 marks😂😂🤣🤣
Bhai 50 marks
Thik hai
Ha bhaii 20 marks😂😂
@@Sanatani_pandit52 watching during exam 🤣
@@2004Officia same 😂
Lalantop ❣️explanation 👌👌
i am watching 2 days before my term1 board on 25 wish me luck
Best teacher of computer 🥰🔥
Thank you so much sir. For you only I was able to score good marks in my pre boards .
~Edit - term 1 over IT paper over~ not happy with the score :(
*21/25*
Was Expecting more.......
I am watching 1 day before Pre board ..lol
@@LearnAsMuchYouCan l was (yesterday )😂
My 50% course is not even TAUGHT till now 😴😴😴
@@Hagrits_hat R.I.P SCHOOL 🏫
@UCtJd9iT4jaEHMGFQhUSXTGw dude in school the mid term conducted
Thankz sir no one had given this easy type of explanation
Iss tarike se bahaut sari chizen hai , jo basic sari chizen hai wo humlog yaha par dekhre hai
ਸਰ ਜੀ ਤੁਹਾਡਾ ਬਹੁਤ ਬਹੁਤ ਧੰਨਵਾਦ ਮੇਰਾ ਕੱਲ ਪੇਪਰ ਹੈ ਤੇ ਮੈਨੂੰ ਕੁਝ ਵੀ ਨਹੀਂ ਸੀ ਆਉਂਦਾ ਤੁਸੀਂ ਮੇਰੀ ਬਹੁਤ ਸਹਾਇਤਾ ਕੀਤੀ❤❤❤❤
Thankuh so so so so so much sir... Bhgwann apko itni trrki aur khushi de... Apki wjh se hi mai kl conputer ka paper dene ke kabil bn paaugi.... Hat's off to ur teaching sirrr🧿.. Gby
thank you sir for the explanation
Best tchr of it on yt for class 10th.. thnk u sir...
Osm explanation it is very useful for me in my school there is practical I confused how to do after see the video I do practical
Chalo Is Baar aap Pass Hojaogi
Can you say syllabus of computer of electronic spreadsheet-Libra office or Ms office
Aap to exam ke itne din pehle se hi padh rahi h ☺️☺️
Seriously sir aaappp jesa to hamare school wale sir bhi nhi padhate you are the best sir aapko vajah se mere achhe number aane ki probability bhad gayi he 😄😄😄😄🙏🙏🙏🙏🙏🙏😊😊😊 thanks sir
Thankyou sir
You re the first I found which take less time and clear all concept by practically (in libreoffice)
So we can easily create theory🙂🙂
You are the best computer teacher ever.
Great sir ☺☺
Thankyou sir for this a lot best channal👋😀😀
very very useful video for every IT student in class Xth.....
I wish all students will get 45+ in IT exam
If you are also watching this video. I prey to God for you that you will get 💯💯✅✅🎉🎉🎉🎉🎉😂😂
But if you ignored this msg then you will fail😂😂😂😂😂😂😂😂😂😂😂
Don't take risk it's IT
Due to online classes I didn't even knew the basics well and can't even ask others about the basics cuz they will tease obviously but because of you I learnt everything, Thankyou so much Sir :)♡
Thank you so much sir....You are genius
Sir thanku it was amazing explanation
This was a very useful, easy and the most important explanation
Thanks sir 👍😌✌️
THANK YOU SO MUCH SIR
00:03 Introduction to the new unit, Prince, in the electronic spreadsheet
00:51 Introduction to subscribing to the computer software
03:22 Customize formatting options in spreadsheet
04:34 Utilize background colors and alignment options for effective spreadsheet formatting
07:19 Functions can be used for various tasks
08:59 Learn how to use functions in spreadsheets
12:14 Discussing the concept of mixed reference in Excel spreadsheets.
14:04 Explaining right-click paste function and its relevance.
17:10 Learn to subscribe and utilize the subscribe button effectively
18:22 Exploring various options after right-clicking
21:10 Drag and drop to move and apply values in a spreadsheet
22:23 How to subscribe to the channel and change selection
24:40 Understanding product quantity and placement
26:33 Creating a new sheet for data consolidation
28:20 Consolidate data for advanced functions
29:05 Introduction to automatic January sheet
30:41 Automatically update and consolidate data in Excel spreadsheets.
31:20 Total charges and simple total calculation
32:58 Understanding the total in a particular category
33:42 Advanced spreadsheet functions for inventory management
36:31 Renaming files and using functions in Excel
37:17 Learn about advanced spreadsheet functions
39:08 Understanding total of specific cells and ranges in spreadsheets.
39:55 Subscribe for access to advanced spreadsheet functions.
42:06 Using functions and buttons for simple tasks
42:48 Tips for using front spoch in Friends City recording
44:17 Understanding the definition and practical aspects of electronic spreadsheets.
45:33 Learning about advance features of electronic spreadsheets
48:36 Explaining the process of comment inserting and rating
49:49 Change cell color and value in the electronic spreadsheet
52:11 Understanding multiple operations in electronic spreadsheets
53:57 Understanding quantity and profit calculation in spreadsheet
56:30 Understanding the maximum profit potential based on quantity and price
57:16 Perform multiple operations on selected cells
59:27 The video covers advanced operations on electronic spreadsheets.
1:00:37 Demonstrating practical handling of spreadsheets
1:04:06 Understanding application of profit percentage in spreadsheets
1:05:15 Understanding subscription percentages and benefits
1:08:05 Selecting intuitive cells in an electronic spreadsheet.
1:09:33 Understanding Simple Interest Calculation
1:11:39 Calculating maximum price and expenses for products
1:12:33 Understanding Profit and Unit Price Calculation
1:15:20 Understanding the changing prices and values of products.
1:17:03 Learn to apply pricing in an engaging calculator style.
1:19:20 Subscribing to the channel and creating, transferring data across sheets
1:21:03 Selecting and changing options in electronic spreadsheet
1:24:09 Guide on subscribing and managing subscriptions
1:25:57 Subscribe for further updates
1:29:11 Advanced techniques in spreadsheet operations
1:30:49 Exploring advanced features of electronic spreadsheets
1:33:33 Learn to link Twitter handle on Instagram
1:34:48 Using basic options to navigate and utilize the system efficiently
1:37:51 Demonstrating how to subscribe and save a PowerPoint presentation
1:39:19 Sharing and securing spreadsheets online
1:42:03 Explaining how to change and save a file
1:43:45 Understanding share options before formation
1:46:03 Understanding permissions and sharing in Excel
1:46:50 Updating files for class 10 exam results
1:49:51 Learn to comment, edit, track changes, and save files
1:51:15 Learn how to make time entries in a spreadsheet
1:53:40 Creating and managing passwords for advanced spreadsheet functions
1:54:49 Creating and recording command sequences in spreadsheets
1:57:38 रूबी क्या करना मुझे सबसे पहले अपने मैक्रो को रिकॉर्ड करना बिल्कुल जरूरी
1:58:45 Data recording process in electronic spreadsheets
2:01:00 Understanding Special Symbols in Spreadsheets
2:02:03 Creating a folder and a module in Excel macros.
2:04:32 Changing marks and modes in electronic spreadsheet
2:05:52 Understanding color coding in spreadsheets
2:08:45 Learn about different options and where to go without wasting time.
2:09:56 Understanding how to change the name and subscribe
2:12:37 Using different colors in electronic spreadsheets for better visualization.
2:13:18 Creating and using functions in a spreadsheet
2:15:36 Covering various advanced topics in Electronic Spreadsheet
27:49 sir koi n sabke sath hota hai😉
A real saviour... Hats off to u sir🌼💗
Gazab explaination but 2x pr hi dekhni pad ri hai, very long vide. nyc..!
Thank you sir it helped me a lot
Yes
The bestest teacher of computer 🖥 I had ever seen
Very very very very very very very very very very very very very very very very very very very very very very very very very very very very very very very very very very very good 👍🏻
Sir you are amazing teacher
Sir is like a god to me
All the best everyone coming here👍👍👍✌
very well explained.. hope it will help me
This video doesn't desire only 4k or 5k likes .
A billion is less for it.🎉
Sir you are really a very great teacher yesterday our IT board exam was there yesterday and I want you to know that my exam went extremely well because of you. At first I became very nervous after seeing the ques paper because not even a single mcq was there which I had studied but because of you all my concepts were clear and I was able to ans each and every ques. Thank you very much sir❤❤
Such a great video i am able to understand all the topics clearly thanku sir
Very good explanation
Very helpful 😊😊
Thank you 😊
Best explanation sir
Thank you so much for this 🙏
Thanks for this sir ❤
02:07:10 apne bloopers dal dia sir
Thank you so much sir.....i can't express my special thanks to you .....i was finding video on open office calc and here you are .......thank you so much sir ....
Very good 👍🏻👍🏻👍🏻
Thank you so much sir your explanation has helped me alot.....👍👍👍❤️
Legend are watching this before last night of exam 😂😂 fact 💯💯
It is really helpful. Thank you sir
Watching it 1 day before exam!
Brother everyone is watching it 1 day before exam
@@xr0nus855 yes 😂
YA IM ALSO 🤣
Thank you so much sir....This video help for board exam...It's great explanation...🤩🤩
Best of luck for your IT exam
sir aap bahut easy way mai padhate hai
अन्य सेल को बदलकर एक सेल का अधिकतम या न्यूनतम मान निर्धारित करने के लिए सॉल्वर का उपयोग कर सकते हैं।
Thank you so much sir for you only l was able to score good marks in my pre board
Best teacher in world of computer sub
Sir please explain in English .. As I was speaking Tamil but I know little bit of Hindi so I can understand ... But you are a good teacher... Please try to explain in English
Thank you sir. Very helpful
Thank you
1000000% better than school teacher ...
Thank you so much sir 😊
Nice explanation 🎉
All the best 👍 for IT exam
Very very very very very very very very very very very very very very very very very very very very helpful 👍🏻
Yes , tomorrow is I.T paper...
Let's see what happens ??
All the best everyone....
27:51 and around ot sir forgot to cut
IT walo..like maro kal pure 25/25...😹😛
sir your videos and explanation is gajab❤❤❤
Which school?
@@hardikagrawal987 haryana se
sonipat 131001 haryana india or kuch batau ke
Interesting chapter 👍
Awesome explanation sir 🎉🎉
Sir linking data from different file jab aap Bta rhe thy 1:31:25 pe to Jo file apne dousre file se link kiye tha (Quantity wala) to ousme cell ki value change Q nhi hui?? 😢😢
Agar link hai to ousme change karne per isme bhi to change Hota na??😢😢😢😢
Well done sir
1:06:09 karne ka kya fayda hai....
Mujhe sare features same hi lagte hai
Sir, you are the best...
Day before exam is most productive day 😂
🤣🤣🤣
Sir sesson was NYC. But 27:00 , you forget to cut video . However, you are appreciable.
Thank you
The video was great I was able to understand everything
Please increase audio sound and
Increase video Speed please
Baap level teaching
Thanx a lot sir
Thank you very much sir
Kl IT exam hai aaj hi padh rhe kl ekdam software engineer bn jaenge😂
Tomorrow is my board exam I am here to score 40 out of 40 can I ? Let's see
First you need to know that IT exam is of only 25 marks
Kar lega agr comment dekhe ke bajay book ko khol ke dekh
@@prashantmishra5769 Tum toh bde hi piro ho
25 ka he🗿
Mera bhi h
thanks a lot