by Ilker | Apr 11, 2018 | Excel Tips & Tricks
Dissecting and organizing data doesn’t have to be challenging. You can quickly filter your data items with this method using a combination of formulas to determine which are unique items. Syntax =LOOKUP(2, 1/(COUNTIF(expanding unique list, original list)=0),...
by Ilker | Apr 9, 2018 | Excel Tips & Tricks
Working with Excel’s coordinate system makes building data models extremely easy. You can retrieve the column index information of a cell using the COLUMN function and implement in other formulas. Syntax =COLUMN(cell or range reference you want get its column...
by Ilker | Apr 9, 2018 | Excel Tips & Tricks
Working with Excel’s coordinate system makes building data models extremely easy. You can retrieve the row index information of a cell using the ROW function and implement in other formulas. Syntax =ROW(cell or range reference you want get its row number) Steps...
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...