December 4, 2020

## How to write Macro in Excel

If there is any repetitive tasks you need to perform in excel, you can create a Macro for the same which is used to automate …

## How to add bullet points and serial numbers in Excel

In this lesson we will learn different techniques of adding Bullets points in Excel. For example we have a table containing couple of rows consisting …

## How to add different icons like plus sign and tick & cross marks in Excel

In this lesson first we will learn how to add plus sign to the numbers in excel. In our below example we have the list …

## How to keep leading zeros in Excel

For example we have a set of numbers for which we need to keep the leading zeros as it is. Excel automatically truncates the leading …

## How to Paste a document or any other file in Excel

Excel provides the feature to embed another file or document inside the spreadsheet.  Click inside the cell of the spreadsheet where you want to place …

## How to see the average of the numbers in a row/column in excel

If you want to calculate the arithmetic mean of a set of numbers , you can use excel’s average function. In the below example we …

## How to add table border in excel

Let’s say we have the below table containing certain number of students and their rank in a University entrance exam. Now To add border in …

## How to check the count of cells in excel

Let’s say we have the below table containing certain number of students and their rank in a University entrance exam. Now to check the count …

## How to see the sum of the numbers in a row/column in excel

Excel provides ‘AutoSum’ function which automatically adds numbers in the cells that you select and show you the total. Let’s say you have an excel …

## How to do conditional formatting in Excel

Let’s say we have the below table containing certain number of students and their rank in an University entrance exam. Now we need to check …