Excel

Adding rich data labels to charts in Excel 2013

Storytelling is a powerful communication tool, and data is essential for many decision-making tasks. Together, they can be data visualization at its best: the science and art of transforming your data so that the most important points shine through. Sometimes a basic chart will do the trick. But to make your visual message really pop, it’s often handy to add data and text to your chart. The rich data label capabilities…

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.

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

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.

Excel

Take the Excel Challenge for a chance to win a Kinect for Xbox 360 prize pack

We have some great news for Excel fans around the world! Our friends over at Microsoft Business Intelligence have launched an exciting new challenge on Facebook to test your skills and knowledge of Excel. Join the So You Think You Know Excel Challenge to answer 15 questions about Excel and you could get your name up on the leaderboard. Challenge your friends and colleagues or just play for fun. And you’ll have…