In my first spreadsheet tutorial, I described how I wanted to take this information from iTunes: and calculate the average song length. If you read that tutorial, you know that the average length of each item in my iTunes library (including podcasts) turned out to be 246.9675647 seconds. In this tutorial, we’ll find out how …read more…

There is a lot that you can do with a spreadsheet beyond simple sums and averages. If you are in business or science, you learn these more complicated functions quickly because everyone around you knows about them and uses them, but if you are in another field, they will probably remain a mystery to you. …read more…