Category Archives: Excel

Speed Loop 2: Appreciate Assets

This is the second post in the Speed Loop series, where I’m sharing the process that helped me dramatically improve efficiency. In the first post, we covered the Invest Time stage. We identified our recurring-project workbooks. We inserted our lead sheets. We are now ready to move on to the second stage: Appreciate Assets. Let’s […]



How are you coping with this?

When I started this blog 7 years ago, my plan was to write about Excel ONLY. No other topics. Ever. But in all honesty, I’m a little preoccupied with COVID-19. So, I want to take one post to share how I’m coping with it and ask how you are coping with it. I hope that […]


XLOOKUP Webinar

XLOOKUP is the next-gen lookup function designed to address the limitations of VLOOKUP and related workarounds. It combines the capabilities of numerous functions including VLOOKUP, INDEX, MATCH, HLOOKUP, and IFERROR. Many have asked me to teach this via webinar. So, I created this short webinar that covers the basics 🙂 This on-demand webinar is about […]


Count Between Dates

Let’s say you measure something with a duration that can span multiple days. For example, a hotel guest can check in for multiple days, a patient can be in a hospital for multiple days, a widget can be in a specific manufacturing stage for multiple days, a book can be checked out for multiple days, […]