Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
In this article, we will describe the method to make a pictograph in Excel. Excel is a software application that focuses on numeric data. To analyze numeric data more effectively and efficiently, Excel provides a way to visualize this numeric data in the form of charts and plots. Excel provides functionalities to develop many kinds of charts and plots. A pictograph is one such chart that contains pictures. A pictograph can be defined as a chart with pictures or icons. Let us see how to make a pictograph in Excel. Example The following steps need to be implemented to create ... Read More
In this article, we will look at the steps on how to list column header names in a single column in Excel. This application is a useful tool for analyzing and carrying out complex calculations for numerical data. Excel provides many formulas and functions that aid in analyzing numerical data as well as visualizing this data with the help of various charts and plots. Excel is a spreadsheet application that is divided into rows and columns. Each column is given a heading or a header name. This heading represents a specific detail that is stored in that column. For example, ... Read More
In this article, we will look at the approach that is used for listing all the worksheets and how to switch worksheets using Excel shortcuts. Excel is a software application that provides end users with many functionalities including shortcuts to make their work faster and increase the productivity of the end users. In addition to this, there are also third-party tools available that can be easily integrated with Excel to enhance the features and functionalities provided by Excel. The only best way to list all the worksheets in Excel is by using a third-party add-in tool called Kutools. This third-party ... Read More
In this article, the user will understand the concept how to list the names of all the tables in a particular Excel worksheet. Excel provides ways to present data to the end user. One of the ways is by organizing the data in a table. A table is a two-dimensional structure that holds data in the form of horizontal rows and vertical columns. In Excel, before inserting a table, we need to enter the data required for the table rows and columns. Then these cells having data are selected and a table is inserted using the Table option under Insert ... Read More
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