What is the course about?
This course covers the table and chart construction features of Microsoft Excel.
What will we cover?
• Constructing simple and more complex tables
• Formatting table ranges
• Working with data tables
• Creating charts and pivot charts
• Editing charts for desired results.
What will I achieve?
By the end of this course you should be able to...
• Create table ranges and data tables
• Create charts and pivot charts from spreadsheet data
• Include a chart from a pre-created pivot table
• Be aware of the different options with regard to chart construction and editing.
What level is the course and do I need any particular skills?
The course is designed for complete beginners, though experience of using a mouse and keyboard, and a basic understanding of Microsoft Excel, would be desirable.
You should be able to follow simple written and verbal instructions to support demonstrations, hand-outs and for health and safety information, and will be invited to take part in group discussion. You should be able to use numbers and be able to do simple measurements and calculations.
Please look at the rest of the course outline carefully to decide if you may benefit from support in your English and Maths skills to help you to take part fully in this class.
How will I be taught, and will there be any work outside the class?
By presentation and demonstration. The learners will have access to computers for practicing.
Are there any other costs? Is there anything I need to bring?
You can bring pen and paper but course notes will be provided.
When I've finished, what course can I do next?
Excel: expert, Excel: financial modelling, Excel: analysing data, Excel: advanced, Introduction to VBA, Excel: analysing your spreadsheet with pivot tables, Data analysis with Power BI.
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