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.

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).

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.

Right around the same time as we moved into our new digs on Market Street, we launched Yammer's civic engagement initiative called Mid-Market Matters, which focuses our community efforts on issues affecting our new neighborhood. Through this initiative we encourage Yammer employees to get out of the office (as beautiful as it is) and interact with our neighbors - whether that means grabbing a coffee at MaVelous, taking dance classes at LINES Dance Center, or volunteering at a local non-profit.

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.

Microsoft Corp. announced today that the power and automation technology company ABB will deploy Microsoft Office 365 and Yammer to its employees worldwide. With about 145,000 employees in 100 countries, ABB is transitioning from multiple IT collaboration and messaging solutions to Office 365 to provide a single solution for productivity, communication, collaboration and enterprise social in the cloud.

Does Microsoft Word 2016 regularly detect words that you commonly use as misspelled words? You can change this by adding custom words to the dictionary. OPTION 1 - ADD WHILE WRITING Type the word in your document and right-click on it and select "Add to Dictionary".

The Outlook 2016 release focuses mainly on de-cluttering the user interface and simplifying your workflow. Microsoft Outlook is the world's most favored business email client. The application already offers excellent integration with contacts, calendars, notes, tasks, and of course, email.

A few weeks ago, preview versions of Microsoft Office products for 2016 were released. The release included Microsoft Office 2016 suite products, plus Project and Visio. All the products are available in desktop and office 365 formats for trials. We shared the links to download/install preview of Microsoft Office and Project 2016 in this post a while ago. Since then, I wanted to write my first hand review of Project 2016, so here it goes. INSTALLATION OF PROJECT 2016 First things first, installation challenges. Prior to installing Microsoft Project 2016 (this is the same for Office 2016) you will need to uninstall the 2013 version of the same product, as they can't both be installed at the same time. It's easy to uninstall and then reinstall a new version, right? Not really. Unfortunately, this isn't as simple as it sounds particularly if you have ever had Microsoft Project 2013 office 365 version installed on your machine along with Project 2013 desktop version. At least in my case, I have tried every possible way of removing 2013 version, but Microsoft Project 2016 kept crashing soon after it started. Here, and may be few other places, described a solution to an issue but it never worked for me and eventually I end up installing to a fresh VM that has no traces of prior version.

What is Microsoft Visio used for? Diagrams. That's what Microsoft Visio does, and it does it better than any other app I've seen yet. From flow charts to floor plans, there isn't much it can't handle. Now, being honest, I didn't know much about Visio until recently. But that changed when I decided to take it for a test drive - right out of the latest Microsoft Office. Visio Templates Office 2013 - www.office.com/setup Microsoft Visio can be used to create simple or complicated diagrams. It offers a wide variety of built-in shapes, objects, and stencils to work with. You can also make your own shapes and import them if you're willing to do all that extra work. The driving idea behind Visio is to make diagramming as easy as possible for the user. I think Visio is on the right track for that! Note: Click images below to open them at Full Size. The Visio 2013 welcome screen features a dozen different templates to get you started. Each template equips you with the appropriate menu and objects already open and ready for use. Even more templates can be found in specific categories within the application, or from Visio's online download page. visio welcome screen - www.office.com/setup Visio's primary clientele have been Enterprise users at the corporate level. If you think about it, it's not too often that the home user needs to write up professional diagrams. Usually, a paper and pen will suffice because a home user's diagram isn't being sent out to an entire department. That's why Visio has always been considered a program for "serious" diagrams. But it doesn't have to be. table chart with live data - www.office.com/setup Visio can be used to create 3D map diagrams, though the built-in tools for this are limited. It works well for simple maps that you might print on a brochure or campus directory. visio map - www.office.com/setup Another thing Visio can do is pull in live information from an external source, such as an Excel shee

Whether you are a novice user of Microsoft Project 2013 or you want to learn about IT Professional or developer topics, please consider our new quick start training for Project 2013-it's free and available on demand! www.office.com/setup You get over 9 hours of content divided into 13 modules. Don't have much time? Don't worry, each module is broken down into individual videos so you can go at your own pace.

Microsoft Word's table templates are great timesavers. With them, you can quickly apply your own custom formatting to any table in Word. Here's how to create your own table style and save it as a template. The easiest way to create your own table template is to start with one of Word's built-in table styles and then tweak it to your preferences.

Stay updated on your Yammer network as new messages come into the feed. Our new integration with The Social Radio provides Yammer users a unique offering: to listen to their Yammer messages, read aloud through The Social Radio interface. The Social Radio reads new Yammer messages, polls, events and praise as they come through the feed, while you simultaneously listen to music. To use, just sign in to The Social Radio using your Yammer credentials and The Social Radio will begin reading your Yammer messages. If you hear something worth checking into - pop over to your Yammer feed to read more about it or join the conversation. www.office.com/setup The Social Radio's team participated in Yammer's Hackathon last year and built the first prototype of the integration. Since then it's been onward and upward! "We launched our first app 1 year ago, and we've been focusing on Twitter because we wanted to do only one thing to make it great. Building the integration with Yammer was really challenging for us because it's not just 140 characters. We choose Yammer to be our second social network because it's would be huge to allow employees to be updated while they can focus on what they are working on" says Roberto Gluck, CEO of The Social Radio. The main goal is to allow users to experience Yammer, and stay updated on their feed, while they are working on something else. The app is available in 6 languages: English, Spanish, Portuguese, French, Italian and German with male and female voices. Currently, the Yammer integration is only available on the web, but support for mobile apps is coming soon.

Yana Terukhova is a Product Marketing Manager on the Microsoft Visio team. Visio offers over 60 types of professional templates to build compelling diagrams, and organization charts are among most the frequently created. Visio organization charts are simple and visual, but what if you want to connect them to key business indicators tracked by your organization, such as sales by region, budget by department, vacation status, or training progress? Sometimes this information is located in another source, like Excel or a complex database. Data-linked diagrams let you add data to Visio diagrams-no code required-and anyone in an organization can quickly create such dashboards to get better insights into data using Visio Professional 2013 or Visio Pro for Office 365.

Inserting images in a word file exemplifies the true meaning of the word document. It helps the document to be more artistic as it includes images and drawings. With the help of images, the word document can be understood in a better way.Whenever we wish to insert a picture/image in a word document, we can copy-paste the image from any directory to the word file but inserting through the conventional method must be preferred.

Learn about Visio, a program designed to help you make diagrams for flowcharts, room layouts, timelines, organizational charts and a lot more. We'll start at the key of Visio: understanding how its shapes work.

Today's post was written by Howard Kourik, Director, Information Systems, San Diego County Regional Airport Authority The San Diego County Regional Airport Authority manages operations at one of Southern California's busiest regional airports, San Diego International. We were created to serve the public and have a mandate from the state of California to address the local area's long-term transportation needs.

Today's guest blogger is Javier Vasquez, Senior Director of Productivity Sales, State and Local Government at Microsoft. For the past 15 years, Javier has helped public sector customers implement solutions that help them realize value in their technology investments. As government agencies prepare for this week's Lean Government Virtual Summit, cloud innovation will surely be a hot topic. So why should governments choose Microsoft Office 365 as they consider moving their productivity software to the cloud?

Yana Terukhova is a Product Marketing Manager on the Microsoft Visio team. Visually displaying always up-to-date information on clearly laid out diagrams helps to communicate information effectively. In this post, we will see how to connect data from external sources to a diagram.