Microsoft Office, Excel Advanced Course, study Pivot Tables
Aims of the Course?
Your training in and use of Microsoft® Office Excel® 2007 has provided you with a solid foundation in the basic and intermediate skills for working in Excel. You have used Excel to perform tasks such as running calculations on data and sorting and filtering numeric data. In this course, you will extend your knowledge into some of the more specialized and advanced capabilities of Excel by automating some common tasks, applying advanced analysis techniques to more complex data sets, collaborating on worksheets with others, and sharing Excel data with other applications. (For more course contents please turn over and look under Basic Level)
How long is the Course?
Each level is taught in one day and if you want to take full course then it will be 30 hours GLH spread over three days
Assessment and Qualification you will achieve:
This course is designed for hands on training. However college will award completion certificate on the completion of the course. If you wish to become Microsoft or City & Guilds qualified please contact our course leader and we will arrange assessment which will incur more charges.
Basic understanding of English language and basic mathematical operations. However if you need additional support please do not hesitate to contact your tutor who will arrange.
What are the opportunities for further studies?
On completion three levels your job prospects will improve in great deal. If you wish to progress further in ICT we have BCS level 4 (full time) course equivalents to first year of degree and will lead to B.Sc. in computer science.
How do I enrol?
You can enroll online or please come to our reception for prospectus and FREE consultation. Course can be discounted by further 20% if Number of delegates are more than 5.
- Piviot Tables
- Search for Data in a Worksheet
- Print Workbook Contents Using Default Print Options
- Set Print Options
- Format Worksheet Tabs
- Manage Worksheets in a Workbook
- Manage the View of Large Worksheets
- Calculate Data Across Worksheets
- Create and Format a Chart
- Insert and Modify Pictures and ClipArt
- Draw and Modify Shapes
|Requirement||Basic IT keyboard and mouse skills|