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 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 6 hour course will be run online via Zoom / Microsoft Teams over the following dates and times:

 

Tuesday 18 August 2020 - 10am - 12pm and 2pm - 4pm (4 hours in total)

Wednesday 19 August 2020 - 10am - 12pm (2 hours)

 

Entry requirements

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

 

Access to a PC or Laptop is essential due to the delivery method of this course

Qualifications

West Suffolk College certificate of attendance.

Further course detail

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

 

Tuesday 18 August 2020 - 10am - 12pm 

  • Custom View
  • Mixed Absolutes
  • Consolidate
  • Subtotal
  • Outlines
  • Auditing (which includes)
  •   Precedents
  •   Dependants

 

Tuesday 18 August 2020 - 2pm - 4pm

  • Pivot Table (which includes)
  • Definition
  •   Create
  •   Layouts
  •   Design
  •   Summarise Options
  •   Field Settings
  •   Slicers
  •   Timeline
  •   Drill Down

 

Wednesday 19 August 2020 - 10am - 12pm

  • Advanced Conditional Formatting (Formulas)
  • Advanced Data Validation (Formulas)
  • Makro (which includes)
  •   Recorder
  •   Do Until Loops

Will I have to provide anything?

PC or Laptop to access online training

I'm interested. What should I do now?

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

 

To book, please complete the appropriate booking form below:

 

Full Cost Enrolment for Employers

 

Full Cost Enrolment for Individuals

Days & times

Starting 18/08/2020
Tuesday
Wednesday

Course price

£95.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