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.
Send an enquiry
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.
Want to learn more?
More CPD courses by Happy Ltd
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...
Training Course
Human Resources
Effective Time Management
Happy Ltd
This one-day time management training course explores the need for reflection: planning: organising:...
Training Course
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...
Training Course
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 bu...
Training Course
Get industry-related content straight to your inbox
Thank you for subscribing
By signing up to our site you are agreeing to our privacy policy