Group items tagged

www.office.com/setup Blogs: Excel 2016 includes a powerful new set of features based on the Power Query technology, which provides fast, easy data gathering and shaping capabilities and can be accessed through the Get & Transform section on the Data ribbon. Today, we are pleased to announce 10 new data transformation and connectivity features that have been requested by customers. These updates are available as part of an Office 365 subscription. If you are an Office 365 subscriber, find out how to get these latest updates. If you have Excel 2010 or Excel 2013, you can take advantage of these updates by downloading the latest Power Query for Excel add-in. Updates include the following new or improved data connectivity and transformation features: Web Connector-UX support for specifying HTTP Request Headers. OData Connector-support for "Select Related Tables" option. Oracle Connector-improved Navigator preview performance. SAP HANA Connector-enhancements to parameter input UX. Query Dependencies view from Query Editor. Query Editor ribbon support for scalar values. Add custom column based on function invocation. Expand & Aggregate columns provide support for "Load More" values. Convert table column to a list-new transformation. Select as you type in drop-down menus. WEB CONNECTOR-UX SUPPORT FOR SPECIFYING HTTP REQUEST HEADERS With this update, we have added support for specifying HTTP Request Headers within the Web connector dialog. Users can specify header name/value pairs from the Advanced mode in this dialog. november-2016-updates-for-get-transform-in-excel-1 - www.office.com/setup ODATA CONNECTOR-SUPPORT FOR "SELECT RELATED TABLES" OPTION In this update, we have added relationship detection support for OData V4 feeds. When connecting to OData V4 feeds, users will be able to use the Select Related Tables button in the Navigator dialog to help you easily select all the tables needed for your reports. november-2016-updates-for-get-

When FHI 360 wanted to move to cloud-based business productivity services, the organization decided to implement a Microsoft cloud-based solution. We recently spoke to Douglas Wilkins, Director of IT Infrastructure at FHI 360, to learn how the company is benefiting: FHI360 logoQ: Please tell us about FHI 360. Douglas Wilkins: FHI 360 is a nonprofit human development organization dedicated to improving lives in lasting ways by advancing integrated, locally driven solutions. Our staff includes experts in health, education, nutrition, environment, economic development, civil society, gender equality, youth, research, technology, communication, and social marketing-creating a unique mix of capabilities to address today's interrelated development challenges. FHI 360 serves more than 60 countries and all US states and territories. Q: Why did you want to move to cloud-based services for messaging and collaboration? Wilkins: We had a diverse IT infrastructure. Employees in the US had different IT toolsets and Internet access than staff in countries like Mozambique. Subscribing employees to a single, cloud-based solution was the most expedient way to ensure that everyone had the same IT tools, to work efficiently regardless of location. Migrating our communication and collaboration technologies to the cloud reduced much of the time required by our IT staff to manage divergent IT infrastructures and connectivity options found around the world. Q: What criteria did you use to select Microsoft as your vendor for cloud-based business productivity services? Wilkins: We wanted a vendor that demonstrated a real interest in our mission and goals, and that offered online business productivity tools tailored for the enterprise space. The capabilities of the Microsoft Services Consulting team, and the work of Intellinet, the partner Microsoft introduced us to, provided us with that. We migrated our 4,300 staff members around the world from diverse platforms to a Microsoft Offi

