Microsoft Excel Manipulating and Presenting Data
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.
Ideally 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.
You will be awarded with a College Certificate outlining the skills you have obtained during this course.
After completing this course you could progress on to Microsoft Certified course.
The course information is accurate at the time of printing but is subject to change.
Office Use: 09/07/2015