Skip to main content

Excel 2013

This page is intended to give an insight into some of the new enhancements Microsoft have included in Excel 2013. For more more detailed information see the links at the bottom of the page

New start screen

Excel's new Start Screen helps you get to work more quickly. A range of templates appears here to help you quick start a project

The Backstage View

The Backstage View, introduced in Office 2010, can be accessed form the File menu. In Excel this has been revamped to show exactly what you are doing so you can choose the appropriate task

Flash Fill tool

This is a new feature that uses predictive data entry to detect patterns and extract and enter data that follows a recognised pattern. For example if you wanted to find a person's first name from a column of full names, all you need to do is use a blank column adjacent to the one that contains full names and type the first name, then click the Home tab, and select Fill, Flash Fill. The first names of everyone in the list will be automatically entered into the new column

Chart Tools

The Chart Tools tab is simpler in Excel 2013, with only the Design and Format tabs to choose from. Additional icons appear outside the top right edge of a chart when it is selected. Click any of those buttons: Chart Elements, Chart Styles or Chart Filters and additional chart formatting options will become available. Click Chart Elements to add or remove elements, such as axis titles and legends; click Chart Styles to change the style and colour of your chart; or click Chart Filters to view filtered data using a live preview

Quick analysis Tool

The new Quick Analysis tool can help users find options for working with selected data. To use it, select the data you want to analyse, and the Quick Analysis icon will appear in the bottom-right corner of the selected data. Click that icon, and a dialogue appears showing a range of tools for analysing the data, such as Formatting, Charts, Totals, etc

Easier to get started with Pivot tables

Pivot Tables are a powerful tool for analysing and answering questions about your data, but they are not easy for new users to create. For the first time, though, if you can click a mouse key, then you can create a meaningful Pivot Table, thanks to the new Recommended Pivot Tables. To use it, select your data, including headings, and choose Insert, Recommended Pivot Tables. All you need do is to select the table that shows what you want to see, click OK, and the Pivot Table is automatically drawn for you

Further Information