by Ilker | Apr 9, 2018 | Excel Tips & Tricks
One perfect example of automatically cleaning up data in Excel is when working with name fields. You can separate first and last names (or actually any text with spaces) using this method. Syntax =LEFT(Full name, FIND(” “, Full name) – 1) Steps Begin by...
by Ilker | Apr 6, 2018 | Excel Tips & Tricks
In need of quick money? Well, we can’t tell you how to get that, but we can show you how to use Excel to find out what you’re getting into. Use this easy method to calculate what you would be paying for that shiny new loan. Syntax =PMT(interest rate for...
by Ilker | Apr 6, 2018 | Excel Tips & Tricks
Working across several workbooks with multiple sheets can be tedious. Furthermore, file names are dynamic and can be changed by your users. Use this simple trick to organize your data and label workbook details. Syntax =CELL(“filename”, reference which is...
by Ilker | Apr 6, 2018 | Excel Tips & Tricks
You can easily count the number of characters inside a cell using the LEN function. This function can be especially useful when identifying data types or creating validation rules. Syntax =LEN(text) Steps Begin by typing in =LEN( Select or type in the range reference...
by Ilker | Apr 5, 2018 | Excel Tips & Tricks
Excel’s Search and Find feature is very helpful when looking up things in workbooks, but this means searching for keywords one by one. SEARCH and FIND are formula versions of this very handy feature and can work wonders in large data sets. Syntax...
by Ilker | Apr 5, 2018 | Excel Tips & Tricks
Working with dates in Excel can be a bit challenging at times, because Excel doesn’t use dates as we conceive it. Knowing how Excel handles dates, you will find it pretty easy to use them in calculations and reports. Syntax =date + days Steps Select or type in...
by Ilker | Apr 5, 2018 | Excel Tips & Tricks
Identifying the detail level of values in a data set can be useful for analysis of results. This simple trick can help you separate the decimal values from the numbers for evaluation. Syntax =number – TRUNC(number) (only for positive numbers) =number –...
by Ilker | Apr 5, 2018 | Excel Tips & Tricks
Do you need to shorten number, but not round them? Need to find the nearest INTeger or TRUNCate numbers in Excel? Yep, Excel has two functions that do exactly that! You can shorten numbers using the TRUNC and INT functions while preserving the original value, without...
by Ilker | Apr 4, 2018 | Excel Tips & Tricks
Sure, it’s easy to find the highest or smallest values in a data set. But what if you’re looking for the 3rd, 10th, 20th rank in a large table, or need to do this in ascending and descending order? Luckily, Excel features a formula that does just that....
