Back to CPD Courses

Excel for Intermediate Users

Training Course

About the CPD Course

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.

Receive more information

CPD Provider

Happy Ltd

Happy Ltd

Imagine a workplace where people feel trusted, confident with their IT software and have the skills to succeed in their roles. Wouldn't you want to work there? Happy will help you achieve it. We are a multi award-winning B Corp, offering workplace consultancy, leadership, personal development and IT software training. Our aim is for your people to find joy in at least 80% of their work.
View Profile

Other courses from Happy Ltd

Business, Human Resources Business, Human Resources

Effective Time Management

Happy Ltd

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.
Course type
Training Course
View course Enquire now
Business, Human Resources Business, Human Resources

Emerging Frontline Clinical & Care Leadership Programme

Happy Ltd

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.
Course type
Training Course
View course Enquire now
Business, Human Resources Business, Human Resources

Excel for Advanced Users

Happy Ltd

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.
Course type
Training Course
View course Enquire now
Business, Human Resources Business, Human Resources

Excel for Beginners

Happy Ltd

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.
Course type
Training Course
View course Enquire now
Business, Human Resources Business, Human Resources

Excel for Expert Users

Happy Ltd

Formulas and Functions are the key to getting work done in Excel. If you are experienced in Excel but need to start building more complex calculations this one-day course (split over two half days) will help you to deepen your understanding.
Course type
Training Course
View course Enquire now
Business Business

Happy Leadership Programme

Happy Ltd

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.
Course type
Training Course
View course Enquire now
Business, Human Resources Business, Human Resources

Introduction to Project Management

Happy Ltd

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.
Course type
Training Course
View course Enquire now
Business, Human Resources Business, Human Resources

Outlook- How to Manage Your Email Inbox

Happy Ltd

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.
Course type
Training Course
View course Enquire now

Send an enquiry

Use the form below to submit an enquiry to Intellectual Property Office

By submitting this form, you consent to CPD sending you email regarding your application.

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply

CPD Subsectors

Business Consultancy
Employment Agent
Human Resources

Get the latest industry updates

Sign up now to receive the latest updates straight to your inbox

Subscribe

Could your organisation become a CPD provider?

Find out more