Fees: Standard £ 77 Conc £32 Full £136
|Saturday||13:00 - 15:00||6||MAC||11/01/2020||15/02/2020||JS2230|
We shall be looking at the following: linking and sharing data, templates, data validation, Flash Fill, LOOKUP tables and encryption.
Do you need rather more than the basics of Excel? Are you wondering what 2016 has to offer to make your work easier to handle, quicker - and more interesting? Then come along and join us.
You should be very comfortable with the basics of computer use, including managing your folders and files and using external storage, eg USB keys. A general acquaintance with Excel will be assumed, though what is needed for this course will be revised in the first session.
Link sheets internally and externally, eg to Word and the Internet, share data with other users, control the type of data entered into a cell, create drop down lists, fill cells according to a set pattern and use LOOKUP tables to search for results by matching data according to a specified criterion.
Through explanations, tasks, demonstrations, discussions, and lots of hands on practice. What extra study or practice is expected outside of the class? To gain the maximum benefit, you will need to practice every week the topics covered during the class, complete and submit all homework set and read recommended books and websites – the more you practice, the faster your skills will improve! Computer access is available at Study Support sessions at Macbeth Centre, or at your local library.
By informal feedback, but tasks will help you decide what else you need to learn or practice. The tutor will provide specific tasks to assess your progress. There will be regular opportunities to review your progress through the class.
We have a 5-week companion course to this one: Analysing Your Data, which can help you get to grips with pivot tables/charts and goal seeking. For other possible ways forward seek your tutor’s advice.
Each week you should have with you a pencil/pen and a notebook, a folder to store your work and handouts, and a USB key, so you can take your work home with you to continue it there and then bring it back to share with us. (Your tutor can give you advice on purchasing USB keys.) You may benefit from investing in a guide book to supplement your studies, e.g. Excel 2016 for Dummies by Harvey (ISBN 111907715X).. The Microsoft website has a great deal of clearly set out information about Excel and a wide range of online courses in using this software.
You may wish to get additional help and guidance offered through the free Study Support Sessions at the Macbeth Centre. At these sessions you can access the internet, work on and print homework and assignments for your course, research, access a range of software, improve your typing and practice/review what you have covered in class. You will need to book a place on these sessions – ask your tutor how. Help with literacy or numeracy is available through the basic education programme and the ESOL programme offers help for speakers of other languages. Additional support can be provided for students with learning difficulties and/or disabilities. If you have a disability and feel you need support to get the best from your course you can contact Sean Buckley (firstname.lastname@example.org) to have a confidential discussion on how best we can support your learning. The Learner Support Fund is a discretionary scheme, funded by the Skills Funding Agency, to assist learners who may be experiencing difficulties in paying for essential equipment/materials, travel costs, childcare, registration fees and other necessary expenses. These funds are only available to learners studying towards an approved qualification and who are on a low household income of under £20,000. Parental income will not be taken into consideration but the income of any spouse or partner will. Proof of low income will be required. Please discuss this with your tutor at interview or enquire at reception for full details of these funds. Details of all available support can be found on our website (hfals.co.uk), in the Guide and the Student handbook, or from teaching or reception staff.