Modern User Interface (UI)
First time you open Excel, you could be surprised to discover new colors. Only 24 colors are used in the ribbon and the Excel window presentation. 24 is not a lot but in fact, the reduced colors will help to set off your data.
As you can see in this screenshot, when your document has a lot of data, charts, or conditional formatting, you notice them much more than the menu or the Excel interface and this is really important for your presentation.
All names of the ribbon tabs are now in uppercase.
First / Last worksheet
In this version, these 2 classical buttons have been removed. Studies found that very few people used them so Microsoft has decided to remove these buttons.
Nevertheless, you can easily get to the first and the last worksheet by
- holding down the Ctrl key and clicking the arrow
- click and hold down the mouse button
Insert a new worksheet
There is a major difference to the previous versions: the new worksheet is no longer added after the last sheet but always after the active sheet.
In this example, you can see 3 worksheets. The first one is active. When you click on the icon “add a new worksheet”, the new worksheet will be added after Sheet1 and not after Sheet3 at the end.
At the top and bottom of the scroll bars, the split screen icons have been removed. To freeze the pane of your worksheet, you need to click Freeze Panes on the VIEW ribbon.