Excel for teachers

How you can use Excel is really up to your imagination. In one of my training course, somebody showed me a template which is used by their GM to monitor how well the team know about the product(s) and other key salient points necessary to carry out their responsibility. The template was very useful and I have since modified it so that it can be used to profile the class performance and make comparison between a student against the class (in the case of a school teacher) This will help to identify which topic is the class is in and also the student(s) that requires special attention. Would you like to share how you are using Excel in your profession?

Uses of Excel

Excel contains a lot of formulas that will help to simplify complicated calculations. By knowing these formulas, you can actually calculate depreciation in less than 5 rows. That's right less than 5 rows. I know some of you might be shock to hear that. I have spoken to many people and also know that they have been using Excel in an inefficient way. Why do I say that? Because they have been using an entire worksheet just to calculate depreciation. Isn't that a waste? Want to learn those formulas? Take a look at my website and see if you can figure out.

Uses of Excel

What can Excel use for? Is it only capable of storing name list? Or to perform summation or tedious calculations? That is what a lot of people thought. The truth is, Excel can do more powerful things than that. One of the interesting things that it can do very well is forms, e.g. survey forms, feedback forms, etc. We are not talking about forms with boxes but form with dropdown list, option buttons and/or with check boxes, something like the form given below:

It is useful to create forms in Excel because by putting the answers in one row through links, users just need to copy and paste the answers into a consolidated worksheet. Thus saving time on consolidation.