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.

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.

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.

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.

April's Customer of the Month is Robert Aichele, Senior Manager, Store Communications at Jamba Juice. I've been at Jamba since 2009 managing internal communication, primarily store and field communication, with a hand in some broader projects connecting our strategic vision with the managers in the field. Our Yammer network debuted in 2011, catching on with a small group and then expanding quickly to include our entire Support Center. It was so popular we extended it to our company-owned store managers later that year, and it plateaued happily there for several months as an interesting tool to share ideas and problem solve operational issues when we needed to hear diverse perspectives quickly. I'm a firm believer in story telling as a means to engage employees with the "why" behind what we do as a company - and sometimes what we stop doing - and in the spring of 2012 we had a big story to tell. Our first National Hiring Day was happening in Jamba stores across the country as we prepared to hire thousands of new employees and ramp up for our busy summer season. We'd organized the event through traditional channels: our intranet, email, weekly task management publications, and pre-event conference calls. And we had big plans to collect photographs, interview hiring managers, and write up a recap to share the success stories with everyone after the fact. On the big day I logged into Yammer and got a big surprise. The event was unfolding in glorious detail right as it happened with photos, comments, personal stories, and genuine pride and enthusiasm for the Jamba brand just pouring out. We never wrote that recap.

If you're a fan of PowerPoint, you may have heard about Microsoft's latest presentation tool, Microsoft Sway. With Sway, you can create and share presentations like never before! In today's blog, we'll give you a basic overview as to what Sway can do as well as some of our personal favorite features. Let's dive in!

Pre-installed copies of Office may come with a product key, or it will activate over the Internet with no product key being required. If the product key is not required, please note that this is a limited time offer and expires six months after you activate Windows. The expiry date will be shown as below.

You have 15 minutes of your Senior Manager's time. Your goal: encourage his/her participation on Yammer. What are the three items you would focus on? Sounds like an awesome challenge, doesn't it? This was exactly the challenge that one of our customers Ernst Décsey, Intranet Manager from UNICEF posed in the YCN, Yammer Champion Community. His question was greeted with a flurry of amazing responses, which we just had to share here (with participants' permissions of course!)

In order to be taken seriously, small businesses need to convince customers of their professional ability and their value. Small businesses can punch above their weight by taking the time to go to market with a professional set of business documents, templates and content to ensure customers aren't dismissing them before they have a chance to pitch the value of their product or service.

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.

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!

Sometimes there is frantic need to create links in database table to web pages, files, folders, images, etc. Access 2010 provides a convenient way to link up data field values with anything to complement the database in much better way. In this post we will guide you on creating a table field having Hyperlink data type. To start off with, launch Access 2010 and navigate to Create tab and click Table. createtable1 Create Hyperlink Field In Access 2010 - www.office.com/setup It will create a new table namely Table1. Right-click newly created table and select Design View to add fields with specific Data types. table11 Create Hyperlink Field In Access 2010 - www.office.com/setup Enter an appropriate table name and start adding fields. We will be entering some generic table fields with their data types such as, ID, Name, Phone Number, Email and other Links.

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.

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.

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.

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.