Start Date: 15/10/2013
Duration: 1 Day
Location: SureSkills Training Centre, 14 Fitzwilliam Place, Dublin 2
Accreditation: Microsoft CPLS
Full Fee: €395
Network Members Fee: €205
Training in and use of MS excel 2010 Intermediate has provided users with a solid foundation in the basic and intermediate skills for working in Excel. Users have used Excel to perform tasks such as running calculations on data and sorting and filtering numeric data.
In this course, Users will extend their 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.
This course demonstrates how to work more efficiently with workbooks, enhance the appearance of data and worksheets, and use the tables and filtering features to manage and analyse data.
Who Should Attend
This course is designed for Microsoft Excel users who have basic skill levels and understanding of Excel and who wish to extend their knowledge and skills beyond building simple workbooks. This course is suitable for people who use or who will use Excel in their daily role.
- Revision of Intermediate Topics
- Advanced File Tasks
- Working with Functions and Formulas
- Managing Tables
- Adding the Finishing Touches
- Showing Data as a Graphic
- Working with Data
- Pivoting Data
- Advanced Excel Tasks
Mary Warde – Microsoft Certified Trainer
- MOS – Microsoft Certified Application Specialist in MS Office 2010
- ECDL Foundation and ECDL Advanced
- Certified Lotus Engineer (CLE)