Quadra

Connecting Technology and Business.

Preventing Macro-based Malware Attack, the Microsoft Way

Macro-based malware is on the rise and Microsoft understand it is a frustrating experience for everyone. To help counter this threat, Microsoft is releasing a new feature in Office 2016 that blocks macros from loading in certain high-risk scenarios. 

Macro-based malware infection is still increasing

Macro-based malware continues its rise. Microsoft featured macro-based malware in their Threat Intelligence report in 2015, but infections are still increasing.

Despite periodic lulls, infections for the top 20 most detected macro-based malware were high over the past three months.

https://msdnshared.blob.core.windows.net/media/2016/03/129.png

 

In the enterprise, recent data from their Office 365 Advanced Threat Protection service indicates 98% of Office-targeted threats use macros.

Note these are detections and not necessarily successful infections.

The enduring appeal for macro-based malware appears to rely on a victim’s likelihood to enable macros. Previous versions of Office include a warning when opening documents that contain macros, but malware authors have become more resilient in their social engineering tactics, luring users to enable macros in good faith and ending up infected.

Block the macro, block the threat

In response to the growing trend of macro-based threats, Microsoft has introduced a new, tactical feature in Office 2016 that can help enterprise administrators prevent the risk from macros in certain high risk scenarios. This feature:

  1. Allows an enterprise to selectively scope macro use to a set of trusted workflows.
  2. Block easy access to enable macros in scenarios considered high risk.
  3. Provide end users with a different and stricter notification so it is easier for them to distinguish a high-risk situation against a normal workflow.

This feature can be controlled via Group Policy and configured per application. It enables enterprise administrators to block macros from running in Word, Excel and PowerPoint documents that come from the Internet. This includes scenarios such as the following:

  1. Documents downloaded from Internet websites or consumer storage providers (like OneDrive, Google Drive, and Dropbox).
  2. Documents attached to emails that have been sent from outside the organization (where the organization uses the Outlook client and Exchange servers for email)
  3. Documents opened from public shares hosted on the Internet (such as files downloaded from file-sharing sites).

Let’s walk through a common attack scenario and see this feature in action.

Claudia is an enterprise administrator at Contoso. After a rash of macro-based malware attacks targeting her organization, she learns of this new feature in Office 2016 and has rolled out a Group Policy update to all Office clients on the network.

Stewart is a cybercriminal looking to attack and penetrate the Contoso network. Stewart uses macro-based malware because he’s had recent successes using it. He launches his attack campaign against Contoso by targeting James, an employee there.

James receives an email from Stewart in his inbox that has an attached Word document. The email has content designed to pique James’s interest and influence him to open the attachment.

Email with a macro-enabled attachment

When James opens the Word document, it opens in Protected View. Protected View is a feature that has been available in Word, Excel, and PowerPoint since Office 2010. It is a sandboxed environment that lets a user read the contents of a document. Macros and all other active content are disabled within Protected View, and so James is protected from such attacks so long as he chooses to stay in Protected View.

Word document instructing a user to enable macros to get out of protected view mode

 

However, Stewart anticipates this step and has a clear and obvious message right at the top of the document designed to lure James into making decisions detrimental to his organization’s security. James follows the instructions in the document, and exits Protected View as he believes that will provide him with access to contents of the document. James is then confronted with a strong notification from Word that macros have been blocked in this document by his enterprise administrator. There is no way for him to enable the macro from within the document.

Warning message appears in a document if macros can't be enabled

 

James’s security awareness is heightened by the strong warning and he starts to suspect that there is something fishy about this document and the message. He quickly closes the document and notifies his IT team about his suspicions.

This feature relies on the security zone information that Windows uses to specify trust associated with a specific location. For example, if the location where the file originates from is considered the Internet zone by Windows, then macros are disabled in the document. Users with legitimate scenarios that are impacted by this policy should work with their enterprise administrator to identify alternative workflows that ensure the file’s original location is considered trusted within the organization.

Final tips

