Group items tagged

This tutorial on using conditional formatting to highlight dates is brought to us by MVP Frédéric Le Guen, with special acknowledgment and thanks to Ken Puls for assistance with translation from French to English. Date functions in Excel make it is possible to perform date calculations, like addition or subtraction, resulting in automated or semi-automated worksheets. The NOW function, which calculates values based on the current date and time, is a great example of this. Taking this functionality a step further, when you mix date functions with conditional formatting, you can create spreadsheets that display date alerts automatically when a deadline is near or differentiates between types of days, like weekends and weekdays.

Part of the thrill of working for the Office Division is the opportunity to tackle thorny business issues on behalf of our customers while providing them with a road map for the future. That may be why an interesting article caught my attention this week. In it, the author examined some of the investments Microsoft is making in the unified communications space. While I didn't agree with all of the conclusions it contained, the article certainly underscored the interest in communications and collaboration and how to make people more productive.

Every couple weeks, we round up industry news and articles you might have missed. We hope you enjoy our latest selections. The Office 365 Upgrade: New Outlook Web App. The new Office 365 includes "a vastly improved" Outlook Web App. ABB Deploys Office 365 and Yammer Worldwide. Power automation firm ABB plans to deploy Office 365 to its 145,000 employees around the world. V8 Supercar Races Off with Microsoft Office 365. V8 Supercars chooses Office 365 because of trust in Microsoft brand. Microsoft's Lync Communications Platform Used by President Obama's Re-election Campaign. The Obama campaign used the Lync platform during the 2012 elections, enabling staff to work from anywhere. Why Office 365 Makes Sense for Small Business. Three compelling reasons why Office 365 may make sense for small businesses: a low upfront cost, multiple licenses, and Exchange Online. Microsoft's Top Ten SharePoint Online Features. A senior product manager on the SharePoint Team shares his top 10 features of SharePoint Online. Microsoft Turns Up 'Scroogled' Attacks with Campaign Against Google Apps. Microsoft calls on Google to stop providing user information to third-party Android developers.

You can access and share Office documents with browser-based versions of Word, PowerPoint, Excel, and OneNote. Learn some of the basics and the latest features of these free tools. Note: Office Online was formerly known as Office Web Apps. There is an updated webinar about Office Online at http://aka.ms/online123.

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.

Over the past few months, customers across the globe and from a wide range of industries have chosen Office 365 to communicate and collaborate more effectively using familiar cloud based applications they know and trust. The retail industry is using technology more than ever to stay competitive while better serving the needs of their customers. In January we shared how large companies like Tescoand Helly Hansen have joined other notable brands such as, 'wichcraft, BCBG, and Sephora who are moving to Office 365 for security-enhanced access to the familiar productivity tools they rely on at all levels of their business. Office 365 has become the go-to-choice for retailers looking to move their productivity to the cloud - in fact, our retail customers employ more than 8 million people worldwide, more than the total population of Hong Kong!

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.

Forms are the cornerstone of business applications, and plenty of options exist to create a form in SharePoint. Which one you use will depend on your needs, technical skill and the version of SharePoint you are using. In this article we'll explore seven ways to build forms in SharePoint along with some of the pros and cons of each. All these options will be storing the data in an existing SharePoint list.

Ready to get a hands-on, in-person learning experience on how Microsoft Project can help you get more out of your projects and optimize your portfolio? Microsoft and our partner community host events in cities all around the U.S. where you'll have the opportunity to learn more about Project and what it can do to help you streamline your work and achieve your strategic objectives.

Meeting notes, vacation plans, grocery lists, great quotes, notes to self-let me count the ways to use OneNote. Consolidate all of your crucial information chunks and snippets in one place, then link with OneDrive to share this virtual notebook with yourself (roaming), with other people (collaboration), and with other devices (OneNote ecosystem).

Most people know that you can create PowerPoint presentations with pictures, music, images, web content, and text, but one little known trick is the ability to save PowerPoint presentations as videos. PowerPoint presentations have been a long time favorite for use in business and academic presentations all over the world. They are highly versatile and offer a wide variety of features that you can use to enhance them.

This post is brought to you by Seayoung Rhee, Product Marketing Manager in the SharePoint Product Marketing Group. 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.

Ever wish Word had an encyclopedia you could tap, or Excel could generate some dummy numbers? Office add-ins provide this kind of added functionality to Word, Excel, PowerPoint, and other Microsoft Office apps. Here are some of the handiest add-ins you can install for Office 2013 and above to get more out of your office suite. We previously highlighted Office add-ins and apps for Office 2013 and earlier, but since then Microsoft has renamed "Office Apps" to "Office Add-ins". Now there are more than a handful of these plugins you can install to enhance Microsoft Office, whether you're using Office 2013 or 2016, Office Online, or Office on the iPad.

Are you using the new Project and wishing you could enhance its powerful capabilities with apps? Project 2013 has great extensibility potential-even across devices. The new apps for Project enhance capabilities of Microsoft Project 2013 applications, including Project Pro for Office 365, Project Professional 2013, Project Online and Project Server 2013.

Guest blogger Emily Warn is co-owner of Two Pens, which provides blogging services and teaches business how to write content that grows a social media following. My writer friends think I'm a geek. You can do what?! I can create a spreadsheet with book sales numbers that can be sorted by name and number. I know that is only the first rung of Excel Geek-dom, and unlike my compatriots, I aspire to climb into the ranks of those who know how to create snazzy charts and perform other formatting feats. Perhaps I'll be able to brand myself as a writer who plays with numbers.

As announced earlier today, over the next few days we are releasing an update to Microsoft account. For people who use Outlook.com, this includes a number of new features such as two-step verification, the ability to sign in with an alias and new international domains for your email address. OPTIONAL TWO-STEP VERIFICATION HELPS KEEP YOU MORE SECURE You can now choose to enable two-step verification for your entire account. Two-step verification is when we ask you for two pieces of information when you sign in to your account-your password plus a code sent to a phone or email that you gave us as security info. Many of you have asked for this and we're delighted to be able to offer this capability. Two-step verification is a great way to add extra protection to your account. Once you've enabled two-step verification, even if a criminal gets your password (for example, through malware on a friend's machine that you used, or if you use the same password for another service that gets breached) they can't access your account.

Actress Felicity Huffman has a lot going on. She's got her website Whattheflicka.com, family activities and responsibilities, television and movie projects, publicity details, and of course her own bucket list. According to Felicity, "If Office 365 is like having your office travel around with you, OneNote is like having an office assistant combined with my own personal tutor right there in my big Mom bag that I carry around everywhere."

Every couple weeks, we round up industry news and articles you might have missed. We hope you enjoy our latest selections. Microsoft: Office 365 Cloud Now $1 Billion Business. Office 365 is now a $1 billion business; one in every four enterprise customers now have cloud seats with Microsoft. Office 365 Review. Office 365 "is still the best productivity suite on the market." Its comprehensiveness and the ability to stream a full version of programs give it the edge over Google Apps.

Today I am going to talk about Microsoft sway in Office 365. Sway is a presentation program and its part of Microsoft since from August 2015. Sway allows users who have a Microsoft account those can combine text and media to create a presentable website, it is very easy to do this. We can copy or open the information from local system and make use for social sites and others. Sway is online and browser based where PowerPoint is primarily as a desktop with Office 365 we can get some limited features.

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!