Alif Bin Hussain

About author

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.

Lives in

Dhaka, Bangladesh.

Education

B.Sc. in Civil Engineering, BUET.

Expertise

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

Experience

  • 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)

Latest Posts From Alif Bin Hussain

0
Understanding Views in Excel (A Complete Guideline)

Excel offers various views of the worksheet to make it easy to work with the database. Different views are appropriate in different cases, where each view ...

0
Bubble Chart in Excel (Create & Customize)

Bubble chart in Excel is very useful to visualize and compare three sets of data simultaneously. This type of chart is useful when you have a dataset with ...

0
Gridlines in Excel Chart

This article focuses on gridlines in Excel. These are important features that play a significant role in enhancing the readability of chart and graphs. The ...

0
Z Score in Excel (Using Functions & Formulas Tab)

Z score is a measurement that indicates the relationship of a datapoint to the mean of the dataset. It calculates the number of standard deviations by which ...

0
Partial Match Excel

Excel is a powerful tool for data analysis and manipulation, and mastering partial matches in Excel can greatly enhance your ability to work with complex ...

0
Wildcard in Excel

Wildcard in Excel: Knowledge Hub Excel Match Wildcard in Lookup Array Search for Question Mark in Excel How to Remove Asterisk in Excel ...

0
Currency Format in Excel (Format, Change & Remove)

Currency format in Excel allows you to present numbers as currency amounts, complete with currency symbol, decimal precision and many other formatting options. ...

0
Spell Number in Excel (With/Without Currency)

Spelling numbers in Excel is often required for banking or marketing sectors. Although Excel does not offer any built-in function to spell numbers, it is ...

0
How to Add, Edit, Hide and Remove Notes in Excel

In this article, we will explore how to add, copy, hide, remove notes, etc. in Excel. We will also learn to add pictures in notes and convert notes to ...

1
How to Solve “End If Without Block If “Error in VBA

The End If without block If error is a VBA code error that occurs when the code containing any If block does not follow the syntax correctly. However, you can ...

0
Excel VBA Calculate Workbook (All/ Single/ Active Workbook)

Formulas and calculations are basic functions of Excel. Sometimes while working with formulas, they might give inaccurate results or calculations might not ...

0
Compare Two Lists in Excel for Matches (All Methods and Uses)

Comparing two lists in Excel allows you to determine variation between two sets of data. You can compare two lists in Excel for matches to identify data, find ...

0
Credit Card Payoff Calculator in Excel (Create & Use)

A credit card payoff calculator allows you to estimate the time and cost involved in paying off the debt of a credit card. Creating a credit card payoff ...

0
How to Use VBA Input Box with Buttons in Excel (2 Examples)

Input Box provides a simple way to get responses from the users. It accepts all types of data such as strings, numbers, formulas, ranges, etc. Input Box can ...

0
Create VBA MsgBox Custom Buttons in Excel (2 Examples)

VBA MsgBox in Excel can display a few standard default buttons which are labeled as OK, Cancel, Yes, No, Abort, Retry. Customizing these buttons is not an ...

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

    Follow these steps to get your desired result.

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

  5. Reply Avatar photo
    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\.

    How to Send Automatic Email from Excel to Outlook with Attachment

    • First, download the workbook provided in this article and open it.
    • 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.

    How to Send Automatic Email from Excel to Outlook with Attachment

    • 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
    How to Send Automatic Email from Excel to Outlook with Attachment

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

    How to Send Automatic Email from Excel to Outlook with Attachment

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

    How to Send Automatic Email from Excel to Outlook with Attachment

  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.
    make an eisenhower matrix in excel
    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.
    make an eisenhower matrix in excel
    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.
    make an eisenhower matrix in excel

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

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo