What is the course about?
This course covers various ways of manipulating Microsoft Excel so that it is easier to work with, and will also cover various aspects of the program to give you knowledge of the different ways you can view, amend and present your data.
What will we cover?
Features of the program such as basic formatting, subtotalling and conditional formatting.
Basic formulas and how to use them efficiently
Tips on how to quickly sort, fill and view data.
How to protect your spreadsheets
Inserting pivot tables and charts.
What will I achieve?
By the end of this course you should be able to...
Use Excel more efficiently in your work
Distinguish more about Excel's features
Improve your decision making to know which feature to use and when.
What level is the course and do I need any particular skills?
This course is aimed at people who have some familiarity with Excel, perhaps but not necessarily using it regularly, but who would like to gain more knowledge. You should be relatively comfortable working with the basics of spreadsheet software such as entering data.
How will I be taught, and will there be any work outside the class?
Each learner will work on a P.C. in the classroom, and there will be demonstrations from the tutor and practical tasks to complete which will help you to understand the material being presented.
There will be no work outside of the class.
Are there any other costs? Is there anything I need to bring?
When I've finished, what course can I do next?
Further excel courses, for example:Excel: advanced, Excel:analysing data and Excel financial modelling.
General information and advice on courses at City Lit is available from the Student Centre and Library on Monday to Friday from 12:00 – 19:00.
See the course guide for term dates and further details