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
Fatman Evolutionary Model in Social Networks
The Fatman model is a model that explains how social media grows and changes over time. Social Media has become an integral part of everyone’s life. Researchers are constantly trying to understand the social media growth and behavior associated with it. In this article, we will understand the Fatman model and its significance in social media network Analysis. Fatman Model The Fatman model was first introduced by Alain Barrat, Marc Barthélemy, and Alessandro Vespignani in a paper published in 2004. Fatman's model says that the growth of social networks is influenced by two main factors − Preferential Attachment ...
Read MoreExtracting the real and imaginary parts of a NumPy array of complex numbers
In Python, we can extract the real and imaginary parts of a NumPy array of the complex number using the real and imag attributes of the array, respectively. Numpy is a Python library that is used for complex calculations and also provides support for complex numbers. In this article, we will understand how we can extract the real and imaginary parts separately of a complex number. Understanding Complex Number in Numpy In Numpy we represent a complex number as a combination of the real and imaginary parts using the complex data type. We can create a complex number in ...
Read MoreHow To Determine If Date Has Passed In Excel ?
Dates are very important for organising and analysing data in Microsoft Excel. It's critical to be able to tell whether a given date has gone or not while managing project deadlines, keeping tabs on significant events, or keeping track of time−sensitive chores. This procedure can be automated, which can help you save a lot of time and work. In this article, we'll walk you through how to use Excel to check whether a date has passed. We'll look at various methods and features that let you quickly compare dates and make defensible choices in light of the results. You will ...
Read MoreHow To Determine If A Number Or Value Is In A Range In Excel ?
With the help of Excel, you can do numerous computations and procedures on your data. Checking whether a specific number or value is inside a given range is a common task. Excel has a number of functions and approaches to help you complete this task quickly and accurately, whether you're working with big datasets or just need to confirm data entries. In this article, we'll look at various Excel techniques for figuring out whether a number or value falls within a range. Simple range tests as well as more complex scenarios involving numerous criteria will both be covered. You'll have ...
Read MoreHow To Determine If A Date Falls Between Two Dates Or On Weekend In Excel ?
With the help of Microsoft Excel, you can do numerous computations and analyses on your data. It's frequently crucial to determine whether a specific date comes on a weekend or fits within a certain range while working with dates. This article will examine various approaches and formulas that will make it simple for you to figure out whether a date satisfies these requirements. You will have a firm grasp on how to use Excel to identify whether a date falls on a weekend or in between two other dates by the end of this session. These abilities will come in ...
Read MoreHow To Determine Frequency Of A Character/Text/String In An Excel Range ?
Excel is a robust programme that is frequently used for data analysis and manipulation; knowing how frequently certain characters or strings appear in a certain region might reveal important information. This lesson will walk you through the process of counting the instances of a character, text, or string in an Excel range. Regardless of your level of Excel proficiency, this article will assist you in understanding the concept and applying it to your data analysis projects. You will have a thorough understanding of how to use the built−in functions and formulae in Excel to calculate the frequency of a character, ...
Read MoreHow To Determine And Identify The Background Color Index Of Cells In Excel ?
Excel is a robust spreadsheet programme that enables you to efficiently organise and analyse data. When working with huge datasets or when performing conditional formatting, it might be especially helpful to know how to extract information about the background colour of cells. We will look at the steps for finding and identifying the background colour index of cells in Excel in this tutorial. To accomplish this, we will discuss a variety of approaches and strategies, giving you a thorough grasp of the procedure. You will be competent in retrieving the background colour index of cells at the end of this ...
Read MoreHow To Design Custom Border Style (Thickness/Width/Diagonal) In Excel ?
Borders are essential for improving your spreadsheet's aesthetic attractiveness and organisation. Excel has the option to design bespoke border styles to meet your unique demands while also offering a variety of established border patterns. In this article, we'll look at how to customise the width and thickness of borders in Excel as well as how to make diagonal borders. Understanding how to develop custom border styles will give you the power to produce any appearance you want, whether you want to draw attention to certain cells, make tables look professional, or inject some creativity into your worksheets. We'll walk you ...
Read MoreHow To Delete Worksheet Without Prompt Or Warning In Excel ?
Excel is a strong tool for managing data and organising information, and occasionally you might need to swiftly and effectively remove a worksheet from your workbook. When you try to delete a worksheet, Excel, by default, prompts you with a confirmation notice. While this can help to avoid unintentional deletions, it can also make workflow more difficult, especially when you need to delete several pages at once. In this article, we'll look at a technique that lets you delete a worksheet in Excel without getting prompted. We will walk you through the procedure with step−by−step instructions so you may get ...
Read MoreHow To Delete Worksheet Based On Cell Value In Excel ?
Excel is an effective tool for organising and analysing data, and you might occasionally need to eliminate particular worksheets from your workbook based on predetermined criteria. This tutorial will show you how to automatically delete worksheets that match certain cell value criteria. It can take a while to manually delete worksheets, especially when working with large workbooks that contain a lot of sheets. To erase worksheets depending on particular cell values, we can make use of the VBA (Visual Basic for Applications) programming language in Excel. Delete Worksheet Based On Cell Value Here, we will first create a VBA and ...
Read More