For end-users, Microsoft always recommend that you don’t enable macros on documents you receive from a source you do not trust or know, and be careful even with macros in attachments from people you do trust – in case they’ve been hacked.

For enterprise administrators, turn on mitigations in Office that can help shield you from macro based threats, including this new macro-blocking feature. If your enterprise does not have any workflows that involve the use of macros, disable them completely. This is the most comprehensive mitigation that you can implement today.

- Microsoft Malware Protection Center

Email Safety Tips in Office 365

Today’s spam and malware attacks are sometimes so well-crafted they may look legitimate to users, and putting messages into the Junk Email folder isn’t enough. Microsoft has been rolling out Safety Tips in Exchange Online Protection, an additional layer of protection for all users that provides a warning to the user in an email that is marked suspicious, or a reassurance when a message is safe.

When a message includes a safety tip, the tip will be displayed in a messaging bar at the top of the email in one of four color-coded categories indicating that the message is either Suspicious, Unknown, Trusted or Safe.

  • Messages marked Suspicious have a red safety tip and are either a known phishing message, have failed sender authentication, are a suspected spoofing message or have met some other criteria that Exchange Online Protection has used to determine the message is fraudulent. You should not interact with suspicious messages and instead should delete them.

https://officeblogseast.blob.core.windows.net/wp-content/2016/04/Suspicious_Safety_Tip.png

  • A yellow bar at the top of the message indicates an Unknown safety level. Being marked as Unknown indicates that Exchange Online Protection has marked the message as spam. You can click the It’s not spam link in the yellow bar of a junk mail item to move the message to your inbox.

https://officeblogseast.blob.core.windows.net/wp-content/2016/04/Unknown_Safety_Tip.png

  • Messages from a Trusted sender display a green bar at the top of the message. These are from domains identified by Microsoft as being safe.

https://officeblogseast.blob.core.windows.net/wp-content/2016/04/Trusted_Safety_Tip.png

  • Messages marked with a gray safety tip indicates that the email was not filtered for spam because it is either considered Safe by the user’s organization, is on the user’s safe senders list or Exchange Online Protection marked the message as junk but the user moved it out of the junk folder to the inbox. The gray safety bar also appears when images within the message have been disabled.

https://officeblogseast.blob.core.windows.net/wp-content/2016/04/Safe_Safety_Tip.png

All four types of Safety Tips are included in the Outlook on the web experience, whereas Outlook clients, whether desktop or mobile, will display only the Suspicious safety tip. Most messages in your inbox will not have a safety tip; we only add them when we have information users need.

How does Microsoft determine which Safety Tip to apply?

As an industry-leading solution for securing your email, Exchange Online Protection analyzes data patterns across millions of emails to identify spam, malware and phishing threats. Based on this ongoing analysis, Exchange Online Protection is able to identify suspicious messages and apply the appropriate Safety Tip.

Users can also report misclassified messages back to Microsoft for analysis. They will take these samples and use them to make user experience better.

Safety Tips are an important tool in combating phishing scams and online fraud. With this new functionality, Office 365 automatically provides an additional layer of protection for all its users. Microsoft will continue to enrich the Safety Tips feature to ensure their users have the best experience.

- Gleaned from Office Blogs

MAXImise productivity & MINImise confusion - Use MAXIFS and MINIFS

If you’re familiar with statistical functions like COUNTIFS, SUMIFS and AVERAGEIFS, then MAXIFS and MINIFS don’t need much explanation.

The classic MAX and MIN functions calculate the maximum or minimum value in a range, but what if you need to apply conditions to filter your data? This is precisely what MAXIFS and MINIFS allow.

Now you can apply conditions and filter data before calculating with MAXIFS and MINIFS in Excel.

The MAXIFS and MINIFS functions are available if you are an Office 365 subscriber and have the latest version of Office installed on your PC. It is also available in Excel Online and in Excel Mobile or Excel for Android phones and tablets.

 