When FHI 360 wanted to move to cloud-based business productivity services, the organization decided to implement a Microsoft cloud-based solution. We recently spoke to Douglas Wilkins, Director of IT Infrastructure at FHI 360, to learn how the company is benefiting: FHI360 logoQ: Please tell us about FHI 360. Douglas Wilkins: FHI 360 is a nonprofit human development organization dedicated to improving lives in lasting ways by advancing integrated, locally driven solutions. Our staff includes experts in health, education, nutrition, environment, economic development, civil society, gender equality, youth, research, technology, communication, and social marketing-creating a unique mix of capabilities to address today's interrelated development challenges. FHI 360 serves more than 60 countries and all US states and territories. Q: Why did you want to move to cloud-based services for messaging and collaboration? Wilkins: We had a diverse IT infrastructure. Employees in the US had different IT toolsets and Internet access than staff in countries like Mozambique. Subscribing employees to a single, cloud-based solution was the most expedient way to ensure that everyone had the same IT tools, to work efficiently regardless of location. Migrating our communication and collaboration technologies to the cloud reduced much of the time required by our IT staff to manage divergent IT infrastructures and connectivity options found around the world. Q: What criteria did you use to select Microsoft as your vendor for cloud-based business productivity services? Wilkins: We wanted a vendor that demonstrated a real interest in our mission and goals, and that offered online business productivity tools tailored for the enterprise space. The capabilities of the Microsoft Services Consulting team, and the work of Intellinet, the partner Microsoft introduced us to, provided us with that. We migrated our 4,300 staff members around the world from diverse platforms to a Microsoft Offi

While we are lucky enough to work with extremely innovative clients that are eager to embrace the latest technology, we always advise them not to adopt the latest version of software until after the kinks are worked out. For a consumer it's not a big deal to be test driving new features and experimenting with the latest version. For a business user, if there's a bit of a learning curve, buggy features or errors that make an application crash, it can be a huge detriment to productivity. That's why we take a lot of time testing out new applications and operating systems before we encourage our clients to adopt them. You may have read that Microsoft recently unveiled Office 2016. We spent some time with it and have some mixed feedback for our business users. Here's the good, bad and the ugly surrounding the Office 2016 suite: The Good: Built to make business better. Word is probably our favorite when it comes to the new suite of products. While there has been minimal change to formatting and structure - the overall design has definitely gotten a facelift. We're all about function, though and when it comes to function we see definite improvements. Word has many more templates. This allows businesses to refine their documents and be more professional without having to go online and download templates to use inside Word. There are also some pretty awesome co-authoring features that we wrote about in this blog. Attachments in Outlook reference recent documents. This is a great feature since it's available on any device that you use Office on. You can easily attach documents in e-mails in Outlook or reference them in an e-mail on your phone. This is really valuable for mobile users or users that work from more than one machine. (Which, lets face is, 90% of the workforce these days does.) OneDrive is also attempting to make its way into the life of business users by making sharing documents, collaborating on documents and authoring documents across devices a l

As governments strive to become more responsive and transparent, it's important for them to make public information easily accessible to citizens. At the same time, it's critical that they protect confidential data. A key reason why governments choose Microsoft Office 365 is Microsoft's leadership in the industry when it comes to privacy, security, and compliance practices. In short, governments know they can trust Microsoft to help protect their data. So how does Microsoft demonstrate leadership and why exactly do governments trust Office 365 to help protect their data? Here are four reasons: We respect your privacy. Google is under criticism for its privacy practices. Office 365 does not build advertising products out of customer data, unlike other companies. Nor do we scan your email or documents for building analytics, data mining, or advertising, or to improve the service. What's more, you own your data. Office 365 customer data belongs to the customer. Customers can remove their data whenever they choose. Office 365 is independently verified. Office 365 is compliant with many world-class industry standards, and it is verified by third parties. For example, Office 365 is the first major business productivity public cloud service to have implemented the rigorous set of physical, logical, process, and management controls defined by ISO 27001, one of the best security benchmarks available in the world. In addition, Office 365 is the first major business productivity public cloud service provider to sign the standard contractual clauses created by the European Union ("EU Model Clauses") with all customers. Office 365 also implements security processes that adhere to the Federal Information Security Management Act (FISMA) required by U.S. federal agencies and to the Health Insurance Portability and Accountability Act (HIPAA). With Office 365, you know where your data is located. Office 365 customers know where major Office 365 datacenters are located

