Tutorials

in Tutorials

Excel VBA

I’ve never been a big VBA coder in Excel, but I’ve always wanted to be a big VBA coder in Excel. It would certainly save me a lot of time, but, well, yeah, I just haven’t learned. Until now! Over…

Continue reading
in Tutorials

Hexagon Tile Map in Excel

This is a guest post from David Napoli, a BI & Analytics Director (and recovering rocket scientist) who has worked as lead actuary, statistician, and headed up analytics departments for several healthcare organizations over the last 20 years. In a…

Continue reading
in Tutorials

Marimekko Chart in Excel

Marimekko charts encode two variables: one along the height of the vertical axis and another using the width of the bars or columns. This one from The Economist, for example, has GDP per capita ($) on the vertical axis and…

Continue reading
Close