Results 1 to 4 of 4
  1. #1
    4 Star Lounger
    Join Date
    Oct 2009
    Posts
    471
    Thanks
    3
    Thanked 2 Times in 2 Posts

    Excel 2016 vs. Excel 2010

    Is there a big difference between Excel 2016 and Excel 2010?

    I have 2010. I am wondering if it is worth my while to upgrade to 2016.


    Thank you.

  2. #2
    New Lounger
    Join Date
    Feb 2016
    Posts
    7
    Thanks
    1
    Thanked 0 Times in 0 Posts
    I think it depends on how heavy a user you are. I teach a basic Excel module in my Computer Apps class and I see no difference between 2010 and 2013 (I think 2016 is the same as '13). But, the most advanced things we do are pivot tables and what if analyses. I did, however, find a minor difference in the pivot tables between Excel for the PC and Excel for the Mac.

  3. #3
    Silver Lounger
    Join Date
    Jan 2001
    Location
    West Long Branch, New Jersey, USA
    Posts
    1,921
    Thanks
    6
    Thanked 9 Times in 7 Posts
    here's a link to new features in Excel 2016:
    http://new.office-watch.com/2016/exc...and-functions/

    I looked at the article. I don't do much charting, so those features were not of much interest to me.

    However, the new built-in functions were mildly interesting.

    I would be interested in knowing about differences between 2010 and 2013. I have 2010 loaded and got 2013 at a cheap price but haven't loaded it yet. And now 2016 is here.

    Fred

  4. #4
    3 Star Lounger
    Join Date
    Apr 2001
    Location
    Joliette, Quebec, Canada
    Posts
    290
    Thanks
    9
    Thanked 0 Times in 0 Posts
    if you want to do mapping the power map it awesome. If you get an BI version of excel the power view add-in allows for amazing dash boards. https://support.office.com/en-IE/art...7-eea62a387030 and https://www.youtube.com/watch?v=trdX7b0_pE0, but if you do not consider yourself a power user and do not need these feature than stay with 2010. But if you use MS access the 2010 version is the best. They seemed to have dumbed down Access in 2013 and 2016, no pivot table forms.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •