v16.0.12527.20194 [9 Sep 2011]
In Word, Excel, and PowerPoint
Use your finger or pen to write and draw, and use the tools on the new Draw tab to highlight content of particular interest.
Learn more about drawing and annotating with ink.
In Word, Excel, PowerPoint, Outlook, and OneNote
Use this new theme to get the highest level of contrast while working in your Office apps.
Learn more about changing the look and feel of Office 2016 apps with themes.
Funnel charts can be used to help you display values as progressively decreasing proportions.
Learn more about creating a funnel chart.
Avoid nested IF functions with the new IFS, MAXIFS, MINIFS, and SWITCH functions.
Data entry made easier
Speed up formula entry with the CONCAT and TEXTJOIN functions.
More Send As Options
Send a document either as an attachment or as a PDF without leaving the confines of your worksheet from the Share pane.
Learn more about sharing your workbook with others.
Improved Formula Autocomplete
Only remember a part of a formula name (for example, you know if contains a “rand” or a “value” somewhere)? No problem! Excel now returns all partial matches for everything you type—not just exact matches from the beginning of the string.
When collaborating with others on a presentation, see not only who is working on the presentation but also what slide each person is working on.
Learn more about collaborating on PowerPoint presentations with real time co-authoring.
Finding email from specific contacts made easier
Ever looked for a mail from someone and realized that they have same name as someone else you frequently email? You can now pick the right person from the list of suggested contacts as their picture appears next to their name.
v15.0.5111.1000 [6 Aug 2012]
The first thing you’ll see when you open Microsoft Office is a clean, new look. But the features you know and use are still there — along with some new ones that are huge time savers. The new Office also works with smartphones, tablets, and in the cloud, even on PCs that don’t have Office installed. So now you can always get to your important files, no matter where you are or what you’re using.
Sign-in for Office where you need it
- Use your Microsoft account to install Office.
- Stream your Office programs to another computer.
- Save files to OneDrive for easy access and sharing.
- Keep your personal settings wherever you are.
Office for the whole family
Tired of sharing your computer with your whole family? An Office 365 Home subscription lets you install Office on up to five PCs or Macs. That way, everybody in your house can have their own copy of Office, their own files, and their own settings.
Updates are automatic, so you’ll always have the latest version. You get an additional 20 GB of OneDrive storage, so you’ll have your files—from to-do lists to presentations—wherever you go. And you get 60 free Skype world minutes each month so you can call friends or family in over 40 countries, even if they don’t have a Skype account.
You don’t even need to be in front of your own computer to use Office. As long as you’re connected to the Internet, you can use Office on Demand to temporarily stream full versions of Word, Excel, PowerPoint, Access, and Publisher to PCs running Win 7 (or later). That way, you can create documents or keep working on documents you’ve saved to OneDrive.
Save and share files in the cloud
The cloud is like file storage in the sky. You can get to it anytime you’re online. Now it’s easy to save your Office files to your own OneDrive or your organization’s site. From there you can access and share your Word documents, Excel spreadsheets, and other Office files. You can even work together with your colleagues on the same file at the same time.
Join online meetings and share PowerPoint slides, Word documents, Excel spreadsheets, and OneNote notes. Meeting attendees can see the files, even if they don’t have Office installed.
More choices for getting started
Instead of seeing a blank file, you can now choose between a recent file or a favorite template. In OneNote, you can sign in and open notebooks from the web or from your computer.
Improved Save As and Open
No more browsing and scrolling in dialog boxes. Your most-used folders are right there from the start. You can also pin a location so it’s always available.
Easier file sharing
Now there’s one place in your Office programs, File > Share, that puts together all your options for sharing your files with others.