How to import data from text file(.txt) to an Excel sheet?

It's really tedious to copy and paste from the text file to excel worksheet. Microsoft Office Excel provides a feature to import data from text file into your excel worksheet as an external data range.

Tip: WORKDAY function in Microsoft Office Excel

WORKDAY function can be used to calculate end or start date of specific project. Why WORKDAY function can be helpful is because weekend and holidays can not be included in number of business/working days. Specific holidays can also be omitted.