How To Check If Multiple Conditions Are Met In Excel
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 […]
How To Check to See Whether a Simple Condition Is Met In Excel 2007, 2010, 2013, 2016…
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 […]
How To Extract Parts of Date In Excel
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 […]
How To Count Number Of Days, Years, Months… Between Two Dates In Excel
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 […]
How To Extract Parts Of Text String
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 […]
How To Remove Leading And Trailing Space From Text String In Excel
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 […]
Excel Tip 2: How To Move To The Beginning And The End of The Data Table In Excel
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 […]
Excel Tips 1: Double Click To Copy Formula
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 […]
How to include double quotes in Excel formulas?
In Excel, string are marked with the double quote. So, in string concatenation (joining string), you will use the double quote. For example: However, how would you join two strings which one of the contain the double quote? The trick would be using three (03) double quotes instead of one: As you can see, in […]
How To Turn Excel Into CSV With UTF-8 Support
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 […]