Excel

Using conditional formatting to highlight dates in Excel

Date functions in Excel make it is possible to perform date calculations, like addition or subtraction, resulting in automated or semi-automated worksheets. When you mix date functions with conditional formatting, you can create spreadsheets that display date alerts automatically when a deadline is near or differentiate between types of days, like weekends and weekdays. In this tutorial, Excel MVP Frédéric Le Guen shows how to put this functionality to work,…

News

Get started with Business Intelligence in the new Office

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. With SharePoint, users of all levels can collaboratively develop and…

News

The new Office lets me work from home–and everywhere else

As blogger-in-chief of MommaSaid.net for the past 10 years, Jen Singer has used technology to work around her kids’ (and occasionally, her cat’s) schedules. She’s done pre-show interviews with TV producers from the supermarket cereal aisle and edited books on her laptop while waiting for track practice to end. Now with SkyDrive, Microsoft’s cloud-based storage system, her Office can truly be wherever she is. She started writing this blog post…

Office 365

dmg Events excites workers, managers, and IT staff with move from Google to Office 365

International events producer dmg Events Middle East & Asia moved from an on-premises email system to the cloud-based Gmail system, and the move proved frustrating for employees and IT staff. When the Google contract came up from renewal, dmg decided it was time for a new email system. We recently spoke to Gehan Madhanayake, Head of IT at dmg Events Middle East & Asia, to learn why.

SharePoint

What’s new in SharePoint Online–top 10

SharePoint Online (SPO) has a gaggle of new innovation and welcome improvements. The premier sharing service is updated with a new, fluid user interface, active personal file sharing, higher storage limits for both personal and team sites, a high-end cloud app development model, and more robust tooling for admins to more easily and effectively control their SPO environment. Everyone benefits from the new SharePoint Online! Users benefit with new ways…

Project

Project Online and Excel Web App: Cloud data improves reporting

Along with the general availability of Project Online in Office 365, new scenarios have been enabled for Project Online reporting. We introduced the Project Online OData feed to help you access your data using Excel 2013, and now you can refresh Excel workbooks in Excel Web App that consume Project Online OData feeds. Learn how to grant the BI Azure Service access to your SharePoint Online tenant.

Excel

Format and customize Excel 2013 charts quickly with the new Formatting Task pane

The new Excel makes creating and customizing charts simpler and more intuitive. One part of the fluid new experience is the Formatting Task pane, which replaces the Format dialog box. The new Formatting Task pane is the single source for formatting–all of the different styling options are consolidated in one place. With this single task pane, you can modify not only charts, but also shapes and text in Excel.

SharePoint

Law enforcement organization cuts costs and streamlines operations with SharePoint 2013

Cambridgeshire Constabulary replaces aging Lotus Notes environment with 40 Microsoft SharePoint 2013 portals The Cambridgeshire Constabulary, which provides law enforcement and public safety services for 800,000 residents in Cambridgeshire, England, started using Microsoft SharePoint 2013 in April 2012 to develop a cost-effective environment where employees can easily discover information, share documents, and manage data.

Excel

Use Webservice functions to automatically update Excel 2013 spreadsheets with online data

Have you ever wanted to incorporate data from online resources into your Excel spreadsheets, such as stock quotes, weather, Bing Search results or even Twitter feeds? With new Webservice functions, now you can pull data from the internet into Excel–and the best part is the information updates automatically in your spreadsheet! Read on to find out how to put this functionality to work for you.

Office 15-Minute Webinars
Office 15-Minute Webinars

Watch Office 15-Minute Webinars anytime

Join us every Tuesday for free webinars about how to use Office programs. You can watch the Office 15-Minute Webinars live; or view them later. They run 9:15 am-9:30 am Pacific time on Tuesdays with a live Q&A session to follow. We’ll add links to previous recordings below as they become available. You can also download a calendar reminder for the series. Click the link to join Tuesdays starting at…

SharePoint

Yammer and SharePoint: Enterprise social roadmap update

At last November’s SharePoint Conference, we announced our roadmap for enterprise social and talked about three phases of Yammer integration: “basic integration, deeper connections, and connected experiences.”  (For more details, see the Putting Social to Work post published just after the SPC keynote.)  Today at Convergence 2013 we provided an update to that roadmap, and I wanted to share the details more broadly.