You can specify one or more conditions that filter the data before calculating the max or min. The conditions can be applied to adjacent ranges or the range that contains the values. For example, let’s say a retailer has a table containing sales data for all their stores. They can use the MAXIFS and MINIFS functions to calculate the maximum and minimum sales figure for a specified item in stores located in a specified region.

 

The MAXIFS function returns the maximum value among cells specified by a given set of conditions or criteria.

 

Here is the Syntax:

 

MAXIFS(max_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...)

 

The MINIFS function returns the minimum value among cells specified by a given set of conditions or criteria.

 

Here is the Syntax:

 

MINIFS(min_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...)

 

The size and shape of the max_range and criteria_range arguments must be the same, otherwise these functions return the #VALUE! error.

 

In the example shown below, MINIFS and MAXIFS are used to calculate the min and max sales figures from the table, but it only includes values from the Sales column if the value in the Retailer column is “BigMart,” the value in the Brand column is “Longlast” and the value in the Sales column is greater than zero.

 

 

Bewildered with nested IFs? Try the new IFS

The logical function IFS is available if you are an Office 365 subscriber and have the latest version of Office installed on your PC or you are using Excel Online. It is also available in Excel Mobile and in Excel for Android phones and tablets.

 

The IF function is one of the most commonly used logical functions in Excel, and using IF inside IF (nested IF functions) has been a common practice in Excel, but it can be challenging or confusing at times.

 

Here is an example of cluttered/ nested Ifs:

 

 

The new IFS function help specify a series of conditions. IFS gives you an alternative to using a series of nested IF functions, when you have more than one condition that you want to test to find a corresponding result. The IFS function checks whether one or more conditions are met and returns a value that corresponds to the first TRUE condition.

 

The advantage of using the new IFS functions is that you can specify a series of conditions in a single function. Each condition is followed by the result that will be used if the condition is true—making it very straightforward to create and read the formula afterward.

 

Here is the syntax:

 

IFS(logical_test1, value_if_true1, [logical_test2, value_if_true2], [logical_test3, value_if_true3],…)

 

Because Excel functions are limited to 254 parameters, you can use up to 127 pairs of condition and result arguments in this IFS function.

 

For example, let’s say you want to get the grade letter for a given score on a test. Using the IFS function, it might be something like this:

 

=IFS(C1>=90, “A”, C1>=80, “B”, C1>= 70, “C”, C1>=60, “D”, C1<60, “Fail”)

 

 

This can be read as, if the grade in C1 is greater than or equal to 90, it’s an A. Otherwise, if it’s greater than or equal to 80, it’s a B. Otherwise, if it’s greater than or equal to 70, it’s a C and so on. It’s pretty easy to write it this way and it’s also straightforward to read and understand what’s going on.

 

Note:

The SWITCH function is also a powerful logical function and can handle multiple conditions. What makes it different is that rather than specifying a series of conditional statements, you specify an expression and a series of values and results. The values are compared to the expression, and when the first exact match is found, the corresponding result is applied to the cell. You can also specify a “default” result that will be returned if none of the values are an exact match for the expression. The advantage of the SWITCH function is that you can avoid repeating the expression over and over, which sometimes happens in nested IF formulas.

 

In the example below, the first part of the formula extracts the size code (i.e. XS, M and G) from the middle of the item in column B. It’s rather long, so it’s nice that SWITCH only needs it to be written once and it can be compared to a list of values.

 

The example below can be explained as:

 Extract the size code from the item in column B. If it equals “XS”, the result is “Extra Small.” Otherwise, if it equals “S”, the result is “Small” and so on. If there’s no match, the result is “Not Specified.”

 

 

Again, because Excel functions are limited to 254 arguments, you can use up to 126 pairs of value and result arguments in this SWITCH function.

Forget CONCATENATE and the Clutter

Combining text strings has become easier using TEXTJOIN in Excel 2016 of Office 365 ProPlus and is available for subscribers right-away. (You must have the latest version of Office installed in your PC). This is also available for users using Excel Online, Excel Mobile and Excel for Android phones and tablets.

 

