Best Excel AutoComplete Suggestions Tool
Sometimes, you need to check if multiple conditions are met to decide what to do next. For example, you have list of friends and you want to know what gift you will send them. Here are the options: “If they are single and over 40, you would send them book, otherwise, you will send a …
Simply put, a condition in Excel can be either true or false. For example, 1 > 0 is a condition that is true while 1 < 0 is false. In Excel, there are many times that you need to evaluate a condition in order to decide what to do next. For example, you want to …
Sometimes, you need to extract different parts of a date to do, for example, comparison. Some people may think of doing a text to column to split parts of date. However, that would not work. Even if it was, it isn’t a good method. Luckily, there are built-in methods in Excel that help you do …
Sometimes you want count the days, months, years… between two dates. For example, you are expecting a child and you may want to know how old he/she in terms of days, months. Well, Excel has a very useful function for this task. Let’s take a look at the DATEDIF function. How does it work? The …
If you want to extract a part of text from a text string in Excel, you don’t need to look any further. With the three built in functions called LEFT, RIGHT and MID, you can extract any part of a text string you need. The LEFT function let you to extract a certain characters from …
Often time, you may copy and paste text from the web, other sources to excel. Then, you need to do comparison between strings. In Excel cells, two strings may look similar but when you do the comparison, they are not. How so? It is because you may have leading or trailing spaces. The solution would …
If you have been working with excel for a long time, you probably worked with sheets with thousands of lines. In such tables, it is essential to move quickly between cells, especially, moving to the first cell and the last cell of the table. If you don’t know how to do so, today, we are …
Every Excel users, from 1995 to 2016 knows that you can move your cursor to the bottom right of a cell and drag down to copy the formula to the cells below. However, what would you do if you have, says, thousands of rows to copy the formula to? Dragging the cursor seems to be …
Excel works wonderfully with UTF-8. However, when you need to send a list to other people, their computer may not have Excel installed. The solution would be turning the .xls or .xlsx file into a .csv file and send to your recipients. The convenience of the .csv is that all operation systems support it without …
Sometimes you have a big list containing words and number. You wonder how would you get just the words (or numbers). If you do this by hand, it would take a lot of time if your list is big (100+ items or more). The task will be come tedious if you have thousands of them. …