Flash Fill You may need to separate first and last names (or product names and numbers, or any other data) into separate columns. New Excel 2013 feature Flash Fill can help you quickly fill in all the data. Flash Fill can recognizes your data and follow its pattern, and then enters the rest of your data in […]
Recommended Charts will recommends the most suitable charts for your data. You can get a quick view to see how your data looks in the different charts. Create a chart Select the data for which you want to create a chart. Click Insert > Recommended Charts. On the Recommended Charts tab, scroll through the list of charts that […]
It used to take a bit of work to analyze data using Excel, but now it only takes a few steps. You can instantly create different types of charts, including line and column charts, or sparklines. You can also apply a table style, create PivotTables, quickly insert totals, and apply conditional formatting. If you are […]
Recommended Charts can quickly analyze your data and suggest the most appropriate charts to you. Select the data for creating chart. Click [Insert] > [Recommended Charts]. On [Recommended Charts] tab, scroll down and select the chart suggested by Excel. Use the [Chart Element], [Chart Style] and [Filtering] button to create new chart item. (Such as […]