Using Absolute Cell References in Excel
Absolute Cell References are one of those jargon words we hear used about Excel formulas all the time.
Jonny worked at Happy for over 11 years, starting as Operations Manager and working his way up to Business Stream Manager.
Absolute Cell References are one of those jargon words we hear used about Excel formulas all the time.
Kensington Youth Services was part of Kensington and Chelsea Council until April 2014. They changed their name to Epic CIC on becoming independent. To break free from the Council and establish themselves as an independent social enterprise, they needed to radically change their organisation's culture. Under the leadership of Brendan O'Keefe, they needed to create an innovative company that would thrive in a competitive market wile still reflecting public sector values. Happy has supported Epic CIC throughout this transformation through leadership programmes and workshops.
Happy helped Alastair Wilson, the School for Social Entrepreneurs's CEO, to restructure his organisation to keep pace with growth. Happy facilitated three sessions for Alastair and the team, enabling them to plan their restructure, bring out and discuss any tricky issues, and move forward.
Happy hosted a two-day leadership programme for TPT Retirement Solutions. We helped managers to delegate successfully and create a culture of job ownership, regular 1-to-1s with staff and more. After working with Happy and implementing the ideas from the course, TPT Retirement Solutions were awarded the Investors in People Gold Award.
Happy ran a fortnightly workshop for all Abel & Cole’s managers, covering HR basics, recruitment, giving feedback, running effective meetings, and motivating teams, followed by individual 1-to-1 management coaching. Since then, we have an ongoing relationship and run regular leadership programmes and 1-to-1 coaching sessions.
Positive East were looking to empower all of their staff to successfully deliver a significant proportion of their services through their volunteers. Additionally we took the opportunity to help them review and reflect on what in their culture was working and what needed to change for Positive East to become a truly great place to work.
Are you finding it difficult to keep your cool in difficult situations? Would you like to be able face pressure at work or at home without feeling overwhelmed, no matter what life throws at you? If the answer is yes, our one-day Emotional Intelligence workshop may be the solution.
Are you new to leadership role? Have you have been an executive, leader or manager for a long time?
Fantastic to see our book The Happy Manifesto, written by our CEO Henry Stewart, on the front cover of The Evening Standard.
In this blog, Jonny explains how to use the LARGE Function to extract the top values in a row and even add them up.