The new version of an application comes with new features. Microsoft Excel 2013 (part of Microsoft Office 2013 suite) also has come with some unique and up-to-date features.
Table of Contents
- Online Storage of Excel 2013
- Opening Excel Files in your workstation
- Excel now Runs in Other Devices
- New Look
- One Workbook One Window
- Recommended Pivot Tables and Recommended Charts
- Fill Flash
- Microsoft Office Support Apps
- Data Model
- New Slicer Option
- Timeline Filtering of Data
- Quick Analysis
- Enhanced Chart Formatting
- 50 New Functions Added
- Backstage Screen
- Newly Added Add-ins
Online Storage of Excel 2013
Excel 2013 files or workbooks can be created in Microsoft’s SkyDrive online storage. You can create an Excel 2013 file in SkyDrive online storage, share that file with friends or colleagues. If you select ‘Recipients can edit’ options before sending the file, your friends or colleagues can edit the file.
If you select ‘Recipients can only view’ before sending the file, then your friends or colleagues can only view the file. They don’t have the power to edit the excel files.
Opening Excel Files in your workstation
You can open Excel files stored in SkyDrive in Excel on your computer or laptop or tablet. Or you can open files in Excel Web App. You can create a link to your file and share it with the social network or in your website or blog. You can Embed your files in your web page or blog in the following way. You can play with the following Excel File 🙂
Excel now Runs in Other Devices
You can run full Office Suite on your touch-sensitive devices such as Windows RT tablets and Windows Smartphones.
The first thing you will like about Excel 2013 is it’s a brand new cleaner look. Excel 2013 shows graphics in Title Bar. Default color scheme is White, but you can choose ‘light gray’ and ‘dark gray’ color schemes from File ⇒ Options ⇒ General ⇒ Personalize your copy of Microsoft Office ⇒ Office_Themes
Changing background graphics
You can change the background graphics of your Excel 2013 with this command: File ⇒ Options ⇒ General ⇒ Personalize your copy of Microsoft Office ⇒ Office_Background.
I have chosen ‘Circles and Stripes’ for my Excel Files. Here is my tiny snapshot of Excel Title Bar.
One Workbook One Window
In Excel, each workbook has its own window. You can now work with two workbooks at a time. If you use two monitors, your life will be easier with this option.
Recommended Pivot Tables and Recommended Charts
Say you have some names. For example, one name is ‘Robert De Niro’. Other names also consist of three parts like ‘Robert De Niro’. You want to separate the first name, middle name and last name in separate columns. With fill flash, you can do it easily.
Enter the first name in the column next to your data and Press Enter.
Start typing the next name. Fill Flash will suggest the first part of all names. If it is what you wants, Press Enter.
Now we type the last part of the name in the next column. We type it in lowercase and press Enter.
Start typing the next name. Fill flash will suggest the last name this time in lowercase. Press Enter. You can separate middle name same way.
Microsoft Office Support Apps
Apps increase the power of an application. Say last month I have earned £50,000 and from different sources. I want to calculate the percentage of earning from different sources. I can take the help of an Apps that will calculate for me. Observe the following images.
To insert an App, you have to use this command: Insert ⇒ Apps ⇒ Apps for Office
I have used here a free Percentage Calculator app. You can download this Apps and get an idea how Office Apps work. See the following image, how it is making my job easier.
From multiple data tables, we can create pivot tables in a relational manner. We shall discuss more in the relevant section of the Data Model.
Read more: Using data model in Excel 2013
New Slicer Option
Slicer feature was introduced in Excel 2010. It is used with Pivot Tables. In 2013 Slice Options can be also used with tables.
Read more: What is a slicer in Excel?
Read more: Filtering Pivot Tables with slicers in Excel
Timeline Filtering of Data
You can filter data by dates with slicer. With Excel 2013, you can filter data with Timeline. We shall discuss more in the relevant section.
Read more: Filtering Excel Pivot Tables with a timeline
If you click two or more cells with data, you will see the Quick Analysis Options near the AutoFill. Click it and you will find tools like Formatting, Charts, Totals or another tool. Tool options may differ with your selection of data.
See the image below.
Enhanced Chart Formatting
You can modify charts more easily now.
50 New Functions Added
Excel 2013 has added around 50 new functions for your use.
You will find the backstage screen is more organized and easier to use.
Newly Added Add-ins
Three new add-ins PowerPivot, Power View and Inquire have been added. They are only available in the Office Professional Plus version.
Happy Excelling 🙂