Course overview
- Spreadsheet options (Google sheets, Excel, Other)
- Basic functions (Opening/Closing/Saving, Ribbons, Shortcuts, Tables)
- Formatting (Using fonts, colours, cell borders, aligning & wrapping text, line breaks, cell formats)
- Data Entry (Autofill, Flashfill, Sheet Linking)
- Conditional formatting
- Drop downs (Creating, Validating)
- Formulas (e.g. SUM, SUMIFS, IF, COUNTIF, OR, AND, VLOOKUP, LEFT, RIGHT, MID, LEN, TEXT, TRIM, SUBSTITUTE, FIND)
- Outputs (Graphs, Pivot Tables)
- Using help and the internet
Course dates
Workshop 1: Tuesday 20th September, 9.30am-12.30pm
Workshop 2: Thursday 22nd September, 9.30am-12.30pm
(Total 6 hours)
Delivery
This workshop will be held at City College Plymouth, Pinpoint, Union Street, Plymouth, PL1 2SR.