We're all creators-each in our own way. I'm part of an organization that advocates for those who are creatively talented or gifted: artists, creators, and entrepreneurs. But I've found that we all bring creativity to our jobs in some form or another. I know that I can approach problems in a more creative way and find innovative solutions when I have the right tools and information within easy reach. At Copyright Alliance, we're a small team that serves more than 40 institutional members and thousands of artists around the country. For each of us, the ability to find and share files while on the go is a huge priority, especially because we tend to fill in for each other on different projects at a moment's notice. Balancing tasks like writing opinion pieces for news publications, giving talks at conferences, and meeting with members-all in the same day-is the norm. In the past, technology issues sometimes sapped my creative energy, making it difficult to stay focused on the task in front of me. Instead, I would have to scramble to find a document or a presentation that I needed. We had a file server at the office and I would routinely download all the documents I thought I would need before dashing off to the next engagement. This not only took extra time out of my day, it also wasn't a foolproof system. There were times when I just couldn't access the information I needed while out in the field. With Microsoft Office 365, all that has changed. Now that we have an online suite of tools for creating documents and managing them in a systematic way, we can all work together more fluidly. The menus and navigation in Microsoft SharePoint Online are simple to use, and it's reassuring to see exactly when a document was last updated. We're looking forward to using more of the tools in Office 365, including Microsoft Lync Online to make calls and hold meetings-all in a couple of clicks. I hardly think about the technology we use anymore. The transition to

Today's post was written by Jacob Guttman, IT Manager, Menchies It's hard to believe it when you look at our rapid growth, but Menchies is still a very young company. We were founded in 2007 with a single store in Valley Village, California. Now, we have more than 300 franchise locations around the world. Maintaining connections between Menchies headquarters, the franchise community, and our guests is critical to our success. In the past, we used hosted services for email, collaboration, and document management. And we used a separate, Java-based application for instant messaging. One of the most persistent challenges I faced was trying to support our company's growth with a set of applications that weren't tightly linked together and that didn't fit the day-to-day work needs of our employees. An increasing number of our employees want to be able to access email and other applications on a range of different devices, including their smartphone or tablet. Ultimately, they want to be able to connect with colleagues and seamlessly move information between applications without having to think much about the underlying technology. When we started looking at moving to a new productivity and collaboration solution, the major factors influencing our decision were ease of use, anywhere access, simplified administration, and cost-effective scalability. As we took a closer look at Microsoft Office 365, it was the obvious choice. And, with help from our partner Cal Net Technology Group, we were able to make the switch to Office 365 quickly and easily. With Office 365, we get online access to all of the capabilities we need-email, calendaring, document management, and unified communications-all rolled into one solution. And it automatically works together with the Microsoft Office tools that our employees use every day. One great example of how Office 365 supports the business needs of Menchies and fits the way our people like to work is through our use of Micro

WWW.OFFICE.COM/SETUP BLOGS: POWERPOINT MIGHT BE INCLUDED IN OFFICE 2016, BUT EVERYONE KNOWS IT'S SO PASSÉ. as easy as drag and drop - www.office.com/setup www.office.com/setup Blogs: These days it's all about Sway - the first of many native apps to be rolled out to Microsoft Office 365 subscribers. To put it simply, Sway is a web browser-based storytelling app. It allows anyone with the most basic computing knowledge to create beautiful-looking websites and presentations with images, text, tweets, videos or whatever other media you want to include. It works a bit like Word and Powerpoint combined - and finished products can be used on websites to display family photos, or in a beautiful work presentation. "The interface is based around a storyline, which allows users to bring in raw content such as PDFs, spreadsheets, graphs, photos, video and text," a spokesman for Microsoft told news.com.au. When creating a new presentation, users begin with a blank page containing nothing more than a title card. From there, add raw content, such as photos or text, and either place it all where desired or use a template that does the work for you. "It is as simple as clicking and dragging the content the user wants to add the presentation," the spokesman said. An impressive feature that sets this application apart from the likes of Powerpoint is its integration with popular social media networking sites. Users can import pictures from Facebook, YouTube videos, tweets and other content without having to leave the app. Once happy with the content included, users can tweak its appearance by using the "Remix" feature. This will cycle the appearance of the presentation through the many templates available in the app. Microsoft has completely embraced the cloud with Sway, with work available to view through a web browser on any device the moment its finished. The work can then be shared on social media or even embedded on other websites. Best of all, itâ€

