We are offering a massive 33% discount on all of our extremely popular MS Excel 2003 courses on Wednesday 20th March here at Happy HQ, London. Starting with the basics right up to advanced, our courses are designed to be practical and easy to understand. On average our clients gain an extra 38 minutes productivity after attending our courses. … more
Tag Archives: Excel
Excel Hints & Tips – The OFFSET Function
How do I set my spread-sheet to automatically extract this month’s figure from the accounts? Let us assume the spread-sheet uses the standard accounts layout of figures for each month, so 12 columns of figures in all, for January to December. You want to indicate the current month with a number (1 for January, 2 for February etc) and … more
Excel Hints & Tips – More Pivot Perfection
Get your pivot table to put your filtered data on different sheets I think we’ve all declared our love of pivot tables haven’t we? If you’re still undecided let us offer you another inducement. In the screenshot below we’ve created a pivot table from our staff database. We’ve created this because we want to be able to see all the … more
Excel Hints & Tips – Timeline
Timeline – a very nice Excel 2013 feature We all like a good pivot table don’t we? But to get the full range of summary option we sometimes need to add more than we’d like. For instance, in my personnel database I want a summary of salary and bonus for each department. But I also want to be able to … more
Excel Hints & Tips – Absolute Cell References
Absolute Cell References It’s one of those jargon words we hear used about Excel formulas all the time, you may be asked if you’re familiar with absolute cell references before attending some of our excel courses at happy. You may have asked for help with a formula and been told “you need to absolute that cell!” So what are absolute … more
IT Apprenticeships, Funded at Happy
Would you, or your colleagues, like comprehensive IT training to build your skills and confidence in using your computer? The IT Apprenticeship with Happy Computers offers funded classroom training for the City & Guilds Level 2 Diploma for IT Application Specialist. This includes all of the following: Word: Create a report, improve document layout, create and format tables,create a Table of … more
