Call us: 020 3045 5176
You have no items in your shopping basket.

Excel in a Day: Part Two

Saturday 24 November 2018
09:30 - 15:00
5 Hours / 1 Weeks
5 Brampton Road, Bexleyheath

Fee information. Click here for eligibility details (opens in a new window).

£40.00 Course symbols: N

Course description

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.

Entry requirements

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)

Not applicable.

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

As above.

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.

Additional information

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.

Venue information

5 Brampton Road, Bexleyheath, 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