Microsoft Excel Level 4
This advanced course, aimed at experienced users, will show you how to use Microsoft Excel proficiently at an advanced level.
We start the course by showing you how to create and use Named Ranges within functions. We’ll move on to show you how to use Logical Functions (the IF Function, the AND Function, and the OR Function) and we’ll show you how to use nested functions. During the course you’ll also learn how to use VLOOKUP Functions, array formulas and how to use auditing and reviewing tools. We’ll also show you how to create advanced conditional formatting rules and how to use advanced PivotTable tools and techniques.
1 Day (6 hours approx)
Please contact us for a quote.
This course will cover the following:
- Use Named Ranges
- Use Data Validation
- Use Grouping and Advanced Filtering
- Use Advanced IF Functions
- Use the AND Function
- Use the OR Function
- Use the VLOOKUP Function
- Use Auditing and Reviewing Tools
- Use Advanced Conditional Formatting
- Use PivotTables
How often do courses take place?
We schedule courses on demand, please contact us for the next available date.
Are there any entry requirements?
Yes, you should have good existing skills using Microsoft Excel, eg be familiar with the majority of topics covered on our Microsoft Excel Level 3 course.
Will I get course notes?
Yes, you’ll receive user-friendly course notes for future reference.
Will I get a certificate at the end of the course?
Yes, you’ll receive the following e-certificate: EC-PC Microsoft Excel Level 4.
Do you offer any tutor support after the course?
Yes, you’ll receive 3 months e-mail support covering questions relating to any of the course topics.
Is there any funding available to pay for the course?
Yes, funding is available for individuals living in Scotland, subject to T&C’s.
Click here to find out more.
What payment methods do you accept?
We can accept payment by card, cheque or by bank transfer – please contact us for more details.