Claire is Head of Marketing at Happy. She has worked at Happy since 2016, and is responsible for Happy's marketing strategy, website, social media and more. Claire first heard about Happy in 2012 when she attended a mix of IT and personal development courses. These courses were life-changing and she has been a fan of Happy ever since. She has a personal blog at lecari.co.uk.
Usually we refer to cells in Excel by their range names, such as A1. This can make deciphering formulas difficult, especially when working with spreadsheets that other people have created. In this 2 minute video, Nicky explains how to create Range Names to make your formulas more meaningful.
Many of us are familiar with copy and paste (Ctrl + C and Ctrl + V). But how many other keyboard shortcuts do you know? In this week's blog, Fenella explains five Excel shortcuts that you never knew were there, such as the shortcut for the Autosum function and moving around sheets — and which will save you time when working.
Did you know that there is a shortcut for the Autosum formula in Excel? In this short video, Nicky shows you how to use this great timesaver, both for simple and more complex spreadsheets. You can even use Autosum on the whole table at once!
Join us for an inspirational look at female leadership and discover more about our one year transformational programme. Our unique blended package of events is all about uncovering, celebrating, and nurturing your power as a female leader. In this taster session we will be exploring what assertive leadership looks like and what this means from a woman's perspective. There is no charge for this 60-minute online workshop on 23rd January, delivered face-to-face online via Zoom. All welcome, with no obligation and no hard sales pitch.
Happy's January competition is back with another set of fantastic prizes. For a chance to win, tell us what challenge you overcame in 2020 and how you met it — or how you will meet it in 2021, if you didn't in 2020. Our top prize includes a free place on any of our one or two day courses, the Happy Planner / Learning Journal, one year's access to our Happy Video Library, and more! Closing date: midnight GMT on 31st January 2021. Winner will be announced on 3rd February 2021.
How often do you struggle to find an email that you need in Outlook? In this short 2 minute video, Nicky explains how you can use the search tools in Outlook to speed up finding emails in your inbox. These handy tools search all folders, and allow you to enter in as much information as you remember about the message.
Pivot Tables are a fantastic way to make sense of complex tables of data. In this two-minute video, Nicky explains how your Pivot Tables can show group your data by Month and Year with just a few clicks.
Quick Analysis is one of the features introduced in Excel 2013. It allows you to visually spot trends and information in your spreadsheets, with just a few clicks. This is a really simple trick that even those of you brand new to Excel will be able to use. In this video, Nicky will show you how to use Quick Analysis and some of the Formatting tools - and how to clear it if you don't want to see the information anymore.
Master Slides enable you to update all of your PowerPoint slides in a presentation at once. This ensures that all of your slides have the same formatting, making your presentation look more professional and consistent. In this short video, Nicky explains how to update your Master Slides, including the background, font and text size.
Did you know that there is a shortcut for the Autosum formula in Excel? In this short video, Nicky shows you how to use this great timesaver, both for simple and more complex spreadsheets. You can even use Autosum on the whole table at once!