IT Short Course - IT in Business - Spreadsheets
What is special about this course?
An introduction to the features and functions of a spreadsheet for practical and effective use in an office environment.
This course can be undertaken as a standalone unit or as part of the HNC in Administration and Information Technology.
Entry requirements
ICT Level 5 or equivalent. You should have a good working knowledge of MS Excel. Our tutors would be happy to discuss your suitability and help you make the right choice.
Course content includes:
- Basic spreadsheet skills
- Formatting text and cells; working with styles; ranges; worksheets; sorting data; headers and footers; printing
- Formulae and functions
- Cell referencing; logical functions; database functions; counting; conditional formatting
- Consolidation
- Referencing cells in other worksheets; 3-D formulae/functions
- Using named ranges, comments and workbook security
- Charts
- Statistical analysis
How will I study my course?
- Flexible
- Open Access
Open access with online tutor support
How long will my course last?
34 Hour34 hours which can be studied at your own pace over around 7 weeks.
Where can I study my course?
Start date
Flexible start dates
Fees
Most full-time students will have their fees paid.
Students on part-time courses may also be eligible to have their course fees waived.
What can I do on completion of my course?
This course can be undertaken as a standalone unit or as part of the HNC in Administration and Information Technology.
Is there more information available online?
You can use the above QR code to connect directly to the course details.
Apply for IT Short Course - IT in Business - Spreadsheets
We are delighted that you are thinking about studying at Perth College UHI. Perth College UHI operates a fair and open admissions system committed to equality of opportunity and non-discrimination. We consider all applications on merit and on the basis of ability to achieve, without discrimination on grounds of age, disability, gender identity, marriage and civil partnership, pregnancy and maternity status, race, religion and/or belief, sex, sexual orientation or socio-economic background. We welcome applications from all prospective students and aim to provide appropriate and efficient services to students with disabilities.