A very common task for users in spreadsheets is to combine text strings, but until now, if you wanted to join text strings from a range of cells, you had to specify each cell individually. The new TEXTJOIN functions let you combine text strings from ranges of cells with or without using a delimiter, such as a comma separating each item. You can simply refer to the range and specify the delimiter once and let Excel do all the heavy lifting. If the delimiter is an empty text string, this function will effectively concatenate the ranges.

 

The old-fashioned way:

 =CONCATENATE(A3, “, “, B3, “, “, C3,”, “, D3, “, “, E3)

 

The new way to join text strings using TEXTJOIN:

 =TEXTJOIN(“, “, TRUE, A3:E3)

 

TEXTJOIN has three arguments – (1) the delimiter to be used, (2) whether to ignore empty cells and (3) the range in which the text strings are located.

 

So, you simply specify the comma (or whatever separator you want), choose whether to ignore empty cells (True) or include empty cells (False) and then specify the range. If a number is supplied, it will be treated as text.

 

For example, =TEXTJOIN(" ",TRUE, "The", "sun", "will", "come", "up", "tomorrow.") will return The sun will come up tomorrow.

 

There can be a maximum of 252 text arguments for the text items, including the first text. Each can be a text string, or array of strings, such as a range of cells. If the resulting string exceeds 32767 characters (cell limit), TEXTJOIN returns the #VALUE! error.

 

Here is another example:

 

Let’s say you just want to join the parts of an address into a single text string. The old way would require you to specify each cell and repeat a comma that separates each part:

 

 

The new way is much simpler.

 

 

 

Note:


There is also a similar and improved function CONCAT. This CONCAT replaces the CONCATENATE function though the CONCATENATE function will still be available for backward compatibility.

 

The CONCAT function combines the text from multiple ranges and/or strings, but it doesn't provide the delimiter or Ignore Empty arguments.

 

For Example, =CONCAT("The"," ","sun"," ","will"," ","come"," ","up"," ","tomorrow.") will return The sun will come up tomorrow.

 

There can be a maximum of 253 text arguments for the text items. Each can be a string, or array of strings, such as a range of cells. If the resulting string exceeds 32767 characters (cell limit), CONCAT returns the #VALUE! error.

Go beyond Passwords - Use an Additional Factor for Authentication

Multi Factor Authentication helps secure user sign-ins for cloud services beyond just a single password. The security of multi-factor authentication lies in its layered approach.

  • Compromising multiple authentication factors presents a significant challenge for attackers.

  • Even if an attacker manages to learn the user's password, it is useless without also having possession of the trusted device.

  • Should the user lose the device, the person who finds it won't be able to use it unless he or she also knows the user's password.

Mult-Factor Authentication overview

Office 365 uses multi-factor authentication to help provide the extra security and is managed from the Office 365 admin center.

Features

Office 365 offers the following subset of Azure multi-factor authentication capabilities as a part of the subscription:

  • The ability to enable and enforce multi-factor authentication for end users

  • The use of a mobile app (online and one-time password) as a second authentication factor

  • The use of a phone call as a second authentication factor

  • The use of a Short Message Service (SMS) message as a second authentication factor

  • Application passwords for non-browser clients

  • Default Microsoft greetings during authentication phone calls

Feature comparison of versions

A form of multi-factor authentication is included with Office 365, but Enterprises can also purchase Azure Multi-Factor authentication that includes extended functionality.

Proofup

The following table below provides a list of the features that are available in the various versions of Azure Multi-Factor Authentication.

Feature

O365 MFA

Azure MFA

Administrators can protect accounts with MFA

Mobile app as a second factor

Phone call as a second factor

SMS as a second factor

App passwords for clients that don't support MFA

Admin control over authentication methods

 

PIN mode

 

Fraud alert

 

MFA Reports

 

One-Time Bypass

 

Custom greetings for phone calls

 

Customization of caller ID for phone calls

 

Event Confirmation

 

Trusted IPs

 

Suspend MFA for remembered devices (Public Preview)

 

MFA SDK

 

MFA for on-premises apps using MFA server

 

A Video Streaming Portal for the Enterprise

