Implementing Modular Spreadsheet Development – a walkthrough
This article is written by Michael Hutchens from Best Practice Modelling.
In the first article on Modular Spreadsheet Development, we got a high level overview of Modular Spreadsheet Development principles. This article discusses the practical implementation of these principles in Excel.
From my experience using Modular Spreadsheet Development over the past decade, there are three increasingly-efficient methods of implementation in Microsoft Excel:
1. Manual implementation;
2. VBA automated implementation; and
3. Commercial add-in implementation.
This article provides a comprehensive overview of each of these methods and a summary of their advantages and disadvantages.
Modular Spreadsheet Development – A Thought Revolution
This article is written by Michael Hutchens from Best Practice Modelling.
This article provides a high level overview of Modular Spreadsheet Development principles. In next part the implementation of these concepts will be discussed.
Modular Spreadsheet Development – An awesome concept
I want to share a concept with you so awesome that once you understand it you may never use Excel the same way again.
This concept, called Modular Spreadsheet Development, makes it possible to build spreadsheets exponentially faster while reducing the risk of errors and making spreadsheets much easier to understand.
This concept is not completely new, but I’m writing this article because the spreadsheet modelling world would be a much better place if it was more commonly adopted.
Robust Dynamic (Cascading) Dropdowns Without VBA
Recently I posted about how you could construct dynamic (cascading) dropdowns that could easily handle multiple levels, like this: …and we saw that users could subsequently change upstream dropdowns in a way that would make downstream choices invalid, like this: In my previous post I used some VBA to clear out any ‘downstream’ choices if […]
Dynamic (Cascading) Dropdowns that reset on change
Dynamic dropdowns are a handy way to get your users to make choices based on what they’ve previously chosen, while steering them away from making invalid choices. Today we’re going to look at one that easily handles multiple levels, and we’ll take a look at what could go wrong. Let’s see one in action, shall […]
Combine pie and xy scatter charts – World Polls chart revisited
Few days ago, we learned how to create a pie+donut combination chart to visualize polls around the world in 2014. It generated quite a bit of interesting discussion (47 comments so far). One of the comments was from Roberto, who along with Kris & Gábor runs The FrankensTeam an online library of advanced Excel tricks, charts and other mind-boggling spreadsheet wizardry.
I really liked Roberto’s comments on the original post and a charting solution he presented. So I asked him if he can do a guest post explaining the technique to our audience. He obliged and here we go.
Over to FrankensTeam.
Did Jeff just chart?
How do you segment customers by revenue easily in Excel, so that you can see which customer groups to focus on. Find out, and download this handy template.
In this charting example, Jeff, our guest author, occasional charter and Excel wizard shows us how to segment customers based on revenue and depict the result using Excel charts.
Creating Triangular Plots using Excel
Triangular plot…! What is it?
Recently, a Chandoo.org forum member asked this,
‘I want to be able to make a graph that, in some aspects, looks like below, but I have no idea how to do it at all.’
After seeing it, I said to myself in Barney Stinson’s tone, ‘Challenge Accepted!‘
The final plot looks like above. Read on to learn how this is made.