Results for:
Excel 2013

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

  23 May 2013

  Today's tutorial is brought to us by MVP Dennis Wallentin, who has been developing Excel business solutions since the 1980s. He is the founder of XL-Dennis , author of various articles for MSDN and Swedish technology publications, and co-author of an Excel textbook. One of the cornerstones in modern...
• New server release: Spreadsheet controls in Office 2013

  14 May 2013

  This blog post was originally published in September 2012, and we've updated it to announce the recent release of the server applications. It is brought to you by Steve Kraynak, Office Program Manager focusing on spreadsheet management features. In April, we released 2 important new spreadsheet management...
• Summing data across multiple criteria on multiple worksheets

  1 May 2013

  Liam Bastick has provided financial modelling services and training to clients for more than two decades. A senior accountant and professional mathematician, he has worked in numerous countries with many internationally recognized clients, providing and reviewing strategic and operational models for...
• Improved data grid for charts in Word and PowerPoint

  25 Apr 2013

  This post is brought to you by Kevin Donovan, a Program Manager in the Graphics and Data Visualizations Team. One of the overlooked improvements that we added to charting in the new Office applications has to do with the "data grid" shared between Excel and PowerPoint/Word. We introduced the "data grid...
• Excel Geek Express—otherwise known as Quick Analysis

  18 Apr 2013

  Guest blogger Emily Warn is co-owner of Two Pens , which provides blogging services and teaches business how to write content that grows a social media following. My writer friends think I'm a geek. You can do what?! I can create a spreadsheet with book sales numbers that can be sorted by name and number...
• Dallas Utilities: Electricity seasonal use simulation using project codename “GeoFlow” Preview and Power View

  11 Apr 2013

  Igor Peev, Bryan Smith, and Ari Schorr collaborated on this article. Igor is a Senior Program Manager who enjoys working on challenging projects that deliver new, innovative and immersive experiences. In project codenamed "GeoFlow," Igor works on the data Time animation and the interactive Tours functionality...
• Public preview of project codename “GeoFlow” for Excel delivers 3D data visualization and storytelling

  11 Apr 2013

  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...
• Using conditional formatting to highlight dates in Excel

  4 Apr 2013

  This tutorial on using conditional formatting to highlight dates is brought to us by MVP Frédéric Le Guen , with special acknowledgment and thanks to Ken Puls for assistance with translation from French to English. Date functions in Excel make it is possible to perform date calculations...
• Format and customize Excel 2013 charts quickly with the new Formatting Task pane

  27 Mar 2013

  The new Excel offers a rich set of charting capabilities that make creating and customizing charts simpler and more intuitive. One part of the fluid new experience is the Formatting Task pane. Until now, precise adjustments to chart elements were made in the Format dialog box. The box sometimes obscured...
• Use Webservice functions to automatically update Excel 2013 spreadsheets with online data

  21 Mar 2013

  This post on exploring Webservice functions is brought to you by Lee Bizek, a Program Manager in the Excel Team. 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...
• Take the Excel Challenge for a chance to win a Kinect for Xbox 360 prize pack

  18 Mar 2013

  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. Please join the So You Think You Know Excel Challenge to answer 15 questions about Excel and you...
• Webinar: 5 things you need to know about Freezing Panes in Excel

  11 Mar 2013

  Need to navigate that huge spreadsheet quickly? Freeze panes can help by allowing you to view your column and row headings continuously while you scroll your document. In this webinar, we'll demonstrate how to freeze panes in an Excel workbook, plus we'll give you 5 tips of this feature, just in case...
• Which keyboard shortcuts should we add next to Web Excel?

  4 Mar 2013

  This post is brought to you by Daniel Stein, a Program Manager in the Excel Team. CTRL+PgUp, CTRL+F, SHIFT+TAB: keyboard shortcuts can help you streamline work in Excel and look like a magician in a spreadsheet. We're currently planning the next round of keyboard shortcuts to add to Web Excel and would...
• Data Explorer brings Big Data connectivity to Excel 2013

  28 Feb 2013

  Today we continue our series of BI related posts highlighting a recent announcement for a new add-in for Excel. On February 27, we announced an early look at a future addition to our self-service line-up with Microsoft Data Explorer Preview for Excel. Data Explorer enhances the self-service BI experience...
• PASS Business Analytics Conference: Keeping up with the evolving world of data

  26 Feb 2013

  The world of data continues to become bigger and more complex, with no plans to slow down. From April 10-12 in Chicago, data professionals and business analysts will gather at the PASS Business Analytics Conference to keep pace with the latest trends around big data, predictive analytics, data visualization...
• Going “Kamping with a K”: How we quickly organized a 20-person trip in Web Excel on SkyDrive

  21 Feb 2013

  This week we continue to highlight new features we've recently released in Web Excel, available to all users through SkyDrive. This post is brought to you by Lee Bizek, a Program Manager in the Excel Team. My wife, Korrin, and I go camping every year with our closest friends. Since she isn’t a...
• New support for query tables in Excel Services improves workbook sharing across an organization

  18 Feb 2013

  This week we're highlighting some improvements in Excel Services , as part of the SharePoint 2013 release. This post is brought to you by Prash Shirolkar, a Program Manager in the Excel Team. Take one last look: The error message below is now a thing of the past. With the enhancements to Excel Services...
• Microsoft BI Solution Builder: Learn how familiar tools like Excel fit within your organization’s BI strategy

  11 Feb 2013

  Better business intelligence and insight can make the difference between a business surviving and thriving. Microsoft aims to make business intelligence (BI) more accessible to everyone across an organization, in part by providing BI capabilities in familiar tools such as Excel to empower more users...
• Open Excel workbooks in separate windows and view them side by side

  7 Feb 2013

  This week we continue exploring new features in Excel 2013. This post is brought to you by Chad Rothschiller, a Program Manager in the Excel Team. "How do I open my workbooks in separate windows?" This has been a common inquiry from many of our customers who want to look at their workbooks side by side...
• Need to combine two chart types? Create a combo chart and add a second axis

  25 Jan 2013

  This post is brought to you by Robin Wakefield, a Program Manager in the Excel Team. Have you ever had two different types of data that you wanted to show in one chart? For example you may want to plot actual revenue with forecasted revenue to compare the two values. In an earlier post , we showed you...