Title

Spreadsheets for Beginners
(Module 4/ECDL)
Date & Time
 7 & 14 December
4 & 11 January
Wednesdays (9.30-12.30)
Cost
 £100 (incl. exam)
£85 (excl. exam)

Duration

 4 wks @ 3 hrs per week

Details

 Microsoft Excel is a spreadsheet design and analysis tool. This course will help you to design a spreadsheet to record and analyze your data efficiently, set up formulas to perform common calculations, use data lists to sort, filter and display key information as well as use charts to present and compare data visually.

Content
  • Creating and managing workbooks
  • Data entry techniques
  • Working with rows, columns, worksheets and workbooks
  • Linking worksheets and workbooks
  • Editing and formatting data
  • Formulas using absolute, relative and mixed cell references
  • Creating charts
  • Creating simple trends and forecasts
  • Sorting and filtering data
  • Protecting your data
  • Templates
  • Data validation
  • Attach notes to cells using comments
  • Creating custom views
 
Book this course     Back to course list     Download booking form