Results for:
Excel

• 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...
• 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...
• 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...
• 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...
• Choose your own PivotTable

  15 Jan 2013

  This post is brought to you by Allie Rutherford, a Program Manager on the Analytics and Presentation team. In many offices, there always seems to be at least one person who is referred to as an Excel expert/master/wizard. Their masterful status often originates from one fact: they can make a PivotTable...
• Your top 10 favorite Excel posts of 2012

  7 Jan 2013

  There's an Excel community out there that continually wants to learn new tricks, and there are lots of people just discovering Excel's capabilities who want to join in. The most popular posts of 2012 that were about the current version of Excel reflect that mixed audience. But the popularity ranking...
• Drilling around in your Excel PivotTables and PivotCharts

  17 Dec 2012

  This week, I want to turn your attention to one of the truly fantastic Business Intelligence (BI) features that we added to the new Excel. It's called, Quick Explore, and, as long as you are working in the volume licensed desktop version or in the Office 365 "E3" and "E4," or "M" packages , you may have...
• Introduction to PowerPivot in Excel 2013

  13 Dec 2012

  This blog post was brought to you by Diego Oppenheimer a Program Manager on the Excel team. Some weeks ago I introduced an important, new part of the Excel 2013 Data Model and how you could create relationships between different data sources right in your Excel workbook ( http://blogs.office.com/b/microsoft...
• Interacting with Your Website’s Data Using Web Excel Mashups

  5 Dec 2012

  This post is brought to you by Harrison Gordon, a Program Manager on the Excel Services team. What exactly is an Excel Mashup? With Web Excel, you can embed workbooks into your website or blog. This alone is really powerful and lets you show a workbook directly in your website (it also lets you easily...
• A Primer on Apps for Office in Excel

  30 Nov 2012

  This post is brought to you by Keyur Patel, a Program Manager on the Excel team. In Excel 2013, even your spreadsheet can have an app . . . One of my areas of responsibility in the 2013 cycle was thinking about integration of the Apps for Office platform into Excel across the desktop and the web. I’m...