WOW! i am really happy for you. I am glad my tutorials were a good resource for you. You must have worked very hard to achieve an A* Well done. Keep up the hard work and you will achieve everything you set your sights on.
Hey man you're a life saver , I really appreciate all your effort into solving these papers which many students might face some troubles in . Thank you again I really can't thank you enough .
Thank you soo much for this video sir🙏🏼 my igcse is tomorrow and im pretty confident for a person that has anxiety that I’ll do well because of your videos, I understand you better than my own teacher lol.
I remember being in the exam centre and attempting this paper, was so confused about the countifs part. The solution only came to my mind in the last 10 mins
I hope you managed to add the functions in 10 min. Goes to show that you need to give your self time to understand the question so that you can figure out which function is needed.
@@paphitisn yeah, thankfully I was. Initially when I saw the excel functions and even after spending 20 minutes on them, I couldnt figure em out, I was so sure Id have to skip them but i didnt give up till the last moment.
@@damian2972 good job. Making use of every minute is the way to go. Even if you have answered everything you still use every minute to check and recheck
I still remember that time when I saw this question first and took the exam. At that time, I wanted to thank you first for your well-explained videos. I prepared my IGCSEs course within 10 months and your videos could help me as a part of my IGCSEs journey. Eventually, I got A(a) in ICT with 81% with the help of you. Thanks a million sir!
You are very welcome. It is success stories like this that motivate me to generate these tutorials. Congratulations on an amazing achievement. getting an A in this course is no easy task. Doing it with only 10 months preparation, is exceptional. Stay motivated and keep up the hard work. Thank you for your comment and kind words.
Thankyou for your comment. It is a perfect representation of what my channel and video tutorials are about. Providing useful resources to students that want to improve. Going from a C to an A is no easy task, congratulations. I would love to hear how you do in the final exams. Next goal, an A*
if i pass my practical paper 3, it will be becuz you! ( i will write an entire essay praising you and i will be recommending your channel to everyone i know who is taking ict ) Atp i just pray and hope that i will do well😭🙏 btw i love your cat send my regards to her
Read the questions carefully. Paper 3 is not that heavy but requires you to take your time to read, understand and figure out how to solve the Excel problems. It is normal for you to read the question the first time and have no idea what to do Analyse the spreadsheets, read the question, repeat 3 to 4 times and each time it will make more sense. If itis a difficult 10+ mark question it means that you will need to take the time to figure it out. Any time you have at the end, use it to check and double check your printouts. I always tell my students that they only finish after they have found 3 mistakes in their work.
Well done! that's the way to do it. Solve a paper and don't get any help from my videos so that you can identify your weaknesses. Then use the videos to resolve your issues. Do it this way and yes, the videos will help you change the way you think and approach a paper, and your skills will definitely improve every time you tray a new paper. Thanks for your comment.
What an AMAZING achievement, congratulations and WELL DONE! Definitely a grade to be proud of. Your hard work and dedication paid of. I am glad the tutorials helped you prepare but your A* is all down to your hard work. Thanks for coming back and letting us know how you did in the exam.
@@paphitisn Your tutorials are a total life-saver, sir. I took ICT 6months before the exam and I had to rush, most of the practical parts I had to rely on you, sir. 😣🥲Once again, THANK YOUUUU and have a wonderful dayyy, sir!!!
Hello sir, I am a new subcriber and want to thank you for be so good explaining all papers points and have the dedication to make very practical tutorials. By the way, all course see your videos!
Hi there and thanks for the subscribe. I am glad the tutorials are helping you and everyone in your course prepare for the exams. Give the them a big "Hello from sunny Cyprus" from me. May we could set up an online meeting some day and i can say hello and thank you for supporting my channel.
hi sir, just finished my p3 and overall it went well thanks to you! but i had trouble with a question that asked to use nested if function for selected cells but i tried it out several times but still couldn’t managed to do it so i ended up doing an ifs function instead bc it more or less gives me the same results… how much marks would i lose there from a total of 9? TT oh and there was a question which wanted me to calculate an average but most of the results was so long due to many decimal places so would i lose any marks if i added a round function to them all up to 1 decimal places? honestly im disappointed that i forgot how to use the nested if function even though i thought i had prepared myself really well for this by practicing and watching ur videos… only the webpage part was super easy but majority of the marks comes from spreadsheets so im abit worried
Not unless you are asked to show evidence of your file. However if you do not save it ad an Excel work book and you close the file and then open it yoy will most likely lose all your formulas. So, best to save as an Excel workbook.
@@paphitisn i already finihsed my igcse last week did everything all formating formulas everything wwas correct and followed all instruction and got all the printouts the only thing is i didtn save it as an excel workbook , so if the examiner checks my excel file will i lose all the makrs because the formatting and my formulas would be gone
That is fine. If for some reason you closed your file and in your pritouts tou found a mistake then you would be in trouble because when youbwould gave opened the file toncirrect the mostake your formulas would not be there.
Hi Nicos, i have a question. I am trying to print only cells a1:c75 in step 8. However, when i select it it still displays columns A to F and i dont know what im doing wrong. Could you tell me why that happens? thank you
Yes i should have chosen selected area. I did mention it but doing the exercise and explaining at the same time sometimes diverts my focus. Yes, you would choose the selected area. However i did get A1 to C75 in one page width and the D E and F columns were on different pages so i could have just not submitted the pages with the extra columns.
@@mystoryanimated8787 Good luck. Yes many students have paper 3 tomorrow. I have just released a quick tutorial on Expression Web as a lot of students were asking for a tutorial. If you use Expression, check it out.
@@paphitisn Thank you sir didnt see that I have praictical in 20 days so im just binge watching all your videos. Again thank you so much for your videos sir
hi is it okay if i show gridlines on my printouts even if it isnt mentioned? i feel like it makes it look more neat and organised kindly let me know thanks!
Try this. Go to the Print Layout tab to view the print layout ribbon. In the ribbon in the middle somewhere there are 2 small sections: Gridlines and Headings. Both have 2 tick boxes called View and Print. In the Headings section tick the box labeled Print. Check the print preview and you should see the row and column headings. Let me know if this helped you.
Well spotted. The height of the first row should be 20% not 85%. I had the 85% of the table width in my mind while i was putting int he height of the first row. Good attention to detail. Make sure to pay the same attention in your exams and you will do great.
@@paphitisn Thank you for the feedback! Also my paper 3 examination is in about 8 days. Do I still have enough time to get an A* grade for this paper? My paper 2 and paper 1 skills are quite solid. How many times should I also rewatch your videos until I should feel confident for the exam?
@admorejnr.6854 the videos will help but it is more important to practice and use the videos if yiu get stuck. Practice is the most important so as to train your thought process, your eye and most important for you to get used to finding the tools you need to complete a task. 8 days is more than enough if you practice.
![2024 March Paper 31, Cambridge 0417 ICT [IGCSE]](http://i.ytimg.com/vi/gKXDjVRRH4I/mqdefault.jpg)
![2024 March Paper 31, Cambridge 0417 ICT [IGCSE]](/img/tr.png)
![2024 June Paper 21, Cambridge 0417 ICT [IGCSE] MUST WATCH](http://i.ytimg.com/vi/jDHgMuZPbp8/mqdefault.jpg)
![Excel Lookup functions, explained: XLOOKUP / LOOKUP / VLOOKUP / HLOOKUP [IGCSE ICT 0417]](http://i.ytimg.com/vi/dbCvU1zkoPM/mqdefault.jpg)
Hi sir, I just wanted to thank you as I got an A* in my ICT IGCSE and your videos were extremely helpful!
WOW! i am really happy for you. I am glad my tutorials were a good resource for you. You must have worked very hard to achieve an A*
Well done. Keep up the hard work and you will achieve everything you set your sights on.
Hey man you're a life saver , I really appreciate all your effort into solving these papers which many students might face some troubles in .
Thank you again I really can't thank you enough .
Your comment is thaks enough. I am glad the tutorials are supporting many students from around the world. Thanks for your comment.
Thank you soo much for this video sir🙏🏼 my igcse is tomorrow and im pretty confident for a person that has anxiety that I’ll do well because of your videos, I understand you better than my own teacher lol.
Good luck with your exam tomorrow. I hope it goes well. Thanks for your comment. Looking forward to hearing how you do in the exam.
@@paphitisn im done with it now and I honestly did not struggle alot, had issues with metadata for webpage only as I didn’t learn it at school
@@descriminalized shame about the metadata but no worries sounds like you did a good job. Well Done.
I remember being in the exam centre and attempting this paper, was so confused about the countifs part. The solution only came to my mind in the last 10 mins
I hope you managed to add the functions in 10 min. Goes to show that you need to give your self time to understand the question so that you can figure out which function is needed.
@@paphitisn yeah, thankfully I was. Initially when I saw the excel functions and even after spending 20 minutes on them, I couldnt figure em out, I was so sure Id have to skip them but i didnt give up till the last moment.
@@damian2972 good job. Making use of every minute is the way to go. Even if you have answered everything you still use every minute to check and recheck
I got A* after watching your video. Thanks a lot!!
That is AWESOME, WELL DONE!!! a fantastic achievement. Thanks for coming back and letting me know. I am glad the tutorials helped you.
WE NEED MORE LESLIE!!!
Ahaha. I promise to include her in my next tutorial :)
@@paphitisn thank you
You're the Man Sir Nicos, Thank you for these videos
Thanks for your comment.
I still remember that time when I saw this question first and took the exam. At that time, I wanted to thank you first for your well-explained videos. I prepared my IGCSEs course within 10 months and your videos could help me as a part of my IGCSEs journey. Eventually, I got A(a) in ICT with 81% with the help of you. Thanks a million sir!
You are very welcome. It is success stories like this that motivate me to generate these tutorials. Congratulations on an amazing achievement. getting an A in this course is no easy task. Doing it with only 10 months preparation, is exceptional. Stay motivated and keep up the hard work. Thank you for your comment and kind words.
I've been watching your videos for a few months now. And I'm getting A now thanks to you. I was a C grade and you brought me up. Thank you so much.
Thankyou for your comment. It is a perfect representation of what my channel and video tutorials are about. Providing useful resources to students that want to improve. Going from a C to an A is no easy task, congratulations. I would love to hear how you do in the final exams. Next goal, an A*
if i pass my practical paper 3, it will be becuz you! ( i will write an entire essay praising you and i will be recommending your channel to everyone i know who is taking ict ) Atp i just pray and hope that i will do well😭🙏
btw i love your cat send my regards to her
Thank you so much seriously this means a lot my paper 3 is day after tommorow i hope i do well !
Read the questions carefully. Paper 3 is not that heavy but requires you to take your time to read, understand and figure out how to solve the Excel problems. It is normal for you to read the question the first time and have no idea what to do Analyse the spreadsheets, read the question, repeat 3 to 4 times and each time it will make more sense. If itis a difficult 10+ mark question it means that you will need to take the time to figure it out. Any time you have at the end, use it to check and double check your printouts. I always tell my students that they only finish after they have found 3 mistakes in their work.
this guy is the best (including the cat of course😭)
thanks for your comment. I will pass on the compliment to Leslie (my cat)
Watching your videos after attempting papers are so life changing. Thank you so much for all of this!😭
Well done! that's the way to do it. Solve a paper and don't get any help from my videos so that you can identify your weaknesses. Then use the videos to resolve your issues. Do it this way and yes, the videos will help you change the way you think and approach a paper, and your skills will definitely improve every time you tray a new paper. Thanks for your comment.
I love him Soo much..u help me in my ict exams
@@LebogangJohannes-p6t ahhh, thanks for your comment. I am really glad the tutoruals helped you.
Step 7-
the number of sightings should be in bold .
26:09 he makes it bold
Thank you for helping me with my homework
You are more than welcome. Thanks for your comment.
Thank you so much for this video 😀
It’s a life saver 😊
You are welcome. Thanks for your comment
thank you I'm sitting ict paper 3 exam in a few days
Good luck. I hope it goes well.
Hello sir!!! I took this 2024 june series and got A* in ICT, I'm utterly greatful to you, sir. Thank you sooo much.
What an AMAZING achievement, congratulations and WELL DONE! Definitely a grade to be proud of. Your hard work and dedication paid of. I am glad the tutorials helped you prepare but your A* is all down to your hard work. Thanks for coming back and letting us know how you did in the exam.
@@paphitisn Your tutorials are a total life-saver, sir. I took ICT 6months before the exam and I had to rush, most of the practical parts I had to rely on you, sir. 😣🥲Once again, THANK YOUUUU and have a wonderful dayyy, sir!!!
Thankyou. You've been so helpful.
I am glad these tutorials are helpful. Thanks for your comment.
Thank you sir! I've got my exam tomorrow this really helped
Hello sir, I am a new subcriber and want to thank you for be so good explaining all papers points and have the dedication to make very practical tutorials. By the way, all course see your videos!
Hi there and thanks for the subscribe. I am glad the tutorials are helping you and everyone in your course prepare for the exams. Give the them a big "Hello from sunny Cyprus" from me. May we could set up an online meeting some day and i can say hello and thank you for supporting my channel.
hi sir, just finished my p3 and overall it went well thanks to you! but i had trouble with a question that asked to use nested if function for selected cells but i tried it out several times but still couldn’t managed to do it so i ended up doing an ifs function instead bc it more or less gives me the same results… how much marks would i lose there from a total of 9? TT oh and there was a question which wanted me to calculate an average but most of the results was so long due to many decimal places so would i lose any marks if i added a round function to them all up to 1 decimal places? honestly im disappointed that i forgot how to use the nested if function even though i thought i had prepared myself really well for this by practicing and watching ur videos… only the webpage part was super easy but majority of the marks comes from spreadsheets so im abit worried
I JUST FINISHED OCT PAPER TODAY!! there is countif,if,and vlookup
thankyou bigman!
You are welcome
Would i lose marsk in my igcse if didn't save it as execl workbook?
Not unless you are asked to show evidence of your file. However if you do not save it ad an Excel work book and you close the file and then open it yoy will most likely lose all your formulas. So, best to save as an Excel workbook.
@@paphitisn i already finihsed my igcse last week did everything all formating formulas everything wwas correct and followed all instruction and got all the printouts the only thing is i didtn save it as an excel workbook , so if the examiner checks my excel file will i lose all the makrs because the formatting and my formulas would be gone
That is fine. If for some reason you closed your file and in your pritouts tou found a mistake then you would be in trouble because when youbwould gave opened the file toncirrect the mostake your formulas would not be there.
@@paphitisn yeah I only closed my file after double checking everythign with my printouts
@@paphitisn thank you so much I was so stressed out about this
Hi Nicos, i have a question. I am trying to print only cells a1:c75 in step 8. However, when i select it it still displays columns A to F and i dont know what im doing wrong. Could you tell me why that happens? thank you
1:11:01 would it be a bad idea if i rotate the image 90° so it fits the whole page?
You mean print the page landsacpe so the image is bigger? You dont have to but you could.
@@paphitisn alright, thank you :)
Hello Nicos
I noticed when printing question 8, you did not select print selected ....why ?? I'm so confused
Cause the others D and E and F shows
Yes i should have chosen selected area. I did mention it but doing the exercise and explaining at the same time sometimes diverts my focus. Yes, you would choose the selected area. However i did get A1 to C75 in one page width and the D E and F columns were on different pages so i could have just not submitted the pages with the extra columns.
Okay thank you so much 😊..i know im going to Ace my exmas cause of your videos ...and we are writing igcse paper 3 tommorow@paphitisn
@@mystoryanimated8787 Good luck. Yes many students have paper 3 tomorrow. I have just released a quick tutorial on Expression Web as a lot of students were asking for a tutorial. If you use Expression, check it out.
Leslie's adorable
She is a diva 😂
We love her immensely even if she does constantly try to video bomb my tutorials. Thanks for your comment.
@@paphitisn that's so cute! 😂
Sir, do we need to enable "Row and Column Headings" in 28:23, or is it okay to leave them off?
This is question 8 and it clearly says that the row and column headings should be visible so you must enable them
@@paphitisn Thank you sir didnt see that I have praictical in 20 days so im just binge watching all your videos. Again thank you so much for your videos sir
@@aya_tadda good luck with the practical. Hope it gies well
How to download Dreamweaver without having to pay it?
can't help you there. Maybe talk to your teacher or school. They maybe able to give you temporary licensing to help you prepare for the exams.
hi is it okay if i show gridlines on my printouts even if it isnt mentioned? i feel like it makes it look more neat and organised kindly let me know thanks!
@@laughingatyourn if it does not specifically say, No Gridlines, then it is ok if you put them.
hello sir, is it possible to do a sort in descending order for question 9 rather than a filter???
@@arunkaarthick1106 No, you eed to filter to leave only what is needed and remove the rest. Sorting will not do that.
26:54 you forgot to bold the Number of Sightings, but anyways amazing explanation
33:36 my row and column headings aren’t showing and I have no idea why
Try this. Go to the Print Layout tab to view the print layout ribbon. In the ribbon in the middle somewhere there are 2 small sections: Gridlines and Headings. Both have 2 tick boxes called View and Print. In the Headings section tick the box labeled Print. Check the print preview and you should see the row and column headings. Let me know if this helped you.
@@paphitisn It worked. Thank you so much!
@@jadeobsessed1281 great, thanks for letting me know.
hey sir thank u alot
You are welcome
Hi lesley 😂❤
Meow 🐈
Hello sir, How do we download Dreamweaver?
From Adobe website. I am not sure if there is a free trial period but you can purchase on a monthly subscription so you can get it for 1 month only.
@@paphitisn ok sir, i will check it out. thank you
sir can u also do for paper 32 🙏
I will, i just need to find a bit of time. Should have it live within the next 10 days
This years paper 3 exam was hard
Sorry to hear that. I am looking forward to seeing the paper when it is released. Forget about it now, its passed, focus on the theory paper now.
@@paphitisn l am just hoping for a reasonable threshold
owwwwwwww yahhhhhhhh
I came here mainly because of the kitty......
AHAHAHA, i will allow her to crash more of my tutorials then :)
In step 11 why is the height not 20%
Well spotted. The height of the first row should be 20% not 85%. I had the 85% of the table width in my mind while i was putting int he height of the first row. Good attention to detail. Make sure to pay the same attention in your exams and you will do great.
@@paphitisn Thank you for the feedback! Also my paper 3 examination is in about 8 days. Do I still have enough time to get an A* grade for this paper? My paper 2 and paper 1 skills are quite solid. How many times should I also rewatch your videos until I should feel confident for the exam?
@admorejnr.6854 the videos will help but it is more important to practice and use the videos if yiu get stuck. Practice is the most important so as to train your thought process, your eye and most important for you to get used to finding the tools you need to complete a task. 8 days is more than enough if you practice.