Category: Microsoft Excel

Updated Data Type Features in excel month, the Office team delivers a feature payload to the productivity package as part of its new drive to treat the software as a service that needs constant maintenance and updates. For the most part, the updates have been relatively benign in retrospect, but ultimately useful in the grand scheme of the evolution of productivity.

For the month of March, however, the Office team is bringing a very good new feature to its Excel program that enables new types of data connected to the cloud. The deployment of new data types begins with Stocks and Geography and understandably will be driven by the Microsoft Knowledge Graph to help improve Excel reports with modified graphics and detailed real-world constructs.

In addition to these new data types in Excel, here is a summary of Office activity this month:

Smart and personalized search: new search capabilities that allow people, information and experience discovery throughout your organization are now being extended to all Office 365 subscribers. Now, wherever you start your SharePoint search , you will get consistent and custom results based on Microsoft Graph.

SharePoint Hub Sites: This month we started deploying SharePoint hub sites, which gather news, activities, searches and navigation on the SharePoint team and the SharePoint communication sites.

Office 365 for the US government UU.: At Government Tech Summit in Washington DC, we announce the general availability of Microsoft 365 for the US government. UU., Allowing government agencies in the United States to transform themselves through the digitization of citizen services and the modernization of workplaces.

In addition to working on the new deliverables of the data type, the Office team managed to expand its global cloud infrastructure by building a local data center in France and made an announcement that other centers will also emerge in Switzerland and the Emirates. United Arabs as new cloud options offered to Office 365 customers in Germany.

Microsoft has paved a clear path for its transition from Windows to cloud-based platforms and with updates like these, it is clear that the company is the foundation to continue the growth of Office and the expansion of its ambitions in the cloud.

Please follow and like us:

When it comes to group collaboration, o The way people work together is evolving, and unique projects, work styles, functional roles, and the diversity of the workforce require a full set of collaborative tools. As the appetite for new ways of working together grows, new developments in communications, mobility and cloud services allow professionals to communicate and collaborate in ways that were previously not possible.

It’s not your typical online event

Each 90-minute session begins with an online business round table that discusses the main business challenges with a trained facilitator and then moves to a live environment in the cloud. You will receive a link to connect your own device to a remote desktop loaded with our latest and best technology, so you can experience first-hand how Microsoft’s tools can solve your biggest challenges

Why should I attend?

During this interactive online session, you will explore:

How Microsoft Teams, the newest collaboration tool:

It keeps everyone involved with persistent ongoing chat.
Create a team work center that works together with your other Office 365 applications.
Create custom options for each team with channels, connectors, tabs and bots.
Add your personality to your team with emoji, GIF and stickers.
How to maintain information security while being productive: Facilitate safe work and compliance without inhibiting your work flow.
How to quickly visualize and analyze complex data: Focus on the data and statistics you need without having to involve a BI expert.
Co-author and share content quickly: access and edit documents even while others edit and review all at the same time.
How to get immediate productivity gains: most attendees leave with enough time saving skills that the time spent to attend a Customer Immersion Experience is more than compensated for by yourself in a few days.
The space is limited. Each session is only open for 12 participants. Reserve your seat now.

US customers US: register here.
Outside the United States.? Register here
The publication When it comes to group collaboration, one size does not fit, everything appeared first in Office Blogs.
Features of Office 2016. image credits microsoft
Please follow and like us:

The new gets first major update In April, we began to deploy a new Office 365 homepage experience that provided a redesigned environment for commercial, educational and home users to collaborate and work on all devices. The update also delivered improved access to recent files and folders and introduced a new platform for faster delivery of innovative features.

We are now implementing new changes that will greatly increase the ease of application navigation and improve access to frequent and recently opened documents. These changes began to be implemented in December and will continue until the beginning of 2017.

final house

Return to your documents online
We know that your best work can take time, so we improve access to your documents without finishing. Users will now see additional controls within the “Recent Documents” list to allow users to filter by type of document in Word, Excel, PowerPoint, and OneNote. Do you have a document that you return to frequently? Write it down in the list so it’s always just a click away.


Know what is coming
We made it easier to see what comes at a glance. Get an in-depth view of the day’s meetings and respond or quickly join Skype for Business calls with a single click. Improved images of people help you establish stronger connections with your co-workers and help you track your different teams and projects.


Stay on task
Create, view, and complete tasks directly in that remain synchronized in Outlook on all your devices. Do you need to add more details to a task? Tap twice to open in Outlook Tasks and add additional details.


Whats Next
We constantly develop and improve the Office 365 experience, so be sure to let us know what you think! We read all the comments we receive as we work to make your Office 365 experience the best it can be.

