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 understand list manipulation and more advanced functions of Excel 2016.

 

It will provide delegates with more advanced skills that will streamline repetitive tasks, manipulate lists and display spreadsheet data in more visually effective ways.  Exposure to conditional logic, lookup formulas and large dataset manipulation is covered.

 

The 6 hour course will be run online via Zoom / Microsoft Teams over the following dates and times:

 

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

Thursday 13 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 Intermediate course will cover the following topics:

 

Wednesday 12 August 2020 - 10am - 12pm 

  • Grouping
  •  Multiple File Arrangement
  • 3D Cell Formulas
  • Multiple Book Formulas
  • Named Ranges
  • Paste Special

 

Wednesday 12 August 2020 - 2pm - 4pm

  • Conditional Logic (which includes)
  •   If
  •   If / And
  •   If / Or
  •   Nested If
  • Sum Conditions (which includes)
  •   Sumif
  •   Countif
  •   Sumifs
  •   Countifs
  • IfError
  • Conditional Formatting (which includes)
  •   Colours
  •   Data Bars
  •   Icon Sets

 

Thursday 13 August 2020 - 10am - 12pm

  • Sorting
  • Filtering
  • Data Validation
  • Lookup Functions (which includes)
  •   VLookup / HLookup
  •   XLookUp
  •   Index & Match
  • Cell Comments
  • Date / Time Functions (which includes)
  •   Concatenation
  •   Left / Right / Mid
  •   Today

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 12/08/2020
Wednesday
Thursday

Course price

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