We have a great last minute offer for you this week on our Health & Safety Risk Assessment course here at Happy. With a fantastic 25% discount, this course is ideal for anyone who is involved with Office Management and/or Health & Safety. We also have a new date for our Data Protection & Confidentiality course. We haven’t run this course for … more
News
Excel Hints & Tips – Mixing Absolute + Relative mode
How do you record a macro that will copy data from a set area on your spread sheet and then paste it into the first available empty row, in an ever increasing list? In the example below our data is imported into an area of our spread sheet in column B – the Sales Order Form (in yellow). We then … more
50% off – Project & 5 Pillars of Inspirational Leadership
50% off – MS Project 2010 & 5 Pillars of Inspirational Leadership We have 2 great offers for you this week with Project 2010 and The 5 Pillars of Inspirational Leadership however you’ll have to be quick as they are both on this week. With an amazing discount of at least 50%*, can you afford to miss out? As well as a day … more
Excel Hints & Tips – Line Breaks in a Cell & Cell Formats
Adding a Line Break Sometimes you want to have text in one cell that is spilt into multiple lines. To do this you need to use the ALT + ENTER keyboard shortcut. What you end up with is something like this: This is very similar to putting a soft return into a Word document except that, in Word, you use … more
LVSC Courses at Happy in June & July
LVSC working in partnership with Happy aim to deliver a full and varied programme of training events. The programme has been designed to provide the highest quality training at the lowest prices. The aim is to keep it affordable, especially to help small voluntary sector organisations. Did you achieve your training goals last year? Have you identified any skill gaps … more
Full Time Apprenticeship Scheme for 16-18 year olds – Get involved!
Our Children Need You! The most memorable event in my career was a time when a young trainee told me “you’re the first person to tell me I’m smart”. The impact of that was incredible as I imagined my own children going through life without any positive encouragement or praise. That trainee went on to achieve his first qualification, … more
25% off – LVSC Managing for the First Time
We have a great last minute offer for you this week on our Managing for the First Time course here at Happy. With a fantastic 25% discount, this course is ideal for new managers and supervisors. Course Managing for the First Time Date 25th June 2013 Price Was £225 now £169* About the course This 2 day course is … more
Happy People – Transformational Learning Under Pressure
Transformational Learning Friday was such a joy for me, it was the final day of our TPMA Train the Trainer course which culminates in an assessment to be accredited by the Learning and Performance Institute. Do I like watching my learners fret and worry with nerves? No, but I absolutely love it when they put in an amazing performance. Selfishly it … more
New Course: TPMA Refresher & Renewal
Re-certify and update your training skills with our new TPMA Refresher and Renewal Course Has it been a few years since you achieved your TPMA certification?. If so I hope your training skills have continued to develop and you are still getting the buzz from helping other people reach their potential. A few things have changed over the last few years, … more
Excel Hints & Tips – Calculations on a filtered list
Auto filter is a wonderful thing isn’t it? With a few clicks of the mouse little dropdowns appear letting you filter your data in a myriad different ways. But what if you want to find out the total or average of your filtered data? Unfortunately the SUM, AVERAGE, COUNT, COUNTA etc functions seem to let us down here. Here’s my … more