-Tom Batcheler, @TomBatcheler, senior product marketing manager for the Office 365 team

Frequent questions
Q. Can I reorder or resize the application’s files? organizes the tiles of the application based on which applications are used most frequently. Currently we do not offer the possibility to reorder or change the size of the tiles of the application. We are evaluating additional options to make the navigation of the application even faster.

Q. Will I be able to deactivate the online documents, the next sections or the tasks if I prefer not to see the content?

R. currently does not allow you to deactivate this content. However, you can collapse the card containers to hide the content you do not want to see. We are evaluating additional personalization, such as activating and deactivating certain cards.

Q. Can I turn off or hide the installation button?

A. These next updates have no impact on the installation button.

The publication The new gets the first important update that appeared first in Office Blogs.

Please follow and like us:

How do you tell the story behind your According to a recent study by Glass door, data scientists are the most requested work of 2016. But collecting information is only half of your organization’s challenge: what counts is what you do with it. How can you be sure that your data not only tells you the story you want to hear, but shows you what you need to know urgently?

Join us in the next episode of Modern Workplace, “Visualize: The Power of Data Storytelling,” which will air on January 10, 2017 at 8 a.m. PST / 4 p.m. GMT, and learn how to unlock the hidden potential within your data through visualization. Also, get an exclusive demonstration of how Microsoft’s smart tools such as Power BI and Excel can help you configure, analyze and visually explore your data.

Altimeter Group industry analyst Susan Etlinger shares how to design her strategies strategies into practical tips that she can use today and provides information on how to create the most insightful data of her organization so far.

The Washington Post data visualization specialist, Gabi Steele, explains how to communicate ideas through design and data narration.

Register now!

Related content

Get the free infographic: Choose the pace of productivity.
Take a quick trip through Office 365.
The publication How do you tell the story behind your data? Find out in the next modern workplace appeared first in Office
This is how the website looks like
Features of Office 2016. image credits microsoft

Please follow and like us:

Help prevent user-error security breaches According to the Association of Corporate Advisors, the involuntary error of employees is the main cause of data breaches. And with 87 percent of IT professionals concerned about the security of cloud data, according to a Dimensional survey conducted for Druva, it’s easy to feel vulnerable. The prevention of these unintentional errors can help keep your data protected.

The problem: simple passwords

Simple or reused passwords open the door to hackers. According to Splash Data, the five worst passwords of 2015 were:

But even a large password can pose problems when used in several places. Hackers know that people like to reuse passwords, so when they decrypt one, they test it on multiple sites, especially those that may contain information of higher value.

Your solution: educate employees on how to create a secure password. Then, implement a policy to ensure that passwords meet the minimum complexity requirements and require users to change them often. Also, encourage safe password-keeping practices, such as the use of third-party services that store passwords in the cloud and secure them all with a master password.

The problem: falling into phishing

According to a Verizon Data Breach report, phishing is the second most common threat and is implicated in about a quarter of all data breaches. If a phishing message ends up in an employee’s inbox, it is very likely that they click on the link.

Your solution: In addition to first-level security and secure email filters, encourage users to report suspicious-looking messages, similar to sending junk mail. Once reviewed and identified as a threat, add these messages to the filters of the entire service.


In Exchange Online, Email Security Tips provide an additional layer of protection with a warning to the user in messages marked as suspicious.

The problem: BYOD practices
The policies of bringing your own device (BYOD) are widely used in the current business landscape, but employees who access confidential information from personal devices can open the door to security threats. According to research by the Ponemon Institute, a total of 67 percent of respondents cited employees who use their devices to access company data as the probable cause or cause of data breaches.

Your solution: Create clear BYOD policies and educate employees on how to follow these guidelines, including what is at risk if ignored. For additional layers of security, the use of approved secure mobile applications and multi-factor authentication is required when accessing company information.

Lost or stolen devices
Lost devices are another major cause of data breaches. And not only the devices owned by employees, even your company’s devices are at risk, leaving your organization exposed to threats if they are lost or stolen.

Your solution: Educate employees on the proper security of the device inside and outside the establishment, and instruct them to report lost devices as soon as possible. Enable security policies to ensure that you can remotely access, locate and delete a device if necessary.

Keep your business and email safe
Help protect your organization’s data with the security features of the email you need to advance your business. Office 365 has built-in security and compliance features, always up-to-date, for greater peace of mind.

Get the free eBook

Educate employees continuously to minimize the risk of common violations of user errors. The security features available with Office 365 help mitigate employee risks. Data loss prevention (DLP) proactively scans emails and notifies users before they send sensitive information. Information Rights Management (IRM) allows you to control access permissions to email to prevent unauthorized persons from printing, forwarding or copying confidential information. In addition, Office 365 gives you the option to use advanced threat protection (ATP) to protect mailboxes against sophisticated attacks in real time.