The concept of a 'physical office' as a small business hub of productivity is quickly being replaced by the connected 'mobile office,' which connects employees wherever they happen to be. Today's business landscape favors those who are nimble and able to adapt rapidly by collaborating on the go, sharing ideas quickly and anticipating customer needs. Luckily, small businesses today can achieve this dynamic work environment through the use of Web-based software available for both desktop and mobile platforms. Web-based software is known as 'cloud services' or as 'the cloud' for short. Today, small businesses have access to IT solutions that were previously only available to enterprises - allowing them to punch above their weight class and better compete in their industry. By taking advantage of these Web-based and mobile solutions, small businesses can effectively run their company from anywhere - even from a mobile device or tablet. Here are just a few of the ways technology can help small businesses overcome everyday business challenges: ELIMINATE THE NEED FOR A PHYSICAL OFFICE Starting a business is difficult. Many small businesses owners may not have the capital to lease office space, or they may be hiring friends and staff who aren't based in the same city. Modern cloud technology can unify small business teams, removing the need for a physical office space. WORK WHEREVER IT'S CONVENIENT Cloud services let employees set up a shared folder from a mobile device while taking the bus; create a new spreadsheet on a tablet at lunch; get a presentation from the company's shared drive and make edits from a friend's computer; or schedule a team meeting from a home computer. Office 365 can be installed on up to 5 devices, giving small businesses the ability to do more than just read documents from a mobile device, a tablet, a laptop or even a desktop* by extending the office experience to employees wherever and whenever they need to cond

Small businesses have enough to focus on without having to spend time and energy worrying about email, data storage or backup servers. In fact, most small businesses don't know or understand what a server is. The good news is that in today's technology environment, they don't need to. This is because more small businesses are rapidly moving from outdated technology solutions to Web-based solutions to power their company, also known as "moving to the cloud." By moving to cloud solutions like Office 365, small businesses find they can concentrate their resources on growing their business rather than trying to solve technical issues. Large enterprises typically have entire divisions dedicated to supporting and keeping their IT infrastructure up and running. Even though small businesses don't have this luxury, they can still punch above their weight by choosing the enterprise-grade IT services in Office 365 to help solve their most top-of-mind business challenges.

Small businesses have enough to focus on without having to spend time and energy worrying about email, data storage or backup servers. In fact, most small businesses don't know or understand what a server is. The good news is that in today's technology environment, they don't need to. This is because more small businesses are rapidly moving from outdated technology solutions to Web-based solutions to power their company, also known as "moving to the cloud." By moving to cloud solutions like Office 365, small businesses find they can concentrate their resources on growing their business rather than trying to solve technical issues.

www.office.com/setup Blogs: If you are still using Microsoft Office 2003, you should be aware that Official support has long ended. If you are using Office 2007, support is due to end in 2 short years. Microsoft Office 2016, the latest Windows-based version of the major technology company's application suite, is scheduled for a release sometime in spring, 2015. However, we already know quite a bit about the product, thanks to a preview and testing program that Microsoft has been running. Here are 6 details to look forward to, ahead of the product's mainstream release: 1. Better Security Microsoft Office 2016 will emphasize the value of better security parameters. In addition to a file-level encryption functionality, new data loss protection tools inside of Microsoft Word, Microsoft Excel, and Microsoft PowerPoint will warn users when they attempt to save confidential files to unsafe locations. Microsoft Outlook will also be more secure, thanks to a multi-factor authentication feature. Similarly, the application suite will have stronger information rights management tools that let you limit what people can do with your documents or emails after you've shared access with them. For example, you can allow access to a certain document to expire after a set period of time, and prevent it from being forwarded. These tools will also stop people from copying and pasting information out of Microsoft Office 2016 applications. 2. Business Intelligence Features Microsoft Excel lives up to its name in Microsoft Office 2016. The latest version of this application features a built-in business intelligence tool called Power Query. This tool can dramatically change the way that you approach your data. Using it, you can quickly combine your own numbers with figures from public databases like Data.gov and Microsoft Azure Marketplace. After doing this, the application has another tool that lets you create detailed visualizations of the combined data. The data analysis tool

