Advanced Office Applications Level 3

Advanced Office Applications Level 3

Adult Skills & Training Location: New Milton
Type: Part Time
Awarding Body:
Download/print details
Download PDF application form

Course Details

Learners have the opportunity of choosing to work towards an advanced level 3 unit qualification in either Microsoft Word, Microsoft Excel or Microsoft PowerPoint. 

The course is for anyone who wishes to gain/update information technology/computer skills with a view to working in an office environment.  Learners will demonstrate the ability to plan, evaluate and improve procedures involving the use of IT and system tools in order to improve the productivity and efficiency of work activities.

Learners will look at:-

• Advanced word processing – formatting, referencing (footnotes, endnotes), table of contents, indexing, fields, forms, templates, advanced mail merge, linking and embedding data, collaborate and review documents, master and subdocuments, document security, watermarks and sections

• Advanced presentations – formatting, templates, drawings and images, advanced charts, create and edit diagrams, insert movies and sound, animation, linking, embedding, importing and exporting, control/customise slide shows

• Advanced spreadsheets – Creating, saving, importing data; formatting spreadsheets, relative/absolute/mixed addressing, array formulae, creating a test plan, functions – logical, date/time, lookup and reference, maths and statistical, text, nested, links, filtering charts – types, comparative, scatter, printing, data validation, macros.

Course Structure & Teaching Methods

The teaching is in well-equipped rooms with explanations, demonstrations, lectures, question and answer, discussion and self learning materials.  Each learner has the use of a computer. The software used is Windows 7, Microsoft Office 2010.


The work will be assessed by the tutor on a regular basis from which feedback will be given to help improve skills. The final assessment will take the form of practical assignments which are marked by the tutor and externally moderated by the examination board, OCR (Oxford, Cambridge and RSA).

Information & Support

Please bring along a notebook/A4 file and pen.    

Experienced and competent staff at our adult learning centres can help you decide on your course and progression options. If you feel you would benefit from more in depth careers advice please contact: The National Careers Service - Call 0800 100 900 Lines are open 8am to 10pm, 7 days a week or
Practical help and advice is also provided to assist students with any kind of disability or individual need, including people for whom English is not their first language. Please contact our centre staff to discuss your needs prior to starting your course.

Progression Opportunities

The college offers a variety of courses to further your skills in using computer software.

Available dates and locations

Please contact us to register your interest for the next available start date.

  • This field is for validation purposes and should be left unchanged.