Learn more
Explore the threat landscape of email in “The current state of email security.”
Learn why now is the right time to take your mail on.


Please follow and like us:

4 tips for easier collaboration with contractors Having independent contractors in companies of all sizes is the new norm. Busy seasons require additional bandwidth, full-time employees temporarily leave or single / temporary functions must be filled.

Whatever the reason, getting the support of contractors can provide scale, flexibility and specialized skills to your team, which is why their popularity continues to grow. For example, 51 percent of companies say that their need for contingent workers will continue to grow within the next three to five years. At the same time, the talent pool is changing to match this trend: by 2020, 43 percent of the US workforce. UU They will be autonomous.

Finding the right contractor for the right job is just the first step. They are likely to work outside of their office, but they will still need to rely on the resources that their internal teams use on a daily basis. If you want your contractors to do their best work, you must ensure that you have the right tools to collaborate with your internal teams.

Here are four tips to prepare your independent contractors for success:

Communication # 1-streamline
Make it easy for your contractors to keep in touch. Set up a technology that allows them to communicate and get to know their internal teams. This can (and should) come in the form of many tools, so they can choose the ones they prefer. Allow them to send instant messages to anyone in the company. Promote the use of video conferencing and screen sharing for efficient collaboration. Not only will this increase productivity, but it will allow full-time employees and contractors to build more personal relationships with face-to-face communication.

Will your independent contractor be working on various teams or projects? If so, you can consider a chat-based work space, not only for them, but also for the rest of your team. They should not strive to keep up with dozens of private instant messages about similar projects. Instead, get them in a threaded group chat that allows a more organized web collaboration.

# 2-share files with ease
Depending on when and where your contractors work, coordination across time zones and locations can be a factor in your success. Avoid a situation where a contractor is caught waiting for a team member to connect to gain access to the files. Instead, opt for file sharing and storage in the cloud. In this way, contractors can obtain the files and documents they need throughout the day to do the work. And with permission settings, you can restrict and allow access to the specific files that an independent contractor needs, and revoke access when a contract ends.

5 faces of today’s employees
Collaboration outside the office has much more than working with contractors. If you have an employee who prefers to work from home or one who always travels from the meeting to the meeting, mobility is necessary. Ready to learn how to support them?

Get the free eBook

# 3: stay on the same page
Improve collaboration with the ability to co-author (edit and work) in the same documents online. Avoid excessive email exchange among team members. The digital files are automatically synchronized and updated through the Internet, so your team is always looking for the most up-to-date version. And since your files live in the cloud, you’ll always know who made the last edition and can review and revoke changes if you ever need to go back to an earlier version.

# 4 – secure your data

Security is not always the most important thing for your employees and contractors, but it is for you and your IT team. Achieve a balance between giving your extended team what it needs and at the same time retaining control over your company’s data. The access to files that you give to your independent professionals does not have to last forever. When your contract ends, simply revoke the access remotely. Even if your independent contractor has used your own device to access your data, cloud-based tools can delete your company’s files from that device.

With the right technology and infrastructure, independent contractors can become an effective extension of their equipment. Forget about interruptions, lost files or lack of security. The right tools can solve those problems and help your teams do their best work.

The first 4 tips to facilitate collaboration with contractors appeared first in Office
This is how the website looks like


Please follow and like us:

Enroll in the preview and l Establishing a meeting with someone outside your company can be a hassle that takes a long time. When you can not see each other’s calendars and availability information, scheduling a time to meet may take more time than the duration of the meeting. Sending back and forth emails, proposing alternative schedules and dealing with conflicts prevents you from doing more productive work. Would not it be great and save a lot of time if you had your own personal programming assistant?

Overcoming the challenges of scheduling meetings outside of your organization is the goal of a new Microsoft incubation project called “”. This project gives Cortana, your personal digital assistant, the ability to organize meetings on your behalf. By delegating programming tasks to Cortana, you can focus on doing things instead of wasting time sending back and forth emails. is the latest project in a series of coordinated investments in Microsoft that brings together artificial intelligence (AI), conversational computing and the calendar. The project, which we are presenting today at a Microsoft AI event in San Francisco, combines the efforts of Microsoft Research, Outlook, Cortana and Genee, an AI start-up that Microsoft acquired in August.

How does it work?

To use this new service, you must first register to get the preview waiting list in Once you are accepted into the program, scheduling a meeting is as simple as adding Cortana to the Cc line: in an email from your registered email address.

