Advanced Excel – Discontinued Features

Imagine Excel as a superhero for numbers. We’re exploring the cool stuff it used to do but doesn’t anymore – like old superpowers it left behind. Join us to find out why and see how Excel keeps getting better! It’s like a quick tour of Excel’s history – fun and easy!

There are many features in Excel 2013. We need to know about that features :

• Features existing in earlier versions of Excel that are no longer available in Excel 2013, and the changed functionality in certain cases

Discontinued Features and Changed Functionality in Excel

The following features were changed in EXCEL 2013.

First of all, we are going to see the deleted features from Excel 2023:

• Save a workspace is deleted
• New from existing option is not available.
• Split box control is gone
• Microsoft clip organizer is deleted
• English assistance is no longer available
• Korean language reference (KOLAR) has been deleted.
• The location of browser view options is changed.
• On chart tools ribbon save as template is not available

Save Workspace

You are not able to save the current layout of all windows as a workspace. The Save Workspace command is no longer available in Excel so you are not able to add it to the Quick Access Toolbar. 
 Although, we can still open a workspace file (*.xlw) that was created in an earlier version of Excel.

New from Existing Option is not Available

When you click on File > New, creating a new file from an existing one is not available in this version.

To create a new one from the existing we can create it by clicking on File and Click on Save As. and save with a different file name.

Otherwise, we can open ‘recent workbooks’, and if required ‘file’ is available ‘right click’ on it and click on ‘open a copy’.

Split Box control is Gone

In older versions of Excel, we have split the window into panes at any position on the worksheet, but in this 2013 version of Excel, we don’t have that option.

But we have the option to split windows into panes using the Split button on the ribbon

Step 1: Open the ‘view’ option

Step 2: Select the cells you want to split

Step 3: Click on ‘split’ which is available in the Windows option

Microsoft Clip Organizer is Deleted

Microsoft Office Picture Manager is no longer available.

Step 1: Click on Insert

Step 2: Go to Pictures and Click on Online Pictures

Step 3: Select the image that you want

This feature has been replaced by Windows Photo Gallery.

English Assistance is no Longer Available

Because of less usage, this feature has been deleted. If you want to use it the message will be displayed like this “The service could not be searched because you are not connected to the Internet. Please connect and try again.

Korean language reference (KOLAR) has been deleted

Same as English assistance, because of less usage this feature has been deleted. If you want to use it the message will be displayed like this “The service could not be searched because you are not connected to the Internet. Please connect and try again”.

Location of Browser View Options are Changed

To get browser view options

Step 1: Go to File Option

Step 2: Go to Info

Step 3: Browser View Options

When saving a workbook to the Web, you can set how users will see your workbook when they view it.

On chart tools ribbon save as template is not available

In earlier versions of Excel, the My Templates folder is under Available Templates (File > New).

In the new version of Excel, it won’t automatically appear as a Personal template on the New page (File > New), instead of that we have to create the folder where you want to store your templates (for example, C:\Users\<User Name>\My Excel) and then make that folder your default personal templates location.

Chart Types have been Changed

In the insert section, we can find the charts option, there we can add any type of charts like, bar charts and different shapes also.

FAQs

What Excel features are going away?

• Save a workspace is deleted
• New from the existing option is not available.
• Split box control is gone
• Microsoft clip organiser is deleted
• English assistance is no longer available
• Korean language reference (KOLAR) has been deleted.
• Location of browser view options are changed.
• On chart tools ribbon save as template is not available

What is the difference between basic Excel and advanced Excel?

In basic Excel we are able to perform calculations using formulas and functions,whereas in advanced excel we can perform complex calculations also.

What are the advanced features of Excel?

• Charts
• Conditional formatting
• Index match
• Vlookup
• Filters
• Macros etc..

What is included in advance Excel?

• Building and applying advanced formulas, like Same Product, INDIRECT, INDEX MATCH, and OFFSET
• Knowing what a Pivot Table is and how to build one.
• Knowing what an add-in is and how to install one.
• Understanding and using the AutoFilter feature.
• Recording a macro and using it later.