The magic of spreadsheet software like Microsoft Excel and Apple Numbers lies in the automation of repetitive tasks. Most spreadsheet users know about the automation of arithmetic operations, but spreadsheets let you also automate the creation of common lists like sequences of numbers and the names of months.
I’ve already explained how you can quickly create common lists in this blog post. While the video below uses Apple Numbers to explain common calculations and lists, the tools explained work the same way in Microsoft Excel.
http://www.youtube.com/watch?v=UJa8I5FqJNk
This video explains percentages. Again, this works the same way in Excel.
http://www.youtube.com/watch?v=DSI6Zj097l8