Visio

Data-linked diagrams: Creating a diagram

Visio offers over 60 types of professional templates to build compelling diagrams, and organization charts are among most frequently created. Visio organization charts are simple and visual, but what if you want to connect them to key business indicators your organization is tracking, such as sales by region or department or budget by department, vacation status, training reports? Sometimes this information is located in another source such as Excel or …

News

Extend your networking reach with social apps for Office

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). Read on to…

Excel

Dallas Utilities: Electricity seasonal use simulation using project codename “GeoFlow” Preview and Power View

The Microsoft account team in Dallas, TX wanted to create a localized demonstration that would be recognizable to customers in the area. Taking advantage of publicly available residential data and awareness of the extreme summer temperatures in and around Dallas, the team decided to present simulated household energy consumption data using Excel 2013, Power View and project code name “GeoFlow” Preview for Excel, believing the presentation would peak customers’ interests. Read…

Excel

Public preview of project codename “GeoFlow” for Excel delivers 3D data visualization and storytelling

Today we are announcing the availability of the project codename “GeoFlow” Preview for Excel 2013, a result of collaborations between several teams within Microsoft. GeoFlow lets you plot geographic and temporal data visually, analyze that data in 3D, and create interactive “tours” to share with others. Read on to learn how GeoFlow adds to the existing self-service Business Intelligence capabilities in Excel 2013, such as Microsoft Data Explorer Preview and…

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…