# Alif Bin Hussain

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.

## Designation

Excel & VBA Content Developer at ExcelDemy in SOFTEKO.

## Education

B.Sc. in Civil Engineering, BUET.

## Expertise

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

## Experience

• Technical Content Writing
• 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)

## How to Create a Rating Scale in Excel (4 Easy Ways)

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

## How to Create Mortgage Loan Pipeline Management in Excel

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

## How to Navigate Large Excel Spreadsheets (10 Useful Techniques)

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

## How to Calculate Residential Construction Cost Estimator in Excel

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

## How to Overline Text in Excel (4 Easy Ways)

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

## How to Create Graph of Skewness and Kurtosis in Excel

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

## How to Create Drill Down in Excel (with Easy Steps)

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

## How to Display Tooltip on Mouseover Using VBA in Excel

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

## How to Circle Text in Excel (3 Easy Ways)

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

## How to Select First Item from ComboBox Using VBA in Excel

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

## How to Insert Text Box in Excel (5 Easy Methods)

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

## How to Apply All Combinations of 3 Columns in Excel

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

## How to Make a Checklist in Excel (with Easy Steps)

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

## How to Increase Font Size Using Keyboard in Excel (3 Easy Ways)

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

## How to Remove Print Margins in Excel (3 Quick Tricks)

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

Browsing All Comments By: Alif Bin Hussain
1. Hello FAIS,

• You can use the following formula to calculate the time required to get the desired salary. This formula will give you the result in years only.

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

In the formula, C6 refers to the desired salary (75000000), C4 refers to the current salary (307584) and C5 refers to the increment percentage (10%).

• If you want the results to be in years and months, use the formula given below.

`=INT(C8)&" years " & INT(MOD(C8*12,12))&" months"`

Here, C8 refers to the required time in years.

• You can set up your Excel worksheet like the following image given below to get the desired result.

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

3. Hello Claire,

Follow these steps to make the stacked bar charts of Likert scales.

• First, select the range B4:G10.
• Then go to,

Insert >> Charts >> 100% Stacked Column

• As a result, the chart will look like the following image.

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

Alif Bin Hussain Mar 9, 2023 at 5:38 PM

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.

• In this example, we want to attach a file named Attachment.pdf.Â The path directory for the file is D:\Exceldemy\.

• Next, add a new column (H) and write the file names you want to attach to the email. Make sure to write the file extension.

• Then, open the code module and write the following code.

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

• After writing this code, go back to the excel sheet.
• Then, select one or more names and click on the button.

• As a result, Microsoft Outlook software will open and you will find the email already written with the attached file. You can just click send to send the Email.

6. 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 H13 through J13. 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, I and J are H6:H18, I6:I18 and J6:J18 respectively.

3. Then select cell D6 and change the ranges of H,I and J cells in the formula bar and press Enter. After that, Autofill formula up to cell D9.

4. Similarly, change the formula ranges for other cells as 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.

Advanced Excel Exercises with Solutions PDF