IT in Business – Spreadsheets

Course description

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. 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 Tutor support on-line