[Anonymous]

Guys, which do you prefer, 2010 or 2013 version? I just started a new job and the company is using 2013 Microsoft products. I am only used to 2010 version. Today, our controller instructed me to provide a schedule (as required by our CFO) of temp wages (through staffing agencies) segregating the production and admin employees on a monthly basis for 2014. For some reason, I could not figure out how to use pivot table correctly using 2013 excel. I ended up breaking them down manually so as to show the sub-total presentation in rows for each month. When I got home, I practiced my 2010 Excel and it didn’t take me that long to come up with the report I wanted to lay out at work using pivot table.

I wonder how does 2013 version work for your financial reports? My husband grabbed 2013 as soon as it was launched, but immediately uninstalled it and went back using 2010. He thought 2013 Microsoft office was pain in the butt.

My next question is the sort and filter tab. For my month column and custom sort, it won’t let me sort the rows containing several months in the right order. I keep clicking January, February, et al, but it keeps showing rambled months.

[Anonymous]

how do you sort month column? I just click AtoZ button and then Expand selection

also, for what you describe it sounds like you could just use subtotal function ?

2013 excel looks weird, I am irritated every time I have to get used to new look

[stoleway]

Pivot table is fine, but it's also easy to use dynamic tables and the group function at the same time. Another option is the subtotal function

REG -63│ 84!!
BEC- 59│70│ 71 │78!
AUD- 75!
FAR- 87!

Mass-CPA

[Anonymous]

I switched from Excel 2010 to Excel 2013 when I switched jobs most recently – still have Excel 2007 at home. I haven't noticed that major of functional differences between 2010 and 201, but some little things still bug me (like “Open” and “Recent” and such being different than I'm used to – then I get used to it at work and am un-used to it at home again!).

My best advice for things you can't figure out how to do in 2013 is go to Google and look it up real quick – search “Excel 2013 sort pivot table manually”, for example, and you've got an answer instantly. Using that, I've been able to figure out in 2013 everything I new in 2010, so far anyway.

[Author]

Replies