Office 365 Video is an intranet website portal where people in an organization can post and view videos. It's a streaming video service for the organization that's available with SharePoint Online in Office 365. It's a great place to share videos of executive communications or recordings of classes, meetings, presentations, or training sessions.

Features

Channels

  • Channel admins for Office 365 Video can create channels to organize videos.

  • Enterprises can have channels for particular subjects, for example, or for specific groups such as departments or teams

  • End users see only the channels that they have permission to view

Uploading videos

  • To upload a video, users upload it to a specific channel.

  • Users can upload multiple videos to a channel at the same time.

  • Anyone in the organization who has edit permission for a particular channel can upload videos to it

Watching a video

  • Users can watch videos from where they are featured on the Office 365 Video home page, and from specific channels.

  • When the user selects a video thumbnail, the video plays right in the browser window

Sharing videos with others

  • Embed an Office 365 video on the enterprise's site. Users can display the video on a SharePoint Online site or other website by adding the embed code for that video to the page where they want the video to appear.

  • Post to Yammer. Users can post to Yammer about a video while they're watching it, and the post will automatically include a link to the video that they're watching.

  • Send a link to a video in an email. To get a link for a video, the users select the video in Office 365 Video and then copy the URL from the browser address bar.

Discover spotlighted channels and videos

  • Admin can spotlight up to three channels and four videos on the home page.

  • Person with edit permission for a channel can spotlight up to five videos on the page for that channel.

Find the most popular videos

  • Users can see what videos are most popular for the entire organization, check the Trending section on the home page.

  • Users can see what videos are particularly popular in a certain channel, check the Trending section on that channel page.

Find videos that you've uploaded

  • Users can see what videos they've uploaded to a channel, select a channel, and then choose My Videos.

Search for a video

  • Users can search for a particular video by typing what they are searching for in the Search videos box.

  • Users can find videos that are in Office 365 Video by using SharePoint enterprise search.

Channel permissions

There are three types of channel permissions: owners, editors, and viewers. One must have owner permission to change permission settings.

  • Owners - has full control over a channel. They can manage the channel from the channel settings page, upload videos, delete videos, and delete the channel.

  • Editors - has edit permission for a channel. They can upload videos and delete videos. Then cannot manage the channel settings or delete the channel.

  • Viewers - can view all of the videos that are in the channel. By default, everyone in your organization has viewer permission for a channel when the channel is created.

Client Requirements for Video Streaming

Desktop Requirements


Browser

OS

Playback Supported

IE 11

Windows 8.1

HTML5

IE 11

Windows 7

Adobe Flash

IE 9 / 10

Windows

Adobe Flash

Chrome 37+

Windows / OSX

HTML5

Firefox

Windows / OSX

Adobe Flash

Safari 8

OSX Yosemite

Adobe Flash

Safari

Below OSX Yosemite

Adobe Flash


 

Mobile Requirements


Browser

OS

Playback Supported

IE 11

Windows Phone 8.1

HTML5

Chrome

Android 4.4.4

HTML5

Safari

iOS 6

Native HTML5


Scenarios where O365 Video comes in handy

  • On-demand Trainings.

  • Corporate Messages.

  • Community knowledge sharing.

  • Help & How to.

Workplace Analytics for the Productivity Pros

Microsoft has announced an update to the Office 365 people profile experience under Delve, which consolidates the profile and activity pages to make it easier for you to discover relevant content, connect with colleagues and find experts inside an organization.

Learn more about your colleagues

The new profile page gives users a place to learn more about their colleagues, providing their contact information, a photo, who they work for and a summary of their experience and expertise, as well as discover their recent activity and a quick glimpse of what they are working on. The profile is actionable, too. Users can start a Skype chat, call or email to a colleague right from their profile page. Remember, Delve only shows content that the user already has permission to see.

The whole experience is responsive and looks great on any device.


Customize User profile and quickly find documents

