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 Hours

34 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?

    QR Code - scan to visit course page

    You can use the above QR code to connect directly to the course details.

    Apply for IT Short Course - IT in Business - Spreadsheets

    I want to start in 2021/22
    I want to start in 2022/23

    We are delighted that you are thinking about studying at Perth College UHI. Perth College 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.