Microsoft Office 2013

What’s new in OFFICE 2013

Many of you have heard about Microsoft’s latest version of their office suite aptly titled Office 2013. Here at Mary Baldwin we are using Office 2010 which, was officially released in the fall of 2009. As Mary Baldwin starts to migrate to Microsoft’s latest offering, we thought it would be worth writing about some of the differences between the two versions. Many of the changes are cosmetic as the software giant has updated the look and feel of their latest suite to reflect that of its later consumer operating systems. Added to all the applications is the integration with Microsoft’s cloud-based storage – OneDrive which was previously known as SkyDrive. I will briefly highlight some of the non-cosmetic differences in the various applications found within the latest suite as compared to its most recent predecessor.

Short Video showing marking up a Word 2013 document with the touch screen monitor 

Word

Quick Start PDF – click here.

Touchscreen Monitor
Click on Review and Start Inking to write on the word document with a stylus on the Touchscreen Monitor. If the pens do not operate the way you want them to, check to see if the document was created with an earlier version of WORD and is in “Compatibility Mode”.  If so, try saving the document in WORD 2013 and that should fix it.

Live Layout
This nice little feature allows you to move in-line images around the document. As you are doing so, your text will automatically wrap around the picture thus giving you a live preview of the new layout.
Simple Markup View
Microsoft has brought us the Simple Markup View which refines the look to remove some of the clutter from previous versions when collaborating on a document. For example, the tracked changes in previous versions were directly marked or scattered on the page. In the new version, a red bar on the left will display the tracked changes when hovered over leading to an overall cleaner look.
Insert Online Pictures and Videos
You may now put pictures and videos from online services (copyrights do still apply) inside your document without having to save them directly to your computer first.
Distraction free Read Mode
Read Mode hides the toolbars and other distractions to allow you to focus on your content. This doesn’t mean that you are limited. You still have the ability to highlight text, copy, change the layout, search, and even add comments. So that you don’t forget where you left off, when you reopen the document, Word will remember the page you were on.
Edit PDF files
A welcome addition to Word is the ability to EDIT a PDF file. In the past, this required a program such as Adobe Acrobat Pro. You may now open, edit, then save as a pdf or a docx file all within the application.

Excel

Quick Start PDF – click here.

The industry leader in spreadsheet applications, Excel has brought some new and improved ways to help you manage and analyze your data.
Flash Fill (Auto fill)
With Flash Fill enabled, Excel will look for patterns when putting information in columns. Let’s say for example, Column A has your students firstname lastname and Column B has their initials. As you are entering their initials in Column B, Excel will recognize this and offer to flash fill the rest of the column.
Quick Analysis
By selecting specific data, Excel will do a quick analysis and offer to present it in charts, tables, or sparklines.
Chart Recommendation
Speaking of charts, Excel will simplify the task of choosing one based on the content of your data.
Use of Timelines
Add a moveable timeline to your chart to filter through selected dates. This allows you to easily show information relevant only to the time period needed such as 6 months, latest quarter, April 1st through July 4th, etc.
Improved Data Analysis
Using the built-in data model, it is easy to link multiple tables together and generate powerful pivot reports.

PowerPoint

The slide presentation software has improved in ways to both help with creating your presentations and work with modern presentation equipment. Video – click here.

Quick Start PDF – click here.

New Default Start Screen
Instead of opening to a blank template, PowerPoint presents you with the option to:
Use a template, a theme, a recent presentation, older presentation, or blank presentation.
Improved Support for Audio and Video
PowerPoint better handles the usage of videos on your presentation. In addition to natively handling the insertion of MP4 and MOV files, you may also export your presentation to MP4 or WMV format. Likewise, it also natively supports many audio formats such as MP3, WAV, and WMA to name a few. It is now much easier to play audio files across the entire slideshow.
Widescreen Format
With the proliferation of widescreen displays in offices and conference rooms, Microsoft has made 16:9 the default slide size.
Improved Guides
Although these exists in PowerPoint 2010, both Smart Guides and Static Guides were improved upon in 2013. With Smart Guides, which show up only when moving an item on the page, Microsoft now makes it easier to have equidistant alignment between shapes. Static Guides are shown until you remove them. They have also improved the context menu to make it easier to work with those tools.
Enhanced Presenter View
For those who like to rehearse their presentation, you may now access Presenter View even if you only have one monitor. Other options include the ability to click a thumbnail of your slide to quickly access it along with a zoom option to draw attention to a specific area on the screen.
Add focal points to your presentations
Improved laser pointer and pen tools along with zoom features allow you to draw your audience’s attention to the points you want to emphasize.
Page Setup
Page Setup has moved!  Video here describing the change.
Quarter Screen Slideshow
In your Powerpoint file, click on File, Slide Show and Set Up Slide Show. Change the Show type to “Browsed by an individual (window). Now when you start your Slide Show it will present within a Windows pane and you can click on the interlocking squares and then drag the edges of the display to adjust the size and position of the window.

 

 

