In this article, we will discuss how to list all dates which fall on Mondays or Fridays in the given month in Excel. Like numeric data, Excel also works well with dates. If we want to fill a series of dates in a worksheet, we can simply use Fill handle. But what if we want only those dates that fall on a Monday or Friday. This task cannot be achieved using Fill handle. We can use two ways to fill the dates in the given month that fall on Monday or Friday. The user defined function would be used in ... Read More
Excel provides various formulas and functions to analyze and examine numerical data. These formulas and functions are mostly aimed at numerical data. An Excel worksheet contains data that is either manually entered or calculated using formulae, but formulas are not visible in the worksheet. We aim to list all the formulas used in an Excel worksheet. In this article, we will describe different ways to list all the formulas present in the given worksheet in Excel. The two major examples can be used to list all the formulae in an Excel worksheet. The Show Formulas option utilize in example 1 ... Read More
Angular JS is a popular JavaScript framework that offers developers a range of useful tools for creating dynamic web applications. A common requirement in web development is to change specific words or phrases within a given text. In this tutorial, we will explain how to replace one string with another using AngularJS. We will provide clear, step-by-step instructions to accomplish this task effectively. To make it easier to understand, we will use a practical example to demonstrate the powerful features of Angular JS for string replacement. Importance of Replacing a String Before we explore the technical aspects, let's first grasp ... Read More
Cross-Site Scripting (XSS) is a major threat to web application security because it allows attackers to inject malicious scripts into reputable websites. This attack depends on innocent consumers, exposing important information or potentially gaining control of their accounts. Understanding and combating XSS threats is critical for maintaining a strong security posture as web applications become more complex and dynamic. In this article, we will dive into XSS attacks and look at possible prevention strategies. What are XSS Attacks? Cross-Site Scripting (XSS) attacks are a common security risk in web applications. Attackers take advantage of vulnerabilities in web pages to inject ... Read More
Fabric.js is a powerful tool written in JavaScript that makes it easier to build applications with interactive and dynamic graphics using HTML5 canvas. It offers many useful features, including the ability to add controls such as resizing and rotation handles to objects on the canvas. Sometimes, though, you might want to take away these controls from certain objects, like text, to limit what users can do. In this article, we'll show you how to remove controls from a text canvas using Fabric.js, using a simple example that you can follow along with. How to Remove Controls of a Text? To ... Read More
In this article, we will guide you through the process of creating a slide puzzle game using Python and the PyGame library. As passionate Python programmers, we have always enjoyed developing interactive games, and slide puzzles are no exception. With the power of PyGame, we can bring this classic puzzle to life on our screens. Throughout this tutorial, we will embark on an exciting coding adventure together. We will explore how to set up the game window, create the puzzle tiles, shuffle them randomly, and handle user input for an interactive experience. Each step will give us a deeper understanding ... Read More
Bootstrap is a CSS framework allowing developers to style HTML elements without writing any CSS code. We can use pre-defined classes of Bootstrap with HTML elements to style them. The Bootstrap also contains the modal. The simple meaning of the modal is the pop-up box. For example, an alert box, payment box, etc. In this tutorial, we will learn to add data to the bootstrap modal using JavaScript or JQuery. One scenario when we require to add data to the bootstrap modal is that we allow users to select any product. After that, we need to open a payment modal ... Read More
While developing web pages, many times, developers require to manage the size of different HTML elements such as image, div element, span element, etc. Developers can use the width and height CSS properties or HTML attributes to manipulate the dimensions of a particular element. In this tutorial, we will see the difference between the width/height HTML attribute and CSS properties. Width and Height HTML Attributes The width/height attributes in HTML are used for the presentation. It takes the width and height values in the ‘px’, ‘%’, etc. units but not in ‘rem’ units. Also, if we don’t define the unit ... Read More
Are you also willing to add a custom audio recording feature to your web application? If yes, you are in the right place, as we will learn to record and play audio using JavaScript in this tutorial. Some applications like Discord allow you to record the audio and store it inside that to play it anytime. The recorded audio can also be used as a meme for fun, alerts in the discord meetings, etc. We can also use the mediaRecorder API of JavaScript to add the recording audio feature to our web application. Here, we will learn a step-by-step guide ... Read More
Sometimes, developers require to put the text in the icons. For example, adding the total number of likes inside the ‘like’ icon makes UI better, adding a comment inside the comment icon, showing a particular number in any icon, etc. In HTML, we can add the text and icon both separately. After that, we can set the position of the text to place them in the middle of the icon. In this tutorial, we will learn different examples of putting the text inside a created icon. Syntax Users can follow the syntax below to set the position of the text ... Read More