Excel

FOLLOWING NOBODY – AN EXPERIMENT IN FINDING CALM

FOLLOWING NOBODY – AN EXPERIMENT IN FINDING CALM

This post is not ground-breaking, it may not even be helpful. I’ve nothing to sell here, I’m not a self-help/self-improvement guru…these are just some experiences I’ve had whilst trying to be more purposeful with how I live. Social media, when used without crystal clear intentions, can lead to a feeling of inadequacy, uncertainty, frustration and anxiety. This [...]

DYNAMIC CHARTS & NAMED RANGES

DYNAMIC CHARTS & NAMED RANGES

Here's a quick video showing how I create charts that shrink and expand depending on the amount of data you have, I have used this technique in the sample testing database on the free downloads page    

FREE SAMPLE TESTING DATABASE

FREE SAMPLE TESTING DATABASE

I've switched it up from GPS databases to a simple example of a testing database that might be a useful template, or maybe you'll get one or two ideas to add in to your current system! Check out the video below and click here to get your free template To see how I've created the [...]

FILTERING LARGE DATABASE FOR SIMPLE EXERCISE SELECTION

FILTERING LARGE DATABASE FOR SIMPLE EXERCISE SELECTION

This is an example of a filtering techniqe I used for a client when building an extensive strength template. There was a database with over 1000 exercises split up into different categories, this is just a sample of the function, in the actual buid there were four slicers to sub-categorize the exercises. I have found [...]

WHAT DO YOU WANT TO SEE?

WHAT DO YOU WANT TO SEE?

I'm hard to reach, this is by design. Unfortunately I no longer do custom excel builds due to time constraints. If you leave some suggestions below and if enough people have the same idea, then I'll put some free content together that will address this issue sometime in the near future.