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.

Create an Alternative to the Datepicker in Excel – 2 Easy Methods

The datepicker feature of Microsoft Excel is only available for the Windows 32-bit version. This is the sample dataset. Method 1 - Use a Calendar ...

How to Make a Payroll Accrual Calculator in Excel

While working with Microsoft Excel, sometimes, users have to make a payroll accrual calculator. Payroll accrual refers to money that is due to your employees ...

How to Apply Abbreviation Using Formula in Excel

While working in Excel, users often need to abbreviate text. The texts can be the name of a person, company, or organization. But there is no single function ...

How to Perform Reverse Geocoding in Excel: 5 Methods

Method 1 - Open Microsoft Visual Basic Application from Developer Tab Go to the Developer tab of the ribbon From the Code group, select Visual Basic. ...

How to Lookup County from Zip Code in Excel: 3 Suitable Ways

Method 1 - Implement XLOOKUP Function Steps: Below the primary data set, construct extra fields for implementing the above functionâ€™s formula. In cell ...

How to Copy a Chart from Excel to PowerPoint Without a Link – 2 Methods

This is the sample dataset. Method 1 - Paste the Excel Chart as an Enhanced Metafile Image Steps: Select B4:D10 and go to the Insert ...

Many times while working in Excel, users need to link Excel files to Google Sheets. Performing this task is quite easy and simple. In this article, I will show ...

How to Skip Data Points in an Excel Graph (with Easy Steps)

Excel is a great tool for showing data in various charts and graphs. These features of Excel help to visualize numerical data. But, sometimes, users need to ...

How to Make a School Time Table in Excel (with Easy Steps)

Using Microsoft Excel, one can perform various types of tasks. Along with the analysis and presentation of data, one can also make charts and tables in Excel. ...

How to Create a Sensitivity Table in Excel (2 Methods)

Sensitivity analysis evaluates how various values of an independent variable impact a specific dependent variable. We will apply this to the sample data set ...

How to Differentiate Between SUMIF and COUNTIF Functions in Excel (2 Examples)

We will use the following sample data set to illustrate the differences: Example 1: Difference in Function Argument Syntax First, letâ€™s discuss the ...

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

The Page Layout tab in the ribbon provides you with various themes, allows changing the orientation and margins of your current worksheet and much more. But ...

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

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

How to Convert Gregorian to Julian Date in Excel – 3 Easy Methods

Introduction to Julian Date in Excel Julian dates are expressed as 5-digit numerals, the first two representing the year and the final three, the day. ...

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