Although the VLOOKUP versus INDEX/MATCH debate gets most of the attention there are MANY more topics to debate in Excel. When calculating student grades what method is best: NESTED IF or LOOKUP/BINNING TABLE? (more…)
We have a bunch of names in a column. We need to create a unique and alphabetically sorted list. BE CAREFUL! Before we jump into a solution we should ask a couple of key questions. Does the solution need to be dynamic? Do we need to teach the solution to our co-worker or client? (more…)
After we get comfortable with something we create habits and then we often go into auto pilot mode. The danger is that we can fail to see things that are right in front of us! (more…)
We all have down time while we wait in line or while we commute. How do you use this time? In the past two years I’ve used part of my down time to learn Excel by reading tweets.