We use cookies to provide you with a better experience. If you continue to use this site, we'll assume you're happy with this. Alternatively, click here to find out how to manage these cookies

hide cookie message
Office software Reviews
15,669 Reviews

Excel 2013 review - new features mean powerful analysis tools for everyone

Office costs from £109 inc VAT

Manufacturer: Microsoft

Our Rating: We rate this 4 out of 5

Improvements in Excel 2013 should mean that everyone can use its more advanced features. Here's our Excel 2013 review.

Excel 2013

As Word 2013 is to word processing, Excel is to spreadsheets, being the best known and widest used application of its type. Where Word has competition from WordPerfectLibreOffice, OpenOffice Writer, and Google Docs, the equivalent spreadsheet programs in these suites don't challenge Excel and Office 2013 in the same way. See all Office software reviews.

The new features in Excel 2013 are more fundamental than those in the new Word and include things like Flash Fill and Quick Analysis. To try and make them more obvious, some now appear as pop-up icons, rather than being buried on a ribbon tab somewhere. See all: PC Advisor software downloads.

Flash Fill makes it much easier to separate out data in the form of text or dates. For example, if you have a column of full names – forenames and surnames – you have imported from another source, perhaps off the Internet, you can extract all the surnames by typing the first surname as an example and clicking Flash Fill. Excel 2013 picks out the corresponding surname from each of the other full names in the list.

In the same way, you could extract the months from a list of dates or the pounds from a financial list. You can concatenate text, too, just by giving an initial example. Flash Fill is a one-off treatment, like Excel's existing ability to fill a series of cells with the days of the week or months of the year; it doesn't put formulas into the destination cells, so if the source data changes, the extracted or concatenated data doesn't.

Quick Analysis is a way to preview and add charts or spark lines to a spreadsheet even more quickly. When you highlight cells in a column of data, an icon appears at the bottom right of the selection. This pulls up a small pane for formatting, charts, totals, tables and sparklines, and hovering the mouse over any of the icon options, previews how the data or chart will look with those options applied.

You can perform quick totals, averages and other statistics and draw bar, line and dot charts without ever committing them to your spreadsheet – though a single click will fix them on the worksheet, when you find what you want.

Excel 2013

Excel can now recommend ways to view your data by suggesting the best choice of pivot for your pivot table. Pivot tables are not for the fainthearted, but can help reveal the underlying trends in sets of data. Knowing how to translate the data in a worksheet to give the most useful view is something which comes with experience, so it's a help to have software assistance in making the right choice.

Say you have a worksheet listing customers' details and what they've bought with you in the last year. It might be worthwhile checking if there's any correlation between their gender or where they live, and the amount they've spent. This is ideal for a pivot table and Excel 2013 should be able to suggest how best to construct it.

Excel 2013 takes on the new flat look the whole Office suite has been given, but apart from the cosmetic changes, it makes little difference to the way the application works. Collaboration is facilitated by saving a worksheet to SkyDrive and sharing it, but can then only be simultaneously accessed via the Web version of Excel. You can use the full Word and PowerPoint apps when sharing their documents in the same way.

New features in the new Excel are mainly aimed at the less experienced, to bring out the powerful analysis tools that it contains and get more people using them. There's less for the power user in Excel 2013, though Flash Fill and Quick Analysis are useful productivity snippets. Read our full Office 2013 review. For more business software reviews visit Business Advisor.

Excel 2013 Expert Verdict »

Microsoft Office Professional 2013 reviews verified by Reevoo

Microsoft Office Professional 2013Scores 8.6 out of 10 based on 8 reviews
1 GHz or faster x86 or 64-bit processor with SSE2 instruction set
1 GB RAM (32-bit)
2 GB RAM (64-bit)
3.0 GB available disk space
Graphics hardware acceleration requires a DirectX10 graphics card and 1366 x 768 resolution
Windows 7, Windows 8, Windows Server 2008 R2, or Windows Server 2012
Microsoft Internet Explorer 8, 9, or 10
Mozilla Firefox 10.x or a later version
Apple Safari 5
or Google Chrome 17.x
.Net version: 3.5, 4.0, or 4.5
A touch-enabled device is required to use any multi-touch functionality
  • Overall: We give this item 8 of 10 overall

New features in the new Excel are mainly aimed at the less experienced, to bring out the powerful analysis tools that it contains and get more people using them. There's less for the power user in Excel 2013, though Flash Fill and Quick Analysis are useful productivity snippets.

  • OpenOffice Calc

    Calc is OpenOffice's spreadsheet application and, as with Writer, compares very well to its Microsoft Office equivalent.

  • GS-Calc 10 review

    GS-Calc 10

    GS-Calc 10 is an inexpensive spreadsheet program that isn't an Excel clone. Here's our GS-Calc 10 review.

  • Star Office 8.0

    Star Office 8.0

    In recent years, thousands of corporate desktops have begun to adopt either StarOffice or OpenOffice. Our review of Star Office 8.0, the latest version of Sun's low-cost Microsoft Office-killer, shows why.

  • OpenOffice 2.2

    OpenOffice 2.2

    OpenOffice 2.2 is the latest update of the open-source rival to Microsoft Office 2007. Our OpenOffice 2.2 review shows that there is plenty to recommend the free alternative.

  • Apple iWork '08

    Apple iWork '08

    With iWork '08, the latest generation of its office suite, Apple has given Mac users a powerful alternative to Microsoft's Office for Mac.

IDG UK Sites

Spotify launches on PS4 as Tidal arrives on Sonos: It's Tidal vs Spotify music streaming

IDG UK Sites

It's World Backup Day 2015! Don't wait another minute: back up now

IDG UK Sites

Adobe Comp CC iPad app review

IDG UK Sites

April Fool's Day pranks: play these geeky pranks on April Fools Day and fool your friends