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 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 Adam | Jun 29, 2017 | Blog
You can create all sorts of mathematical models in Excel, but imagine a model with thousands of formulas, all of which need to be calculated every time you enter a value. This would make calculations very slow and the user experience, not a pleasant one. Thanks to its...
by Adam | Jun 20, 2017 | Blog
INDIRECT is a versatile function in Excel’s already huge repertoire of referencing tools. In this guide we’re going to take a look at its various use cases. This function can return the reference specified by a text string, foolproof your Excel models, or even...
by Adam | Jun 12, 2017 | Blog
Were you just handed a massive spreadsheet and you have no idea how it’s structured, or what it does? Are you tired of following the root cause of errors in your formulas? If you answered yes to any of these questions, or simply would like to audit the formulas in an...