BLOGS BY TOPIC
BLOGS BY AUTHOR
BLOGS BY YEAR
Excel 2013 contains radical changes to charts, pivot tables and the user interface. This review explains all the new features of Excel 2013
Posted by Andy Brown on 30 January 2013
You need a minimum screen resolution of about 700 pixels width to see our blogs. This is because they contain diagrams and tables which would not be viewable easily on a mobile phone or small laptop. Please use a larger tablet, notebook or desktop computer, or change your screen resolution settings.
Excel 2013 changes: working with files
There are lots of changes to the way that you can open, share and export files. Let's start with what the file dialog boxes look like.
When you choose to open a file, you see the following:
A beautifully designed "dialog box" - it could hardly be easier to use.
You can right-click on a file to pin it to the list of recent workbooks, or to remove it.
When you click on Computer, you see recent locations that you've used - again, a brilliant idea and implementation:
You can click on Browse to find the folder you want, but I suspect that after a while you'll nearly always be able to choose it from your list of recently used locations.
Microsoft have gone cloudy! You can save files to the cloud using SkyDrive (more on this below), although first you have to sign in to your Microsoft account:
When you click on SkyDrive, this is what you first see.
When you sign on with your Microsoft account (if you've got a Windows Live one, it's the same), you can create files and folders:
Here I've created 3 files.
You can also use web-based cut-down versions of Excel, Word and PowerPoint to edit Office documents online.
You can open any Excel workbook either into your desktop copy of Excel, or using the Excel web app.
All in all, it's a seamless way to save files directly from MS Office into the cloud.
I have to say I'm impressed with SkyDrive. It shows up as a normal folder in Windows Explorer, and you can choose exactly which files and folders to synchronise. For the first time I can see the benefit of cloud computing!
Saving to social networks
You can save any Excel workbook to Facebook, Twitter, LinkedIn, etc:
Four services are provided by default.
You now have copious amounts of ways to share documents, including the ability to invite people to work with it:
You can email workbooks out in various ways too ...
When you export a workbook, another very well-designed "dialog box" (perhaps I should stop using this term?) makes everything very easy:
I only mention this because you can also import a PDF document into Word and then save it as a Word document!
Choosing what will be browsable online
You can embed Excel workbooks on webpages or share them online. Browser view options allow you to specify which worksheets (or even which named ranges) are viewable and/or editable online:
Browser view options work in a similar way to the way protection works.
I hope I've given an impression of how much work Microsoft have put into making working with files easy. They have invested a huge amount of time in SkyDrive!
One last statistic: my SkyDrive folder shows up as having 25GB of space. That's a serious bit of cloud.
Time now to look at changes made to working with data and pivot tables.