About author
## Designation

Excel & VBA Content Developer at ExcelDemy in SOFTEKO.
## Lives in

Dhaka, Bangladesh.
## Education

B.Sc. in Civil Engineering, BUET.
## Expertise

ABAQUS, ETABS, AutoCAD, Microsoft Word, Excel, C++, SAP 2000, MATLAB, FAARFIELD
## Experience

Alif Bin Hussain earned a BSc in Civil Engineering from Bangladesh University of Engineering and Technology. As an engineering graduate, he has a deep passion for research and innovation. He loves to play with Excel. In his role as an Excel & VBA Content Developer at ExcelDemy, he not only solves tricky problems but also shows enthusiasm and expertise in handling tough situations with finesse, emphasizing his dedication to delivering top-notch content. He is interested in C, C++, C#, JavaScript, Python, Microsoft Office, AutoCAD, Adobe Illustrator, Data Entry, and Web Scraping.

- Technical Content Writing
- Undergraduate Projects
- Detailed Traffic Study, Roundabout Design and Analysis for Palashi Intersection

- Submitted for review
- Nonlinear Finite Element Analysis of Flexural Behavior of Composite Beams with Rebar Shear Connectors" submitted for review in 3rd International Conference on Structural Engineering Research, Sydney, 2022 (iCSER 2022)

This is an overview. Syntax: expression.VerticalAlignment Expression is a variable that represents a cell-format object. These are common ...

Alif Bin Hussain
Aug 3, 2024

A File System Object (FSO) is an object in VBA that provides a way to work with files and folders on a computer’s file system. It allows VBA code to create, ...

Alif Bin Hussain
Jun 28, 2024

This is an overview. Key Concepts i. Dir Function The Dir function returns the first file name in the specified folder. ii. File System ...

Alif Bin Hussain
Aug 4, 2024

Introduction to VBA Array Arrays are powerful tools for managing data, and they allow you to group related values under a single variable name. Here are the ...

Alif Bin Hussain
Jul 10, 2024

Method 1 - Calculate Free on Board Insert the price of the following four types of expenses. Value of the goods Cost of handling carriage before ...

Alif Bin Hussain
May 30, 2024

Here’s an overview of the offset mortgage calculator we’ve prepared for this article. Introduction to Offset Mortgage Offset mortgages offset the ...

Alif Bin Hussain
Jul 16, 2024

This is an overview. Step 1 - Enter the Date and the Odometer Reading Insert two columns: Date and Odometer Reading. Enter the dates and the ...

Alif Bin Hussain
Jun 28, 2024

Reason 1 - Numerical Data Converted into Text Format The issue can occur if the data we are trying to sort is in Text format. We can only sort data from ...

Alif Bin Hussain
May 21, 2024

We will use the following dataset to demonstrate how to use the ISNUMBER function for IF statements. Example 1 - Check If a Cell Starts with a ...

Alif Bin Hussain
May 15, 2024

Interpolation is the process of determining the value of an unknown point that lies between two known data points. While calculating linear interpolation is an ...

Alif Bin Hussain
Jul 7, 2024

Example 1 - Insert a Pie Chart for Grade Distribution Steps: Insert a column named “Grades”. To find out the grade, select cell D5 and enter the ...

Alif Bin Hussain
Jul 3, 2024

We will use the following dataset, which contains two columns named Student Name and Test Score. A bar chart is inserted using these two columns. ...

Alif Bin Hussain
Jul 3, 2024

This is an overview. Unchecking the AutoCorrect Dialog Box Steps Click the arrow button above the ribbon and select More Commands. ...

Alif Bin Hussain
Aug 4, 2024

Excel is a very useful tool for plotting different kinds of charts. Excel offers various options to format the plotted charts to make it look more attractive. ...

Alif Bin Hussain
Jul 6, 2024

Method 1 - Create a VBA Dictionary Steps: Open the Microsoft Visual Basic window by pressing Alt+F11 . Click on the Tools tab and go to, Tools → ...

Alif Bin Hussain
Jul 3, 2024

Browsing All Comments By: Alif Bin Hussain

About ExcelDemy.com

ExcelDemy is a place where you can learn Excel, and get solutions to your Excel & Excel VBA-related problems, Data Analysis with Excel, etc. We provide tips, how to guide, provide online training, and also provide Excel solutions to your business problems.

Contact | Privacy Policy | TOS

Hello FAIS,

Follow these steps to get your desired result.

`=LN(C6/C4)/LN(1+C5)`

In the formula,

C6refers to the desired salary (75000000),C4refers to the current salary (307584) andC5refers to the increment percentage (10%).`=INT(C8)&" years " & INT(MOD(C8*12,12))&" months"`

Here,

C8refers to the required time in years.Excelworksheet like the following image given below to get the desired result.Hello Tom,

The upward arrow between C9 and C10 in the formula indicates the exponent operation of mathematics. In the formula, C9 raised to the power of C10 is written as C9^C10. A simple example would be “Two Squared” which is written as 2^2 = 4, where 2 is raised to the power of 2, resulting in 4.

Hello Claire,

Follow these steps to make the

stacked bar chartsof Likert scales.B4:G10.Insert >> Charts >> 100% Stacked ColumnHello Torsten,

Thank you for bringing this matter to our attention. We will look into the VBA function to see if it can be updated to minimize the deviation of the orange line from the given points.

Besides, I would like to address your concern regarding interpolation methods. There are some interpolation methods that go through all the given points such as Lagrange interpolation or polynomial interpolation etc. However, interpolation method such as cubic spline interpolation does not necessarily pass through all the given data points.

Hello SANJAY DANGI,

Thank you for reaching out. You can add attachment to the email in the first method easily. Follow these steps to do it.

Attachment.pdf.The path directory for the file isD:\Exceldemy\.H) and write the file names you want to attach to the email. Make sure to write thefile extension.`Sub ExcelToOutlookSR() Dim mApp As Object Dim mMail As Object Dim SendToMail As String Dim MailSubject As String Dim MailBody As String Dim FileName As String Dim Path As String 'Declare variable for file path Path = "D:\Exceldemy\" 'Set file path For Each r In Selection SendToMail = Range("C" & r.Row) MailSubject = Range("F" & r.Row) MailBody = Range("G" & r.Row) FileName = Range("H" & r.Row) 'Get file name from H column Set mApp = CreateObject("Outlook.Application") Set mMail = mApp.CreateItem(0) With mMail .To = SendToMail .Subject = MailSubject .Body = MailBody .Display .Attachments.Add (Path & FileName) 'Add attachment End With Next r Set mMail = Nothing Set mApp = Nothing End Sub`

Hello Theo,

Follow these steps to adjust ranges to make a longer list without any error.

1. First, to make the task list longer, select cells

H13throughJ13. Then drag the fill handle down to add new task.2. In this example, we added five new tasks. Therefore, the new ranges for column

H, IandJareH6:H18,I6:I18andJ6:J18respectively.3. Then select cell

D6and change the ranges ofH,IandJcells in the formula bar and pressEnter. After that,Autofillformula up to cellD9.4. Similarly,

change the formula ranges for other cellsas well.5. Finally, you can see in the following figure that the formula is working properly.

I hope this solves your problem. Please let us know if you face any other issues.