Excel for Expert Users

This one-day time management training course explores the need for reflection, planning, organising, setting goals and responding to day-to-day activities and demands. It'll also help you decide what activities give you the biggest return at work and in life. You will consider what methods of time management are possible in your situation and learn how to make time management a daily practice.

Would you like to be the type of manager that people want to work for, who enables a highly productive team in a positive and supportive work environment? In this leadership programme, you will gain personal insight and develop practical leadership and management skills to create a high performing team. You will develop your coaching skills and how to put your people at the heart of what you do.

If you use Excel for budgets, timesheets, reports or other data that needs calculating, this advanced one-day course will improve your ability to organise and analyse data. Learners must be confident creating formulas that use Absolute Cell References ($ to fix cells when copied) and more complex functions like IF. You will take functions further and be able to make them more powerful by nesting them. Our public dates for this course are in the classroom and online, via Live Online Learning. This course is also available for private group bookings for your organisation.

By the end of this beginner one-day Excel course, you will be able to, Create, save, close, open and print spreadsheets, Insert and delete rows or columns in your spreadsheet, Get Excel to add up numbers automatically, Copy formulas in your spreadsheet, Sort large databases into order and filter to show only the data you need, Alter the look of the numbers and text, insert notes (aka comments), lay out text with merged cells and wrapped text, use cell styles, change the layout for printing, and Visually represent numbers and text (as a chart) in your spreadsheet, to make them stand out and easy to understand.

This intermediate course is for anyone who has used Excel before and is confident with creating basic formulas e.g. adding, subtracting, multiplying and dividing. In this intermediate Excel course you will learn time-saving techniques including Absolute Cell References e.g. a multiplication that involves a fixed figure (such as VAT) and requires two-dollar signs (e.g. $B$4). You will explore more Conditional Formatting Settings use Range Names and several functions e.g. IF, SumIFs and CountIFs to analyse your data. You will also learn how to create a basic Pivot Table to summarise large sets of data quickly and easily.

Would you like to be the type of manager that people want to work for, who enables a highly productive team in a positive and supportive work environment? In this leadership programme, you will gain personal insight and develop practical leadership and management skills to create a high performing team. You will develop your coaching skills and how to put your people at the heart of what you do.

Suddenly everything is a project. And yet very few people are taught the basic project management skills required to stand a chance of success. This course is Happy’s response to the problem.

What do you hate about email? The most common complaint we hear is that email can take over your day – you open Outlook and before you know it, it’s 4pm and you’ve not achieved anything on your ‘to do’ list for the day. In response, we have created this half-day course to give you a radical new approach to your email that will help you to free up time for the big things you want to achieve. It will also leave you with the technical skills to deal with your emails more efficiently, so you feel in control.