Useful features that stripped from Excel 2013
1 PHOTOS
To summarise:
I have been using MS Excel, MS Word, MS Access from the very earlier versions (Windows 3.0). Fort that time they created great software, very handy and easy for use.
Every time Microsoft 'upgrades', the most of the users feel aggravated. They discard useful stuff, add a lot of useless features. New versions are more and more complicated instead of being simplified.
I noticed that now in Word or Excel 2010 I usually spend much longer time for the very basic tasks which I performed in the earlier versions just in few clicks.
Why does Windows XP and Office 2003/2007 continue to have such a wide usage? And all the latest versions of Windows (Vista, 7, 8) are being criticised by the majority of the users.
Anyway, let’s see what Microsoft changed in the latest version of Excel.
Excel 2013 removed some pretty useful features - like saved workspaces, fax templates, and various chart options. Below is the brief description of what is gone:
Save Workspace
This feature very handy when you regularly work with the same set of workbooks. You can avoid the hassle of reopening them by saving them as a workspace. You can then open the workspace to open all the workbooks at once.
Split control
Using the Split control, you can quickly divide the screen. This is useful to quickly view/edit various parts of worksheet. But now it was removed in Excel 2013. To split the screen, use Split in the Windows group on the View tab.
Blank workbook when launching Excel
When you launch earlier versions of Excel, it displays a blank workbook. Excel 2013 displays the start screen, which is absolutely useless.
Anyway, it is possible to disable this new default, as follows:
Click the File tab and choose Options.
Choose General in the left pane.
In the Start Up Options section, uncheck the Show The Start Screen When This application Starts option.
Click OK.
So the next time you launch Excel 2013, it will bypass the start screen and open a blank workbook.
Change Chart Type
One of the more efficient charting options in earlier versions lets you change the chart type for an individual series — quite easily. You simply right-click the series you want to change and choose Change Series Chart Type from the shortcut menu. If you try this in Excel 2013, you’ll change the chart type for all the series in the chart, not just one. Excel 2013 users will have to create a combo chart, which will take a bit more work.
Chart template
Excel 2007 and 2010 offer a Save As Template option on the contextual Design tab. Creating a chart template is an efficient way to save custom settings you want to reuse. This option is missing from Excel 2013’s Ribbon, but you can still create your own chart templates by right-clicking the chart and choosing Save As Template.
