This course is intended for those with minimal experience of spreadsheets.
We will cover the skills necessary to build a functional spreadsheet table from scratch, with suitable design, colours and number formatting.
- classes normally about 2 hours, online or classroom based
- Entry 3 Level apx
- part 1 of a multi-part programme
- the next class covers basic formulae and functions (using maths)
- progress on to EDSQ
Online:
- if you’re joining online with Teams etc, it may be better to connect using the web browser rather than an app
- you can upload completed work or screenshots of your work to the chat area (to hand in)
Content
- Introductions & induction
- creating a spreadsheet
- understanding worksheets, creating etc
- inputting, editing, copying data
- adding, removing rows/columns
- hiding rows/column; freezing panes
- simple formatting
- number formats
- colouring, merging cells
Optional
- conditional formatting basics
- printing
Home Study
All these resources, the videos, practice spreadsheets and support guides, are for you to use in your own time after the class. Some classes are very short and serve only as an introduction, please use the resources in your own time to develop your skills.