I think this is what you are looking for:
https://www.dropbox.com/s/01neaoj9e0nb6j4/Color%202%20Columns%20at%20a%20time.xlsx
Uses conditional formatting to color two columns at at time.
Don't feel too bad, sometimes what can appear to be easy can elude us. Anyways, here's what I cam up with:
https://www.dropbox.com/s/0ommx45oc26jvfe/No%20Sundays.xlsx
The important thing is to start slow. Star with the basics and then build up from there. Starting off by looking at the tax burden chart, which is pretty advanced, is going to cause you nothing but frustration as you dont have a solid foundation yet. Though, just spending a few days and...
I would stay away from 3rd party certs, they could good to help you learn more, but I would just go with a cert actually from microsoft.
http://www.microsoft.com/learning/en/us/mos-certification.aspx
They offer 2 excel tests, one is specialist and one is an expert. If you have any sort of...
I think PowerPivot will be a great course. The more I use and mess around with the more I realize how powerful it really is. Looking forward to that one for sure.
You could always use the GetPivotData function. Might have to use two or more pivot table, but then just build one using the function of everything you want
if you have your data and pivot table how you like it, then I'd look into the GetPivotData Function. Gives you all the nice things that come with pivot tables, while allowing you to use "regular" formulas.
This should be what you are after. I showed two ways of getting what you want, hopefully lol. Personally, pivot tables are a lot easier.
https://www.dropbox.com/s/hmy1lhii227cqho/Sumifs%20vs%20Pivot%20Table.xlsx
Wasnt 100% clear of what you wanted, so this may or may not help. Just used the MOD function
https://www.dropbox.com/s/kg31m1xa2o6j7t2/Reset%20Numbering.xlsx
Building upon what Montrey suggested. This link should be a good start.
http://office.microsoft.com/en-us/sharepoint-server-help/introduction-to-excel-services-and-excel-web-access-HA010105476.aspx