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.
Are you fed up with having to continually add new data to your data validation drop-down lists? Are you also fed up with having to modify the source data to extend the list manually each time new data has been entered? In this blog, Edmund, one of our Office experts, will show you how to make dynamic data validation drop-down lists and extend the lists automatically when new data is entered.
The latest update to Excel 2019 includes six new functions: CONCAT, TEXTJOIN, MINIFS And MAXIFS, IFS, SWITCH and XLOOKUP. In this blog, Edmund, one of our Office experts, explains what you need to know about them.
As well as helping you to work more efficiently, keyboard shortcuts can be easier than using a mouse or touchscreen, especially to those who have mobility or vision disabilities. And what would you do if your mouse stopped working? In this week's blog, Edmund will introduce you to six keyboard shortcuts that you may not know about in Excel for both Windows and Mac.
With Outline view in Microsoft Word and PowerPoint, you can quickly and easily create a short summary of the content of your document — without the need to type it out again. In this blog, Edmund explains the benefits of Outline view and how to do it.
With the majority of the workforce now moving to working entirely from home, people are adjusting to new ways of working together without being able to just turn to a colleague and ask something. Microsoft Teams offers many benefits for remote work environments, allowing teams to continue to collaborate and communicate. In this blog, Ed explores our favourite three features of Teams that will change the way you work in Office 365 forever.
Why is INDEX & MATCH so much better than VLOOKUP?
What is Google Groups? Google Groups makes it easy for groups of people to keep in touch with friends, connect with people who have similar interests, and organise projects and presentations such as project teams, departments, or teamwork to communicate and collaborate easily.
Do you need to view and compare lots of data in a single spreadsheet? In this blog, one of our Excel experts shares how to use the Data Consolidation tool.
COUNTIF is a powerful tool that can help you to make sense of large sets of data, pulling out the information you need quickly and easily. Find out how to use COUNTIF in this blog by Happy’s IT HelpLine Manager, Ed Lepre.