Make the most of your data when you use Microsoft Excel 2013, offering new features such as instant data analysis and individual windows for workbooks.
Excelling in looks
Exploring your data in Excel 2013 has a whole new streamlined look that helps you to get the results you need quickly. You can get started in no time thanks to the range of spreadsheet templates on offer, such as calendars and budgets, so you can make the most of your spreadsheets. This spreadsheet software now includes Flash Fill, which senses what you want to do and enters your data all at once, recognising patterns – in essence, more intelligent worksheets.
You can analyse your data in no time thanks to instant data analysis, allowing charts and tables to be made in only two steps. Previews of data are available, and Excel can also recommend a suitable chart for your data, so you can preview them and select your choice.
Comparing workbooks won't be a hassle now that they each have their own window, and there are a variety of ways to share your files, such as a cloud-based service (internet connection required), so that everyone can work on spreadsheets at the same time.
Excel has become smarter thanks to the new calculations and Excel functions, and you can now save files in the .xlsx Strict Open XML Spreadsheet format. This allows you to write ISO8601 dates.
Pivot tables aren't as daunting in Excel 2013 as it recommends ways to summarise your data so you can be confident you are selecting the right information. There are a range of new pivot table options that make analysing data an easier task. Use the Excel Data Mode to create multiple tables for data analysis, establish relationships between them and unlock even more results.
Access different levels of detail using the Drill Down, Drill Up and Cross Drill functions, and using Power View you can discover insights about your data by interacting with charts, slicers and other visualisations.
Take an in-depth look at your data with Microsoft Excel 2013.
Product code: 043356