Excel

Excel

Opening workbooks by running separate instances of Excel

In Excel 2013, each of your workbooks opens in its own window, similar to Word and PowerPoint. This means that each workbook has its own ribbon and top-level window frame that you can move and resize independent from your other open workbooks. This functionality can improve multitasking, visibility, and analysis across workbooks. In this post, we’ll discuss some of the more advanced aspects of these changes, in particular how to…

Excel

Simplify management of an Excel Power View template by using a VSTO add-in

Templates are one of the cornerstones in modern professional Excel development. By using one or more templates, we can provide a structural approach for end users to acquire, store and present data. From a development point of view, we can simplify the maintenance. In this tutorial, Excel MVP Dennis Wallentin shows how to simplify management of a Power View template by using a VSTO add-in.

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…