Once you have mastered the basics, it is time to move into more advanced spreadsheet topics. This listing gives a great review of some of the more complicated things Microsoft Excel can do (transferable to other applications). I think this would be a great follow up for teachers who want to know more about using spreadsheets in their classrooms.
Excel is probably one of the most common spreadsheet applications a teacher will encounter (Google spreadsheets being another). This video tutorial provides great advice for the beginner and the advanced spreadsheet user. While it focuses on Excel, the skills presented can be transferred to other applications. I highly recommend all spreadsheet users watch this video.
If you are more of a visual learner, then this video is for you. The speaker explains basic spreadsheet terminology and how to enter and manipulate data. I would suggest that teachers view this video to get a basic idea of what a spreadsheet can do.
This collection of Excel tests will evaluate every skill possible one can attain with the software. I like how comprehensive it is, but wish it were a bit more up to date (all these tests assess an older version of Excel). I highly recommend taking one or more of these to see what the gaps in your knowledge are.
Once you have learned the basics of using a spreadsheet it is a good idea to test your knowledge. This free online test does just that. While it is based on an older version of the Excel software, the skills it assesses are still applicable today. I recommend everyone take this test to see how much they know (I got a few wrong).
When using spreadsheets, there are several things that all users should know how to do. This handout not only provides a listing of these skills, but also gives directions as to how to complete them. It is a tutorial. I really like this set of activities. I think it does a really good job of getting "hands on" and should be read by all teachers.
Microsoft Excel is probably the most common spreadsheet application to which teachers will come in contact. This listing outlines the top ten things users of this software should know how to do. I agree with what this article has to say. I think all of the skills presented are essential for teachers to know how to do.
Preparing students for the future is one of the roles of a teacher. Using spreadsheets is something that many students probably do not do regularly. Therefore, they need to learn some basic skills in order to be successful. As the teacher, you should be sure to have mastered these skills prior to trying to teach them to students. Being proficient yourself will only help you in the long run.