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

0
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. 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