Mistakes are painful when they happen, but years later a collection of mistakes is what is called experience.
Denis Waitley
Monthly Archives: June 2023
FILTER Function Technique
An application I use recently updated it’s filtering options to allow you to filter by any filters or all filters. This was a useful addition to the software and I thought that I could apply the same idea to Excel’s FILTER function.
It’s good to remember that there’s much to learn from negative experiences. In science, mistakes always precede discoveries.
John C. Maxwell
Benford’s Law in Excel – Part Two
Benford’s law is used in auditing to identify data sets that may have been manipulated or adjusted. In my previous post I created a report to analyse a data set based on Benford’s Law. In this post we will create a single formula to create the report and then convert that into a custom function.
When opportunity comes, it’s too late to prepare.
John Wooden
Benford’s Law in Excel – Part One
Benford’s law is used in auditing to identify data sets that may have been manipulated or adjusted. In actual data sets when reviewing values the 1st digit of the values tends to follow a predetermined frequency. For example, roughly 30% of the values should start with a 1.
If you’re willing to consider failure as a blessing in disguise and bounce back, you’ve got the potential of harnessing one of the most powerful success forces.
Joseph Sugarman
Comparing Averages in Excel
It is common in Excel to use averages to summarise large data sets. It is also common to compare the averages across different segments. Here’s a technique you might find useful when comparing a segment against all other segments.
The most common trait I have found in successful people is that they conquered the temptation to give up.
Peter Lowe