In this article, we will discuss the ways in which we can make cells bold if greater than a certain number in Excel. Excel is an ideal application to handle numeric data. In order to analyse numeric data accurately, Excel comes in various built-in formula and features. These formulas come ... Read More

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 ... Read More

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 ... Read More

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 ... 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 ... 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 ... 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 ... 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. ... 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 ... Read More