# Md. Araf Bin Jayed

I am Araf. I have completed my B.Sc in Industrial and Production Engineering from Ahsanullah University of Science and Technology. Currently I am working as an Excel & VBA Content Developer in Softeko. With proper guideline and aid of Softeko I want to be a flexible data analyst. With my acquired knowledge and hard work, I want to contribute to the overall growth of this organization.

## How to Create Loan Calculator with Extra Payments in Excel

In todayâ€™s world, loans are an inseparable part of our lives. Sometimes, we need to use the help of loans and installments to buy our essential products. In ...

## How to Make Excel Run Faster with Lots of Data (11 Ways)

Excel is an essential tool for everyday life. We use Excel to analyze lots of data for our calculation purposes. Sometimes, Excel may not run fast while ...

## Income Tax Computation in Excel Format (4 Suitable Solutions)

It is mandatory for every eligible citizen to pay income tax on time. Sometimes, it is hard to determine the amount of tax based on oneâ€™s income. In this ...

## How to Rearrange Columns in Excel (4 Ways)

In Microsoft Excel, the worksheets consist of rows and columns. Sometimes, the user needs to rearrange the columns in Excel for their working purposes. In this ...

## How to Calculate Outliers in Excel (5 Easy Ways)

Outliers may need to be identified in order to do statistical computations on data from a data set. You can discover outliers from huge datasets using ...

Browsing All Comments By: Md. Araf Bin Jayed

1. Hello Bombshellshock,
You are absolutely correct. To expand the table by a row, click the row just below the table and enter your desired data. After inserting data press Enter and your job will be done.
If this reply doesnâ€™t give a proper answer to your problem, then send the Excel file to [email protected]. Moreover, you can find the Excel file here.

2. Hello Queda,
If you want to add and subtract across an Excel spreadsheet, it means if you want to give a cell reference in your formula from another sheet, the formula will look like the following one.

``=SUM(B5,B6,B7,B8,B9,B10)-SUM(Cost!B5,Cost!B6,Cost!B7,Cost!B8,Cost!B9,Cost!B10)``

Without giving the proper sheet and cell reference, the formula wonâ€™t work or show an error. If this reply doesn’t give a proper answer to your problem, then send the Excel file to [email protected]. Moreover, you can find the Excel file here.

Advanced Excel Exercises with Solutions PDF