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
Articles on Trending Technologies
Technical articles with clear explanations and examples
How to AutoFilter Rows Based on Cell Values in Excel?
Generally, in Excel, we can always apply a filter to a list just by using a slicer, and we can click on the cell value you want to filter internally. But if you want to apply the filter based on a cell that is not inside the table, we cannot do it with the help of Slicer. We can complete this process with the help of the VBA application. We can apply the filter using an external value. This tutorial will help you understand how you can auto-filter rows based on a cell value in Excel. Step 1 Here we ...
Read MoreHow to Autofill Weekdays Excluding Weekends in a List of Google Sheet?
When you want to create a list of dates that only include weekdays in Excel, you can do it by default by using the formulas supported by Excel. For example, if we want to create a list of working dates in an office, we can use this process. Leaving out the weekends means ignoring the dates of both Sunday and Saturday in the list. This tutorial will help you understand how you can autofill weekdays and exclude weekends in a list of Google Sheets. We can complete this process just by using a single formula. We can complete this process ...
Read MoreHow to Autofill Formula When Inserting Rows in Excel?
When we insert a new row in the table of data where we have the formula in any of the columns, you can see that the formula will not be applied to the new row even though we entered the data in the cell. We need to reapply the formula with the auto-fill handle to all the cells manually. If you are dealing with frequently changing data, you may end up wasting a lot of time applying the formula. You can solve this problem by enabling the formula to auto-fill when inserting new rows in Excel. This process can be ...
Read MoreHow to Auto-Fill Date or Only Weekdays Sequence in Excel?
Have you ever tried to create a list of dates in Excel? It is a simple process, but have you ever tried to create a list of only weekdays in Excel? It is possible by using this process. Read this tutorial to learn how you can autofill dates or only weekdays in Excel. We will complete the task using the "format" function. AutoFill Date Sequence in Excel To finish our task, we will select a range of cells, then open the format pop-up and select date. Let us see a simple process to auto-fill data sequences in Excel in a ...
Read MoreThe Realization of Logic Functions Using NAND Gates
A logic function is a basically a Boolean expression that returns a Boolean value, which is a value that is either TRUE or FALSE. The NAND gate is a universal logic gate, thus it can be used to implement any type of logic function. Read this tutorial to learn how you can realize different logic functions using NAND gates. Let's start with a basic introduction of the NAND gates What is a NAND Gate? A NAND Gate is a type of universal logic gate that one can use to realize any kind logical expression or any other type of logic ...
Read MorePositional Number System
A number is a method used for representing an arithmetic value, measure, or count, of a physical quantity. A number system is defined as a method of naming and representing numbers. The concept of number system helps in defining the rules associated with the numbers and different operations on numbers. A number system is determined with the help of its radix or base. The radix or base of a number system is nothing but the total number of symbols used in the number system for representing the different numbers. For example, in the decimal number system, there are 10 ...
Read MoreBuild an Inverter with a Transistor
In this tutorial, we will discuss the realization of an inverter (NOT gate) with a transistor. But before that let's have a look into the basics of inverter or NOT gate. What is an Inverter (NOT Gate)? An inverter is a single input and single output logic gate that toggles or inverts the logic level (or state) of a single to the opposite state or logic level. The inverter is also known as NOT gate. When a low signal (logic 0) is applied to an inverter, it transforms it to a high signal (logic 1). If a high signal (logic ...
Read MoreParallel Computing with Dask
Dask is a flexible open-source Python library which is used for parallel computing. In this article, we will learn about parallel computing and why we should choose Dask for this purpose. We will compare it with various other libraries like spark, ray and modin. We have also discussed use cases of Dask. Parallel Computing A type of computation known as parallel computing carries out several computations or processes simultaneously. Large issues are typically divided into manageable pieces that may be solved separately. The four categories of parallel computing are Bit-level Instruction-level Data-level Job parallelism. ...
Read MoreLatest Research Topics in Cloud Computing
Cloud computing is acquiring much prevalence and interest the lookout. It is getting executed in numerous associations exceptionally quickly. Cloud computing can be characterized as a recent trend of processing in which powerfully versatile and frequently virtualized assets are offered as a type of assistance over the Web. The benefits of Cloud computing innovation incorporate expense investment funds, high accessibility, and simple versatility. The most widely recognized and notable arrangement model is Public Cloud. A Private Cloud is appropriate for delicate information, where the client is subject to a specific level of security. The benefit of cloud ...
Read MoreTop 10 Innovations in IoT Using 5G
The Internet of Things is a very powerful technology that will change the future world. But one of the most important things IoT requires to operate successfully is the Internet. The Internet is available to all of us, making our lives easy. We have witnessed everything from 2G to 3G and 3G to 4G. Its call changed so rapidly that super high-speed Internet can now boost IoT technology to the next level! Hence we are now shifting from 4G to 5G – the Giga Hertz speed, faster than we ever imagined. Let us look at how IoT and 5G technology ...
Read More