Excel: essentials

Learn the basics of spreadsheets - entering text, numbers, formulae, formatting, modifying and linking sheets and creating charts. Knowledge required: basic computer literacy and the ability to use a mouse and keyboard.

» View full course outline

Key course information

Dates
17/04/12 - 22/05/12

There are more dates to choose from, click here

Day(s)
Tue

Duration
6 weeks

Time
10:30 - 13:00

Fees ?
Full fee: £119
Senior fee: £67
Concession: £47

Venue
KS - Keeley Street

» View location

Course code
CEX14

Availability
This date is full

This course is full

Occasionally places may become available. You can add yourself to the waiting list.

» Find another course in Computing» Search all courses

Course outline

What is the course about?

You will learn to confidently use the basic functions of Excel and get to grips with 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.

What topics will we cover?

Introduction to Excel.
Entering data.
Enhancing the appearance of the data by changing the font, colour, size and style.
Entering and deleting a column, row or sheet.
Headers and footers.
Basic formulae.
Basic functions used in calculation such as Sum, Average Maximum and Count.
Working on multiple sheets simultaneously.
Linking across sheets and other applications such as word processing.
Using spreadsheets in word documents.
Creating charts, graphs and enhancing their appearance.
Using and creating templates.

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

Create worksheets in Excel.
Perform calculations in Excel using formulae and functions.
Convert numerical data into charts/graphs and make changes to them.
Link worksheets and spreadsheets.
Enhance the appearance of worksheets using formatting.

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

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.

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, interactive 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?

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.

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
17/04/12 to
22/05/12		 Tue 10:30 - 13:00 6 weeks £119 £67 £47 CEX14 Full » Select
13/09/11 to
18/10/11		 Tue 10:30 - 13:00 6 weeks £119 £67 £47 CEX12 Finished » Select
14/09/11 to
12/10/11		 Wed 18:00 - 21:00 5 weeks £129 £129 £62 CEX01 Finished » Select
10/01/12 to
14/02/12		 Tue 10:30 - 13:00 6 weeks £119 £67 £47 CEX13 Finished » Select
11/01/12 to
15/02/12		 Wed 18:00 - 21:00 6 weeks £129 £129 £62 CEX02 Finished » Select
18/04/12 to
16/05/12		 Wed 18:00 - 21:00 5 weeks £129 £129 £62 CEX03 Finished » Select

Browse full range of courses

Click to view Click to close browse courses box

Contact us

Computing

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.

Computing

computer keyboard for IT training

City Lit’s wide range of part-time, evening and weekend computer courses range from beginner level to advanced qualifications, covering the major Microsoft Office applications, desktop publishing, web design, multimedia packages and programming

More