Article Categories
- All Categories
-
Data Structure
-
Networking
-
RDBMS
-
Operating System
-
Java
-
MS Excel
-
iOS
-
HTML
-
CSS
-
Android
-
Python
-
C Programming
-
C++
-
C#
-
MongoDB
-
MySQL
-
Javascript
-
PHP
-
Economics & Finance
Microsoft Technologies Articles
Page 115 of 175
How to Apply a Button to Open Another Workbook in Excel?
Have you ever tried to access the data in two workbooks at once? You could have compared data in two sheets of the same workbook using the VLOOKUP function. We can also connect the two worksheets in Excel. This process can’t be completed using the formulas; we will need to use the VBA code. This tutorial will help you understand how we can apply a button to open another workbook in Excel. Applying a Button to Open Another Workbook in Excel Here we will first insert a shape and then assign a macro to it. Let us see ...
Read MoreHow To Compare Two Strings For Similarity Or Highlight Differences In Excel?
In this article, we will learn how to compare two adjacent strings in excel for identifying differences or similarities. Two methods have been explained in this article as mentioned below. Compare two strings for similarities using a formula. Compare and highlight two strings for similarities or differences using VBA Code. Compare Two Strings for Similarities using a Formula Step 1 − A sample data has been taken as shown below to compare the strings of two columns. Step 2 − Now, enter the following formula in Match Result column and drag the same till the last row to which ...
Read MoreHow to compare two columns and delete matches in Excel?
If you want to compare two or more columns to find duplicate values, it can be done using a formula mentioned in this article. Many times, we come across a data set where values are entered repeatedly and required to be filtered. Let’s see how this can be achieved. Compare Two or More Columns Using a Formula Step 1 − We have taken sample data as shown below having two columns with some duplicate values. Step 2 − In the column C, we will identify the duplicate and unique values using the below formula. IF(ISERROR(MATCH(B3, $A$3−$A$10000, 0)), "Unique", ...
Read MoreHow to compare if multiple cells are equal in Excel?
To compare the values of two or more cells there are multiple formulas that can be used. For example, MATCH, If(A=B), EXACT, COUNTIF, etc. Here we will be learning the following two functions to find the exact match or where the formula will compare the strings without considering the case of strings. EXACT − To find the exact match. COUNTIF − To find similar values. Compare Multiple Cells for Equal Values Step 1 − Following is the sample data that we have taken for comparing the strings/cell values in a datasheet. Step 2 − Here, we have ...
Read MoreHow to compare dates if greater than another date in Excel?
If we want to compare a date in an excel sheet with all other dates available in the sheet, then manually doing this activity will be very tedious and time taking. For this activity, we can use a formula that may give the comparison in one shot. Let’s learn how to use this formula to compare the dates. Compare Dates to Check if a Date is Greater than Another Date Step 1 − Below is the sample data that we have taken for comparing the dates. In the first column, we have taken the dates with which comparison needs to ...
Read MoreA study on cloud-based Internet of Things: CloudIoT
A clever worldview where Cloud and IoT are combined is predicted as troublesome and as an empowering influence on countless application scenarios. Examining the common features of the progressions that participated in enlisting is crucial. Undoubtedly, this is decidedly the situation with Distributed computing and the Internet of Things (IoT) - two norms that share various ordinary features. The compromise of these thoughts might work with and work on these progressions. Distributed computing has changed how advances can be gotten to, made due, and conveyed. The way that Cloud makes it, generally, agreed figuring can be used later in utility ...
Read MoreWhat Is Azure Machine Learning, And Why Would You Use It?
Introduction The lifetime of a machine learning project is driven by the cloud service Azure Machine Learning. It can be used by machine learning experts, data scientists, including engineers in their daily workflows: Operate MLOps while training and deploying models. An open-source platform, including Pytorch, TensorFlow, sci-kit-learn, or a model we put together in Azure Machine Learning are both options. We may observe, retrain, and deploy models with the use of MLOp. In this article, we will be exploring Azure Machine learning and the usage. Cognitive Services and Azure Machine Learning Services Azure Table Storage is Microsoft's first offering with ...
Read MoreTop 10 IoT Sensors You Need to Know in 2023
Nowadays, sensors are widely used. Over the past ten years, the cost of various sensors used in consumer electronics and industrial applications has decreased due to the smartphone revolution. And they are more widespread than ever because of the IoT's growing influence in our daily lives. IoT is regarded as a very potent system. They have a great potential to alter how systems function and how businesses run. IoT systems are capable of gathering, analyzing, reporting, and acting on enormous amounts of data. Not even human interaction is necessary. IoT sensors make it possible to collect data in this manner. ...
Read MoreWireless Sensors for the Internet of Things (IoT)
What if you are at work and forget to switch off the Air conditioner at home? Do you need to travel back? If you have a mobile application that checks the AC status and switches it off immediately. This use case is not limited to Air conditioners; how about having this advantage with all home appliances like refrigerators, washing machines, heaters, security alarms, etc.? Yes, we can connect all these appliances internally, leading to a trending technology called IoT, the Internet of Things. The Internet of things can make every machine smarter, giving internet access to internet−not−enabled devices. This results ...
Read MoreWhat is Green Cloud Computing?
The rising interest in cloud frameworks has brought about a critical ascent in energy utilization. This mission for power has impressively expanded the carbon impression of the climate. The remarkable ascent of server farms with many servers and different foundations is mainly answerable for the always−expanding energy necessity. Luckily, an answer is accessible as Green Cloud computing assists associations with limiting their carbon impression and advancing ecological supportability. The developing interest in cloud frameworks has prompted an emotional expansion in energy utilization. This longing for power has fundamentally added to the climate's carbon impression. The always−expanding interest in energy is ...
Read More