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
Merge Two Columns in Excel with First Name and Last Name

In many instances, users have to handle or exploit data in Excel in different ways. One such instance is to merge the first name and last name of people from ...

0
How to Reverse Data in Excel Cell (5 Easy Ways)

While working in Excel, users may have to reverse the data in the worksheet’s cells for working purposes. But there are no integrated options in Excel to do ...

0
How to Count Missing Values in Excel (2 Easy Ways)

Sometimes, users have to list missing things in Microsoft Excel. While making these kinds of lists, it is important to count how many values are missing from ...

0
How to Count Significant Figures in Excel (2 Ways)

We can define significant figures as the important figures of a certain number that accurately represent the meaning of that number. The concept of significant ...

0
How to Flip Bar Chart in Excel (2 Easy Ways)

There are many graphical features available in Microsoft Excel. Users use those features to represent statistical data. The Excel bar chart is one of them. ...

0
How to Make Electronic Raffle Draw in Excel (2 Ways)

To select a winner from a lottery, we need to do a raffle draw. Drawing raffles manually is time-consuming and tedious if there are many participants. But this ...

0
How to Create Tabs Automatically in Excel (3 Cases)

While working in Microsoft Excel, sometimes you need to create new tabs based on various criteria. Also, various companies or institutions need separate Excel ...

0
How to Undo Remove Duplicates in Excel (3 Ways)

While working in Excel, users may sometimes have to deal with duplicate values. Sometimes, these values might not be necessary for working purposes. So ...

0
How to Make a Modified Box Plot in Excel?

A great way of representing statistical data in Excel is by using a box plot. If the data in a data set are interrelated to each other then showing them in a ...

0
How to Reverse Score in Excel (4 Easy Ways)

For better analysis in many surveys and questionnaires, a reverse score is used. Generally, in the reverse score, we transform 1 = 5, 2 = 4 and so on. Doing ...

0
How to Add Brackets to Negative Numbers in Excel (3 Easy Ways)

It is a common case while working in Excel to get negative values in the calculation. By default, Excel will put a negative sign before such values. But if you ...

0
How to Reconcile Data in 2 Excel Sheets (4 Ways)

While working in Excel, users have to reconcile two data sets for various working purposes. If the two data sets are in the same worksheet, then it is easy to ...

0
How to Write 00 in Excel (11 Easy Ways)

While working with various numbers in Excel, sometimes it is necessary to add a 0 or 00 at the beginning of the numbers. But by default, Excel will not keep ...

0
How to Calculate Growing Annuity in Excel (2 Easy Ways)

An annuity is a term that is mainly associated with retirement. By following some simple steps in Excel, one can easily calculate a growing annuity for one's ...

0
How to Calculate Cost of Funds in Excel (with Easy Steps)

Cost of funds is a term of finance and banking. Many times, financial institutions have to calculate the cost of funds for their working purposes. This ...

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