Outlook

Quick Start PDF – click here.

The email, calendar, and contact software has improved in ways to make it easier to navigate your world to access the information you need at your fingertips.
Quicker Access to Your Information
Use the improved navigation bar to quickly open up your email, calendar, and contact lists.
One-Click Access to Unread Emails
For those who don’t practice good inbox hygiene, Microsoft has added the ability to show only unread email at the click of an “Unread” button.
Take a Peek at Your Schedule
You can peek at your schedule without having to leave an email just by placing your cursor over the calendar icon.
Attachment Reminder
If you are one of those who has sent an email and then remembered that you forgot to attach your file, this is a welcome feature for you. If you refer to an attachment in the body of your email and hit send without first attaching it, an attachment reminder window will open prompting you to review.

Other Microsoft Applications that may be installed on your PC

Access

Quick Start PDF – click here.

The next big thing is the Web App. Microsoft is betting big time in the merging of SharePoint and Access in building web-based solutions.
New Database Type – WebApp
A web app is a new type of database that you build in Access which is available through either SharePoint or your web browser to share on your local network or internet. Building your app is simple, you select the type of data you want to track then Access creates the database structure, complete with views that let you add and edit your data. Access is based on Microsoft’s SQL Server technology. Navigation is easy, as the basic commands are built-in, so you can start using your app right away.
Drag and Drop Form Designer
Quickly customize your web app using a simple drag and drop interface. Web developer expertise not required!
Creating and Running Desktop Databases
Even though Access 2013 focuses on the web, it is still backwards compatible with your existing desktop databases (ACCDB/MDB/VBA).

Publisher

Quick Start PDF – click here.

Although not as big of an upgrade as compared to Publisher 2010, Microsoft’s print page design software did manage to throw in a couple of new aspects to make it easier to create that sparkling brochure or pamphlet.
Working with Pictures
You may easily take your image and set is as a page background. Why relegate your favorite pet Fido to just a corner when he can become the center of attention? Just as easily, you can quickly swap two images with the click of a mouse. Both these features are indeed in 2010 but not easy to locate. Speaking of working with pictures, added are new and improved visual effects such as shadows, reflections, glows, bevels, and 3-D rotations. Also along with other applications in this suite, you may use pictures directly from the cloud without first having to download.
Send to Online Print Services
Should you choose to send your creation to a professional print shop, you may do so by selecting the new Photo Printing option. This gives you the ability to save in JPG or TIF format eliminating the requirement to the other party for opening PUB files.

OneNote

Quick Start PDF – click here.

OneNote is a digital notebook for capturing, storing, and sharing all kinds of information. The first thing you’ll see when you open OneNote 2013 is a fresh, clean look that lets you focus on your thoughts and ideas instead of the interface. Full integration with the cloud means you can free your files from your computer’s hard drive so your notes and information are saved and searchable wherever you go — on nearly any mobile device, tablet, or browser.
Draw, Sketch, or Handwrite Notes
Easily keep notes by drawing and editing with your finger, stylus, or mouse on any touch-capable device, such as a Tablet PC, phone, or Windows PC. OneNote can even automatically convert your handwritten notes to text by the use of Inking.
Improved Search Capabilities
Expanded search capabilities gives you the power to locate and recall anything you’ve ever created or saved inside your notes. Type in your search term and OneNote will search through lengthy text files. It even checks through the text within a picture!
Access Your Notes from Anywhere
With an OneDrive account, you can store your files in the cloud and access them anytime from anywhere on almost any device. You have the capability of syncing and opening the most current version of notes.
Embed Files into Your Notes
Use the Send to OneNote tool to clip and embed whatever you are seeing on your screen. You may send almost any computer file to your notes; from a web page, PowerPoint presentation, Excel spreadsheet, or Visio diagram. You can edit the information right on the spot.
Easily Collaborate with Friends or Coworkers
Thanks to OneNote’s integration with cloud services from Microsoft’s SharePoint and OneDrive, it is now easier than ever to work together. Simply allow authorization to whomever you want to share with, send them the URL and they can view and edit your notes from anywhere. If they don’t have OneNote they may still view your notes from a web browser.
What else?
Other features of OneNote are the ability to automatically save and sync your notes while you work and export to different file formats for those who don’t have the software.

Additional Resources:

All Office 2013 Quick Start Guides

Vlookup Tutorial

Information obtained from Microsoft sources here.

X