Skip to content

Excel AutoComplete Suggestions From Lists by Oheen

Best Excel AutoComplete Suggestions Tool

X
  • Contact
Menu

Tag: excel tips

How To Check If Multiple Conditions Are Met In Excel

How To Check If Multiple Conditions Are Met In Excel

Posted on January 5, 2018May 15, 2019 by exceladmin

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 …

Continue Reading →

Posted in Excel tipsTagged and function, excel tipsLeave a Comment on How To Check If Multiple Conditions Are Met In Excel
How To Check to See Whether a Simple Condition Is Met In Excel 2007, 2010, 2013, 2016…

How To Check to See Whether a Simple Condition Is Met In Excel 2007, 2010, 2013, 2016…

Posted on January 5, 2018May 15, 2019 by exceladmin

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  …

Continue Reading →

Posted in Excel tipsTagged excel condition, excel tips, if functionLeave a Comment on How To Check to See Whether a Simple Condition Is Met In Excel 2007, 2010, 2013, 2016…
How To Extract Parts of Date In Excel

How To Extract Parts of Date In Excel

Posted on December 30, 2017May 15, 2019 by exceladmin

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 …

Continue Reading →

Posted in Excel tipsTagged excel tipsLeave a Comment on How To Extract Parts of Date In Excel
How To Count Number Of Days, Years, Months… Between Two Dates In Excel

How To Count Number Of Days, Years, Months… Between Two Dates In Excel

Posted on December 30, 2017May 15, 2019 by exceladmin

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 …

Continue Reading →

Posted in Excel tipsTagged calculate datediff, excel tipsLeave a Comment on How To Count Number Of Days, Years, Months… Between Two Dates In Excel
How To Extract Parts Of Text String

How To Extract Parts Of Text String

Posted on December 18, 2017May 15, 2019 by exceladmin

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 …

Continue Reading →

Posted in Excel tipsTagged excel functions, excel tipsLeave a Comment on How To Extract Parts Of Text String
How To Remove Leading And Trailing Space From Text String In Excel

How To Remove Leading And Trailing Space From Text String In Excel

Posted on December 18, 2017May 15, 2019 by exceladmin

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 …

Continue Reading →

Posted in Excel tipsTagged excel functions, excel tipsLeave a Comment on How To Remove Leading And Trailing Space From Text String In Excel
Excel Tip 2: How To Move To The Beginning And The End of The Data Table In Excel

Excel Tip 2: How To Move To The Beginning And The End of The Data Table In Excel

Posted on November 18, 2017May 15, 2019 by exceladmin

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 …

Continue Reading →

Posted in Excel tipsTagged excel tipsLeave a Comment on Excel Tip 2: How To Move To The Beginning And The End of The Data Table In Excel
Excel Tips 1: Double Click To Copy Formula

Excel Tips 1: Double Click To Copy Formula

Posted on November 18, 2017May 15, 2019 by exceladmin

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 …

Continue Reading →

Posted in Excel tipsTagged copy formula, excel tipsLeave a Comment on Excel Tips 1: Double Click To Copy Formula
How To Turn Excel Into CSV With UTF-8 Support

How To Turn Excel Into CSV With UTF-8 Support

Posted on November 10, 2017May 15, 2019 by exceladmin

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 …

Continue Reading →

Posted in Excel tipsTagged csv export, excel csv, excel tipsLeave a Comment on How To Turn Excel Into CSV With UTF-8 Support
How To Filter Numbers Out Of A List Using Excel (Working With 2003, 2007, 2010, 2013, 2016)

How To Filter Numbers Out Of A List Using Excel (Working With 2003, 2007, 2010, 2013, 2016)

Posted on November 10, 2017May 15, 2019 by exceladmin

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. …

Continue Reading →

Posted in Excel tipsTagged excel filter nubmer, excel tipsLeave a Comment on How To Filter Numbers Out Of A List Using Excel (Working With 2003, 2007, 2010, 2013, 2016)

Contact Support

If you need support, please click below

Recent Posts

  • How To Check If Multiple Conditions Are Met In Excel
  • How To Check to See Whether a Simple Condition Is Met In Excel 2007, 2010, 2013, 2016…
  • How To Extract Parts of Date In Excel
  • How To Count Number Of Days, Years, Months… Between Two Dates In Excel
  • How To Extract Parts Of Text String
  • How To Remove Leading And Trailing Space From Text String In Excel
  • Excel Tip 2: How To Move To The Beginning And The End of The Data Table In Excel
  • Excel Tips 1: Double Click To Copy Formula
  • How to include double quotes in Excel formulas?
  • How To Turn Excel Into CSV With UTF-8 Support
Theme Design & Developed By OpenSumo
  • Contact
  • Excel Autocomplete From List