Welcome. Westgate Computer Centre is A Wexford County Council Initiative. WINC (Wexford Information Networks for the Community.  
 
 
   

- Keyboard Skills
- Hardware Maintenance
- Web Design
- TAS
- Equalskills
- Digital Imaging
- Beginners -Over 55's
- Intermediate PC Skills
- Business Writing
- Online Marketing
- E-commerce
- Internet Literacy
- NetAssure
- Outlook 2000
- Project Management
- Web Technologies
- MS Project
- Internet & Email-Intro
- Internet - Advanced

- ECDL Certification
- ECDL Word Advanced
- ECDL Powerpoint Advanced
- ECDL Excel Advanced
- ECDL Access Advanced
- ECDL Expert

- MOS Word Core
- MOS Excel Core
- MOS Access
- MOS Powerpoint
- MOS Outlook
- MOS Word Expert
- MOS Excel Expert

Westgate Computer Centre
Westgate Yard, Wexford
Ph: 053-46291
Fax: 053-46295
Contact Us

 

ECDL Excel Advanced

You will learn

·         How to create, modify, share and revise workboosk using templates, automated procedures and the Web

·         Retrieve, analyse and summarise data.

====================

Audience

Holders of ECDL or MOS Core level Certification.

Anyone wishing to enhance their employment opportunities..

====================

Duration

7 weeks X 3 hours

====================

Cost

Contact Westgate Computer Centre for details

  

Overview

Spreadsheets are now pervasive and vital tools that are used by many.  This course is designed for the individual who manipulates and analyses data, prepares reports, and who wants to realise the full potential of modern spreadsheet application

WHAT IS COVERED?

  • Custom number and conditional formatting

  • One-input, two-input and what-if tables

  • Querying and filtering

  • Data linking and consolidation

  • Charting techniques

  • Date/time, mathematical, statistical, financial, logical, text, lookup and reference functions

  • Pivot tables, dynamic crosstabs and named scenarios

  • Spreadsheet auditing

  • Templates and macros

  • Spreadsheet formatting and presentation
 





   
 

© Copyright Westgate Computer Centre 2004