Blog

In the early days of electronic spreadsheets when the interface was primitive and navigation was much more difficult than today, Excel had a handy command called Go To, activated by function key F5.  Go To did exactly…

Excel Tip Average Logic

Our last installment we discussed the logical-mathematical functions SUMIF and COUNTIF.  Here we continue that discussion with the functions AVERAGEIF…

Functional Logic

In the last two blog posts we discussed the logical…

 In my last post, we started looking at the banker’s Rule of Thumb that the larger the loan balances carried by a customer the more profitable is that customer.  The chart displayed in that last post, based on customer profitability management information from a mid-sized Credit Union, tended to bear this out, particularly for customers with loan balances exceeding $300k.  However, there are only…

In Part 1 and Part  2 of this blog we dispelled the banker’s old Rule of Thumb that the more financial products (accounts) owned by a customer the more profitable is that customer.  One take-away from rejecting this Rule of Thumb is that sales campaigns…

The customer profitability management system at one mid-sized credit union provided a look at the Banking Industry’s Rule of Thumb that the more financial products (accounts) owned by a customer the more profitable is that customer.  See Alta Via’s blog Banking Industry Myths, Part 1.

In the prior blog, we showed that…

Banking Industry Myths, Part 1

 Over the years practitioners in the Banking industry have developed Rules of Thumb to guide their everyday decisions.  These Rules of Thumb were based on general observations, anecdotal evidence, and high-level averaged financial…

In our last article we discussed the basic logical function IF. We are going to build on that here by introducing the AND and OR functions, which…

It is only logical to use logic in your Excel spreadsheets. In this installment, we discuss the basic logical function IF. Our next article will discuss using the functions AND and OR to build…

A co-worker called me the other day with a conundrum. The Excel VLOOKUP function was the perfect tool to solve his problem, but he had two columns to match not one column, as required…