Users can give their Delve profile a personal touch—upload a favorite profile photo, choose a unique background or edit your expertise. Up-to-date profiles make it easier for others to find out about the user and help the user when the user is looking for information. From the user’s profile, users can also quickly and easily get back to their documents, as well as see documents their most frequent contacts are working on.


Delve is more useful and intuitive than ever thanks to the new profile page. By connecting the users with the content and the contacts who are relevant to them, Delve helps break down silos and keeps the user in the know.

The new profile experience will roll out to First Release Office 365 tenants over the next several weeks, and Microsoft expects it to roll out to all eligible Office 365 customers by the second quarter of 2016.

Delve is included in the Office 365 Enterprise E1–E5 subscription plans (including the corresponding A2–A4 and G1–G4 plans for Academic and Government customers, respectively). Delve is also included in the Office 365 Business Essentials and Business Premium plans.

Delve never changes any permissions and only shows the users content that they already have permission to view. Only they can see their private documents in Delve, and other people can’t see their private activities—such as what documents they’ve read, what emails they’ve sent and received or which Skype for Business conversations they have participated in. Other people can see that they’ve modified a document, but only if they have access to the same document.

Office 365 - Frequently Asked Questions

How is Office 365 different from Microsoft Office?

"Office 365" refers to subscription plans that include access to Office applications plus other productivity services that are enabled over the Internet (cloud services), such as Skype for Business web conferencing and Exchange Online hosted email for business, and additional online storage with OneDrive for Business.

Many Office 365 plans also include the desktop version of the latest Office applications, which users can install across multiple computers and devices. The full, installed applications include: Word, Excel, PowerPoint, OneNote, Outlook, Publisher, and Access. (Publisher and Access are available on PC only.) And you can install them across multiple devices, including PCs, Macs, Android tablets, Android phones, iPad, and iPhone. When you have an active Office 365 subscription that includes the desktop version of Office, you always have the most up-to-date version of the applications.

The Office 365 plans that are online-only are a great choice for certain business needs, and they are compatible with desktop versions of Office 2013, Office 2010, Office 2007 (with slightly limited functionality), Office 2016 for Mac, Office 2011 for Mac, and Office 2008 for Mac. This does not include the Exchange Online Kiosk or Office 365 Enterprise K1 plans.

All Office 365 plans are paid for on a subscription basis, monthly or annually.

Microsoft Office. "Microsoft Office” is the name we still use for our familiar productivity software. Office suites are available as a one-time purchase and include applications such as Word, Excel, and PowerPoint, which can be installed on only one PC or Mac. The applications are not automatically updated; to get the latest version, you can purchase the product again when the new version becomes available. The latest versions currently available for one-time purchase are Office 2016 for Windows and Office 2016 for Mac. These suites do not come with any of the cloud-based services included in Office 365.

Will Office 365 work with my copy of Office?


Office 365 works best with the latest version of Office, Office 2013, Office 2010, Office 2016 for Mac, and Office 2011 for Mac. Office 365 works with slightly limited functionality with Office 2007. If you have an earlier edition of Office, you will need to update to a newer version of Office in order to use Office 365; or you can subscribe to one of the many Office 365 plans that include the latest version of Office. In addition to getting the latest version of Office as part of your subscription, you will also get automatic updates, so your Office will always be up to date. Compare plans.

Is Internet access required for Office 365?


Internet access is required to install and activate all Office 365 plans and to manage your subscription account. Internet connectivity is also required to access Office 365 cloud productivity services, including email, conferencing, IT management, and other services.

Many Office 365 plans also include the desktop version of Office, for example, Office 365 Business Premium and Office 365 Enterprise E3. One of the benefits of having the desktop version of Office applications is that you can work offline and have the confidence that the next time you connect to the Internet all your work will automatically sync, so you never have to worry about your documents being up to date. Your desktop version of Office is also automatically kept up to date and upgraded when you connect to the Internet, so you always have the latest tools to help you work. Compare Office 365 plans.

What is the cloud?


