Communication sites are perfect for internal cross-company campaigns, weekly and monthly reports or status updates, product launches, events and more. To help you jumpstart getting your message out fast, communication sites provide configurable templates for the sites and pages within. When you click Create site from the SharePoint home in Office 365, you have a choice of three initial site designs:
Topic—Select the Topic design when you have a lot of information to share, such as news, events and other content.
Showcase—Use the Showcase design to feature a product, team or event using photos or images.
Blank—Start with a blank site and make your design come to life quickly and easily.
Communication site designs (from left to right): Topic, Showcase and Blank.
And it is easy to tell your story. Once your new site is created, simply drag-and-drop to reorganize web parts on the page to bring your use cases and scenarios to life. News and pages allow for multi-column layouts to represent your message in a meaningful, intuitive fashion.
Learn how to create a communication site in Office 365, add a page and work with column layouts.
Share your plans and updates in engaging, interactive ways
Communication sites allow people to create and share recurring updates beyond email. When you create a page on a communication site, you can embed documents and video, and dynamically pull in real-time data from across Office 365, including documents from SharePoint, Power BI reports, Microsoft Stream videos and Yammer discussions. The resulting page is a rich and dynamic communication. And the page persists on the site, so people can refer to it easily, even as the membership of your team changes, so new members can more easily get up to speed.
The new capabilities for the rich section layouts and new web parts can be utilized on SharePoint team sites as well.
Consume, create and connect from your mobile device via the SharePoint apps
It’s easy to access, engage with and create content for communication sites from any device. The full site, pages, news, navigation, search and more are natively viewable, functional and engaging. Read a page, create a news article, engage in a Yammer conversation—all in the context of the site—from within the SharePoint mobile app experience.
You can download the SharePoint mobiles apps for iOS and Android today, and the new features will be available in the coming weeks. Learn more about the SharePoint mobile app for iOS, SharePoint mobile app for Android and SharePoint app for Windows 10 Mobile.
A great and vast set of features (called as an Excel add-in) based on the Microsoft’s Power Query technology are made available in Excel 2016 to make it capable for quick as well as trouble-free gathering and shaping of the data, resulting in enhancing the self-service Business Intelligence experience in Excel and this can be obtained easily from the Get & Transform section provided on the Data ribbon.
On the demand of many of the users, we had brought three new features working for data connectivity and transformation.
Microsoft Office 365 subscribers can search for the guidance to achieve these latest updates as these are made available as an Office 365 subscription’s part. Excel 2010 or Excel 2013 users can also download the amazing Power Query tool for Excel add-in and enjoy the benefits given by these updates.
Office 365 (the brand name used by Microsoft for a group of software and services subscriptions, providing productivity software and related services to subscribers) subscription lets to attain the latest applications for the same previously paid price and additionally at the same time of the release.
The three latest and enhanced data transformation and connectivity features included in these updates are as follows:
Combine Files: Ability to select sample file to use
DB2 Connector—option to specify Package Collection
Split Column using Delimiter along with automatic detection of delimiter
Talking something more about these features:
Combine Files: Ability to select a file to use as a sample
Based on the recent feedback seems common to most areas; a feature providing an ability to choose a file as a demo file from a particular folder, to further choose objects and identify any step related to custom transformation along with many other improvements to the Combine Files experience are given in this month. Also, a new control to permit you the selection of a file available in the selected folder was added in preview dialog box of file. Though by default, the first file that appears has been selected yet the users can customize this according to them easily.
Split Column using Delimiter along with its automatic detection
Delimiter is used to separate columns or fields within the file. Here, on the basis of text pattern recognition in the data preview rows, excel will detect the Delimiter in this dialog box automatically at the time of splitting column using delimiter within the Query Editor passing through Home tab followed by Split column option. This automatic detection is good as in most of the cases it allows only a few clicks but in case you want to change the delimiter, you can do it easily.
DB2 connector incorporates an option to specify Package Collection
As written in the heading, the DB2 connector window incorporates a latest option to identify the package collection to link to an inbuilt provided DB2 server, in the DB2 connector dialog box beneath the Advanced Options section but its usage is limited with the Microsoft IBM DB2 driver only.
Murrieta, CL: Microsoft in its recently made announcement had talked about the release of its new “Centralized Deployment for Office 365 web add-ins” feature.
Making use of the PowerShell scripts or the Office 365 admin center, the latest feature enables the administrators to easily organize the add-ins to a particular user, a group of users or a complete organization based on one’s preference.
The release and preview of the particular service has been marked at the end of the year 2016.
Microsoft has also announced in a post on the company’s Office blog that the users can easily view all the add-ins that are installed on the ribbon of their MS-Office applications like Word, Excel or PowerPoint running on Mac, Windows or Office online, just by simply opening these applications. This will further permit all the organizations (whether small or large) to expand their Office with the help of the enhanced and important services across each and every platform.
To demonstrate the efficiency of the service, the usage case of the “Genetec Inc” (a Canadian supplier of access control and license identification solutions combined in a single platform, called Security Center) is concerned and praised by Microsoft.
“Genetec” makes use of “Qorus” add-ins that helps Office 365 users to search for proper content to add to proposals, pitches, emails and reports as well as to create accurate and efficient business-related documents.
Microsoft explained in a distinct but associated post on its blog that “Genetec’s bid response team” on realizing the requirement for boosting up of its content’s value along with the efficiency, joined hand with the “Qorus” to focus on content in Microsoft OneDrive and Microsoft SharePoint Online for Business by creating separate Microsoft platform to make a better content easily available.
The post also includes that, the tasks such as creating new documents, increasing cooperation with subject matter experts, etc. is simplified by the “Qorus” add-ins. It also provides the “Genetec” employees to have great prospect on its usefulness for tracking the usage of the content.
This latest feature (Centralized Deployment) of Microsoft is offered to almost all the supported Office languages. Another great news is that this is compatible with all recent editions of Office as well as of Exchange, that are OAuth-enabled.
One of the blog also states that, “the telemetry will be made available for the IT admins and the developers soon, to help them to view the facts about the deployments in the Office 365 admin center and to view their add-in deployments in the Office ISV Seller Dashboard respectively”.
Recently, Microsoft reveals a latest test edition of Windows 10 build number 16215 along with a number of drastic changes. All of the new features will be available to all the users till the end of this year in the Windows 10 Fall Creators Update but the Windows Insider on the Fast Ring can catch them immediately.
The first major change is the redesigning of the notification center with the separate sections provided for the apps, which has resulted in a complete new look. It combines group notifications from devices, apps and somewhere else together in a more logical way and look-wise also seems more attractive.
This latest Windows 10 update will allow you to pin your preferred websites to the taskbar. Obviously, the pinned websites will open in Microsoft’s Edge browser but this feature is returning after receiving feedback from the Windows 10 users. Microsoft is also making changes in its Cortana (an intelligent digital assistant created by Microsoft Office.com for Windows 10, Windows 10 Mobile, etc.), making the digital assistant able to prompt for reminders by scanning the images for things such as events, etc. For instance: Cortana can create the reminder for the taken photo of a poster or of other things. Cortana has also enriched with a new lasso feature that allows the stylus users circle content to create reminders for things such as movies. Additionally, Microsoft is also enhancing the animations for new tabs in Edge to speed up the things a little more.
Perhaps, Microsoft has come happening gone the biggest regulate in Windows 10 stylus preserve. The handwriting panel has been renovated behind features such as more gestures, emoji, enhanced editing, hasty right of entry to emoji and symbols, automatic handwriting detection, etc. These features have enough maintenance facilities such as words written following the pen acquire converted to text automatically along considering varying ahead to let you conveniently continue the writing. These furthermore confirm you to select the converted text to reply and make corrections along behind scratching, joining, or splitting it by making use of the ink gestures. By default, the handwriting panel will be to hand floating adjoining where you are writing at expertise. The stylus can even be utilized to scroll in the middle of apps and websites now. An other Find my pen to court accomplishment at which word or phrase you were regarding your device taking into account you last used the pen, has plus been included by the Microsoft.
Microsoft has also brought a new winkey + period / semicolon keyboard shortcut that will activate a new emoji panel from where one can easily pick up the most suitable emoji for his/ her messages, making it effortless to insert emoji into social media messages or even e-mails. The company is also providing the Windows 10 desktop and the tablet users with a new touch keyboard which includes features such as prediction, one- handed input, shape writing with your fingers or a stylus and emoji sug
In addition to the bigger features mentioned above, some other smaller changes to Windows 10 like a new copy link feature that allows easy sharing of links is provided in the new share page, a feature that make you able to switch between public and private for network connections easily and enhanced support for HDR monitors, are also available.
Microsoft in its blog has also mentioned a number of other smaller changes and fixes that will be provided to the Windows 10 users.
Social apps can make working with Office 2013 more engaging, efficient, and fun. They combine the networking and outreach capabilities of social media sites with the mobile productivity power of Office. Together, Office and social apps give you more insight into your contacts, allow you to monitor your social channels without using a browser, and can spice up your SharePoint sites in ways that you’ll “like” (thumbs up).
The LinkedIn for Outlook app is one of the most popular of the social apps. It lets you see LinkedIn profile data for your contacts while you are using Outlook. Not only can this app give you greater insight into your email contacts, it can help you build your professional network quickly from one of your most valuable professional resources: your Outlook contact list. Likewise, if you’re an active Tweeter, you may want to add the ExTweet app to your library. It offers a way to display real-time Tweets that match the data in your Excel workbook.
From the most popular social media website comes the Facebook Integration App. Use it to add Facebook social plug-ins to your SharePoint site so people can interact with it as they would a Facebook page. It can make your site more social by encouraging increased user engagement and eliciting immediate feedback and comments. Similarly, the ConnectWithUs app lets you connect your SharePoint site to your page on Facebook, Twitter, Pinterest, Google+, or any other community.
These are just a few examples of apps that work with the Office applications you use every day to make them even more dynamic and useful. Explore the Office Apps Store to find more apps for Office 2013 that can make your work easier, increase your productivity, and help you have fun.
It’s a service that creates Office Web Viewer links. Office Web Viewer links open Word, PowerPoint or Excel files in the browser that would otherwise be downloaded. You can easily turn a download link into an Office Web Viewer link to use in your website or blog (e.g., recipes, photo slide show, a menu, or a budget template).
Some benefits of the Office Web Viewer include:
You don’t need to convert Office files for the web (e.g., PDF, HTML).
Anyone can view Office files from your website or blog, even if they don’t have Office.
It keeps eyes on your website or blog, because readers don’t need to download the file and they stay in the browser.
One link will work for computers, tablets, and mobile phones.
How to get started
To use Office Web Viewer, click this link: http://officewebviewer.com
Then copy and paste the document’s URL in the text box. It looks like this:
To make the URL yourself, you can use the link below, where <Document Location> is a URL to the document.
Note: the <Document Location> needs to be URL encoded, and the document must be publicly accessible on the internet.
Here are a few examples of documents in the Office Web Viewer:
At the Microsoft Build conference there were a lot of presentations with PowerPoint decks. If you want to watch a video of one of the presentations, you can also look at the PowerPoint deck that goes with it using the Office Web Viewer. http://view.officeapps.live.com/op/view.aspx?src=http%3a%2f%2fvideo.ch9.ms%2fbuild%2f2011%2fslides%2fTOOL-532T_Sutter.pptx
On a popular banking site we found this great Wedding Budget Planner spreadsheet. To preview the spreadsheet instead of downloading it, we created an Office Web Viewer link. http://view.officeapps.live.com/op/view.aspx?src=http%3A%2F%2Flearn.bankofamerica.com%2Fcontent%2Fexcel%2FWedding_Budget_Planner_Spreadsheet.xlsx
Here’s a school newsletter template we found on Bing. With the Office Web Viewer, you don’t have to worry about everyone at the school being able to view a Word document–now all they need is a browser. http://view.officeapps.live.com/op/view.aspx?src=newteach.pbworks.com%2Ff%2Fele%2Bnewsletter.docx
If your document is an Office document and is publicly accessible on the internet, then you are good to go. Office Web Viewer links are a great alternative to download links because your readers don’t need a special program to view your documents, and they don’t have the interruption of leaving their browser.
Reliable business intelligence and insight are key to a thriving business. Excel, SharePoint and Office 365 make business intelligence (BI) in the new Office more accessible to everyone across an organization as part of their everyday work. New and enhanced features in familiar tools such as Excel empower everyone in a business to easily explore, model, analyze, and visualize data from various sources. With SharePoint, users of all levels can collaboratively develop and share insights through dashboards and scorecards, and this experience continues seamlessly in the cloud with Office 365. For corporate environments, these features are further enhanced by SQL Server for higher levels of performance and scalability both on-premises and in the cloud with BI Azure. Ultimately with Microsoft BI, anyone in the organization can develop the insights that help drive new discoveries and make better, more informed decisions.
Explore your data
PowerPivot was a popular add-in to Excel 2010, allowing users to create large data models with hundreds of millions of rows in Excel. This feature is now natively embedded in Excel to reduce the hassle of downloads and installation. PowerPivot is also supported in SharePoint with SQL Server Analysis Services where the workbooks with PowerPivot models can be shared broadly across the organization. New features like Quick Explore aid users in navigating their data, and Quick Analysis provides previews of their charts, graphs, and scorecards.
Combine and analyze large datasets with PowerPivot
Summarize data and discover trends with Quick Explore
Instantly preview charts and pivot tables with Quick Analysis
Visualize your insights
Introduced with SQL Server 2012, Power View provided a canvas to create visual dashboards in SharePoint. Now this feature is embedded into Excel and SharePoint so that business users can create stunning reports to share and interact across the organization. Excel Services now supports the Field List to pivot and change views in the browser. We’ve also enhanced PerformancePoint Services to offer additional features such as themes, filter enhancements, authentication enhancements, a new BI portal, and server-side migration.
Perform interactive data exploration with Power View
Share reports with your colleagues with Excel Services
Work together to make decisions on dashboards with PerformancePoint Services
Control your assets
Self Service BI has often raised concerns for IT Pros in managing the integrity of reports and security. With the new Inquire tool in Excel and Audit and Control Manager in SharePoint, IT governance teams can now further manage self-service BI for end user created assets. Together, these features will aid in comparing various versions of reports and tracking changes in report libraries to ensure one version of the truth of your insights.
Consolidate and simplify management with SharePoint
Diagnose workbooks for errors and track changes with Spreadsheet Inquire
Manage spreadsheet risk within an organization with Audit and Control Manager
A great way to get started using Microsoft BI is through our new Microsoft BI Solution Builder online tool that will help configure the right platform for your organization.
With 22 acquisitions in the past five years, it’s easy to see how Allergan is a leading exponent of the new “Growth Pharma” business model. Expanding its diversified portfolio of branded and generic pharmaceuticals by acquiring companies like Botox and Zeltiq Aesthetics, Allergan is pursuing a rigorous growth strategy, rather than investing heavily in R&D. This approach, known in the industry as “open science,” sees the company enriching its intellectual property by acquiring new talent, promising new products and partnering closely with many external stakeholders. It requires an agile, IT-enabled workplace to pull off the rapid employee onboarding and a rich culture of teamwork and creativity to make this strategy work. At the same time, it’s critically important for Allergan to ensure the security of its IP and to remain compliant in this highly regulated industry. So, it’s great news that Allergan chose the Secure Productive Enterprise solution to enable this disruptive way of doing business in the pharmaceutical industry.
Here’s what CIO Sean Lennon has to say about the organization’s decision to facilitate a new culture of work at Allergan that securely enables teamwork and creativity for all workers with the help of the Secure Productive Enterprise solution:
“As Allergan continues to build its global portfolio of products and services, it’s our role in IT to enable the company’s scalability. That’s why we chose the Microsoft Secure Productive Enterprise, because it allows me to deliver a secure technology experience that drives creativity, collaboration and teamwork for the business. So, while employees are working more collaboratively and are empowered to innovate with immediate access to all the tools they need—Office 365, Enterprise Mobility + Security and Windows 10 Enterprise—I’m also saving money by consolidating our IT landscape and reducing the burden of on-premises maintenance. It’s always a challenge to maintain a lean IT organization and provide the best tools for enabling the business to achieve its goals, but we’ve achieved the right balance with Microsoft.”
Missing a key security signal could mean not catching a breach, but the number of security signals is increasing exponentially. It’s becoming impossible to manually prioritize them. That’s why Office 365 applies intelligence to help you proactively manage risk and ward off threats. Today, we’re pleased to introduce several new capabilities in Office 365 that help you manage risk and stay ahead of threats:
Office 365 Secure Score—A new security analytics tool that applies a score to Office 365 customers’ current Office 365 security configuration.
Office 365 Threat Intelligence Private Preview—Service that leverages billions of data points from the Microsoft Intelligent Security Graph to provide actionable insights to the global threat landscape and help customers stay ahead of cyber threats. Office 365 Threat Intelligence is now in private preview, with general availability planned for later this quarter.
Office 365 Advanced Data Governance Preview—Applies machine learning to help customers find and retain the most important data to them while eliminating redundant, obsolete and trivial data that could cause risk if compromised. Office 365 Advanced Data Governance is now in preview, with general availability planned for later this quarter.
Know your Office 365 Secure Score
Do you know how you’d be rated if someone were to evaluate your security configuration? To give you better visibility into your Office 365 security configuration and the security features available to you, we’re pleased to introduce Secure Score—a new security analytics tool. Secure Score helps you understand your current Office 365 security configuration and shows you how implementing additional controls can further enhance your security and reduce risk.*
Here’s how it works:
Secure Score Summary—Displays your Secure Score and provides access to view your Score Analyzer. Your Secure Score, the numerator, is the sum of the points associated with security configurations that you have partially or fully adopted. The total score, the denominator, is the sum of the points associated with all the security controls that are available to you through your Office 365 plan.
In this example, the Secure Score is 130 out of 273 points possible:
Score Summary window showing your Secure Score.
Score Analyzer—Allows you to track and report on your score over time. The graph shows your Secure Score on any date in the past, what specific actions you completed and which actions were available to you. Your score results can also be exported to a CSV file for easy planning and communication with your organizations.
Score Analyzer graph showing the Secure Score over time.
In addition to providing insight, Secure Score provides suggestions on the possible actions you can take to improve your security position. These suggestions are prioritized based on the effectiveness of the action and level of impact to end users. Actions that are highly effective with low level of user impact are placed at the top, followed by actions that are less effective and more impactful to users. You can also filter actions in the list with criteria such as those that have low end user impact or that apply to user accounts.
Secure Score can play an important role in a holistic security strategy, which encompasses how an organization strengthens its risk controls, mitigates potential losses and offsets some of the risk. To help businesses strengthen their security position, property and casualty insurer The Hartford will consider a customer’s Office 365 Secure Score as a part of the cyber insurance underwriting process.
“We believe aligning the solutions between security and insurance can make a real difference. By encouraging the use of an innovative security analytics tool like Office 365 Secure Score and making it a part of the underwriting process, businesses have more information to make risk-based decisions around privacy and security, potentially reducing their exposure to loss.” —Tom Kang, head of Cyber Insurance at The Hartford
This builds upon the endorsement of Office 365 made by insurance industry leader AIG last year.
Watch this Microsoft Mechanics video for an in-depth look at Secure Score:
To learn more about Secure Score, check out your score and see recommendations on how you can increase your security position in Office 365, go to securescore.office.com.
Office 365 Threat Intelligence—now in private preview
According to a recent Ponemon Institute study, the average cost of a data breach has risen to $4 million. These costs can include litigation, the effects of brand or reputation damage, potential lost sales, and in some cases, complete business closure. Organizations that are prepared for a breach by spending on appropriate staffing, security training and security products can ultimately reduce their long-term costs.
Office 365 Threat Intelligence uses the Microsoft Intelligent Security Graph to analyze billions of data points from global datacenters, Office clients, email, user authentications and other incidents that impact the Office 365 ecosystem, as well as signals from our Windows and Azure ecosystems—to provide actionable insights to global attack trends.
It provides information about malware families inside and outside your organization, including breach information with details, like how much bitcoin the attackers typically request in ransomware attacks. Office 365 Threat Intelligence also integrates seamlessly with other Office 365 security features like Exchange Online Protection and Advanced Threat Protection, so you’ll be able to see analysis, including the top targeted users, malware frequency and security recommendations related to your business.
Office 365 Threat Intelligence provides this visibility, along with rich insights and recommendations on mitigating cyber-threats, ultimately supporting a proactive defense posture, leading to long-term reduced organizational costs.
The Office 365 Threat Intelligence Dashboard provides visibility into the global threat landscape.
To sign up for the private preview of Office 365 Threat Intelligence, please contact your Microsoft account representative.
Why data governance matters
Many organizations are exposing themselves to unnecessary risk because they don’t have a good grasp on all the data they have. Often, they retain data they no longer need, such as the personal information of former employees who have long since left the company. Should this personal data be compromised in a breach, the company could be liable for costly remediation, such as lifetime credit monitoring for these former employees.
Office 365 Advanced Data Governance helps you find and retain the data that is most important to you while eliminating redundant, obsolete and trivial data that could cause risk if compromised. Office 365 Advanced Data Governance applies machine learning to intelligently deliver proactive policy recommendations; classify data based on automatic analysis of factors like the type of data, its age and the users who have interacted with it; and take action, such as preservation or deletion.
We’re already receiving a great response from legal professionals who expect Office 365 Advanced Data Governance to enhance their data management practices.
“The machine learning designed into Microsoft Office 365 Advanced Data Governance’s suite has the potential to tame the ever-increasing growth and complexity of data types we deal with. Office 365 Advanced Data Governance can apply unified policies to data in place across all Office 365 applications, regardless of when the data was ingested, to intelligently retain high-value data while disposing of what isn’t needed or is obsolete. As organizations grasp its potential to reduce compliance and security risks, this will be a game changer in information governance.” —Paul Meyer, eDiscovery and Data Management managing counsel at Willis Towers Watson
Watch this Microsoft Mechanics for an in-depth look at Office 365 Advanced Data Governance:
Visit Office 365 Advanced Data Governance to register for the limited public preview.
Office 365 Secure Score is now generally available to organizations with an Office 365 commercial subscription and who are in the multi-tenant and Office 365 U.S. Government Community clouds.
Today, we are releasing Office Training Roadmaps to help your company set training expectations and track progress for six Office apps. The training roadmaps help you quickly find what you need to learn and are available both online and as printable posters for Office 365, Excel, Outlook, PowerPoint, Word and Access 2016.
Also, if you or your company needs help getting started with Office apps, we have expanded our Quick Start Guides to include Excel, Outlook and Sway. All of these free resources can be found at the Office Training Center.