Efren Nolasco

Efren Nolasco is a former OFW in Abu Dhabi, a web geek and founder of this website. He also manages Guides & Tips for Beginners and co-founder of trending news website boklit.com

Filtering

Filtering is used to make easier to focus on specific information on the large table of data. The records that will be displayed when filtered is the one who meets a certain criteria. The data that aren’t … Read more

Sorting

Having a lot of data in your worksheet needs to be organized to make it easy to understand if someone reads it. Like making lists of employees, it is cleaner and more readable if it is … Read more

Lookup Functions

Lookup functions in Excel are divided into two, VLookup (Vertical Lookup) function which look for the value in the leftmost column of the range of cells you specify in table-array and the HLookup (Horizontal Lookup) function … Read more

Text Functions

If you want to convert numbers to text or simple text manipulation  in your worksheet, Excel has many text functions that you can use. Like for example, you can easily convert a date in number into … Read more

Date and Time Functions

Date and time are very important in Excel project, like in making a timesheet, you need to get the elapsed time to compute the total number of regular hours and overtime. In this lesson you … Read more