SkyDrive
Save directly to SkyDrive
What’s the new tool?
SkyDrive, Microsoft cloud storage service,
is integrated into each of Office 2013’s new programs. So when you click ‘Save
as’ in any program, you can choose to either save the file on your computer or
upload it straight to SkyDrive.
Save
directly to SkyDrive
How can I get it for free?
You can install the SkyDrive Desktop app
free from bit.ly/skydrive312. This works with Windows Vista, 7 and 8, as well
as Mac OS X Lion computers. It adds a direct link to your SkyDrive account to
your favorites list in Windows Explorer. Now, when you click ‘Save as’ in any
program (it doesn’t have to be Office software), you can save the file straight
to be cloud, without needing to open your browser or sign into your account.
You can also drag and drop photos, videos and other files from your PC into
your SkyDrive folder.
The SkyDrive mobile app
(apps.live.com/skydrive) is available on Xbox, Android, iOS and Windows Phone.
Openote
Sync notes across devices and clip web
pages
What’s the new tool?
OneNote
(office.microsoft.com/en-gb/onenote) is Microsoft’s digital note-taking program.
It can be used for to-do lists, sketches and doodles, and you can import
documents, tablets, audio and videos. The 2013 version lets you sync files
across PCs and devices, and clip and save information from the web using its
Send To OneNote tool. OneNote is available on Windows XP, Vista, 7 and 8,
Android, iOS, Windows Phone and Symbian.
How can I get it for free?
Evernote (evernote.com) has many of the
same features of OneNote, but for free. It’s also available on more platforms:
Windows XP, Vista, 7 and 9, Mac OS X, Android, iOS, Windows Phone, BlackBerry
and Web OS.
Evernote lets you add to-do lists, and
typed and ‘handwritten’ notes; import files; record and add audio notes; save
video; clip web pages, and more.
When you download and sign into the Evernote
Desktop and mobile apps, all your files and notes are automatically synced and
can be downloaded to your local hard drive.
To get you advanced note-taking options,
you can download Evernote add-ons including the Web Clipper
(evernote.com/webclipper) for Chrome, Firefox and Safari, which makes it easy
to clip online pages to Evernote straight from your browser.
The Skitch app (evernote.com/skitch) for Windows,
Mac, Android and iOS, has advanced sketching and annotation tools, while
Evernote Food (evernote.com/food) stores recipes, cooking tips and restaurant
review, cooking tips and restaurant reviews. You can get more add-ons from
evernote.com/download.
Excel
Excel filter chart and add slicers
What’s the new tool?
Excel 2013 makes it easier to filter data
in tables and charts. Because the options appear automatically when you select
cells or create a chart. These options aren’t new, however, and you can do the
same tasks, albeit in a more roundabout way, I Office 2007 and 2010.
Slicers, which were first introduced in
Office 2010, have been made more prominent in Excel 2013. They make it easier
to color-code data within a table, and work like an extra filter.
Excel
filter chart and add slicers
How can I get it for free?
The simplest way of adding filters to your
tables is by going to Data, Filter. For more advanced filtering options, or if
you want to filter data in a chart, create a PivotTable. To do this, select a
cell in your worksheet and go to Insert, PivotTable. Create your table by
selecting Row and Column headers, Values and Report Filters. You can then
filter the information using the arrows.
From the PivotTable Tools menu, go Options
and click Pivot Chart. Choose a type and your data will be turned into a graph.
Click the chart to get the filter options.
You can now add and remove parts of the chart to see different variables. Learn
more about PivotTable at bit.ly/pivot312.
To add slicers to a PivotTable, go to
Insert and choose Slicer. In the Existing Connections box, click Show and
choose how you want the slicers to appear. You can read more information about
slicers at bit.ly/slice312.
Powerpoint
Edit slides live and stream your
presentation online
What’s the new tool?
The Presenter View in PowerPoint 2013 lets
you view your speaker notes and annotate slides on your tablet, for example,
while presenting the slides on another screen.
PowerPoint 2013 also has a feature called
Present Online, which streams your presentation over the web to any PC with the
link.
How can I get it for free?
Office 2007 and 2010 already have Presenter
View: you just need to enable it by going to the Slide Show menu and ticking
Use Presenter View. It will check for additional monitors and connected
screens. You can then choose which monitor is used for the presentation and
which is used for your speaker notes.
Edit
slides live and stream your presentation online
Alternatively, if you want to present an
online presentation, sign up to Prezi.com (prezi.com). the free version lets
you create collaborative online presentations that can be shared with others,
or you can shared with others, or you can stream presentations in real time by
clicking Present Online from the editing screen. You can also save
presentations, and download them for offline use.
If you upgrade to a Pro account for $59 a
year, you can also edit presentations offline, and use the iPhone, iPad and
Desktop apps.
