Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Microsoft Excel has the potential to make your professional life easy. It helps you organise, evaluate, and calculate data reliably. Managers and administrators can make relevant decisions that benefit their organisations using the various tools and functions available on the software. With Excel, you can also check the time difference over a specific period. Using this simple method in this tutorial, you can determine if a time difference is greater than a particular period in any given situation. Comparing Time Difference with a Specific Duration Using an Array Formula Suppose you maintain an employee log-in sheet and must determine ... Read More
What if you could find out whether a number in your Excel data set is prime or not in less than 5 steps? We will tell you how in this tutorial, but first, let us understand what a prime number is. A prime number is a number which is divisible only by 1 and itself, and the number 1 is not a prime number. Applying this simple definition, you can use the formula described in the steps to determine if a number is indeed a prime number or not. Array Formula For Checking Prime Numbers An array formula ... Read More
There are cases when we need to compare multiple sheets for consolidating the data in a single sheet against similar entries. Manually this task may need huge manpower as well as time. On the other side the same data can be consolidated by using a one or two formulas and copying the same in all respective sheets. In this article, we will be working on the following formulas for identifying one list against another. =VLOOKUP(lookup_value, table_array, column_index_number, [range_lookup]) =MATCH(lookup_value, lookup_array, [match_type]) Check one list against another using VLOOKUP function Step 1 − We have taken the sample data ... Read More
Planning to send emails but worried some addresses may be entered incorrectly in your spreadsheet? When mailing your clients, you may often see more than one invalid email. Thanks to Microsoft Excel, you can identify these email addresses and correct them as required. This process is also known as data cleansing. Cleaning your data ensures that your spreadsheet only contains relevant information so you can easily move on to the next task. The goal is to repair any data that is wrong, incomplete, poorly structured, duplicated, or even unrelated to the data set's mission. Find Invalid Email Address ... Read More
Are you looking for a simple and quick way to find if the numbers in your data set are integers or not? Well, if you are using Microsoft Excel, the answer is here! An integer is a whole number that can be positive, negative, or 0 but cannot be a fractional number. There are formulas in Excel that help professionals identify the integers in data sets. In this article, we explain two techniques and how to use them. Technique 1: Using the INT Function With Excel's INT function =INT(), you can find the integer fraction of a number, and ... Read More
When it comes to text in MS Excel, one of the most commonly required tasks is to capitalize the first letters in the cells if it contains names, tasks, products, places, or anything else. Unlike Microsoft Word, Excel does not offer the Change Case button, which allows the capitalization of texts. Human errors, such as not capitalizing the relevant letters in the spreadsheet, are common when entering a lot of data. When this happens, one wonders how to quickly check whether a certain cell has a capital letter in the first letter. In this tutorial, we teach how to ... Read More
Often there comes a spreadsheet where you would need to make a preliminary check to see if any row is hidden. Fear not; it is very easy to check. Hiding rows is an interesting feature of MS Excel where not relevant information can be concealed in a spreadsheet without deleting them forever. While working on the file, your teammates may have concealed rows to optimize their visual perspective of the data by removing unnecessary rows, computations, or anything else that might reduce the file's readability. In this tutorial, we explain how to identify hidden rows in your excel ... Read More
Regular expressions, often known as RegEx, are a string of characters corresponding to letters, words, or character patterns in text strings. It implies that you may use regular expressions to match and retrieve any string pattern from the text. Search and replace procedures benefit from the usage of regular expressions. The most common application is searching for a substring that matches a pattern and substituting something else. What are whitespace characters? "Whitespace" refers to any letter or set of characters representing either horizontal or vertical space. Using regular expressions, the metacharacter “\s” matches whitespace characters in python. Algorithm ... Read More
Introduction The re-module is what we use in Python for regular expressions. Text searches and more complex text manipulation employ regular expressions. Tools like grep and sed, text editors like vi and emacs, and computer languages like Tcl, Perl, and Python all have built-in regular expression support. The re-module in Python offers functions for matching regular expressions. A regular expression that defines the text we are looking for or modifying is called a pattern. Text literals and metacharacters make up this string. The compile function is used to create the pattern. Raw strings are advised since regular expressions ... Read More
To understand why dictionary keys must be immutable. Let us related it to hash table. The hash table implementation of dictionaries uses a hash value calculated from the key value to find the key. If let’s say the key was a mutable object, its value could change, and thus its hash could also change. As stated above, since whoever changes the key object can’t tell that it was being used as a dictionary key, it can’t move the entry around in the dictionary. Then, When you try to look up the same object in the dictionary it won’t be ... Read More