5 years later, you are prolly in the 20s ? there is some kid who turned 15(turns 16 in march) and is being saved right now just like you were saved 5 years ago
Not all heroes wear capes, Mr. Evans Chikasa is the best example and my hero who saved my grades (hopefully). (my exam is tomorrow....im so nervous...)
i know this video is old but if youre reading this a biggggg thank you to you today i had my pracycal exams and i dont know what i could do without these videos
thank you very much Mr Chikasa for all videos you have uploaded. Thank you Mrs Chikasa for allowing him to teach us. I'm really grateful for all and may the Lord God almighty bless you
Hi Mr. Evans! I actually discovered you couple of days ago. My term exam paper 2 was today and you were SUCH A HUGE HELP, though i did miss up in access. Anyways, when i found out that my friends watched your vids too i was like OMG. You are a really, really great teacher Mr. Evans! I hope I can do better on my Paper 3 exam this Monday!
Thank you for this video Evans, it really helped in me securing higher marks in my board exams, thanks to you. These videos were really awesome at explaining the uses of the functions, as excel used to scare me!
The fact that he teaches in a right way while also keeping entertainment on is something rare from channels like these, you are a underrated teacher and deserve more subs >:3
U actually are the best IT teacher I have come across can u please do data analysis on excel 2010 it will be great and majority of student are doing exam in excel 2010
Thank you so much Evans!! You've helped us a lot with our igcse ict exams!! Especially on Tuesday, the paper was a good one, nothing too difficult. Hopefully next Tuesday's paper is the same :)
thanks alot evans......your videos have helped me alot for my preparation for my igcse board exam...which is on the comming thursday..whish me luck..and thank you again so much.
I consider you, Evans Chikasa, a god in the capsule of a human body, if the world ever came to an end, my ice exam, then u would be there to help the people, me, of the world rejuvenate and pass the almighty's test that was supposed to be our dooming fate. Again I thank you for allowing me to not kill myself in despair for my ICT practical exam.
Thanks a lot for the tutorial. I have CIE exams of paper 32 tomorrow, so your videos are really helpful. Excuse me for my crappy english. Also keep up the wonderful work.
@evansChikasa you should change the format from csv to word document . its a must, if u didnt do that an say for example u shut ur computer down by mistake or just turned the word document off all the data and editing on it will be gone and it will return to its original form.
Yes, you are right. Forgot to save the evidence document as a word processed document from rtf in step 1. The formatting might be lost if you used various formatting which are only supported by word. I understand what you mean. Many thanks
Evans Chikasa your welcome! Your conternt is really good i always get straight A*s(i am a 10th grade student) when i submit any paper done using your instructions. Btw i wanted to ask u if u have ever heard of an html program called sharepoint designer by microsoft. It has many similar stuff like sharepoint as its done by the same company.
Yes, I have heard of it. a number of students have asked me to use it, also dreamweaver, kompozer and many packages that different students use in their schools. I will consider one of them soon, especially dreamweaver since it is the professional one. Which one do you use at your school?
Hi thank you for the great video . i have only one question - what i do for the print is that i go to page break view and select the area for printing for each page so that makes it like in 2 paper sheets. is that fine ? also if i dont change the row and column headings and potrait for the second printout will it still be ok or will i lose marks?
i messed up in the 'IF PART' even after checking closely several times, wish you could have gone over the mistake that people make and gone over it again.
Did this exact paper for my mocks a couple of days ago.. My only hope right now is paper 2, otherwise, I'm seriously failing ICT and it's stressful :') Can't believe how many mistakes I made hsvbkbsosjdbg
sometimes there are two formulas that can be used right? and it'll still give the same answer, so when they ask to print the spreadsheet with the formulas showing, do they only look for specific functions that are given in the mark scheme?
When we are finding the weekly wage, why won't we multiply the divided by 52 value by 100? This is the formula i have used: =ROUNDDOWN(((E17/52)*100),0) The question says to the nearest paisa and they've given the conversion rate as well. So if E17/52 is actually in rupees, the value of it in paisa will be (E17/52)*100. Please let me know if my thought process is right or wrong asap. Will really appreciate it.
Annayah Usman This is wrong because round to the nearest paisa does not mean change the currency from rupees to paisa. It is trying to say round the paisa to the nearest paisa
Thank u so much, evan's wife, for allowing him to stay up late to save poor students
@2308ARY OMG FR?
@@ozairbaigg SLAAYYY
5 years later, you are prolly in the 20s ? there is some kid who turned 15(turns 16 in march) and is being saved right now just like you were saved 5 years ago
@@eslamonthevlog same, except I'm15 turning 16 next year
Best ICT teacher helping poor students suffering from ICT
FACTS!!!!!
Facts
Not all heroes wear capes, Mr. Evans Chikasa is the best example and my hero who saved my grades (hopefully). (my exam is tomorrow....im so nervous...)
u will fail
abdullah shafiq stfu
Did you pass? BTW my exam is tomorrow!
@@FernsDrummer same here today
@@anomaly_echelon7994 Don't worry! It will go fine!
my test’s in 20 mins, I’m so glad this video helped me understand so much!!
Thank you Mr. Evan's boss. Your tutorial is still valuable 5 years later!😎
6 years
@@sweaty_sadiqhe wrote it 2 years ago
No one cares lil bro@@zaidbaidas
Lol, Chikasa has the best wife
Yep:))
@Anjal Krishna there was another comment here but it looks like they deleted it. I had replied to that comment with a "yep!". Lol 😂
thank you very much for this video because tomorrow we have boards and from this video I have understood the excel functions
Am glad to hear that. You are most welcome
sir can you give me some tips about solving the excel part easily
thnx a lot but ur laugh makes me laugh. good really and u r the only one who soes these videos so respect to u.
kannada movie hombisalu
sir i used if functions and still got the right answer
=IF(F17=1,"Full time",IF(F17=0,"Not Started",IF(1>F17>0,"Part time",0)))
tHank yOu so much for the thorough explanation! My exam's tomorrow & binging your videos have been EXTREMELY HELPFUL. ((thanks to ur wife too))
Hahaha, you are most welcome. I will tell her
i know this video is old but if youre reading this a biggggg thank you to you today i had my pracycal exams and i dont know what i could do without these videos
I think I will ace my ICT. Thank you so much!
You are most welcome
Thank you Ma for allow him to make this recording and thank you sir
I'm a Zambian watching this in Ghana.i just wanna say your tutorials are helpful!keep it man
Thank you and you are welcome
thank you very much Mr Chikasa for all videos you have uploaded. Thank you Mrs Chikasa for allowing him to teach us. I'm really grateful for all and may the Lord God almighty bless you
ppl watch your vids to learn... i watch to laugh xD . your laugh makes me laugh
Dude I was so confused on wtf to do and you just helped me so much. God bless you!
thank u u r way more better than my shit teacher ....now i understand all functions .... thank u very much brother!!!
Its okay brother some teachers are shit!
i am telling ur teacher
OMG ITS NOT ONLY ME WHO HAS A SHIT ICT TEACHER, BUT MINE IS WORST I GOT 2 A PRIVATE SCHOOL AND MY TEACHER IS THAT SHIT
bro das fax
Hi Mr. Evans! I actually discovered you couple of days ago. My term exam paper 2 was today and you were SUCH A HUGE HELP, though i did miss up in access. Anyways, when i found out that my friends watched your vids too i was like OMG. You are a really, really great teacher Mr. Evans! I hope I can do better on my Paper 3 exam this Monday!
thank you Mr. Evans I have my may june 2017 paper 32 tomorrow and this really helped me. Thanks again and may god bless you good sir.
Ur awesome!!! My ICT teacher doesn't teach us how to write the codes. He only makes us use the dialogue box to enter the functions.
Av Exam Tomorrow, Many Thanks Evans. I won't fail as badly now thanks to you.
Mr Chikasa , allow me to tell you that you are a life saver . My practicals are in 10 days and your videos are so helpful !
Thank you for this video Evans, it really helped in me securing higher marks in my board exams, thanks to you. These videos were really awesome at explaining the uses of the functions, as excel used to scare me!
Thank you for that feedback and you are most welcome
The fact that he teaches in a right way while also keeping entertainment on is something rare from channels like these, you are a underrated teacher and deserve more subs >:3
I had my ICT P2 today it went really well, all thanks to your videos :))
thank you i took my paper2 exam yesterday .. it was easy ... i will take my paper 3 tommorow .. thank you you helped me more than my teachers 💕💕
Really helpful !! Surely this will aid me in my IG exam , 10 days from now !
You Are the best i have my CIE board exam for paper 2 with includes excel and share point thanks brother!
U actually are the best IT teacher I have come across can u please do data analysis on excel 2010 it will be great and majority of student are doing exam in excel 2010
Thank you so much Evans!! You've helped us a lot with our igcse ict exams!! Especially on Tuesday, the paper was a good one, nothing too difficult. Hopefully next Tuesday's paper is the same :)
your having exam on 18 oct?
i am
You are welcome, am glad you did well in the paper
We just finished our practicals today- and they went well! Thank you for the videos :D They were a great help
You are most welcome
The way you explain things is priceless!
Thank you Eman
Hallo sir it is coniah gxotelwa form your Class.i have been watching your videos and it’s been helping a lot
Hi Coniah, great to hear from you. It has been a while. How are you doing and where are you?
your videos helps me a lot in my exams thanxx
My exams tomorrow and I just started studying thx to ur vid
Thank u so much sir my mock exam is in 2 weeks so this really helped me out alot!!!
thanks alot evans......your videos have helped me alot for my preparation for my igcse board exam...which is on the comming thursday..whish me luck..and thank you again so much.
Hello Saim, am glad to hear that. I wish you all the best in your exams
how was your exam bro
Helped alotttt..... You are certainly doing a good job by teaching us through this platform.. thankyousomuch
You are welcome
Thank you for your extraordinary efforts.. You are truly a life saver!!!!
You are welcome
you actually pronounced 90% of the names without any problem :)
i always watch his videos when i cant understand anything in the past paper i have to do
Thank you so much Evans Chikasa best teacher in the world
God bless you & your wife
ilysm mr evans your the best ict teacher in the universe
again as i say you really deserve a like
and here you go
Thanks alot bro
You are welcome and thank you for the complement
I consider you, Evans Chikasa, a god in the capsule of a human body, if the world ever came to an end, my ice exam, then u would be there to help the people, me, of the world rejuvenate and pass the almighty's test that was supposed to be our dooming fate. Again I thank you for allowing me to not kill myself in despair for my ICT practical exam.
bro you're legit a life saver, tysm for these videos
Thank you sir. Your videos are just making me rock in the class. To be short, you are awesome
Thank you and well done
What a lesson I laughed soo much during this session
Helped me a lot Thanks alot
Hahaha, you are welcome
thank you vry much i saw your access vid and i scored well i havent looked at any other ict teaching videos after yours
can you show me how to use vlook up function using FX because I get confused with it
Thanks a lot for the tutorial. I have CIE exams of paper 32 tomorrow, so your videos are really helpful. Excuse me for my crappy english. Also keep up the wonderful work.
Mustafa Yesil same your english is good lol
Thank you. Also I did my IGCSE ICT paper 32 today, it was easy I hope that I get A or A*.
you are amazing chikasa !! , keep saving our lives
best teacher
you helped a lot...................
thxns love from india
Thank you very much
wooohooooo you are a legend... if only we had you in our school :))
Thank you so much, i now understand how and where to use the different formulas.
Thank you very much for the video and files that you left in the description!
Thank you Mr Evan's Wife ✌✌✌✌🙌
Love ur vids I am going to score A* now!!!! Wakanda forever
that's little bit racist
Evans Chikasa your are amazing i literally watch you videos thanks for helping me especially
You are most welcome
hi i am really interested in your work don t have other paper for different years thanks for you amazing videos
Thank you soo much!, this helped a lot.
I am gonna tell all of my friends about your channel , because your videos are really helpful.
Thank you so much for the support you are rendering to this channel
THANK U SO MUCH SIR YOU HAVE HELPED OUT SO MUCH TODAY, YOUR LAUGH IS SO WHOLESOME HAVE A GOOD DAY
Sir point number 13 says ASCENDING ORDER of JOB DESCRIPTION but you have sorted it in DESCENDING ORDER of JOB DESCRIPTION??
Thank you chikasas wife!!🙏🙏🥰
this helped so much. im having ict igcse this april!
UR JUST THE BASSST..
btw pls wish me good luck for my exam
Thank you. I wish you all the best for your exam
wallah i love you so much ur the best ict teacher
HELLO SIR ...
When do we use VLOOKUP and when do we use LOOKUP ??
please help
Your videos are very very helpful......
could you pls upload a video in which all the excel functions are explained in details
so, you're saying this video isn't detailed?!
Why
thanks man.. you did too much work .. please can you share a video about all excel functions ... plz be fast as you can my exam is tommorow
Holy cow, thank you! Clear and easy to understand!
Thanks alot mam sir is of alot of help.They are truly wondurfull tutorials
You are most welcome
thank you chikasa for sacrificing your time with your wife to teach us. #WEDONTDESERVETEACHERS
@evansChikasa you should change the format from csv to word document . its a must, if u didnt do that an say for example u shut ur computer down by mistake or just turned the word document off all the data and editing on it will be gone and it will return to its original form.
Yes, you are right. Forgot to save the evidence document as a word processed document from rtf in step 1. The formatting might be lost if you used various formatting which are only supported by word. I understand what you mean. Many thanks
Evans Chikasa your welcome! Your conternt is really good i always get straight A*s(i am a 10th grade student) when i submit any paper done using your instructions. Btw i wanted to ask u if u have ever heard of an html program called sharepoint designer by microsoft. It has many similar stuff like sharepoint as its done by the same company.
Yes, I have heard of it. a number of students have asked me to use it, also dreamweaver, kompozer and many packages that different students use in their schools. I will consider one of them soon, especially dreamweaver since it is the professional one. Which one do you use at your school?
Hi thank you for the great video . i have only one question - what i do for the print is that i go to page break view and select the area for printing for each page so that makes it like in 2 paper sheets. is that fine ? also if i dont change the row and column headings and potrait for the second printout will it still be ok or will i lose marks?
i messed up in the 'IF PART' even after checking closely several times, wish you could have gone over the mistake that people make and gone over it again.
Did this exact paper for my mocks a couple of days ago.. My only hope right now is paper 2, otherwise, I'm seriously failing ICT and it's stressful :') Can't believe how many mistakes I made hsvbkbsosjdbg
thanks Chikasa,this video really helped me a lot
Thank you sir😃.Really helped me a lot😍😍😍
OH YEEEEE EVANS CURTIS WOULD BE PROUD...
sometimes there are two formulas that can be used right? and it'll still give the same answer, so when they ask to print the spreadsheet with the formulas showing, do they only look for specific functions that are given in the mark scheme?
😂 thank you so much you make learning fun and the way you keep laughing and mentioning your wife lol
You are most welcome... and thanks for the compliment
omg guys i am so stupid at 38:30 the formula i typed was =IF(F17=1,"Full time",IF(F17=0,"Not started",IF(F170,"Part time",0),0)))
Thank you Evans Chikasa
what if you use the function tab for the V-lookup?
55:34 how did u opened the window find and replace
why did you use lookup function and not vlookup in the second lookup function and if i used vlookup will it be wrong
ur really a life saver Thanx alot 😃😃😃
You are welcome
thank you very much chikasa for helping me
You are most welcome
appreciating all your videos! could you pls do more variant 2 for zone 2 students?
stay blessed!!
you are amaziing you helped me so much
Ik this is late but how do you Centre align text in footer, or is it automatically aligned?
I am getting errors when doing the Annual Salary column when it comes to multiplying it to numbers which are not 1 or 0. Please help.
The function for Annual Salary does not work on some of it that has decimal for Works. What do you think is the problem, sir?
lol mr.evans has the best wife ever! (P.S. thanks for the thorough details and nice explanations.)
Your Username may hurt him.
thank you , but why dont you use the fx box ?
it doesn't matter u can use both ways
thank you so much, pleaSE UPLOAD FOR MARCH AND JUNE 31
Mr. Chikasa Evans I have a problem on the absolute reference when I am pressing f4 my computer doesn't add the dollar signs
Your F4 button could be configured for something else. Just type it in
Hello Mr.Evans! Is it alright if my printed pages are six in total?
When we are finding the weekly wage, why won't we multiply the divided by 52 value by 100? This is the formula i have used:
=ROUNDDOWN(((E17/52)*100),0)
The question says to the nearest paisa and they've given the conversion rate as well.
So if E17/52 is actually in rupees, the value of it in paisa will be (E17/52)*100.
Please let me know if my thought process is right or wrong asap. Will really appreciate it.
Annayah Usman This is wrong because round to the nearest paisa does not mean change the currency from rupees to paisa. It is trying to say round the paisa to the nearest paisa