Thanks for your comment. I am glad you found the tutorial useful. If you check out my playlists you will find tutorials for all the components for paer 2 and 3, uncluding me solving past papers. I also have a great tutorial on solving paper 1 questions with same answers. Good luck with your exams.
These videos helped me so much in my paper 2 exam and I’m very thank full for finding you but can you suggest a UA-camr who uses expression in the web page task?
Good luck. Make sure to double check your printouts. If you have time at the end check your printouts against the question paper and make sure everything in the question paper can be seen in the printouts (not the computer). I always tell my students, when you finish check your work and find 3 mistakes. Trust me, you will find mistakes and each one could be the difference between a A and an A*. If you can not find 3 mistakes keep trying till the end of the exam.
No reason, it is just a demonstration on how to use countifs. To do this i needed more than 1 criteria so i used a second criteria amount more than 100, there is no specific reason.
![Excel References, Relative, Absolute and Mixed references explained [IGCSE ICT 0417]](http://i.ytimg.com/vi/qgankq3WqAE/mqdefault.jpg)
![Excel References, Relative, Absolute and Mixed references explained [IGCSE ICT 0417]](/img/tr.png)
![Excel introduction for beginners [IGCSE ICT 0417]](http://i.ytimg.com/vi/j7lpJ1jItfE/mqdefault.jpg)
![Excel Lookup functions, explained: XLOOKUP / LOOKUP / VLOOKUP / HLOOKUP [IGCSE ICT 0417]](http://i.ytimg.com/vi/dbCvU1zkoPM/mqdefault.jpg)
just cause of u i got 80%+ in my mocks exams thank you so much sir may god bless u!!! 💖💖
That is great. Well done. I just provided resources, you put in the hard hark.
This gives me confidence- I have my OLs in a week 😭
@@cinnap00fle glad it helped, good luck with the exams.
@@paphitisn thank you! 🤍
How was paper 1
amazing could not have gotten pass exams without this
I am so glad this tutorial helped you with your exams. Thanks for your feedback.
Thank you Nicos Paphitis, to help us with the ICT IGCSE if it wasn't for you I will be living in the street. You are the best ICT teacher.
Thank you so much! I’m on my way to my external for paper 3 and I wasn’t so familiar with using these functions, but now it’s all clear!
Nahhhhh, this teacher is way too good tbh..... Im pretty sure paper 3 is now secured for me... God bless you sir!!
Thanks for your comment. I am glad you found the tutorial useful. If you check out my playlists you will find tutorials for all the components for paer 2 and 3, uncluding me solving past papers. I also have a great tutorial on solving paper 1 questions with same answers.
Good luck with your exams.
@@paphitisn Will do!!..your work is much appreciated sir🫡
2:26 count
3:02 countA
3:40 countblank + space
5:05 hide data
7:39 countif
9:03 absolute reference
10:35 countIFS
You were a giant help in my mocks revision and the exam as well. THANK YOU SO MUCH!!!
You are more than welcome. Thanks for your comment
Super helpful and easy to understand.
You really helped me a lot in improving in my mocks thank you so much!
I am glad. Thanks for your comment
very talented teacher,thank u helped alot
Thank you for your feedback and kind words. I am glad this tutorial helped you
These videos helped me so much in my paper 2 exam and I’m very thank full for finding you but can you suggest a UA-camr who uses expression in the web page task?
Hello, AjiroTech and Finz papers both use express and help me out a lot, hope this helps and good luck
very useful video pray for me to get a star in ict ol and thank you for the outstanding video
Good luck. Make sure to double check your printouts. If you have time at the end check your printouts against the question paper and make sure everything in the question paper can be seen in the printouts (not the computer). I always tell my students, when you finish check your work and find 3 mistakes. Trust me, you will find mistakes and each one could be the difference between a A and an A*. If you can not find 3 mistakes keep trying till the end of the exam.
how was it
Thank u very much ❤ very useful video
i am glad it helped you. Thanks for your comment.
the best
😘😘
do u have videos for cambridge it 9626?
Sorry, No
@@paphitisn but the excel videos are similar yes?
Can someone explain why did he choose amount instead of income in countifs?
No reason, it is just a demonstration on how to use countifs. To do this i needed more than 1 criteria so i used a second criteria amount more than 100, there is no specific reason.