Monthly Archive:: October 2015
Conditional Formatting is used to highlight cells with certain value that meet the condition set. There are several condition rules that you can use to format your worksheet like highlight cells rules, Top/Bottom Rules, etc. For example, when making class …
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 meeting the criteria will be …
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 sorted alphabetically, by hire date, by …
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 look for value at the …
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 a text date format. Here …
