Simple PDF demonstrating how to merge cells in Microsoft Excel. Designed for low ICT literacy adult learners completing Functional Skills ICT at Level 1 and Level 2

Simple PDF demonstrating how to add gridlines to a Microsoft Excel sheet. Developed for low ICT literacy adult learners completing Functional Skills ICT qualifications at L1 and L2.

These interactive spreadsheets have been designed to teach Excel from the basics upwards. They cover: +-/* functions cell references addition, subtraction, multiplication and division with two cells SUM function IF statements The read only one is designed for students to use, allowing them to enter information into the spreadsheet without overwriting the original copy. The spreadsheet is programmed to give notifications if the learners enter in the formulae and answers correctly. There is also an editable copy to allow you to make changes to the master sheet, if you wish to adapt it for further use. Designed for Functional Skills ICT (Level 1 and Level 2) and used to teach adults who were barely ICT literate, or novices at Microsoft excel. Makes use of colour coding to direct learners around the spreadsheet. Separate tabs for each function to allow for separating out individual skills for revision.

PowerPoint resource to cover IF statements and Absolute Cell references. These two are often assessed in combination by the Pearsons ICT Functional Skills (L2) assessments and combining them within one set of training seemed like a good idea. The PowerPoint breaks down the process of writing an IF statement, including a refresher on brackets, and then incorporates an absolute cell reference to use at the end . Encourage learners to create their own version of the Excel sheet displayed on the screen and to type in the functions to see how they work. Uses colour coding and builds up the IF statement one section at a time. Ideal for visual learners. Used to teach ICT Functional Skills to adults who have not yet mastered using Excel spreadsheets.

Level 1 FS ICT - quick self assessment sheet Useful for teaching multi level groups to get a quick idea of common strengths and weaknesses Skills matched to the L1 FS ICT Curriculum Could also be used at KS2/KS3 for new or supply teachers to determine what a class has already covered or developed competency in.

This worksheet breaks down the process of writing a SUM formula in MS Excel. It explains the uses of brackets, colons, cell references and the equals sign within the formula. Colour coded and annotated, ideal for visual learners.

Resource which reviews the Microsoft Excel buttons (MS 2013 + ) Useful for Functional Skills L1 and L2, as well as introduction to Excel courses, ICT training and CPD up-skilling. Highlights the uses of the common 'HOME' tab buttons and explains how they can be used within Excel.

Simple handout explaining how cell references work in MS Excel. Ideal for ICT beginners and people who are new to Microsoft Excel in particular. Designed for adult learners taking Functional Skills courses (ICT L1 and L2) Inspired by my father and his references to cell block H, this resource encourages people to think of the cells as prison cells, and the data inside them as prisoners. Excellent for visual learners.