TOC - 1:25 Session starts - 2:29 [1] Analysing data - 4:03 [2] Linking data - 15:23 [3] Sharing n reviewing - 18:40 [4] Macros - 21:26 Thank u so much sir for this Session 💓
00:06 Today's session covers e-spreadsheet in IT402 and its importance in the theory examination. 03:01 E-spreadsheets for calculations and data analysis 06:16 Consolidation, subtotal, and scenarios for data analysis. 09:40 Calculation of EMI and multiple operations in electronic spreadsheet 13:01 Goal Seek and Solver in electronic spreadsheets 16:24 Absolute vs Relative Hyperlinks 18:36 Benefits of sharing and reviewing spreadsheets 21:15 Using sharing and reviewing in e-spreadsheets 24:07 Chapter completed with focus on easy concepts
Hello Sir, i don't know if you'll read this. But Thank You So Very Much. IT is a small subject, hence the study-videos out there aren't of the greatest quality. But studying from an IITian really helps this subject. I wish I could have found you earlier. Keep Publishing Such Videos on Other Subjects too :)
Tbh there many good channels who teaches IT for class 10th but all of them seems so formal and only explains what is written in the book but akash sir's channel seems more like your senior or bhaiya is teaching you in simple language and clearing basically all the concepts !! And tbh these amazing qualities of a person can make any subject so interesting and easy !!! Btw thank you so much bhaiya bcz of you i scored 47-49/50 everytime in computer's exam !!
Power of teacher you had changed the career of Ronaldo from footballer to SBI worker 😂😂 Apart from this u are the great teacher as well as mentor so appreciate to work ❣️❣️
I won't lie bhaiya, I'm not even going to take up computer related subjects in grade 11 but because your videos helped me so much , i subscribed 🌜 Thankyou so much for all the efforts you've put in!
My school teacher did not teach this well for the whole year and you taught so efficiently in just a matter of minutes. I have my exam today and thankyou so much for the help sir
Attack On Titan Fan's Should have realized He is wearing a shirt with Survey Corps Batch Attached Thank You Sir This video actually clears up all the doubts.............
i was literally having a breakdown for IT ,,but ur videos literally helped me so much like in preboards i scored highest because of u and now one night before the board exam i am back here
Bhaiya pehle lg rha tha ki IT me kuch padha nhi hai and i am going to fail. But, after seeing your videos i can proudly say that i can score high marks even by studying before 1 day.. THANKS A LOT 💖
bhaiya i litrally love u from my bottm of my heart ....>>> i wish i could met with you yrr bhaiya sumita arora ka jb mai book dekhta hu to pagal jaisa ho jata hu but aap one shot mai acche pura ake unit padha dete ho ...!! u are true gentleman 🙏💜
I am veryyyy gland to see this video. Its real helped me to take 99% In past i was taking 45%. It realy helped me Thank you so much sir ❤ I like to see ur video and its interesting Do video like this ok Nicee...... I am lucky to see ur video Tqsmmm❤
I am in 9th and our school have this book for both 10 & 9 class thx, sir, sir you are a very good teacher I don't understand anything in school but u made it very clear thx❤️🤞
Thank you so much Bhai for such a wonderful and easy explanation. But I have a query, our teacher told that you need to learn the steps too but in any of the sample papers they didnt asked any steps. So please tell me should I do steps too or just the theory that you've told!
Sir please please make practice sessions of IT class10 exam is very near, MCQ practice, one word questions practice, and important questions according to 2023 syllabus please 😭😭😭😭😭😭😭😭😭😭😭
bhaiya accidently found and before i was wooried about IT but now it is too easy thankyou soo much btw on query tg ki link open nahi ho rahi hai plz reply 👍
TOC - 1:25
Session starts - 2:29
[1] Analysing data - 4:03
[2] Linking data - 15:23
[3] Sharing n reviewing - 18:40
[4] Macros - 21:26
Thank u so much sir for this Session 💓
Thanks dude
THX btw aur likes. Milenge tujhe 2 din hain abhi
@@hemaanggupta8183 😂
Iska practical kaha milega?
bro thanks
World cup yaad nahi dilana tha sir😭
Bhai video wc ke 9 mahine pehle bani thi
I am so glad to see your videos on IT subject because someone is there who gives right direction to us for our boards exam
IT ke to bahot videos hai but ye quality video hai
00:06 Today's session covers e-spreadsheet in IT402 and its importance in the theory examination.
03:01 E-spreadsheets for calculations and data analysis
06:16 Consolidation, subtotal, and scenarios for data analysis.
09:40 Calculation of EMI and multiple operations in electronic spreadsheet
13:01 Goal Seek and Solver in electronic spreadsheets
16:24 Absolute vs Relative Hyperlinks
18:36 Benefits of sharing and reviewing spreadsheets
21:15 Using sharing and reviewing in e-spreadsheets
24:07 Chapter completed with focus on easy concepts
steps board exam me nahi ayege ?
@@cutegirl..777 yes
Hello Sir, i don't know if you'll read this. But Thank You So Very Much. IT is a small subject, hence the study-videos out there aren't of the greatest quality. But studying from an IITian really helps this subject. I wish I could have found you earlier. Keep Publishing Such Videos on Other Subjects too :)
Tbh there many good channels who teaches IT for class 10th but all of them seems so formal and only explains what is written in the book but akash sir's channel seems more like your senior or bhaiya is teaching you in simple language and clearing basically all the concepts !! And tbh these amazing qualities of a person can make any subject so interesting and easy !!!
Btw thank you so much bhaiya bcz of you i scored 47-49/50 everytime in computer's exam !!
Bhai ek baat btao..aakash bhaiya ne steps nhi btaye hain. Vo nhi aate kya waise exam mei?? Mai confused hu🙂
Power of teacher you had changed the career of Ronaldo from footballer to SBI worker 😂😂
Apart from this u are the great teacher as well as mentor so appreciate to work ❣️❣️
I won't lie bhaiya, I'm not even going to take up computer related subjects in grade 11 but because your videos helped me so much , i subscribed 🌜
Thankyou so much for all the efforts you've put in!
Glad to hear that!
You really deserve more bhaiya. You're the best teacher of IT I ever met.💛
genuine
Met???
Neighbours huh?? 😅😂
Btw..fr ❤
8:02 kya fayda..wc final to haar gae😢😭
13 March wale attendence lgao 😅
Uss😅
My school teacher did not teach this well for the whole year and you taught so efficiently in just a matter of minutes. I have my exam today and thankyou so much for the help sir
Bro i literally didn't studded it this year but now after watching the videos I have got all the topics fit in my mind
same
STUDDED SALE UNPAD GAREEB CHAKKE STUDIED HOTA HAI
Sir u are a very underrated teacher..Love ur videos ❤
20:36 such a good teacher
Attack On Titan Fan's
Should have realized
He is wearing a shirt with Survey Corps Batch Attached
Thank You Sir This video actually clears up all the doubts.............
Yea
+1
I think he's a ronaldo fan
No he watched aot
True@@ninasingh9299
Cristiano !!!!! 🗿
SUIIIIIIIIIIIIIIIIIIIIIIIIIII!
@@ninasingh9299 aot means attack of titans!
Exam today and I'm learning now, you really saved me
you are such a genius.
you explain the chapter in a very simple and intresting way
thankuuu so much sir ...........
14:43 sir goal seeks defination is not changed its the same as the defination of multiple operations...
Ronaldo after learning about macros - suiiiiiiiiiii..!!!😂
10:40 Bhaiya, wouldn't someone go for the least interest rate?
and If the interest rate goes down, so would the EMI
Ab to paper bhi hogya
Bhaiya , I love ur calmness while teaching .💝💝
Please Never let your calmness go away💜💜😌
i was literally having a breakdown for IT ,,but ur videos literally helped me so much
like in preboards i scored highest because of u
and now one night before the board exam i am back here
Was this video helpful for mcqs?
Sir🙋, maine pura TH-cam pe, itne Kam Time me , bahot kuch ( sara) easily samjha diya ..... Really helpful 😃 , respect 😇😅...no match 🔥
sir tomorrow is my preboard and your videos help me a lot
Ganta kuch help nahi kara
😂
24:47 hey why am i watching a it lecture video i forgot everything 😂
😂😂
Kal computer exam hai aur maine pehle kuch padha nahi tha but aapke videos dekhkr saare topics clear ho gaye 🎉
Arigato bhaiya ❤️
At this time your videos are helping like someone brings water to a thirsty crow🥰
Bhaiya pehle lg rha tha ki IT me kuch padha nhi hai and i am going to fail. But, after seeing your videos i can proudly say that i can score high marks even by studying before 1 day.. THANKS A LOT 💖
2:29 , 2:37 , 2:39 , 2:42 , 2:45 , 2:46 , 2:49 , 2:52 , 2:55 , 2:58 , 3:01 , 3:03 , 3:05 , 3:08 , 3:12 , 3:15 , 3:18 , 3:21 , 3:24 , 3:27 , 3:30
Thank u sir (for simplest teaching of LT 402)
Best teacher ❤❤❤❤❤❤❤
thanks a lot sir ,i used to hate IT but after watching ur videos i have started liking it thank u bhaiya
bhaiya thank you for all your kind work for us ❤
I fell in love with your teaching skill at the first sight and also you became my idol as you are a IITB graduate
Hi 👋 guys you can switch to 1.5 x it will be clear to understand lecture in less time for this channel
The Most Crisp Lectures for I.T. Code 402....Literally Fabulous Bhaiya😘❤
7:13 marker total 5500
bhaiya i litrally love u from my bottm of my heart ....>>>
i wish i could met with you
yrr bhaiya sumita arora ka jb mai book dekhta hu to pagal jaisa ho jata hu but aap one shot mai acche pura ake unit padha dete ho ...!!
u are true gentleman 🙏💜
I also have sumit atora is he enough plz tell tmrw pre board
You got a new subscriber ❤
Isse jyada helpful kuch nahi ho sakta❤❤❤❤❤
21:42 i literally imagined a fat Ronaldo in a light blue shirt and a tie🤣🤣🤣🤣🤣🤣🤣
Thankuhh so much sir 🥰 to clear my all doubts 🤗😘
Best Lecturer of IT for class 10th
Do we need to learn the syntax in macros .? Does formula based questions come in exams?
no
IT seems easy when Akash Bhaiya teaches 😅
Best It teacher
We didn't have any IT teacher at all
Just started IT in the end your videos help a lot
the ronaldo example is so good
Tomorrow is my board exam and i didnt understand this ch but suddenly i found this video thank you so much sir
I thought that I am going to fail in IT but then I came across your videos and now I will not fail atleast
BHAIYA BECAUSE OF THE YOU ADD IN BTW IT HELPS A LOT TO LEARN WITH EASE❤❤
Love you sir not only you have covered the syllabus you had also put a great effort ❤
I don't know if yo read this message. But your videos are helping me for my class 10 exams. Thank you bhaiya for everything.
7:53 yaad mat dilao bhyiya 1😂😭 WC India har gya
I am veryyyy gland to see this video. Its real helped me to take 99% In past i was taking 45%. It realy helped me
Thank you so much sir ❤
I like to see ur video and its interesting
Do video like this ok
Nicee......
I am lucky to see ur video
Tqsmmm❤
9:00 required run rate will be 6.44 runs/per over
Sir your are great which our school teachers had not taught us you teach us . I hope I will score good after seeing this video
Thank you..........
I am in 9th and our school have this book for both 10 & 9 class thx, sir, sir you are a very good teacher I don't understand anything in school but u made it very clear thx❤️🤞
Thanks sir
My concept is clear when I watch your video 👏👍😀
sir, after seeing all your IT code 402 video lectures I am tension free now
thanks a lot
❤❤
Please bring videos fast and also important questions of IT.
I love your videos....I have never seen someone teaching IT in such an easy manner ....Thanks for teaching us
Nice explanation 👍🏾
👍👍
Sir Do we need to learn the steps of the features of Spreadsheet?
Sir dil se kahu, AAP millions subscriber kr hakhdar ho 🙋💝,,, sach sir your content = Quality content 😇
I also secore 47/ 50 by just studying your video notes thanku
Thanks sir for giving us your precious time you will be a lot Sir
Thanku sir this video is also helpful and yaa some topics aar left 💌
Which topics?
No bhaiya this is correct all topic are cover
Sir aapne deleted topics bhi cover kiye ??
Thank you so much Bhai for such a wonderful and easy explanation.
But I have a query, our teacher told that you need to learn the steps too but in any of the sample papers they didnt asked any steps.
So please tell me should I do steps too or just the theory that you've told!
I have a question : any subtopics like setting up and inserting hyperlink , linking to external data and many others are imp. or not ??????
Best explanation 🥲 whole chapter cover in 24mint
Consolidate data = relational database
Aakash Bhaiya I am so glad that i got your support for my IT exam no one was able to explain me that well
this teacher is so underrated
Thank you so much sir!!!! Tomorrow is my exam.. really helpful
Sir please please make practice sessions of IT class10 exam is very near, MCQ practice, one word questions practice, and important questions according to 2023 syllabus please 😭😭😭😭😭😭😭😭😭😭😭
Hii sir your teaching is very good
21:46 vah sirji , ronaldo ko bhi govt. job dilva di😂
Thankyou so much akash bhaiya.
bhaiya accidently found and before i was wooried about IT but now it is too easy thankyou soo much
btw on query tg ki link open nahi ho rahi hai plz reply 👍
check this: t.me/+c5gWM6PiL085M2I1
thank you sir bacha liya aapane IT sa
Sir , do we have to learn the steps to enable any features for our board exams ?
No
@@aakashsingh. sir , if possible please make a video on important questions of ICT skills 😀🙏
Mujhe school teachers ke pass it smj nhi ati thi bt apke pass ache see smj aa gyi💝🤩
I just started studying for my tomorrow's exam and its like 11:11 p.m now.
Sir chapter 3 basic ict skill ka jldi upload kijiye aur web security ka bhi ok sir fast plz.
Bro is literal meaning of underrated👺
who's on 13th march (i mean its 1am rn)
U r growing really fast...yesterday I saw 8k subs and now 16k
I am so excited to 😊 read with a IITAn of BOMBAY which is my dream ❤❤ salut to you sir and
You are also so handsome ☺️☺️
8:59
Sir it is a very important question to be asked .
Ronaldo or Messi ?
Ofc, the G.O.A.T
Hey bro please answer my this query. Will step writing be asked in the exams from any of the chapters and specifically from this chapter? Reply ASAP.🙏
Sir please Make. One shot for web security also
And for rest of the chapters plz
24:28 how can i like it physically 😂😂
Sir your explanation is superb.👌👌👌 Important question of class 10.
21:45
Ronaldo be like gajab bejite h... 😑
I'm watching this 1 hour before my exam
FR
bro is obessed with ind vs aus but anyways appreciate ur work
sir pls web application ki video aur daal do . kal mera preboard hai , baaki sab ho gya wo reh gya .
Hey Madhavi, it will take some time.. please refer to my Unacademy videos.. and all the best!
@@aakashsingh. thank you sir ! will see it