Excel

Excel

New server release: Spreadsheet controls in Office 2013

In April, we released 2 important new spreadsheet management server-based applications to complement the desktop spreadsheet management features we introduced with the release of Office 2013. Now available are Audit and Control Management Server (ACM), and Discovery and Risk Assessment, which are both designed to help you manage the use of spreadsheets and Access databases.  Read on to learn more.

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,…