Excel Hints & Tips – Mixing Absolute + Relative mode
How do you record a macro that will copy data from a set area on your spread sheet and then paste it into the first available empty row, in an ever increasing list?
Excel Hints & Tips – Line Breaks in a Cell & Cell Formats
Sometimes you may want to add text in Excel that’s spread over multiple lines. Find out how to do this, or how to remove these, in this week’s blog by Happy trainer Ian Balboa.
Delivering Transformational Training Under Pressure
Friday was such a joy for me. It was the final day of our
TPMA Train the Trainer course
which culminates in an assessment to be accredited by the Learning and Performance Institute.
Choose Your Manager — My Radio 4 Four Thought Broadcast
“49% of the UK working population would take a pay cut to have a different manager.”
Calculations on a Filtered List in Excel
Auto filter is a wonderful thing isn’t it? With a few clicks of the mouse little dropdowns appear letting you filter your data in a myriad different ways.
In this blog, learn how to create a dropdown filter in your Excel spreadsheets.
Radio 4 Four Thought: Let People Choose Their Managers
Below is the script of the talk for Radio 4’s Four Thought, broadcast on 22nd May 2013.
Listen to it here
As I talked from prompts it won’t be exactly the same. But this is roughly what I planned to say:
Being a Best Practice Manager
I was recently facilitating day two of a Leadership and Management programme for a group of managers and one of the things that struck me was how much they had learnt and remembered from day one!
What was also impressive was just how much they had actioned back in the workplace before coming back for day two.
Excel Hints & Tips – Calculating Age
You’d think that there would be an AGE function that worked out how many years since the anniversary by passing in a date. However, life is not that easy.
Being a Best Practice Manager
I was recently facilitating day two of a Leadership and Management programme for a group of managers and one of the things that struck me was how much they had learnt and remembered from day one!
What was also impressive was just how much they had actioned back in the workplace before coming back for day two.
How Spiral Health Implemented The Happy Manifesto
Publishing the Happy Manifesto has led to a lot of organisations contacting Happy. Some call us in to help them improve their workplace and we love doing this. But there is an even bigger thrill when I get a letter from somebody we’ve not been involved with, who has taken the Manifesto and put the ideas into practice. So I’m delighted to copy the blog below, originally published on the Spiral Health site, about the work they are doing at an NHS site in Lancashire.
