In Excel, it’s pretty common to add numbers based on multiple criteria (SUMIFS). In the past, I’ve always had to work with criteria that are in row OR columns. What about if my criteria are in rows AND columns? Will SUMIFS still work? The answer is No, but I found a workaround.
I’ve been using Planning Center for about two years now. This is a fantastic service for churches and ministries to connect with people and allow electronic giving. There is a monthly fee, but the cost per transaction is about as cheap as you are going to find anywhere…as long as you give through a bank account instead of through a credit card.
Just a quick post for today. I saw someone with two monitors dragging a window from one screen to the other, and I thought “I remember when I used to do that. Should I tell them the secret way to move windows?”
In this post, I give two tips on how to better manage multiple windows and multiple monitors.
If you enjoy Jeopardy or want to reinforce learning, creating your own Jeopardy game is a great way to go. My family has been using Jeopardy Labs for year. Let me show you how.
Back when I first became an auditor, I learned that there are times when you need a truly random number…no human bias. In this post, I share with you exactly how to do this.
It has been a long time since I posted anything, but I’m back in the saddle. Here is the biggest QuickBooks thing I’ve learned over the last 8 months: QuickBooks has a built-in calculator!
Whenever I presented reports, I would warn people about the colors. I’m color blind so I usually pick very contrasting colors.
I always thought of the colors as a help…because they help me. They can also be a distraction or even a nuisance if you are printing in black and white. I recently found a solution for keeping my colors but printing a clean report for the recipients.