When writing the email, give Cortana instructions including the natural language to specify the duration of the meeting (for example, “let’s do this one 90 minutes”), the time (for example, “sometime next week”) and location (“make this a Skype meeting” “). Alternatively, you can set the default preferences in advance and Cortana will use those settings without additional commands.

To schedule your meeting, simply add Cortana to the Cc line.

After sending the email, Cortana looks at her calendar to find the hours it is available and then communicates with the guests to propose schedules. Cortana communicates directly with the assistants so that the round-trip email does not temper your inbox. While attendees respond with their availability, Cortana keeps the conversation going until a schedule that works for everyone is found. Cortana also follows up with attendees if they do not respond within 48 hours.

Cortana handles the coming and going of programming.

Once the date and time are confirmed, Cortana creates an event on your calendar with all the details and then sends an invitation to everyone.

Once the date and time are confirmed, Cortana sends a calendar event to the attendees of her calendar.

All interactions are natural and colloquial, as if a real-life assistant was coordinating the meeting. The service has human and machine intelligence to ensure that all programming requests are handled accurately.

Join the exclusive preview of

Microsoft is always looking for ways to help you do your job better. The project is an example of how we are working to add intelligence to our productivity applications so that you can focus on more important things. Today we are making these programming capabilities available in an exclusive preview for customers who are interested in helping to improve the service, especially those who frequently schedule meetings with people outside their organization. If you want to be considered for the preview, visit: and schedule some time together.

-The team

The post Enroll in the preview of and let Cortana schedule your meetings appeared first in

Please follow and like us:

Flex—delivering supply chain innovat Global companies often struggle to maintain the kind of fast-growing innovation culture that smaller companies seem to employ effortlessly. But this is a time of change in business, and thanks to technological advances, global companies can communicate almost as fast as a team working side by side. Now, companies like Flex can cross geographic boundaries to serve global customers even more effectively than ever. At Flex, our approximately 200,000 employees are responsible for prototyping, design, manufacturing and logistics for customers around the world. We are operating as a unique and cohesive company focused on innovation. It is not just that we can communicate and collaborate efficiently between our more than 100 factories or between headquarters and our various shopping centers. We are focusing on reinvention one step further by allowing all employees to share their ideas and experience to make Flex even more agile.

The notion of continuous improvement is well established, but we wanted to make sure that we are capturing opportunities to improve operations in all facets of our business, from the IT department to the factory. We are supporting this effort with Microsoft Office 365, using integrated applications not only for teamwork between companies, but also as the basis for applications that promote innovation and improve processes. For example, we have created an ideation portal in Microsoft SharePoint Online where we can share ideas. Employees send and vote ideas, and we see what ideas gain momentum and acceptance. We have even included some gamification around the winning ideas to encourage our entire workforce to participate.

Giving employees the opportunity to see their ideas come to life is rewarding and empowering. It also benefits the operational efficiency of our business and improves our level of service for customers. Supporting upward communication is paramount to our capacity for improvement, because our employees see how things work every day and think of new ways to offer better results. And most importantly, employees can have a global impact when their ideas are implemented as part of a workflow used by other colleagues.

We have also created interactive SharePoint Online communities for our project managers and vendors, who can use Yammer directly from SharePoint Online sites or on their smartphones with the Office 365 mobile applications. Employees can interact freely with each other through geographical and hierarchical boundaries, communicating and cooperating throughout the company. Whether it’s for customer incorporation, production line configuration, material distribution or new IT projects, some employees are using Office 365 to help us share knowledge and foster better teamwork in Flex.

Our clients trust us to offer the best solutions for their success. Showing the ways in which we are leveraging our own knowledge base to become a stronger company makes us a better business partner and a smarter employer. The types of open and unified communication and support for innovation that we provide through Office 365 help us meet those goals in the modern workplace.

-John Wrenn

Read the case study for more information on Flex digital transformation.

The innovation of the supply chain after the delivery of Flex on a global scale with
Office 365 first appeared in Office 

Please follow and like us:

Road realities—how to support your roa The road warrior travels from city to city, meets with potential clients and attends conferences and industry events. And your travel requirements do not seem to be diminishing. According to the Global Business Travel Association, spending on business travel reached record levels of $ 1.2 trillion in 2015, and is expected to increase to $ 1.6 trillion by 2020.

Their road warriors bring their products and services to new markets, diversify the clientele and strengthen existing relationships. They are helping your business grow, now more than ever.

However, doing your job from the road can be very difficult without the right productivity tools. So, how do you know if they have what they need?

