Buzz
The release of Office 2013 brings fresh experiences to users, not only in terms of interface but also with integrated, helpful features. Let's explore the widely used features in Excel 2013.
Top Features Embraced by Users in Excel 2013
Flash Fill
This feature intelligently guesses data and automatically fills cells in the spreadsheet. It's a fantastic tool in Excel 2013. For example, if you have a column for Full name and want to separate it into First name and Last name.
Here's how to use Flash Fill:
- Go to the Data tab → Flash Fill
- Results Obtained
Recommended Charts
When you have a dataset and want to create a chart from it, selecting the right chart type can be confusing if you don't have specific requirements. With the Recommended Chart feature, it suggests suitable chart types based on your dataset.
Here's how to do it:
- Step 1: Select the data range for the chart → Insert tab → Recommended Chart
- Step 2: Choose the chart type you want → OK.
Recommended PivotTables
If you're familiar with Excel, PivotTables are likely not new to you. The functionality of Recommended PivotTables is similar to Recommended Chart, but instead of charts, you'll be selecting PivotTables.
Here's how to use it:
- Step 1: Select the data range for the PivotTable → Insert tab → Recommended PivotTables
- Step 2: Choose the PivotTable you want to display → OK.
Quick Analysis
This is a relatively new feature in Excel 2013. It allows you to quickly perform tasks on selected data ranges such as formatting, charts, totals, tables, and more. To use this feature, simply select the data range → click the Quick Analysis button (or press Ctrl + Q) in the bottom right corner of the data range.
Cloud Database
This is a new and highly valued feature of Office 2013 by Microsoft. It enables you to store your Excel spreadsheets in cloud databases like SkyDrive. This allows you to access your spreadsheets from anywhere (phone, tablet) as long as you have an internet connection, without needing to carry a computer with Office 2013 and a cumbersome USB drive for data.
To do this, it's very simple, you just need to select Save as → One Drive (SkyDrive)
Our article has introduced some of the best features according to Mytour's evaluation, but there are many other great features in Excel 2013. You can spend time exploring more features and giving your own opinions. Additionally, you can refer to articles: alternating row colors in Excel, Inserting text, watermark logo in Excel 2013, ...
