Our Teach Yourself Advanced Office manuals cover popular globally recognised qualifications, which include the ECDL Advanced (European Computer Driving Licence), ICDL Advanced (International Computer Driving Licence) and ITQ Advanced (Information Technology Qualifications). Advanced certification levels are set at level 3 (A-level in UK). Learners can purchase manuals by ordering a paperback version (via Amazon, Barnes & Nobel and CreateSpace) or PDF version (LULU). UNITS start at just £6.99 and cover Microsoft Office 2007, 2010, 2013 and 2016 versions.
This unit covers complex tasks within a Word-Processor (Microsoft Word) application including, using sophisticated typographical, formatting and layout configurations, including tables, forms and graphics, master documents, using tools such as macros and carry out more advanced mail-merge operations. Achievable certifications - ECDL Advanced Word-Processing, ICDL Advanced Word-Processing, ECDL Expert and ICDL Expert (four units required).
Achievable certifications - ECDL Advanced Spreadsheets, ICDL Advanced Spreadsheets, ECDL Expert and ICDL Expert (four units required). This unit covers complex tasks within a Spreadsheet (Microsoft Excel) application, including using advanced formatting options such as conditional formatting and functions associated with logical, statistical, financial and mathematical operations, working with tables and lists to analyse, filter and sort data, functions and creating and using scenarios.
Achievable certifications - ECDL Advanced Databases, ICDL Advanced Databases, ECDL Expert and ICDL Expert (four units required). This unit covers complex tasks within a Database (Microsoft Access) application, including creating relationships between tables, designing and using queries to create a table, using controls and sub-forms, creating reports to perform calculations and using macros.
Achievable certifications - ECDL Advanced Presentations, ICDL Advanced Presentations, ECDL Expert and ICDL Expert (four units required). This unit covers complex tasks in a Presentation (Microsoft PowerPoint) application, including creating and modifying templates, formatting slide backgrounds, enhancing a presentation using built-in drawing and image tools, applying advanced chart formatting features, inserting movies and sound and applying built-in animation features and using linking, embedding, importing and exporting features to integrate data.
Advanced Word-Processing (ITQ)
ITQ qualifications are listed by QCF (Qualifications and Credit Framework) and therefore maybe eligible for funding in England, Wales and Northern Ireland. Achievable certifications - ITQ Advanced Word-Processing (UK only) and ECDL Expert (four units required).