I am familiar with Excel 2007. I just got the news that I will be expected to use Excel 2010 instead. What are some of the differences between Excel 2007 and 2010? Were there many changes between those two editions? If someone has used both versions, do you have a preference of one over the other?
http://www.google.com/search?rlz=1C2GGGE_enUS379US455&hl=en&source=hp&biw=1366&bih=643&q=differences+between+excel+2007+and+2010&oq=differences+between+excell+&aq=0l&aqi=g-l10&aql=&gs_sm=c&gs_upl=3800l8556l0l11851l27l25l0l7l7l2l612l3805l2-5.6.0.1l12l0
I'm still using the 2003 suite! I don't like the "upgrades" (I've worked with both on my daughter and son-in-law's computers) and I refuse to spend money on something I don't like!!
Is there a place that walks a user through only the new features of the latest one? I just want to have some idea of only what has changed.
Excel 2010 introduced several new features and improvements compared to Excel 2007. Here are some of the key differences:
1. Backstage View: Excel 2010 replaced the Office button found in 2007 with the File tab, which opens the Backstage View. This view provides access to various file-related operations, such as opening, saving, printing, and sharing.
2. Ribbon Customization: Unlike Excel 2007, Excel 2010 allows users to customize the ribbon by adding, removing, or rearranging commands. This provides a more tailored and efficient user experience.
3. Sparklines: Excel 2010 introduced Sparklines, which are small, data-rich visualizations that can be easily placed within cells. Sparklines enable quick analysis and visualization of trends and patterns.
4. Slicer: Slicers are interactive visual controls that make it easy to filter and analyze data in PivotTables. This feature, available in Excel 2010, simplifies filtering data dynamically within your tables.
5. PowerPivot: Excel 2010 introduced PowerPivot, a powerful data analysis and modeling tool. It enables users to manage larger volumes of data and create advanced relationships, calculations, and visualizations.
6. Improved Collaboration: Excel 2010 introduced enhanced collaboration features, such as simultaneous co-authoring, improved version tracking, and integration with SharePoint.
As for personal preference, it is subjective and varies depending on individual needs and familiarity. Some users might prefer Excel 2010 for its additional features and improved customization options, while others may find Excel 2007 sufficient for their needs. If you are transitioning from Excel 2007 to 2010, it is recommended to explore and familiarize yourself with the new features and improvements by using online tutorials or referring to Excel 2010 documentation.