Learn the basics of spreadsheets - entering text, numbers, formulae, formatting, modifying and linking sheets and creating charts. Ideal if you have some computing experience.
Dates
27/06/12
Day(s)
Wed
Duration
1 week
Time
10:00 - 17:00
Fees
Full fee: £75
Senior fee: £42
Concession: £30
Venue
KS - Keeley Street
Course code
CEX06
Availability
This date is full
Occasionally places may become available. You can add yourself to the waiting list.
» Find another course in Computing» Search all coursesYou will learn the basics of Excel - Microsoft's popular spreadsheet software - and how to manage data, perform calculations and create charts and graphs. The course includes a general overview of the concepts, terms and functions of spreadsheets.
A spreadsheet is composed of a large number of boxes or cells, laid out in orderly rows and columns.
Introduction to Excel.
Entering data.
Enhancing the appearance of the data by changing font, colour, size and style.
Adding and deleting rows and columns
Basic formulae.
Basic functions used in calculation such as Sum, Average Maximum, and Count.
Adding, deleting and moving worksheets
Creating charts, graphs and enhancing their appearance.
Print options.
Create worksheets in Excel.
Perform calculations in Excel using formulae and functions.
Convert numerical data into charts/graphs and make changes to them
Enhance the appearance of worksheets using formatting.
Though this is an introductory course, you should be able to use a keyboard and mouse and understand the principles of file management.
You should be able to follow spoken and written instructions and add, subtract, multiply and divide.
Each student has their own computer.
Presentations will be made using computers, interactive whiteboard, overhead screen and printed notes.
Step by step instruction, with demonstrations where appropriate, will help you grasp the concepts.
No.
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.
Please complete the evaluation form at the end of your course. These are monitored and help us to continually improve our courses.
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
Excel Advanced
ECDL Advanced Excel.
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.
Tel: 020 7492 2515
computing@citylit.ac.ukAdvice 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.
| Dates | Day(s) | Time | Duration | Fees | Snr | Conc | Code | Availability | |
|---|---|---|---|---|---|---|---|---|---|
| 27/06/12 | Wed | 10:00 - 17:00 | 1 weeks | £75 | £42 | £30 | CEX06 | Full | » Select |
| 23/11/11 | Wed | 10:00 - 17:00 | 1 weeks | £75 | £42 | £30 | CEX04 | Finished | » Select |
| 21/03/12 | Wed | 10:00 - 17:00 | 1 weeks | £75 | £42 | £30 | CEX05 | Finished | » Select |
Computing
Tel: 020 7492 2515
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.