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
How to Create a Sensitivity Table in Excel (2 Effective Ways)

Sensitivity analysis or sensitivity tables in Microsoft Excel are quite easy to create or perform. By giving proper input of data and following some commands, ...

0
Difference Between SUMIF and COUNTIF Functions in Excel

While working in Microsoft Excel, users have to use various types of functions for their working purposes. Some of these functions have many similarities, ...

0
[Solved!]: Excel Page Layout Being Greyed Out (4 Quick Fixes)

While working in Microsoft Excel, you will find the Page Layout tab in the ribbon that is in the menu bar of a worksheet. This tab provides you with various ...

0
How to Copy SUM Formula in Excel (6 Easy Methods)

While working in Excel, users have to apply various types of functions and their corresponding formulas. One such function is the SUM function of Excel. ...

0
Difference Between XML and Excel Files (9 Real Instances)

While working with Excel files, users may save them in various formats other than .xlsx. One such format is the .xml format, which means Extensible Markup ...

0
How to Convert Date to Julian Date in Excel (3 Easy Ways)

Usually, users have to perform many tasks in Excel, which includes mentioning dates. These dates can be days, months, or years of a particular time. Mentioning ...

0
CONCATENATE vs CONCAT in Excel (2 Ideal Examples)

While working with Excel, you need to use various functions depending on your purpose or criteria. Two such functions are the CONCATENATE function and the ...

0
How to Concatenate Names in Excel (10 Practical Examples)

In this article, I am going to show you 10 practical examples of how to concatenate names in Excel. You can quickly use these methods even in large datasets to ...

0
How to Rename Files in a Folder in Excel (2 Easy Ways)

Renaming files might not sound difficult to do for most people. But, renaming a large number of files one by one can become very tedious and time-consuming. ...

0
How to Change Width of Column in Excel Chart (with Easy Steps)

In Microsoft Excel, you can perform numerous tasks in a few minutes. Apart from calculating or using various functions for problem-solving, users can use Excel ...

0
How to Create Attendance Sheet with Time in and Out in Excel

Attendance sheet is a very important feature for an organization or institution. It helps to keep track of employee performance. Creating an attendance sheet ...

0
How to Calculate Percentage for Multiple Rows in Excel

Sometimes, Excel users need to calculate percentages for various working purposes. They may need to find out efficiency or contribution towards total ...

0
How to Create Line of Credit Payment Calculator in Excel

In this article, I will show you how to create a line of credit payment calculator in Excel. I will demonstrate the whole procedure using the Microsoft 365 ...

0
How to Add or Remove Dotted Border in Excel

A dotted border in Excel is a formatting style that uses dotted lines to outline a cell or a range of cells. The dotted border is not a permanent feature of ...

0
How to Make Food and Beverage Budget in Excel

In daily life, people have to make or follow many types of budgets. This is necessary for maintaining the expenses of day-to-day life. If you want to throw or ...

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