Here you can find all of Happy’s blog posts, covering our Excel hints and tips, ideas for creating happy workplaces, and ways to be more productive at work — and more.
George Osborne was today reported as stating that government procurement from SMEs (small or medium sized enterprises) will rise five-fold. It is a great aspiration. It would result in big cost savings and better service if government was prepared to look beyond the likes of G4S, Capita and Serco. But the chances of this government actually delivering on this promise? Absolute zero.
Today, Wednesday 20th March, is the first UN International Day of Happiness. Take the pledge to bring more happiness to others at the World Happiness Day web-site, add your Happy Heroes and see what events you can attend on the day.
The only class I ever got thrown out of at school was art. The teacher and I both knew I was no artist. Although I make my own Christmas cards and enjoy photography, I have always firmly believed that I can’t draw and I’m not creative.
In this blog, Jonny explains how to use the LARGE Function to extract the top values in a row and even add them up.
How do I set my spread-sheet to automatically extract this month’s figure from the accounts?
Learn how to get your Pivot Table to put your filtered data on different sheets in Microsoft Excel with this blog.
Learn how to create simple Timeline filters that provide a slider type interactive filter.
What on earth has Florence Nightingale got to do with Excel? Florence Nightingale famously created a polar area diagram (a type of pie chart) in 1858 to show the cause of death in British military hospitals in the Crimean War. This highlighted the extent of preventable deaths (such as from typhus and cholera). The result was that the British government took action and commissioned Isambard Kingdom Brunel to design a new civilian hospital – reducing the death rate to just 1/10th of what it was before. This important use of data visualisation shows how powerful charts (and especially pie charts) can be.
Choosing your own manager is becoming more popular, allowing staff to choose a manager who really motivates them. Find out more in Henry's blog.
A big thanks to Marion Janner of Star Wards, @starwards, for alerting me to this fabulous approach to an annual report. And its not from a cutting edge startup, but from the public sector, the good old NHS: The annual report for Whittington Hospital Trust for 2004.