Our app

Download our app

Click on the App Store or Google Play logos below to download the College app.

app store

google play

news icon 1.1       Policies1

Check out our latest events!

Apply now!

Not sure? No problem

Choosing what to study can be challenging. Speak to one of our advisors to find out what your options are.

Advice & Help Centre

Overview of course

 

This is a 1 day workshop for those designed for those who already have a good knowledge of Excel but want to enhance their knowledge to help them use the advanced features of Excel to create complex formulas, interactive reporting dashboards and automate tasks.
The format will be 'teach and try' where we show you what to do then you will be given files to try it out for yourself.
At the end of the course you will be able to use Pivot Tables and charts to create interactive reports and dashboards and use a wider range of formulas and functions to get the answers you need quickly.

What will I learn?

  • More complex pivot tables and slicers.
  • More advanced formulas and functions, e.g. VLOOKUP, text and date functions. Using Names and dealing with formula errors.
  • Working with external data.
  • Data Validation.

Who is the course for?

Those who already have a good knowledge of Excel but want to use the more advanced features of Excel to create complex formulas, interactive reports and dashboards and automate tasks.

Will I have to provide anything?

Computers and handouts will be provided; however, if you have one, you can bring in a USB (memory) stick so you can take home the example files and work completed in the course.
The memory needed will be less than 1 Gigabyte so any old memory stick you have lying around with a little bit of space on it would be OK.

Am I ready to start?

There are various levels of this course.  If you are not sure if the level of this course is suitable for you, please get in touch with us either by emailing This email address is being protected from spambots. You need JavaScript enabled to view it. or by calling us on 01842 760150 Monday-Friday 9am-5pm.

I'm interested. What should I do now?

To enrol and pay for this course you must visit www.wsc.ac.uk and apply for course code 19LP3123CHA by clicking the Enrol Online button.

Days & times

Starting 23/05/2020
Saturday 10:00 - 14:00

Course price

£27.20

Ask us a Question

If there is anything more you would like to know about this course, please message us here.

Please enter your name
Please enter a valid email address
Invalid Input
Please enter a message

Ask us a Question

If there is anything more you would like to know about this course, please message us here.

Please enter your name
Please enter a valid email address
Invalid Input
Please enter a message