How to count names in excel

Hence, 7 names have been counted  that have a bank balance. The count function does not calculate the names directly. So, we calculated names by indirect method, with the support […]

How to change scale on a graph in Excel

How to add labels to axis in Excel

We have a chart showing the quantity of cars sold by dealers in our excel worksheet as shown. However, there are no axis labels. Let’s add axis labels to the […]

How to find duplicate rows in excel

How to make a duplicate of Excel sheet

Microsoft Excel is a very powerful tool for computing that contains rows and columns to manage the numeric data. It can carry billion transactions and numeric values. The data has […]

How to refresh a worksheet in Excel

We have a worksheet containing the PivotTable for car sales data as shown. The pivot table is connected to data from another worksheet containing a table, Table1.

How to group sheets in Excel

Let’s consider the dataset containing the marks of various students in sheets 2, 4 and 5. The data structure in all these sheets is the same and we’ll learn to […]

How to capitalize first letters in excel

During typing in Excel, users face difficulty in changing the case of words. In this tutorial we will learn how to capitalize the first letter in Excel. To handle this […]

How to add zeros in front of number in Excel

You can watch a video tutorial here. Microsoft Excel is a very powerful tool for computing that contains rows and columns to manage the numeric data. It can carry billion […]

How to do subscript in excel

In this tutorial, we will learn how to subscript in excel. When we subscript a text, it goes below the baseline. Suppose we have to write a chemical formula, in […]

How to copy data from one excel sheet to another

Microsoft Excel is a very powerful tool for computing that contains rows and columns to manage the numeric data. It can carry billion transactions and numeric values. The data has […]

How to move rows up in Excel

Resultantly, we have been shifted rows up in Excel.

How to swap rows in Excel

How to create a database in Excel

How to convert from notepad to excel

In this case, Microsoft Excel helps us with its built-in tool to add text from text files and align it into Excel. Below are the steps to follow;