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.
How to make a Random Number Generator in Excel
Tag: Excel
How to Print a Clean Report in Excel by clicking one Check Box
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.
Spreadsheet to Adjust for Inflation
If you like data like I do, you can’t ignore inflation. I have spreadsheets with decades of financial data. When you adjust those numbers for inflation, it can be very insightful. In this post, I share with you my Inflation Adjuster spreadsheet.
How to fix the rounding problem with monthly budgets
Accountants and bookkeepers are usually bugged by the littlest things. I know a number of people that will spend hours looking for pennies when reconciling their bank statement. Along those lines, one of the things that bugs me is when you have are creating monthly budgets, and the rounding causes you to be off by pennies. For the longest time I would manually correct this when I had time. Now I have a better soluntion.
Excel: How to calculate the Last Day of any Month
I remember early on in my training as an accountant I had to learn the number of days in each month. We did this to save time so we didn’t have to stop and look at a calendar whenever there is a transaction that’s posted to the last day of a month. I’m not sure how long this has been around, but Excel has a function that will just give you the last day of any month. In this post, I show you it.
Cheap good accounting program for Churches – PcMars
Some months ago I saw posted on a message board that some churches were using an accounting software made for farmers. Farm accounting program that works for churches? Really? Only $75/year? This sounds way too good to be true. In this post I give my review.
Excel: How to Freeze Columns and Rows
I love working in Excel, but not everyone does. One of the things that can make it a little easier to work with large Excel files is if you know how to frees columns and rows. In this post and the related video, I’ll show you how.