Fee information. Click here for eligibility details (opens in a new window).
£40.00 Course symbols: N
Extend your knowledge of Excel to include some of the built-in functions, combined with a range of features to produce professional and informative spreadsheets, such as charts. Ideal if you have attended the Excel in a Day: Part One course or have basic knowledge of creating spreadsheets in Excel.
a) guidance needed:
A willingness to enhance your existing knowledge.
b) entry requirements:
An ability to use a computer and prior experience of using spreadsheets.
What you will learn
The course will cover using functions and calulating percentages. Sorting, filtering and replacing data, creating charts and graphs and protecting worksheets and workbooks.
How you will learn on this course
Explanation from the tutor. Plenty of practical hands-on. Information sheets. Practice tasks. One-to-one tuition where necessary.
How you will be assessed on this course
1. Create graph(s)
2. Enter graph and axes titles
3. Set axis upper and lower limits
4. Display data labels
5. Apply designs to graphs
6. Use and move a legend
7. Use a range of functions (SUM, AVERAGE,COUNT, MIN, MAX )
8. Use absolute cell referencing
9. Calculate percentages
10. Hide & unhide columns and rows
11. Use tools and techniques for analysing data – AutoFilter and Sort
12. Use and create Custom Lists
13. Move data to another location using copy and paste
14. Freeze panes
15. Password protect worksheets and workbooks
Qualification and exam information (only for courses leading to a qualification)
What you will be expected to do outside your lesson time
None, but learners will find additional study at home or at the Open Study Centre at Brampton Road helpful.
What you need for your course
What you need to bring to the first class
Pen, paper, folder and USB stick.
What you can do next
1806P999 Private tuition on an individual one-to-one basis.
At the beginning of the course, you will have an induction to the College and the course. Your tutor may ask you to complete an Individual Learning Plan (ILP) and agree your personal learning goals.
This paperwork is a requirement of the College’s Quality Improvement Programme.
5 Brampton Road,
Kent DA7 4EZ
Nearest Train Station: Bexleyheath.
Buses: 89, 96, B16, B15, B14, B12, 422
Car park available onsite. Please note car parking spaces cannot be guaranteed.
For further details of parking please refer to https://www.bexley.gov.uk/services/parking