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)

Rating scales are used to evaluate responders' feedback towards a particular product. Excel can help greatly in creating a rating scale for any number of ...

Alif Bin Hussain
Dec 21, 2023

If you need to keep track of mortgage loan status, Excel can help you greatly. In Excel, you can easily create a table of the various stages and regularly ...

Alif Bin Hussain
Dec 24, 2023

Sometimes we work with a large amount of data in Excel. Keeping track of this much data is often very difficult. In this article, we will show you how to ...

Alif Bin Hussain
Dec 19, 2023

Residential construction estimator is a method of evaluating the potential cost of construction by calculating material quantities and their costs with the ...

Alif Bin Hussain
Jan 4, 2024

One might need to put a line over text for various purposes. For instance, Means and Vectors are expressed by putting a bar on the top of a text in ...

Alif Bin Hussain
Dec 28, 2023

Symmetric datasets give us normal distribution curves, whereas asymmetric datasets give us skewed normal curves with different shapes of peaks. Asymmetric ...

Alif Bin Hussain
Dec 19, 2023

While working with a large amount of data, one might need to filter only a fraction of the whole data for various purposes. Excel can be a very useful tool for ...

Alif Bin Hussain
Apr 30, 2023

Sometimes you might want to know information before clicking on anything in Excel. You can do it by adding a tooltip to a text, shape, and image that will be ...

Alif Bin Hussain
Dec 20, 2023

Sometimes you might need to enclose a text inside a circle to highlight it or for some other purpose while working on Excel. You can do this easily and quickly ...

Alif Bin Hussain
Dec 20, 2023

ComboBoxes and listboxes are useful approaches to controlling the consumer experience by confining the values that a consumer can choose to a predefined list. ...

Alif Bin Hussain
Nov 6, 2023

Sometimes we need to write a large text of multiple lines in Excel. Text boxes are very useful when it is necessary to show a large text in Excel. Moreover, ...

Alif Bin Hussain
Dec 20, 2023

Sometimes we need to find combinations of various things. Only a few different things can have a large number of combinations. As a result, finding these ...

Alif Bin Hussain
Dec 18, 2023

Checklists are essential for an individual to keep track of tasks already completed and tasks that need to be done yet. Excel can help in creating a checklist ...

Alif Bin Hussain
Oct 16, 2023

Using keyboards while working in Excel can increase efficiency and speed. It often saves time and reduces boredom. Changing the font size every time using a ...

Alif Bin Hussain
Dec 27, 2023

An individual might need to print some Excel data on a piece of paper. To do that, Excel worksheets need to be properly aligned to the printing page to get the ...

Alif Bin Hussain
Dec 19, 2023

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.