Ed Lepre

Ed is a Microsoft Certified Trainer (MCT) and has worked at Happy for over 12 years. Although he trains the full suite of MS Office and non-Office packages at all levels, his favourite package is Excel. A previous winner of the prestigious Learning and Performance Institute’s ‘Learning Professional of the Year’ award, as well as other training accolades, he is also the IT Helpline Manager.

How to Make a Dynamic Data Validation Drop-Down List in Excel

Are you fed up with having to continually add new data to your data validation drop-down lists? Are you also...

Ed Lepre

28 Mar 2022

6 New Features in Excel 2019 That You May Not Know About

The latest update to Excel 2019 includes six new functions: CONCAT, TEXTJOIN, MINIFS And MAXIFS, IFS, SWITCH and XLOOKUP. In...

Ed Lepre

21 Aug 2021

6 More Shortcuts in Excel That Will Speed Up Your Work

As well as helping you to work more efficiently, keyboard shortcuts can be easier than using a mouse or touchscreen,...

Ed Lepre

28 Jun 2021

How to use Outline View in PowerPoint

With Outline view in Microsoft Word and PowerPoint, you can quickly and easily create a short summary of the content...

Ed Lepre

09 Jun 2021

How To Collaborate While Working Remotely With Microsoft Teams

With the majority of the workforce now moving to working entirely from home, people are adjusting to new ways of...

Ed Lepre

30 Mar 2020

Why You Should Use INDEX & MATCH Instead of VLOOKUP

Why is INDEX & MATCH so much better than VLOOKUP?...

Ed Lepre

09 Apr 2018

Work Smarter with Google Groups Using Our Guide

Google Groups makes it easy for groups of people to keep in touch with friends, connect with people who have...

Ed Lepre

16 Jan 2018

How to Use the Data Consolidation Feature in Excel

Do you need to view and compare lots of data in a single spreadsheet? There is a quick and easy...

Ed Lepre

05 Dec 2017

Using COUNTIF for Better Data Analysis and Validation

COUNTIF is a powerful tool that can help you to make sense of large sets of data, pulling out the...

Ed Lepre

09 Oct 2017

Stay inspired with Happy

Join 20,000+ professionals receiving workplace tips, leadership insights, and exclusive offers.

Since 1985, Happy has been providing great solutions to help people thrive at work. Be the first to hear about free resources, events, and training opportunities that make work more joyful and productive.

Get in touch

Find us

3rd Floor
Robert Dolan House, 9 Alie Street
London E1 8DE
United Kingdom

Direction On Google Map

Social

Linkedin Youtube Facebook-f Instagram

Copyright © 2025 Happy. All rights reserved Registered Company 02198980

Workplace Consultancy

Leadership & Management

Leadership & Management Programmes

Project Management Programmes

Private & Tailored Group Courses

Leadership Conference

1-to-1 Workshop

Personal Development

Personal Development

Train the Trainer Programmes

Coaching Hub For Leaders

Executive Coaching and Assessments

Conference

Happy Workplaces Conference 2025

Save the date for next year's conference on Thursday 12th June 2025,

Learn More

IT Training

Microsoft Excel

Microsoft Teams

Other Microsoft Applications

Google Workspace

Adobe Creative Suite

View all training

Other Applications

Canva

Slack

Chat GPT

Chat GPT and AI

Project Management Tools

View all other apps

Solutions

Software Rollouts

Digital Workshops

Private and Tailored Group Courses

1-to-1 Coaching

IT Video Library

Featured Courses

Microsoft Excel Courses

Build your Excel skills from beginner to expert. Perfect for mastering data analysis and visualization.

Learn More

Learn

About Happy

Happy Manifesto

Careers

Case Studies

Resources

Resources

Blogs

Press

The Happy Manifesto

Outline the 10 core principles for a happy workplace. It has since helped thousands of leaders build trust-driven, empowered teams.

Download Your free Copy
Apprenticeships
Room Hire