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

Due to current circumstances with COVID-19  we have no confirmed dates for this course - please contact us on either 01284 716246 or e-mail This email address is being protected from spambots. You need JavaScript enabled to view it. for further information or to register your interest in future course dates

 

This course is designed for users who wish to use the advanced functions of Excel including pivot tables and simple macros. 

 

It will provide delegates with more advanced skills and techniques for customising and automating spreadsheets.  Exposure to pivot tables and macros are covered.

 

The course will be run at The Stem Innovation Campus, West Suffolk College.  

Entry requirements

Prior knowledge and / or experience of Microsoft Excel 2016 is desirable.

Qualifications

West Suffolk College Certificate of Attendance

Further course detail

The Microsoft Excel 2016 Advanced course will cover the following topics:

 

  • Review
  • Custom Views
  • Consolidate
  • Conditional Options (Using Formulas)
  • Subtotal
  • Auditing
  • Filter
  • Pivot Table / Chart
  • Macro
  • What if

I'm interested. What should I do now?

For further information or to book, please contact us on 01284 716246 or This email address is being protected from spambots. You need JavaScript enabled to view it.

Days & times

Please contact us for dates and further information

Course price

£145.00

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