Techmechtips

Filter Image in Excel Vlookup, Hlookup, Index, and match functions are used to search data and retrieve the desired results based on the given conditions. The alphabetical, string, and numerical data can be easily obtained using these functions. Nevertheless, it can be challenging to obtain the associated image from the Employee database or table, if you wish to do so using the Employee code or name. However, in the latest version of Excel, retrieving an image from a database that based on some criteria is quite simple using formula too. So, we are trying to tell you how we can retrieve pictures as per given condition or query from a table or database in Excel using three different methods. Maintain Images within the Cell First of all maintain position of your images in cell properly, the images should be inside the cell only. If you are using Excel365 then there is an option called “Place in Cell” but in earlier version you have to select picture then right click to choose size & ...

The insecurity and the increase of crime pressed human to think about some sort of system to keep an eye on. These types of incidents lead to the invention of Surveillance System. What is Surveillance? Keeping an eye on someone or a situation in order to gather information is called surveillance. Monitoring an area for undesirable behaviour or looking into a suspect person are two uses for surveillance. History of Surveillance CCTV was invented by Walter Bruch and was first used back in 1942 in Germany to capture live video footage. He built it, so Nazi scientists and military personnel could safely observe the launch of V-2 rockets at the Peenemunde Airfield. Marie Van Brittan Brown and her husband Albert invented the modern video security system in the late 60s. Video surveillance and recording gained momentum as a security measure in the 1970s and 1980s. Banks and retailers installed CCTV with VCRs to prevent theft. The charge-coupled device (CCD) enters the picture in 1976. Using m...

The Maya operating system has been developed in India. It is based on UBUNTU," a popular Linux system that employs free and open-source technologies. The Indian Ministry of Defence has taken this endeavour to secure its computer systems against unforeseen, vulnerable Cyberattacks that may cause minor to severe disruptions to our internal systems. It was designed with an easy and error-free transition from Windows OS to Maya OS in mind. Its interface and functionalities are quite similar to those of the Windows system, thus switching from Windows to Maya would be seamless. Maya OS also has a feature called Chakravyuh, which is end-point anti-malware and antivirus software that prevents system hacking.  As the name implies, it might be a multi-layer system that protects the system from digital threats. Its development began in 2021, following a series of cyberattacks on India's crucial information and military systems.  India recognises the importance of developing a robust ope...

Wi-Fi and Li-Fi both are wireless method of data transmission, but are different in technology usage. Wi-Fi uses radio waves while Li-Fi uses visible light for data transmission. You are more familiar with Wi-Fi but I am sure very few peoples known about this Li-Fi technology. So, let’s know about these technologies in brief:    What is Wi-Fi? Wi-Fi is a wireless networking protocol through which devices use to communicate without direct cable connections. Wi-Fi stands for Wireless Fidelity. It is based on 802.11 IEEE network standards. The Wi-Fi standards were created by the Institute of Electrical and Electronics Engineers and are certified by the Wi-Fi Alliance. In  1991, NCR Corporation with AT&T Corporation invented the precursor to 802.11 but actually  It has started in the Year 1997 with 902.11 standard. The main requirement for Wi-Fi is a device that receives and transmits a wireless signal, usually a router. Wi-Fi network is established by installing W...

Data Backup plays an important role in today’s digital world. As we are progressing further and developing new technologies to make our life easy-going, we are generating enormous amount of data. This enormous amount of data is known as Big Data. Big data means continuous generation of mystify and demystify data. To protect this sort of data is a crucial part of digital system. In order to safeguard this valuable data there is a need of backup system.  Backup of data is an important task to safeguard your digital assets like drawings, photo and database etc. Dependency on digital computer world insists us to take back up of our valuable data regularly. So, what is Backup? What is  Data Backup ?  Backup is a method to keep your data more securely in other places so that in case of loss of data due to hardware failure, malware attack, accidently delete something,  fire and natural disaster etc. to retrieve the same. This is a wonderful way to protect your digital world...

Technology has given us computer and mobile and both play a pivotal role in developing human being. Mobile is work like computer nowadays and no field is exempt from the influence of computers. The majority of us spend a significant amount of time using computers/ mobiles every day. Due to spending of most of the time on computer / mobile, we are more susceptible to several illnesses, some of which may be fatal, due to our excessive use. Let's therefore have a look at a few ailments that can harm our health if we use them quite often.   Carpel Tunnel Syndrome (CTS) : Pain in hand and wrist It causes pain in hands and wrist. This disease happens due to lot of typing, continuous stress, long hours of using mouse and restrictive movements of hands. Basically it happens due to pressure on the median nerve. The median nerve helps to move your wrist, forearm, hand and fingers. Precaution:   Gently bend your arm and wrist after every 30 minutes. Use wrist-rest to support your wrist K...