![Syed Shah Zahurullah Hussaini](/img/default-banner.jpg)
- 176
- 3 958 482
Syed Shah Zahurullah Hussaini
India
Registrace 14. 09. 2007
I've come up here on CZcams to share some of my videos from different courses of life. I will also keep adding informative and some learning videos. Subscribe to my channel for updates on my videos.
Global Capitals Challenge: Can You Guess Them All?
Welcome to the Ultimate World Capitals Quiz, the most engaging and educational geography challenge on CZcams! 🌍 Test your knowledge and see if you can correctly identify the capital cities of countries from around the globe. This fun and interactive quiz covers a diverse range of countries, including popular ones like the USA, Japan, Germany, and many more!
*What You’ll Find in This Quiz:*
*Exciting Questions:* Guess the capital cities of 100 countries, featuring major cities like New York, Tokyo, Berlin, and many more.
*Time Challenge:* You have 8 seconds to read the question and guess the capital city of the country.
*Fun Facts:* You get 8 seconds to read the answer and learn a fun fact about that place.
*Global Coverage:* From Asia to Africa, Europe to the Americas, and beyond, challenge your knowledge of world capitals.
*Why Take This Quiz?*
*Educational Fun:* Perfect for middle school students, geography enthusiasts, and curious minds.
*Interactive Learning:* Each question is designed to be both challenging and informative.
*Viral Potential:* Share your score and challenge your friends and family to beat it!
*How to Play:*
Watch the video and follow along with the questions.
Choose the correct capital city from the four options provided.
Keep track of your score and see how you rank!
*Engage with Us:*
Don’t forget to mention your place and write a fun fact about it in the comments. We'd love to learn more about your hometown!
Tags:
#worldcapitals #geographychallenge #capitalcities #capitalcityquiz #capitalcitiesquiz #educationalquiz #middleschool #funfacts #travelquiz #globalknowledge
Song: Elektronomia - Sky High [NCS Release]
Music provided by NoCopyrightSounds
Free Download/Stream: ncs.io/skyhigh
Watch: czcams.com/video/TW9d8vYrVFQ/video.html
*What You’ll Find in This Quiz:*
*Exciting Questions:* Guess the capital cities of 100 countries, featuring major cities like New York, Tokyo, Berlin, and many more.
*Time Challenge:* You have 8 seconds to read the question and guess the capital city of the country.
*Fun Facts:* You get 8 seconds to read the answer and learn a fun fact about that place.
*Global Coverage:* From Asia to Africa, Europe to the Americas, and beyond, challenge your knowledge of world capitals.
*Why Take This Quiz?*
*Educational Fun:* Perfect for middle school students, geography enthusiasts, and curious minds.
*Interactive Learning:* Each question is designed to be both challenging and informative.
*Viral Potential:* Share your score and challenge your friends and family to beat it!
*How to Play:*
Watch the video and follow along with the questions.
Choose the correct capital city from the four options provided.
Keep track of your score and see how you rank!
*Engage with Us:*
Don’t forget to mention your place and write a fun fact about it in the comments. We'd love to learn more about your hometown!
Tags:
#worldcapitals #geographychallenge #capitalcities #capitalcityquiz #capitalcitiesquiz #educationalquiz #middleschool #funfacts #travelquiz #globalknowledge
Song: Elektronomia - Sky High [NCS Release]
Music provided by NoCopyrightSounds
Free Download/Stream: ncs.io/skyhigh
Watch: czcams.com/video/TW9d8vYrVFQ/video.html
zhlédnutí: 139
Video
50 MIND BLOWING Facts You Think You Know TRUE OR FALSE?
zhlédnutí 75Před měsícem
Think you're a trivia whiz? Get ready to have your mind with 50 True or False questions that will challenge EVERYTHING you thought you knew! From science myths to history hoaxes, this video will expose the surprising truth behind some of the most common misconceptions. Is chewing gum REALLY stuck in your stomach for 7 years? Do bulls actually charge at the color RED? Can you REALLY taste differ...
Can You Ace This Planet Quiz? Most People Fail!
zhlédnutí 114Před měsícem
Calling all space explorers! Think you know your planets? Put your knowledge to the test with this ultimate Planet Quiz! 50 challenging questions will test your memory and reveal surprising facts about our solar system. 🪐 From fiery giants to icy dwarfs, are you ready to travel the cosmos and become a planet pro? - This quiz is perfect for beginners and space enthusiasts alike! Here's a concise...
Import Data from Another Google Sheet Using ArrayFormula
zhlédnutí 117Před měsícem
Learn how to import data from another Google Sheet using the powerful combination of ARRAYFORMULA and IMPORTRANGE functions. This step-by-step tutorial will show you how to efficiently manage and analyze data across multiple sheets. Follow along with our practice file to master these essential Google Sheets functions. 🔹 Topics Covered: How to use ARRAYFORMULA in Google Sheets How to use IMPORTR...
How to Import Data from Another Google Sheet Using IMPORTRANGE
zhlédnutí 110Před měsícem
Learn how to import data from another Google Sheet with IMPORTRANGE function. This step-by-step Google Sheet tutorial covers the syntax, key components, and practical applications of IMPORTRANGE function, enabling you to seamlessly connect and manage data across multiple Google Sheets. Perfect for anyone looking to enhance their data handling skills in Google Sheets. 📌 Topics Covered: - Introdu...
VLookup in Google Sheets from Another Sheet
zhlédnutí 103Před 2 měsíci
Learn how to use VLOOKUP in Google Sheets to search and retrieve data from another sheet with this detailed tutorial. 🔹 Topics Covered: How to use VLOOKUP in Google Sheets from another sheet Understanding the VLOOKUP syntax: =VLOOKUP(search_key, range, index, [is_sorted]) Practical examples of VLOOKUP across different sheets 📂 Practice File: docs.google.com/spreadsheets/d/1ouVpjgym-t-nYIVhJh-BY...
VLOOKUP in Google Sheets with Syntax Breakdown
zhlédnutí 78Před 2 měsíci
Learn how to VLOOKUP in Google Sheets with our comprehensive tutorial! Learn how to use the VLOOKUP function to efficiently search and retrieve data. We break down the syntax and provide clear examples to help you master this essential tool. 🔹 Topics Covered: How to use VLOOKUP in Google Sheets Understanding the VLOOKUP syntax: =VLOOKUP(search_key, range, index, [is_sorted]) Detailed explanatio...
Index and Match Formula in Excel - Two Dimension lookup in Excel
zhlédnutí 70Před 2 měsíci
Discover the magic of two-dimensional lookups in Excel with our complete guide on the Index and Match formulas. In this tutorial, you'll learn how to do dynamic lookups spanning rows and columns using these must-have Excel functions. Ideal for anyone eager to boost their data analysis prowess. Remember to show some love by liking, sharing, and subscribing for additional Excel tutorials! 📌 Topic...
Index and Match Formula in Excel - Dynamic Lookup in Excel
zhlédnutí 81Před 2 měsíci
In this video, I will demonstrate how to use Index and Match Formula in Excel and build a Dynamic Lookup in Excel. By the end of this video you should be comfortable with the following: - Use Index and Match Formula in Excel. - Use Index Formula in Excel - Use Match Formula in Excel - Build Dynamic lookup 🔔 Subscribe for more Excel tips and tutorials: czcams.com/users/hussainisyed 📂 Download th...
Index and Match Formula in Excel - How to Lookup Data Efficiently
zhlédnutí 101Před 2 měsíci
Unlock the full potential of Excel with our detailed tutorial on the Index and Match Formula in Excel. Learn how to perform powerful data lookups using these essential functions. This video covers everything you need to know about using Index and Match combo. Perfect for anyone looking to enhance their Excel skills for data analysis. 📌 Topics Covered: How to Use Index and Match Formula in Excel...
How to Create a QR Code for a Google Form | Easy Step-by-Step Guide
zhlédnutí 38Před 2 měsíci
Learn how to create a QR code for your Google Form in just a few simple steps! In this tutorial, we'll show you How to Create a QR Code for a Google Form that people can scan with their smartphones to access your Google Form instantly. This is perfect for surveys, feedback forms, event registrations, and more. In this video, you will learn: How to Create a QR Code for a Google Form How to Downl...
How to Freeze Multiple Rows in Excel: Complete Guide
zhlédnutí 73Před 2 měsíci
Learn how to freeze multiple rows in Excel with our comprehensive tutorial. Discover how to freeze multiple rows, multiple columns, the first column, and the top row in Excel. This step-by-step guide will help you keep important data in view while scrolling through your spreadsheet. Perfect for enhancing your data analysis and presentation skills. Don't forget to like, share, and subscribe for ...
How to Remove Duplicates in Excel
zhlédnutí 47Před 2 měsíci
In this video tutorial, I'll show How to Remove Duplicates in Excel. Practice File: drive.google.com/uc?export=download&id=1bCl6vbO_rrAw-fZ2J6Am6LkEEnWpXgM0 #exceltips #exceltutorial #exceltricks #excel #microsoftexcel #microsoft #exceltipsandtricks #excelguide
Filter Data and Return Matching Records in Excel Using the FILTER Function
zhlédnutí 52Před 2 měsíci
Filter Data and Return Matching Records in Excel Using the FILTER Function
Extract Unique Entries from a List in Excel Using the UNIQUE Function: Step-by-Step Guide
zhlédnutí 56Před 2 měsíci
Extract Unique Entries from a List in Excel Using the UNIQUE Function: Step-by-Step Guide
How to Create a Table in Google Sheets | Convert Range to Table in Google Sheets
zhlédnutí 570Před 2 měsíci
How to Create a Table in Google Sheets | Convert Range to Table in Google Sheets
VLOOKUP to Left: Retrieve Values from Left Columns in Excel with INDEX & MATCH Functions
zhlédnutí 93Před 2 měsíci
VLOOKUP to Left: Retrieve Values from Left Columns in Excel with INDEX & MATCH Functions
Retrieve information using INDEX function in Excel
zhlédnutí 65Před 2 měsíci
Retrieve information using INDEX function in Excel
How to Generate Random Numbers with Decimals in Excel Using RANDARRAY
zhlédnutí 105Před 2 měsíci
How to Generate Random Numbers with Decimals in Excel Using RANDARRAY
How to Highlight Duplicates in Excel: Step-by-Step Tutorial
zhlédnutí 94Před 2 měsíci
How to Highlight Duplicates in Excel: Step-by-Step Tutorial
Excel Drop Down List Multiple Selection
zhlédnutí 141Před 2 měsíci
Excel Drop Down List Multiple Selection
Number to Words in Excel | Convert Numbers to Words in Excel Using VBA | Easy Tutorial
zhlédnutí 695Před 2 měsíci
Number to Words in Excel | Convert Numbers to Words in Excel Using VBA | Easy Tutorial
XLookup in Excel: Your Friendly Guide to Nailing It! 🎯
zhlédnutí 406Před 11 měsíci
XLookup in Excel: Your Friendly Guide to Nailing It! 🎯
Case Sensitive VLookup in Excel: Get Down to Business!
zhlédnutí 945Před 11 měsíci
Case Sensitive VLookup in Excel: Get Down to Business!
Vlookup the Same Value Multiple Times in Excel
zhlédnutí 5KPřed 11 měsíci
Vlookup the Same Value Multiple Times in Excel
Using Arrays with Dynamic Filters in Google Sheets
zhlédnutí 1,5KPřed 11 měsíci
Using Arrays with Dynamic Filters in Google Sheets
Using Arrayformula with Filters in Google Sheets
zhlédnutí 4,2KPřed rokem
Using Arrayformula with Filters in Google Sheets
Easy Peasy Arrayformula Basics in Google Sheets!
zhlédnutí 288Před rokem
Easy Peasy Arrayformula Basics in Google Sheets!
Find the nth largest or smallest value in Google Sheets
zhlédnutí 715Před rokem
Find the nth largest or smallest value in Google Sheets
How to Use Smart Fill in Google Sheets - A Step-by-Step Guide | Google Sheets Tutorial
zhlédnutí 4,4KPřed rokem
How to Use Smart Fill in Google Sheets - A Step-by-Step Guide | Google Sheets Tutorial
It does not work when one worksheet get closed
Thank you so much after seeing so many videos I was so confused to perform on a task, but thisss video made my mind so clear thanks a lot
thank you so much for this informative video
I want to find data from 25 to 30 worksheets how can I find the data please help me
You can try combining the data into a single master sheet to simplify the vlookup. Here is a video that can be useful: czcams.com/video/JYZ5MR6e6Qs/video.html
When u have selected the range u have fixed that value as well right ?
How to manage the workbook path, if I send the Excel to another person
Hello sir, in my company I want to create over time sheet column like from, to,1.25 and 1.5. If the employee put their over time start in column from and end time in column to. there is a condition if employee work between 6:30 p.m. to 11 p.m. the rate will be added in column 1.25. and if employee work between 11:00 p.m. to 6:00 a.m. overtime work add in 1.5 column. But problem is there is if employee work between 11:00 p.m. to 3:00 a.m. Excel is not dividing the column 1.25 and 1.5 there is only addition in 1.25 column.. Please help me..
Hello sir, in my company I want to create over time sheet column like from, to 1.25 and 1.5. If the employee put their over time start in column from and end time in column there is a condition if employee work between 6:30 p.m. to 11 p.m. the rate will be added in column 1.25. and if employee work between 11:00 p.m. to 6:00 a.m. overtime work add in 1.5 column. But problem is there is if employee work between 11:00 p.m. to 3:00 a.m. Excel is not dividing the column 1.25 and 1.5 there is only addition in 1.25 column.. Please help me..
Thank you so much for this video ❤❤
H lookup
Hello.! Thanks for the Excel Education.! I understand all the formula and also tried on the sheet that you provided in link. but I stucked on "If with AND function" TAB You applied this formula in excel : =IF(AND(B3>35, C3>35, D3>35, E3>35), "Passed", "Failed") and When I applied this, I also got the correct answer But I want different type in this : like for eg: "IF HARRY SCORED LESS THEN 35 MARKS IN ANY SUBJECTS THEN IT SHOULD SHOW FAIL" but I tried this. : and showing "PASS" in all Cell.. Basically you applied : MORE THAN ">" and I want to apply : LESS THAN "<" By using MORE THAN ">"...the outcome shows correct.! By using LESS THAN "<" .. the outcomes shows incorrect.! By the way, I used this formula (eg. also attached below from excel sheet : =IF(AND(B4<35,C4<35,D4<35,E4<35),"Failed","Passed") In this Gandalf scored "29"in Math, So Outcome should show "FAILED" , but it is showing "Passed" Name Science Math English Social Analysis Result less then showing error Gandalf 67 29 41 82 Failed Passed
Thanks bro
Thank you
Very well professionally explained, hats-Off to you Janab, ALLAH bless you, I solved my issue :)
@@3aslogisticspakistan538 Thank you for this lovely feedback and thank you for the blessings.
You are a very clear and patient teacher. Thank you for all your helpful videos.
Finally i understand Vlookup and the practice sheet is the good one
FIRST ONE TO COMMENT AGAIN!
You have to teach another way if you know
@@venkateshchintagunti4236 thank you for the feedback. Please let me know if you have any questions for me so I can help you with that.
@@Syedhussainipage there is no problem 1 or 2 sheets, but 3rd sheet couldn't work and I have done same as you but it's not working. for 3 Days I have been trying 'n/a is coming'
@@venkateshchintagunti4236 would it be convenient for you to get on a zoom call and use your sample data so I can help you understand how it works? If yes, please use the following link to book time with me as per your convenience meetings.hubspot.com/syed57?uuid=5cb6d038-abcc-4d3b-b586-82c2beccb0d4
It's not working
@@venkateshchintagunti4236 would you be able to share a sample data with the steps that you performing so I can take a look? You can share the data using the following link forms.gle/7SAitfb8UmQyYorh9
The weekday function is not working for me, no matter what I do. I tried formatting the return cell value with General and Numbers but the cell keeps returning the error code #Value!. This is how I type the function, on the right side of the date column I typed; =WEEKDAY(A3,2) Result shows #VALUE!. I need help, can it be my excel worksheet settings? I'm using MS Excel 2021
@@dandan9175 please let me know what is in the A3. Also, if you can please share a copy of your data as a sample for my reference. Use this form to share sample file forms.gle/DGXWd7Cc9u11GPao9
nice tutorial
Glad you liked it!
Can I use it 2007-2010 version of Excel
Yes, you can do that in the older versions of Excel as well. Let me know if you need any help.
what if want to make sum for 4 tables ?
Thank you!
Seriously watching this after 12 years and I still remember full video 😂
Great explanation, thanks
Thank you for the helpful feedback.
I had this option for one day only, after that this feature ist gray/disabled. It was a testing version for short time? You wrote it is only for paid workspace yes?
I saw that on a regular unpaid version too recently. Let me share a screenshot with you shortly. I am driving at the moment.
@@dasistpfui I discovered that it is now available to all the users. Earlier it was only for the paid Google workspace subscriptions. Now it is made available to all the users of Google sheets. Please let me know if you do not see it.
@@Syedhussainipage Thanks for share this great news :) i see it works 🙏
What if I need the difference to be all minutes instead of hours and minutes?
Hey there, I have posted a step-by-step process to achieve this here: onlineknowledgeportal.com/2024/06/14/show-the-time-difference-in-excel-in-minutes-only/ Please let me know how it goes.
@@Syedhussainipage Thank you for your reply! When I apply the formula =(xx - xx) * 1440 to my time frame, it comes back with 00:00. My times are formulated to hh:mm. I work in food manufacturing and the operators are not calculating regrind the same way each time, as they should be, so I want to create an Excel calculator for them. They would input the time frame and get the correct minutes back that they would use to calculate the regrind. The shifts are 12hrs (0700-1900) and (1900 to 0700).
@@maryellenbrooks2921 Can you share a sample data with me so I can take a look. You can also book a time slot for a quick Zoom call so I can help you. You can use this link to book 15/30 minutes: meetings.hubspot.com/syed57
@@Syedhussainipage I did not get a notification that you had replied, so thank you for waiting for me. I want to calculate the minutes between press start to time product was called good. i.e..operators would enter the press start 07:22 to good product 08:01. When I use your formula (08:01-07:22)*1440 it returns an answer of 0:00. It should say 0:39 min.
@@Syedhussainipage I figured it out! I am going to use the calculation that I found and just input the hour and the minutes in separate cells and then the formula I found works perfectly. Thank you for being available, and willing, to answer questions.
the topic is easy to understand and well-explained.
I don't find table option in format menu
I just discovered that the option for Tables is currently available to Google Workspace Paid edition only. support.google.com/docs/thread/274482551?hl=en It will soon be available to all. 🤞🏼
@@hbp7633 I discovered recently the tables option is now available to all users of Google sheets.
Well explained sir - keep it up
Thank you for the helpful feedback. It is motivating. If you haven't already, please subscribe for regular updates.
I will wait for the next video
Here is the next video: czcams.com/video/wFq3EnZSr4s/video.html
"Thank you so much for this fantastic video! Your explanations are clear and easy to follow, making complex topics much more understandable
Thank you for this amazing feedback! It truly helps in keeping me motivated.
You have explained it quite well, and I can understand it easily. Thank you sir
Thank you for the helpful feedback. This helps in keeping me motivated. If you haven't already, please subscribe to my channel for regular updates. Best Regards, Syed H
@@Syedhussainipage all ready done sir
Amazing sir
Sir can i do it with index+match function?
I will get this done in a few days using these functions and will drop a comment here to keep you posted.
Really it's work for me, thank you very much
Thank you very much Syed bhai, very very useful information.
Thank you for your feedback. This helps in keeping me motivated. If you haven't already, please subscribe to my channel. Best Regards, Syed H
thank you!!!
Thanks for the information
I am happy to help!
can i use index+match function instead of vlookup+match funciton?
Yes, I will post a video about it tomorrow. Please let me know if there is something specific you want me to consider in the tutorial.
@@Syedhussainipage sir thanks for your kind ness.Can u make any video about cell referencing. That matter is not clearing to me.for this reason i facing problem when i using advance vlookup.
@@asifquader8447 How about a quick 15 mins zoom call? I can help you gain more clarity on that.
@@Syedhussainipage thanks sir.that will be helpful
Here is a link to book time meetings.hubspot.com/syed57?uuid=6684d994-9348-414c-b151-86cbd01354f8
Wouldnt this be better if you added comma's and "and" in the output such as Two Million, Three Hundred Thousand, Five Hundred and Twenty dollars, and Thirty cents. And include an instruction to change dollars and cents to the current currency, ie. pounds and pence
By the way, thanks for including the Mac shortcuts. So many excel videos leave this out.
I have revised the script further. I also added steps to change the currency when needed. onlineknowledgeportal.com/2024/05/25/number-to-words-in-excel/ Please take a look and let me know.
how is "one million thousand" proper English?
Thank you for letting me know that. I understand the issue. The problem arises because the script is not properly handling the segments and placing them in the correct position. We can adjust the script to ensure that the larger numbers are placed correctly and do not result in incorrect concatenation like "One Million Thousand." I have updated the script on the Post: onlineknowledgeportal.com/2024/05/25/number-to-words-in-excel/. Please take a look and let me know.
Good Teaching ❤❤❤
Love what you do❤
Exactly what I was looking for ... clear and concise. Thank you.
=IFERROR(VLOOKUP(A2,'Table 1'!A1:B833,2,FALSE),IFERROR(VLOOKUP(A2,'Table 2'!A1:B862,2,0),VLOOKUP(A2,'Table 3'!A1:B792,0))) , may i write formula in this way
This is helpful! Subscribed
Superb Explanation. Great to learn from you
Question what if on any day they have no time entered because they were off? How is that calculated?