Ten Tips for Office 2013

By Stuart Box

Office 2013

Microsoft Office 2013 is here

Available in several different versions, Office 2013 is part of the Office 365 subscriptions as well as a stand-alone product. Users will find it’s a big change if they move from Office 2003 or earlier, but if they’ve been introduced to Office 2007 or 2010 then the upgrade isn’t too scary. We can now offer any of our Microsoft courses in Office 2013 and have developed specific Office 2013 Upgrade Courses to help you over the change and get the best out of the new software.

We’ve compiled a list of ten tips for Office 2013 to help you discover some of the features that this new version offers.

  1. To disable the Start screen for Word, Excel or PowerPoint, go to File, Options, General category and in Start-up options, check off “Show the Start screen when this application starts”.
  2. When using these commands, to display the Open and Save As windows, instead of Backstage view, go to File, Options, Save category and put a check in “Don’t show the Backstage when opening or saving files”.
  3. You can now Auto-hide the ribbon so it only shows when you want it.  At the top right of Excel, Word or PowerPoint, just along from the Close and Restore and Minimise buttons is a button called “Ribbon Display Options”.  Click on this and it will display different ways that you can show and hide the Ribbon.
  4. In Outlook, you can take a “Peek” at another Outlook area whilst reading email. In the mail view, hover your mouse over the “Tasks”, “Calendar” or “People” navigation text at the bottom of the screen. A view will pop up of your Schedule, Tasks or Contacts. You can “Dock” this peek view by clicking on the icon in the top right of the peek view.
  5. You can now Open and Edit PDF’s in Word. When you open a PDF in Word you’ll get a message “Word will now convert your PDF to an editable Word document. This may take a while. The resulting Word document will be optimized to allow you to edit the text, so might not look exactly like the original PDF, especially if the original file contained a lot of graphics.” This is both very useful and worrying, as many people use PDF’s to transport data “because they can’t be edited”, but now with Word 2013 they can.
  6. In Word, to translate your document into another language, click on Translate icon on the Review tab and choose Entire Document or Selected Text.
  7. In Excel, you can now use Slicers to filter data that has been formatted as a table. To format your data as a Table, click into your data and on the Home tab, click on Format as Table. Then on the Insert tab click on Slicers to create a slicer for the selected table.
  8. In Excel, create Pivot Tables for multiple data ranges by formatting your data as a table and then, when you create a Pivot table, simply put a tick in “Add this data to the Data Model” check box.
  9. In PowerPoint, the default slide size is now for Widescreen.  If you require, use the Design tab and the Slide Size icon the change back to Standard screen size.
  10. In your Outlook Calendar, to make appointments for different time zones, click on the Time zones Icon on the Appointment tab.  Select a time zone from the dropdown and then set a time for the appointment in this time zone.  The appointment will be added to your calendar in your time zone.

These are a selection of the many new features of Office 2013, there are some big new additions too, like PowerPivot and Power View in Excel which we’ll cover in more detail later on.

So, what do you think of Office 2013 are you using it yet? like it or loath it? leave us a message to let us know your experiences.

Leave a Reply

Your email address will not be published. Required fields are marked *