You want to know how to make using spreadsheets "a bit fun, creative and interesting?
Firstly, forget the definitions of "spreadsheet" that you find in most dictionaries and adult textbooks.(These originated as a sales-pitch for business people.)
Spreadsheets are programs that can be used in basically three ways:
(a) Like a piece of grid paper, to record and display information
(b) Like a hand held calculator, to do simple maths (try typing in =24/3 +5)
(c) Like a programming language, to give your computer a list of things to do.
Skills in taking advantage of this are cumulative. They take time (even years) to develop and the best time to teach any of them is when the kids are asking for a quicker, better way to do something.
I have often introduced Year 4's to spreadsheets, for example, by showing them
(a) how to make the cells in a worksheet square shaped and (b) how to colour these in.
Then I set them the task of finding out how many different shapes they can make by joining 2, then 3, 4 and 5 squares along their sides. I also get them to record their findings as a table on another worksheet. One boy doing this with me stopped for a moment to tell me that he had never played this game before!
So think about useful and interesting things that kids will find fun to learn and will learn more readily by using spreadsheets rather than other ways. e.g. how to set out a solution to a problem neatly and logically recording the numbers and calculations used rather than just scribbling down a mess of answers.
I am going to include a lot of these in a book I hope to get back to writing again soon now that I have finally retired..
Good luck
Des Howell (Retired teacher, Caloundra, Australia)funwithspreadsheets.blogspot.com/