Excel: advanced

Learn advanced features - sorting, filtering, linking, formulae, pivot tables and macros to create and work with complex spreadsheets. Knowledge required: essentials course or equivalent knowledge and experience. See also 'ECDL advanced'.

(average based on 1 review) » Write a review of this course

» View full course outline

Key course information

Dates
21/02/12 - 27/03/12

Day(s)
Tue

Duration
6 weeks

Time
10:30 - 13:00

Fees
Full fee: £119
Senior fee: £73
Concession: £52

Venue
KS - Keeley Street

» View location

Course code
CEX20

Availability
This course has finished

This course has finished

» Find another course in Computing » Search all courses

Still got questions?
computing@citylit.ac.uk or call 020 7492 2515

Course outline

What is the course about?

It builds on the Excel Beginners course and introduces the more advanced features of the application.

What topics will we cover?

Advanced sorting of data
Advanced filtering of data
More advanced linking of worksheets for calculations
More advanced formulas incorporating various functions
Using pivot tables
Recording macros
Using data tables
Scenarios
Auditing
Naming data ranges.

By the end of this course you should be able to:

Sort and filter data using specified criteria
Analyse data using pivot tables
Set up best/worst case scenarios
Do calculations using functions and values from different worksheets/workbooks
Automate tasks using macros
Work with large and more complicated worksheets with confidence.

What level is the course and do I need any particular skills?

This is an advanced course and you should have completed the Excel for beginners course or have working knowledge or experience of using Excel.

You should also be able to follow spoken and written instructions and be comfortable carrying out mathematical calculations.

How will I be taught, and will there be any work outside the class?

Each student has their own computer.
Presentations will be made using computers, whiteboard, overhead screen and printed notes.
Step by step instruction, with demonstrations where appropriate, will help you grasp the concepts.

Do I need to have an interview before I can enrol?

No.

What feedback will I get?

You will receive regular feedback from your tutor throughout the course, as and when appropriate. At the end of the course you and your tutor are asked to assess the progress you have made.

How will I be able to give my views on the course?

Please complete the evaluation form at the end of your course. These are monitored and help us to continually improve our courses.

How do I find out if I can get some support for my learning?

You may be interested in: education and careers advice; financial and childcare support; disability support; support for Deaf and hearing-impaired students; dyslexia support; English and maths support; counselling, and library services (supported learning centre). To find out what may be available to you, and how to apply, see page 213 of the 11/12 course guide, or visit www.citylit.ac.uk/students

When I've finished, what course can I do next?

General information and advice on courses at City Lit is available from the Information and Advice Shop, open Monday to Friday 12:00 – 19:00 during term time, and Monday to Friday 12:00 – 17:00 out of term time. See the course guide for term dates and further details.

Who can I contact for further information?

Tel: 020 7492 2515

computing@citylit.ac.uk

Advice times:

Tuesday 17.30 - 18.30; Wednesday 12.30 - 13.30

You do not need to book an appointment, just come along on the days and at the times listed.

To enrol on a course, call 020 7831 7831.

Select another date / day / time

Dates	Day(s)	Time	Duration	Fees	Snr	Conc	Code	Availability
29/05/12 to 03/07/12	Tue	10:30 - 13:00	6 weeks	£119	£73	£52	CEX21	Available	» Select
10/06/12 to 17/06/12	Sun	10:00 - 17:00	2 weeks	£122	£75	£61	CEX09	Full	» Select
13/07/12 to 20/07/12	Fri	10:00 - 17:00	2 weeks	£122	£70	£56	CEX22	Available	» Select
18/09/11 to 25/09/11	Sun	10:00 - 17:00	2 weeks	£122	£75	£61	CEX15	Finished	» Select
25/10/11 to 29/11/11	Tue	10:30 - 13:00	6 weeks	£119	£73	£52	CEX19	Finished	» Select
06/11/11 to 13/11/11	Sun	10:00 - 17:00	2 weeks	£122	£75	£61	CEX07	Finished	» Select
15/01/12 to 22/01/12	Sun	10:00 - 17:00	2 weeks	£122	£75	£61	CEX16	Finished	» Select
21/02/12 to 27/03/12	Tue	10:30 - 13:00	6 weeks	£119	£73	£52	CEX20	Finished	» Select
04/03/12 to 11/03/12	Sun	10:00 - 17:00	2 weeks	£122	£75	£61	CEX08	Finished	» Select
22/04/12 to 29/04/12	Sun	10:00 - 17:00	2 weeks	£122	£75	£61	CEX17	Finished	» Select

Contact us

Computing