Updates
2017 March | Data Tab, Get External Data Group - removed |
Data Tab, Get & Transform Group - renamed to Get & Transform Data | |
2016 August | Tell Me Box - Improved search, content and recommendations. Simple tasks can be taken care of here while complex questions will show multiple options. |
Review Tab, Accessibility Group - Added to provide shortcut to Check Accessibility command | |
Data Tab, Get & Transform Group - Enhanced connectors (SAP, OData, Access) | |
Data Tab, Get & Transform Group - Query Editor, Step Names use Regional Settings to display different languages. | |
Data Tab, Get & Transform Group - Query Editor, Query Steps has additional description field. | |
Data Tab, Get & Transform Group - Query Editor, Date, Name of Day added, Name of Month added, Date and Time added, Combine Start of Hour added, End of Hour added. | |
2016 July | Data Tab, Get & Transform Group - More connectors added (SAP, SharePoint folder) |
Data Tab, Get & Transform Group - Data Tab, New Query > From Online Services menu added | |
2016 June | Data Tab, Get & Transform Group - Query Editor, Conditional Columns added |
Data Tab, Get & Transform Group - Query Editor, Column data type indicator added | |
2016 January | Draw Tab was added to replace the context sensitive Ink Tools - Pens Tab. |
You can annotate with ink to make notes, create shapes and write maths equations. | |
Equation Tools Design Tab, Tools Group - Ink Equations | |
2013 | Insert Tab, Tables Group - "Recommended Pivot Tables" added |
Insert Tab, Illustrations Group - "Online Pictures" added | |
Insert Tab, Illustrations Group - "Clip Art" removed | |
Insert Tab, Illustrations Group - "Screen Clipping" added | |
Insert Tab, Apps Group - added | |
Insert Tab, Charts Group - "Recommended Charts" added | |
Insert Tab, Charts Group - Doughnut has been put under Pie | |
Insert Tab, Charts Group - Bubble has been put under Scatter | |
Insert Tab, Charts Group - Stock, Surface or Radar has its own drop-down | |
Insert Tab, Charts Group - Insert Combo Chart - added | |
Insert Tab, Sparklines Group - added | |
Insert Tab, Filters Group - added | |
Insert Tab, Text Group - "Object" removed | |
Insert Tab, Text Group - "Equation" added to Symbols group | |
Insert Tab, Text Group - Symbol moved to Symbols group | |
Data Tab, Data Tools Group - "Flash Fill" added | |
Data Tab, Data Tools Group - "Relationships" added | |
Review Tab, Proofing Group - Translate moved to the Language group | |
View Tab, Workbook Views Group - Page Break Preview and Page Layout has been swapped around | |
View Tab, Workbook Views Group - "Full Screen" removed | |
View Tab, Show Group - Message Bar removed | |
View Tab, Window Group - Save Workspace removed | |
2010 | Better support for high performance computing (hpc) and clusters. Excel 2010 can delegate the calculation of particular User Defined Functions (UDF) to a compatible compute cluster so that a UDF is actually calculated remotely and not on the desktop PC. |
Additional Actions was introduced to replace custom Smart Tags. | |
Available in 64 bit version addressing the 3G RAM limit, which exists in 32 bit | |
Support for larger data sets | |
Although it was previously possible to save and publish worksheet data to a SharePoint site, in Excel 2010, the options for doing this are now conveniently located together on the Share tab in Microsoft Office Backstage. | |
Backstage View was introduced to replace the Office Button. | |
KeyTips - The shortcuts that are available for the ribbon are called keytips - Press Alt to activate. To go back one level press ESC. |
© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited TopPrevNext