In order to stay competitive in today's world, teams need to connect and share with each other more than ever before. On March 28th, we had the pleasure of hosting Rob Koplowitz from Forrester Research and Walton Smith from Booz Allen Hamilton in a live webinar where they discussed why organizations are turning to enterprise social and how they are using it to help their teams work more openly and efficiently. Rob discussed how communication is changing, and how we're accessing and interacting with information in new ways-incredibly, 66% of information workers in North America and Europe already work remotely.* The shift to cloud-based software and platforms is definitely contributing to some of these changes. The old way of building software involved engineers, months of coming up with specs, running Beta programs, and debugging. The time from idea to ship could take years. So the introduction of the cloud-and social-to the Enterprise is enabling companies to innovate and move to market faster than ever before. The cloud provides anytime, anywhere access which is essential to our increasingly mobile work environments; today employees can quickly and easily access a range of business systems, information and expertise from anywhere in the world. Our shift to cloud-based platforms and the introduction of working openly with social are changing the way teams collaborate. Take, for example, Booz Allen Hamilton, a leading provider of management and technology consulting services. The company has over 26,000 employees worldwide, with over 71% of their employees working on-site with customers, which often limits their access to company resources.** But in order to provide the best service to their clients, consultants need to be able to quickly and easily access information and expertise. Booz Allen recently integrated Yammer as a social layer across business tools because the cloud-based platform enables consultants world-wide to collaborate virtually. When o

www.office.com/setup Blogs: When it comes to technology in the workplace, most every convenience is balanced against a potential threat. Email and the cloud-for as much as they've revolutionized the way we do business-have enabled new methods of theft and fraud and necessitated new regulations. That means planning a secure future for your company is no easy task. Thankfully, you don't have to set out on the road to protection without a map. Keeping a few key considerations in mind can help guide your way and keep your business safe from harm.

New US President Donald Trump's 'Buy American, Hire American' call in his inaugural address has put the Indian IT industry on edge.

Last week, we welcomed Brian Solis, Altimeter principal analyst, thought leader and book author, to Yammer HQ to give a fireside chat, followed by signing of his new book: "What's The Future of Business?" I was thrilled to interview Brian, and we covered a variety of really meaty subjects - just check out the video below! The theme of the evening was transformation - transformation that is happening in our lives as individuals, how we relate to each other through technology and what we as businesses must do to stay relevant to the connected customer. Even the book itself is transformation of the book publishing convention. Unlike a regular, information-dense business book, "What's the Future of Business" attempts to bring together the best of both worlds: hard-hitting facts and practical frameworks, as well as a visual experience. The experience of the book is just as important as the content therein. What is the future of business? The future of business is experience, according to Solis. We as connected consumers make decisions outside of the sales funnel that companies have organized themselves around. We reference experiences of consumers who came before us, and contribute our own experiences to this dynamic tapestry. When consumers share, they are reacting to an experience, and the future of any business depends on its ability to provide experiences that are worth sharing. In his talk, Brian talked about the 4 moments of truth that add up to shareable experiences. At every stage of the customer journey, it is our job as businesses to design an experience to trigger the sharing of a moment. The Zero Moment of Truth comes when the consumer is starting to explore choices and is just becoming aware of needs and possible solutions. 1st Moment of Truth happens when the consumer is ready to buy. Consumer packaged goods companies have perfected providing the right experience at this point. 2nd Moment of Truth happens after the consumer purchases,