“The cloud" is a friendly way of describing web-based computing services that are hosted outside of your organization. When you use cloud-based services, your IT infrastructure resides off your property (off-premises), and is maintained by a third party (hosted), instead of residing on a server at your home or business (on-premises) that you maintain. With Office 365, for example, information storage, computation, and software are located and managed remotely on servers owned by Microsoft. Many services you use every day are a part of the cloud—everything from web-based email to mobile banking and online photo storage. Because this infrastructure is located online or “in the cloud,” you can access it virtually anywhere, from a PC, tablet, smartphone, or other device with an Internet connection.

How many users does Office 365 support?


Office 365 is highly scalable and can support everything from a one-person business to companies with tens of thousands of users:

·         Office 365 Business plans are best for companies with one to 300 users.

·         Office 365 Enterprise plans fit organizations ranging in size from a single employee to 50,000-plus users.

Mobile Apps for Office 365

Office provides the following apps:

·         Office for Android™: View, create and edit documents with touch-friendly Word, Excel and PowerPoint apps. You can count on Office for Android to keep your content and formatting intact so the document looks great when you’re back on your PC or Mac. In Word, add comments or track changes while you work together with others. Review and update Excel spreadsheets and easily add formulas or charts. Make changes to PowerPoint presentations and project them wirelessly on a big screen.
You can view documents for free with Office for Android. Editing and creating documents requires an eligible Office 365 subscription: Office 365 Home, Office 365 Personal, Office 365 University, Office 365 Business, Office 365 Business Premium, Office 365 Enterprise E3, E4, and E5, Office 365 Enterprise E1 and E3 (Government Pricing), Office 365 Education Plus, and Office 365 ProPlus.
·         Office for iPad®: View, create and edit documents with touch-friendly Word, Excel and PowerPoint apps. You can count on Office for iPad to keep your content and formatting intact so the document looks great when you’re back on your PC or Mac. In Word, add comments or track changes while you work together with others. Review and update Excel spreadsheets and easily add formulas or charts. Make changes to PowerPoint presentations and project them wirelessly on a big screen.
You can view documents for free with Office for iPad. Editing and creating documents requires an eligible Office 365 subscription: Office 365 Home, Office 365 Personal, Office 365 University, Office 365 Business, Office 365 Business Premium, Office 365 Enterprise E3, E4, and E5, Office 365 Enterprise E1 and E3 (Government Pricing), Office 365 Education Plus, and Office 365 ProPlus.
·         Office Mobile: Office Mobile is preinstalled on Windows Phone 8 and is available for select models of iPhone® and Android phones. Office Mobile offers great Office content viewing and on-the-go content editing capabilities. And you can count on Office Mobile to keep your content and formatting intact so the document still looks great when you’re back on your PC or Mac. Office Mobile for iPhone and Android phones can be used for free for non-commercial use, simply download the app from the store on your phone.
In order to edit or create documents or to access documents stored in SharePoint and OneDrive for Business on premises, you must have a qualifying Office 365 plan: Office 365 Business Premium, Office 365 Enterprise E3, E4, and E5, Office 365 Enterprise E1 and E3 (Government Pricing), Office 365 Education Plus, Office 365 ProPlus, and Office 365 University.
·         Outlook Mobile: Windows Phone 8 includes a pre-installed version of Outlook that you can use to access your Outlook.com, Office 365, or Exchange email.
·         OneNote: You can use the mobile OneNote app to access your notes while on the go. This app is available on Windows Phone 8, iPhone, iPad, and Android phones.
·         OWA: If you have an Office 365 subscription that includes Exchange Online, you can use the OWA app to sort, scan, and respond to email, and stay on top of your schedule. This app is available on iPhone and iPad.
·         Lync Mobile: If your organization uses Skype for Business or the newest version of Lync, you can use the mobile Lync app or the Skype for Business mobile app, to stay connected while on your mobile device. This app is available on Windows Phone 8, iPhone, iPad, and Android phones.
·         SharePoint Newsfeed: If your organization uses the newest version of SharePoint, you can use the SharePoint Newsfeed app to access your newsfeed from your mobile device. This app is available on Windows Phone 8, iPhone, and iPad.