Microsoft Excel Manipulating and Presenting Data
- Type of study
- Examination board
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.
Availability & Details
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:
- 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.
South Downs College is a bright and happy place, everyone is kind and friendly to each other.Megan Hall, A Level student
My experience at South Downs was enjoyable and productive, with thoroughly helpful people surrounding you, an excellent experience. I wasn’t expecting it to be as good as it was, with the work shop time and experience I had, it was a great two years preparing me for the next stage.Edward Smith, BTEC student
I overcame a couple of barriers by working really hard to get the top grades. My experience was really good, with the course and the lecturers, the residentials and activities, together it was all really good. I had really great teaching support, I could always go to the lecturers and speak to them if I needed to.David Stenning, Public Services student
After completing this course you could progress on to Microsoft Certified course.