How to Copy Formulas in Excel Using Absolute Cell References
When copying formulas in Excel, you’ll find that sometimes it works and sometimes it doesn’t. The key to making sure your formulas work every time is Absolute Cell References. This makes sure that your formula uses the same cell reference each time — wherever it is copied to.
Learn how to create an Absolute Cell Reference in this video with Senior Facilitator Gill — understanding how to use Absolute Cell References will allow you to confidently and efficiently expand on your Excel skills!
Giving Your Employees Freedom is the Key to Success, Says Isaac Getz
“In every aspect of our lives — in politics, in economics, in entertainment, and in family life — we demand the freedom to decide matters for ourselves. And yet when it comes to our work lives, far too many people are stifled, constrained, hemmed in, and tied down by bureaucracy and rules that have nothing to do with allowing them to do the best they can in their jobs. These constraints leave people feeling out of control of their work lives, which, in turn, leads to stress, fatigue, and disengagement from work.”
Isaac Getz is an author, senior business advisor and professor at the ESCP Business School. He is an instrumental figure in the modern corporate liberation movement and has worked with numerous companies across Europe and in Canada. Isaac will be speaking at our 2024 Happy Workplaces Conference on Wednesday 15th May.
How You Can Create a Culture of Trust in Your Workplace by Using Pre-Approval
Find out from Henry Stewart how you can create a workplace culture based on trust by using Pre-Approval.
In this 30-minute video, recorded from his live session on 10th April, Henry gives examples from Happy and from Netflix about how Pre-Approval has been used in practice. He also hears from people attending and how Pre-Approval could work in their organisation, and what the barriers are to using it.
How Michelle Hill Has Maintained TLC’s Culture Whilst Growing
“We’re a relationship charity, and we want to invest as much time in our team and their relationships at work as we do with our clients,” says Michelle Hill, CEO of TLC: Talk, Listen, Change. “We want them to have a workplace where they feel valued and where they want to do their best work. I think the more we invest in wellbeing and the team being happier, the better the results are.”
Michelle will be speaking at the 2024 Happy Workplaces Conference about maintaining your organisation’s culture whilst growing.
Building Career Resilience in the Age of AI
Remember when “artificial intelligence” was only in the realm of science fiction? We are now living in that future. AI is no longer simply conceptual; it’s woven into the fabric of our professional lives, transforming how work gets done across almost every industry.
While some may fear AI replacing jobs, the reality is far more nuanced. The key is to develop the skills to use AI effectively or else risk being displaced by those who do. Learning to properly prompt AI systems will soon become an essential competency for professionals in almost every sector.
Learn more in this blog written by Happy’s facilitator, DJ.
XLOOKUP Made Easy: Simplifying Complex Data Searches in Excel
XLOOKUP is a new feature in the latest version of Excel. It means you’ll no longer need to use either VLOOKUP or Index and Match, as it’s a much more powerful and accurate tool. It also allows you to use Wildcard characters such as * or ?, which means you can match parts of a string or account for misspellings.
In this two minute video, Gill explains how to use XLOOKUP with an example scenario.
Happy Receives Feefo Platinum Trusted Service Award 2024
Happy is proud to announce that we won the Feefo Platinum Trusted Service Award, an independent seal of excellence, which recognises businesses that consistently deliver a world-class customer experience.
Our Next Level 7 Programme for Senior Leaders Starts in September
I once asked a panel of Deans of MBA programmes why they focused so much on strategy and finance and not so much on people. The response from Roger Martin, then Dean of the Rotman School of Management, was “we do the easy stuff.”
Our
Level 7 Senior Leadership Apprenticeship programme
, the equivalent of a post-graduate degree or MBA, is different. It is focused on people and how you create trust-based organisations where people can truly fulfil their potential.
Discover Which of Happy’s Leadership Courses is Right For You
We have workshops to suit all management levels and experience – but it can be hard to know which one is right for you.
All of our programmes use the same basic principles, as outlined in our CEO’s book,
The Happy Manifesto.
We are leading a movement towards teams built on trust and self-management, as we know this allows people to do their best work. We have helped hundreds of organisations improve their staff productivity, lower costs, increase retention and dramatically increase profits.
Here is our guide to some of our leadership programmes, and when they are next running as public dates (open to all), wherever you are on your leadership journey.
