Happy Open Day 2017

Wednesday 29th November 2017 | Happy, Alie Street, London
View SessionsBook Your Sessions

We are delighted to invite you to our 2017 Happy Open Day.

On 29th November, Happy is hosting a series of free one-hour workshops throughout the day from our Happy People, Happy Computers and eLearning programmes to give you a taster of what we offer.

Last few places available – RSVP now to avoid disappointment

All workshops are ticketed so please make sure you RSVP in advance – our Happy Computers sessions are restricted to up to 8 people and our Happy People and eLearning sessions are restricted to up to 12 people. We’re expecting a lot of demand so make sure you book early to avoid disappointment!

Please note: all Happy Computers sessions will be run in Office 2016 but (aside from Office 365) the features are available in 2010 and 2013 in much the same way so it will be suitable for most users.

If you have any questions, please email Simone or John, or call the team on 0207 375 7300.

Take a look at what’s on offer in each session below – and don’t forget to RSVP!

Introducing Live Online Interactive Learning

This session will introduce the concept of Happy’s Live Online Interactive Learning courses. Darren will be on hand to answer any questions you may have as well as demonstrating the key features of our software and the techniques used during the training. These courses are designed to ensure Happy’s high standards of learner involvement are transferred from the physical classroom to the virtual.

Discover how Live Online Learning can offer learner-focused, flexible and cost-effective training for your teams.

New Functions in Excel 2016

This more advanced Excel session is designed for anyone who uses Excel for managing budgets, timesheets, reports and other data that requires more advanced formulae and calculations. You will learn the new Excel 2016 functions and you will be able to such as IFS or SWITCH, IFERROR, the new CONCAT and TEXTJOIN, MINIFS and MAXIFS function to speed up calculations.

We will cover:

  • Using the new Excel 2016 functions
  • Using IFS or SWITCH functions to replace a nested IF statement
  • Using IFERROR to create a neater IF with error trapping
  • Understand the differences between the new CONCAT and TEXTJOIN functions and the old CONCATENATE
  • Using MINIFS and MAXIFS to avoid the need for an array function and therefore speed up calculations

Using Styles for Professional Formatting in Word

In this session you will learn the importance of Styles in creating consistent and professional formatting in Word. You will also find out the benefits and features they can open up to you. This session is for users who already confidently create and format documents in Word. We will cover:

  • Using pre-set Styles and themes
  • Editing Styles or creating your own to match your own branding or house style
  • Modifying Styles when you change your mind
  • Creating a Table of Contents based on Styles
  • Navigating and rearranging your content using Styles

Excel 2016 V/H Lookup and Index & Match

This session is for anyone who has been using Excel for budgets or other data that needs calculations and would like to learn more features to improve their ability to organise and analyse data. You will learn the new how to cross reference data using an HLOOKUP or VLOOKUP function. For example, how to look up a National Insurance Number to find other personal details from another sheet or book. We will also cover how to cross reference information from specific rows and columns in a table using INDEX and MATCH. Learners must have used Excel before to create calculations that include absolute cell references (e.g. $B$4) and IF statements. We recommend this for advanced learners who have been on our Excel Core Level 3 course. Topics Covered:

  • Use the V and HLOOKUP functions to reference data that exists on a different worksheet
  • Understand when the IFNA function is needed and use it to trap errors
  • Nesting functions (VLOOKUP, HLOOKUP, INDEX, MATCH, INDIRECT)

Creating a Recruitment Process that Works

Much of common recruitment practice seems almost designed to hire the wrong people.

Instead of asking people lots of questions, this session will explore ways to:

  • Hire for attitude (train for sill)
  • Get people to do the job, (or as close to it as possible) in the interview
  • Hire collaboratively, involving your people.

Introducing Live Online Interactive Learning

This session will introduce the concept of Happy’s Live Online Interactive Learning courses. Darren will be on hand to answer any questions you may have as well as demonstrating the key features of our software and the techniques used during the training. These courses are designed to ensure Happy’s high standards of learner involvement are transferred from the physical classroom to the virtual.

Discover how Live Online Learning can offer learner-focused, flexible and cost-effective training for your teams.

eLearning: From Formal to Informal Learning

Formal eLearning is usually twinned to a Learning Management System (LMS) with a formally structured course and curricula, and developing these programmes is a long and complex process. Informal eLearning is much more flexible, without the restrictions of an LMS, and allows learners to study at their own pace or ‘on the go’.

In this one hour session, Lucy Blake, Head of eLearning at Happy, will discuss the shift towards informal eLearning programmes and the benefits to your business.

New Charts in Excel 2016

in Excel 2016, there are 17 categories of chart type – with a myriad of variations on each category! In this one-hour session, you will discover how to create some of these new chart types and will explore when it is appropriate to use them to communicate your message. Learners should already be confident creating and using charts in Excel.

Charts covered will include:

  • Map
  • Treemap
  • Sunburst
  • Box and Whisker
  • Waterfall

Using Styles for Professional Formatting in Word

In this session you will learn the importance of Styles in creating consistent and professional formatting in Word. You will also find out the benefits and features they can open up to you. This session is for users who already confidently create and format documents in Word.

We will cover:

  • Using pre-set Styles and themes
  • Editing Styles or creating your own to match your own branding or house style
  • Modifying Styles when you change your mind
  • Creating a Table of Contents based on Styles
  • Navigating and rearranging your content using Styles

Excel 2016 V/H Lookup and Index & Match

This session is for anyone who has been using Excel for budgets or other data that needs calculations and would like to learn more features to improve their ability to organise and analyse data. You will learn the new how to cross reference data using an HLOOKUP or VLOOKUP function. For example, how to look up a National Insurance Number to find other personal details from another sheet or book. We will also cover how to cross reference information from specific rows and columns in a table using INDEX and MATCH.

Learners must have used Excel before to create calculations that include absolute cell references (e.g. $B$4) and IF statements. We recommend this for advanced learners who have been on our Excel Core Level 3 course.

Topics Covered:

  • Use the V and HLOOKUP functions to reference data that exists on a different worksheet
  • Understand when the IFNA function is needed and use it to trap errors
  • Nesting functions (VLOOKUP, HLOOKUP, INDEX, MATCH, INDIRECT)

eLearning: From Formal to Informal

Formal eLearning is usually twinned to a Learning Management System (LMS) with a formally structured course and curricula, and developing these programmes is a long and complex process. Informal eLearning is much more flexible, without the restrictions of an LMS, and allows learners to study at their own pace or ‘on the go’.

In this one-hour session, Lucy Blake, Head of eLearning at Happy, will discuss the shift towards informal eLearning programmes and the benefits to your business.

 

Now book your place!

Now you have chosen your sessions, please use the form below to let us know your details and which sessions you’d like to join us on.

Remember, you can attend up to three sessions – but please select up to two sessions per timeslot in case one of the sessions you have selected is full.

 

  • (if there are any sessions you'd particularly like to attend, for example, tell us here and we'll do our best to accommodate you)
  • This field is for validation purposes and should be left unchanged.