Menu
Microsoft has launched the new Office 2013. Here we are talking about some new Excel 2013 features.
In Excel, Flash Fill makes it easier to automate filling out columns. Quick Analysis allows you to hover over data and get suggestions for the best way of formatting the information in tables and charts. With the modern feel and easy navigation experience acknowledged, cloud-based services using Microsoft SharePoint and SkyDrive.
Otherwise the quick analysis tool shortcut will not show up. Excel (2016) 1: 9: Absolute Value Cell shortcut key is F4. Many keyboards require the use of a function + F4 in order for the function key to operate. Mac users please see above section for assistance or just type in the '$' symbol in the correct locations. Quick Access Toolbar is a universal toolbar that is always visible and is not dependent on the tab that you are working with. For example, if you are in the Home Tab, you will not only see commands related to Home Tab but also the Quick Access Toolbar on the top executing these commands easily.
Excel 2013 provides us an easy way to organise data in a simplified manner and it also has a great user interface experience. Excel 2013 comes with a new design and modern splash screen that loads faster. In this article we will try to discover the new features in Microsoft Excel 2013. We will discuss the new features of Quick Analysis that allow us to organize and analyze data easily. It has a new powerful user interface tool with a set of analysis features that provides access to data analysis features. This includes formulas, conditional formatting, Sparklines, tables, charts, and PivotTables. We can use any of these features by clicking on them and the result is reflected on your screen immediately.
It gives us a shortcut to data analysis. Here we take an example to show the Quick Analysis tool feature in Excel 2013. Step 1: Open the Microsoft Excel 2013 Preview. Step 2: Open a new Workbook. Step 3: Here we create a data table. Step 4: After creating the table, select the table. You will be shown a popup button at the bottom-left side.
Click on the Quick Analysis button. Step 5: You will be shown a toolbar with many data analysis features. Select anyone and use it. Here we are creating a chart on the selected data. Step 6: Select the type of the chart you want to create or you can also click on more chart options to get a list of all charts in Excel 2013. Step 7: After selecting the charts you wil see that it appears on your Excel sheet.
. When you select a range of cells, a small icon appears in the lower right corner of the selected area. This is the Quick Analysis icon, and clicking it opens a panel containing shortcuts to several types of common activities related to data analysis. Click on of the five headings to see the shortcuts available in that category. Then hover over one of the icons in that category to see the result previewed on your worksheet:. Formatting: These shortcuts point to conditional formatting options.
For example, you could set up a range to make values under or over a certain amount appear in a different color or with a special icon adjacent. You can use Quick Analysis to add summary rows or columns. Tables: You can convert the range to a table for greater ease of analysis. You can also generate several different types of PivotTables via the shortcuts here. A PivotTable is a special view of the data that summarizes it by adding various types of calculations to it.
The PivotTable icons aren’t well-differentiated, but you can point to one of the PivotTable icons to see a sample of how it will summarize the data in the selected range. If you choose one of the PivotTable views, it opens in its own separate sheet.