excel

How to avoid this common Excel disaster…

By Bernie | September 11, 2018

On 4 January 2010, in the Marriott hotel in Atlanta, two giants in the world of economics, Prof Carmen Reinhart and former chief economist of the International Monetary Fund, Ken Rogoff, were presenting their research paper, ‘Growth in a Time of Debt’. Their message from their research turned the heads of global leaders and pushed…

took kit

Managing KPIs with Excel?

By Bernie | March 13, 2014

Are you managing KPIs with Excel? I often hear that Excel is not capable of managing KPIs but in reality that is rare. Consider this, your PC, laptop or tablet has more than a million times the computing power of the Apollo moon missions. Excel is an extraordinarily powerful, flexible and widely used application. So…

9 Things you should never do in Excel

By Bernie | January 24, 2012

Excel rules the roost when it comes to real-world management information. It’s easy to knock it, but millions of people find it quick and painless to use. There are some things you just should not do in Excel. Here’s my highly subjective list. Never….   Use Excel as a database. OK, I know you are…

BlinkCharts, what they are and why you need them

By Bernie | July 22, 2011

A bog standard Excel chart/graph Most people just use the default graphs on Excel, perhaps with a colour change or two. Who says that Microsoft knows how much detail to put on your graphs? The default graphs (or charts, if you speak Microsoft English) are jam-packed with clutter. Why should you care? Every piece of…