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
Brave Browser Alternatives
What is Brave Browser? Brave is a browser which can be used to navigate to different websites on the basis of search results. You can also use the tool to run web apps. Brave browser can be easily downloaded and installed for free. The tool was introduced in 2016 and is one of the latest browsers. One of its advantages is that it does not eat memory of your system. Price Plans of Brave Browser Brave browser can be downloaded for free. Users need not have to fear about any subscription or hidden costs. Why Brave Browser alternatives? There are ...
Read MoreHow to make an entire column capital (uppercase) or lowercase in Excel?
In this article, we will discuss how to make an entire column capital(uppercase) or lowercase in Excel. A spreadsheet in Excel is prepared in a way such that end users can easily understand the data in a tabulated way. To make the headings and significant values stand out, it is required to change their format. For text values, this can be done by changing the case of the heading and the significant values. There are two ways to change the data of an entire column to either uppercase or lowercase. Using formula. Using Kutools. Example 1: By using ...
Read MoreHow to make all rows same height or columns same width in Excel?
In this article, we will discuss two things – how to make all rows of the same height and how to make all columns of same width. A spreadsheet in Excel is made of up of horizontal rows and vertical columns. The height of all the rows or individual rows can be changed as per the requirement. For example, rows having headings usually have more height than other rows holding data values. Similarly, width of some columns can be changed according to the size of the headings. This can be seen from the image below. There are two ways ...
Read MoreHow to make a pictograph (chart with pictures) in Excel?
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 MoreHow to list column header names in Excel?
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 MoreHow to list all worksheets and switch sheet with shortcuts in Excel?
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 MoreHow to list all table names in Excel?
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 MoreHow to list all Mondays or Fridays in a month in Excel?
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 MoreHow to list all formulas in Excel?
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 MoreHow to replace a string by another string in Angular JS?
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