Home •  Projects • Contact Us

Athenry Community Training Centre

Advanced Excel

This is for basic and regular users who wish to become proficient using MS Excel.

After the course you will be able to:

Use sub-totalling features

Use past special options for many tasks

Create a single or multiple criteria query using available options

Analyse data in varied ways using pivot tables and pivot charts

Create named scenarios and scenario reports

Add, edit and delete worksheet comments

Apply worksheet protection for security purposes
 

What is covered?

Relative and absolute cell referencing

Working with multiple workbooks

Creating and using named ranges

Financial functions

Database functions

Logical functions - IF and Nested IF

Look up functions

Conditional formatting

Subtotalling and group and outline features

Excel as a database:

Data forms and lists

Multiple sorting options

Create custom and advanced filters

Linking data between worksheets and workbooks

Using paste special options

Importing and exporting data

Advanced chart options

Data analysis using pivot tables and charts

Scenario manager

Auditing a worksheet using worksheet comments

Data validation and workbook protection

 

Athenry Community Training Centre
ADC House, Station Road, Athenry, Co Galway
Tel: 091-845422
Fax: 091-845496
Email: louise@athenryadc.com

Back to:

Training Centre Programmes

Training Centre
Training Centre Schedule
Training Centre Awards

Athenry ADC Homepage
ADC Projects

Tel:
+353 91 845422

Fax:
+353 91 845496

e-Mail:
info@athenryadc.com

Webmaster:
oreganathenry@eircom.net