Recent content by Trader273

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

Could mess around with formulas, but easier and quicker to just use a pivot table with a slicer or filter.

Also, might want to reconsider using pie charts as they can be easily misunderstood by the target audience

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

3.5 <> 3 and 1/2 minutes. If you put in 3:50, then your calculation comes out correctly.

Hopefully this helps: https://www.dropbox.com/s/up85yf0z01o8tqx/Average%20without%20Outliers.xlsx

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.

See if this points you in the right direction: https://www.dropbox.com/s/8fml9ulw1dnh5ay/Show%20Pie%20when%20Data.xlsm

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