Md. Araf Bin Jayed

About author

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.

Latest Posts From Md. Araf Bin Jayed

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

You can see a sample data set given below that will help us compute income tax in Excel format. Method 1 - Computing Income Tax for Flat Rates in Excel ...

0
How to Rearrange Columns in Excel (4 Methods)

Dataset Overview For the demonstration of rearranging columns in Excel, we will use the following dataset. Method 1 - Using Keyboard and Mouse ...

0
How to Calculate Outliers in Excel (5 Ways)

  Method 1 - Using Sort & Filter to Calculate Outliers in Excel Step 1: Select the column header that you want to sort in your Excel dataset. ...

Browsing All Comments By: Md. Araf Bin Jayed
  1. 1

    2
    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. 1

    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

 

 

ExcelDemy
Logo