Today's post was written by Nick Portello, Network Manager, Steve Moore Chevrolet. Read more Office 365 customer stories here. Office 365 Customer Steve Moore Chevrolet_Nick PortelloWhen I joined Steve Moore Chevrolet as the sole IT staffer six months ago, the dealership was in dire need of new technology. Employees coped with aging PCs, an outdated POP3 email service, a poor mobility experience, data loss, and no collaboration tools. Then I heard about Microsoft Office 365, which gives you the latest version of Microsoft Office, plus a suite of cloud-based communication and collaboration tools that solved all our problems. Unlike Google Apps, the UI was familiar to our employees and Microsoft offered a flexible subscription-based payment option, which is ideal for our fluctuating workforce. Now that our documents are stored in Microsoft SharePoint Online and SkyDrive Pro, we have easy access to collaboration tools with robust security. I no longer worry about falling out of compliance with Chevrolet auditors, losing important financial data, or having to pay fines that could reach $250,000. I can also find data on-demand for Chevrolet auditors and use my mobile device to look up information, which saves about 40 percent of every day-I'm no longer running between my computer and the sales, service, and administration departments. I can focus on what I really need to do. Thanks to Office 365, we are all able to get on with our work! Learn more about Steve Moore Chevrolet and Office 365 by watching the video below and reading the case study.

The U.S. Environmental Protection Agency expects to save $12 million over four years. The City of Chicago anticipates saving $1.3 million over the same length of time. And the State of Minnesota expects to save at least $800,000. Governments of all sizes are finding ways to reduce IT costs while improving efficiency. What's their secret weapon? With public sector budgets shrinking in many places around the globe, smart governments are making taxpayer dollars stretch further by migrating from an on-premise environment to Microsoft Office 365 in the cloud. By moving to Office 365, governments can reduce both their capital and operating costs. And by saving money, they can make taxpayer dollars go further during a time when budgets are tight and there's often less revenue to work with. So how exactly can Office 365 save governments money? First, governments can cut back on the capital cost of investing in more computer servers. Second, they can reduce the administrative cost of having to maintain an IT environment. Third, they can lower their energy costs by reducing the size of their data centers. And they can also reduce costs using the many tools within Office 365 that improve employee efficiency. According to a study conducted by Forrester Consulting, Office 365 delivers an ROI of 321 percent with a payback period of two months for a composite midsize organization. That translates into huge value for public sector organizations! Among the government agencies that anticipating money saved by implementing Office 365 is the Environmental Protection Agency. The agency expects to save $12 million over four years by moving to the cloud and Office 365. Some of those savings will be in energy costs as the agency relies on Microsoft to operate its data centers. "The EPA will continue to lead the pack on environmental stewardship, and moving an IT environment to the cloud is a natural part of that," says Greg Myers, vice president of Microsoft Federal. "There

Today's post was written by Nick Portello, Network Manager, Steve Moore Chevrolet. Read more Office 365 customer stories here. Office 365 Customer Steve Moore Chevrolet_Nick PortelloWhen I joined Steve Moore Chevrolet as the sole IT staffer six months ago, the dealership was in dire need of new technology. Employees coped with aging PCs, an outdated POP3 email service, a poor mobility experience, data loss, and no collaboration tools. Then I heard about Microsoft Office 365, which gives you the latest version of Microsoft Office, plus a suite of cloud-based communication and collaboration tools that solved all our problems. Unlike Google Apps, the UI was familiar to our employees and Microsoft offered a flexible subscription-based payment option, which is ideal for our fluctuating workforce. Now that our documents are stored in Microsoft SharePoint Online and SkyDrive Pro, we have easy access to collaboration tools with robust security. I no longer worry about falling out of compliance with Chevrolet auditors, losing important financial data, or having to pay fines that could reach $250,000. I can also find data on-demand for Chevrolet auditors and use my mobile device to look up information, which saves about 40 percent of every day-I'm no longer running between my computer and the sales, service, and administration departments. I can focus on what I really need to do. Thanks to Office 365, we are all able to get on with our work! Learn more about Steve Moore Chevrolet and Office 365 by watching the video below and reading the case study.

The digital advertising company, which receives ninety percent of its revenue from advertisers has publicized in its blog that it is dynamically tackling the "bad ads" that "promote illegal products and unrealistic offers" or "trick people into sharing personal information and taint devices with harmful software."