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
Make an Alternative to Datepicker in Excel (2 Easy Methods)

As the datepicker feature of Microsoft Excel is only available for the Windows 32-bit version, it is very difficult when you need this feature for the 64-bit ...

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

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

0
How to Perform Reverse Geocoding in Excel (with Easy Steps)

Reverse geocoding means finding out the actual address or location from a given latitude and longitude. This task can be quite hectic if you want to perform it ...

0
How to Lookup County from Zip Code in Excel (3 Suitable Ways)

Sometimes users need to look up a county based on zip codes in Excel. This task can be easily performed by utilizing some Excel functions and features. In this ...

0
How to Copy Chart from Excel to PowerPoint Without Link

Sometimes users need to copy charts from Microsoft Excel to PowerPoint for presentation purposes. But, if you copy your chart with a link and then paste it ...

0
How to Link Excel to Google Sheets (with Easy Steps)

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

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

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

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

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