Start by understanding the common challenges you face. Whether it’s to organize meetings, collaborate with colleagues or meet deadlines, you can make sure they’re set up for success.

Here are four productivity fears that often affect business travelers while on the road:

Did I forget to save the files of the company server before traveling?

Secure access to files should not be a privilege only for office employees. Being able to access the company’s server to access important resources is a basic requirement for most jobs. For employees who are on the move, it is essential to have such access anywhere, at any time. Whether in a hotel lobby or in a cafeteria, they should be able to connect to Wi-Fi and do their work. When the company documents are protected in the cloud, your employees can continue with their usual activities, practically from anywhere.

Will free time affect daily communication?

For road warriors, productivity depends on fluid communication and collaboration with teams in the office. Without face-to-face interaction with colleagues, employees can sometimes feel disconnected, and the ability to connect in multiple ways can make a difference. Secure video conferencing and messaging tools can close the communication gap, allowing business travelers to converse with team members and conduct online meetings on the fly.

Can we collaborate successfully while I’m in another location?

Teamwork is essential for business, whether your employees are on the road or huddled in a conference room. Business leaders must consider the value of technology that allows business travelers to create, co-author and share documents in real time. These skills allow teams to complete tasks and meet deadlines together, virtually from anywhere. Now, with the technology to share and collaborate remotely, it’s easier than ever.

5 tips to improve collaboration

How are the most reliable tools delivered to work together while reducing the challenges of multiple applications, mobility needs and security risks? Here are five tips to make it a reality.

Get the free eBook

What happens if I lose my internet connection?

The trip often occurs during business hours. While traveling on a train or 30,000 miles in the air, your road warrior still needs to send emails, build sales covers and meet deadlines. But sometimes the technology fails and they could lose Internet connectivity for minutes or even hours. At times like these, they can rely more on the tools that keep their work (documents, presentations and even email files) on a hard drive while they are offline and upload at the time of reconnection. While they are disconnected, they can continue reading emails, writing drafts, editing files, and making the work continue.

The productivity of your traveling employees is as good as the technology that supports them. As a business leader, you have the power to provide technology to help you do your job while traveling.

The post-road realities: how to support road warriors with technology first appeared in Office
This is how the website looks like
Features of Office 2016. image credits microsoft


Please follow and like us:

Learn more about the insights in Microsoft MyAnalytics In Microsoft Mechanics today, we take a tour of the latest Microsoft My Analytics updates. Catherine Pidgeon shares how to use My Analytics to improve the impact and success at work. From understanding where your time is going to to identifying areas of opportunity and getting information about collaborating with your most important groups, Catherine offers a complete overview of current features and the road map.

In addition, today we announce the availability of external contacts within your My Analytics experience. Now you can stay up to date on how you interact with important contacts outside of your organization. Whether clients, partners or external personnel: sometimes those with whom you work in all organizations are the most important to your success. Now you can quickly add important external contacts to your My Analytics panel to stay up to date with collaboration information, such as total collaboration time, meeting time, reading percentage and response time.

Get email summaries so ideas are sent directly to your inbox

Starting in January, the summary of My Analytics email will provide information about the weather and the network directly in your inbox. The summary will give you an idea of ​​your time and progress in relation to the objectives to help you identify the key trends that your action might require. With the quick ideas that are delivered each week, you will now be better informed to plan ahead and make sure you spend your time in alignment with your goals.


Do you already have My Analytics? Send us your comments in the comments, on Twitter @_MyAnalytics or through My Analytics User Voice. Would you like to see your own view of My Analytics? Start a free E5 test today at

Frequent questions

Q. How do I add an external contact?

A. Use the “search to add” field of the network section in your My Analytics panel to add external contacts to your full and valid email address.

Q: When will the groups be available?

A. The “My important groups” function is currently under development and will be available to customers in the first months of 2017.

Q: When will the summary email be available?

A. The summary email will begin to be implemented to customers in early January 2017.

Q. How is privacy managed within My Analytics?

A. Most of the information provided in My Analytics is already available to you, such as your time in meetings or your response time to others. In the event that this information is not available to you, such as the company’s average time at meetings, the knowledge is aggregated and voided to preserve the privacy of the end user.

In addition, organizations have significant controls to ensure that My Analytics meets the privacy requirements of their organization. See My Analytics for Office 365 administrators for more information.

Q. I am an end user in an organization that has My Analytics and I want to get more information about it. Is there any reference material available?

A. For more information, visit the tips of My Analytics and stay connected through our User Voice, Twitter @_MyAnalytics and the My Analytics group in Microsoft Tech Community.

The publication Get more information about ideas in Microsoft My Analytics first appeared in Office Blogs. 

Please follow and like us: