Which Version to Learn?

[Ziggy]

Hi All,

I'm a newbie Excel user re entering the workforce. I am learning Excel 2007 since that what I have at home. Will I be lost when I get a job that uses newer versions?

 

[David Evans]

Hi All,

I'm a newbie Excel user re entering the workforce. I am learning Excel 2007 since that what I have at home. Will I be lost when I get a job that uses newer versions?

Not really - there may be some features that are improved, but you can keep learning with 2007 and certainly not be lost with newer versions. Good luck with Excel - it is a lot of fun!

 

[Hui]

Since 2007 there have been a few new Functions issued as well as a few new chart types. But all the old functions still work and so 2007 is fine.

The biggest change in 2007 was how charts are used and defined within the Excel Object Model. That won't impact you as an Excel user but once you get into VBA there is a difference between pre-2007 and 2007+ versions

 

[NARAYANK991]

Hi ,

My answer would be YES.

At the earliest , you should switch to learning Excel 2010. The reasons for this are :

1. Excel 2010 contains the AGGREGATE function , which is like a Swiss army knife. This one function can be used in a variety of tasks. Go through this link to get a basic idea.

https://newtonexcelbach.wordpress.com/2015/12/11/max-min-and-aggregate/

2. Even more important , Excel 2010 is the first version which allows you to use the Power Pivot add-in ; in later versions , Power Pivot is integrated into the Excel model.

Narayan