Microsoft Excel Manipulating and Presenting Data

Course code
Type of study
Examination board

Apply now


If you are a regular Excel user, chances are that you have had to work with large data sets and require some new skills to help you manage and extract vital information.

You will also explore the importing and exporting of data into and out of Excel finishing up with more advanced reporting skills.

You should have completed the beyond beginners course or have equivalent experience to the Beyond Beginners course.

On this course you will cover the following topics:

  • Validation
  • Pivot tables
  • Large datasets
  • Advanced conditional formatting
  • Import and exporting data
  • Creating reports using excel data and charts

Each topic will be introduced with relevant tuition/demonstrations/handouts followed by tasks for practice.

Students will be assessed through the development of a portfolio of work covered throughout this course.

Apply now

Contact us

There are great teachers here. South Downs College has felt more like a University than a school, and it’s definitely lived up to that more grown-up feel.

Vicky Lipscombe, A Level student

I’m very, very happy, I didn’t expect to do so well. The College has been helpful and supportive. I loved my courses, and the teachers were really good – every single one of them. The facilities are great, but it’s the staff that really make this place.

Matthew Randell, A Level student

You take control of your own learning…they (South Downs College) were really helpful and always willing to do anything and go that extra step to help me get my grades.

Scarlette Tiller, A Level student


After completing this course you could progress on to Microsoft Certified course.

What to do next

Apply now Contact us