Results for:
PivotTables

• What's your favorite thing about Excel PivotTables?

  20 Mar 2012

  Do you belong to LinkedIn ? Did you know that LinkedIn has lots of Excel user groups where Excel trainers, developers, financial modelers, and even Excel blackbelts compete to out geek each other--or just share information. (The Excel Blackbelt group is for data visualization experts.) We loved this...
• Five most popular posts on the Excel blog in 2011

  26 Jan 2012

  It's still January. There's still time to share the most popular posts on the Excel blog in 2011. Thanks for reading them! Can't remember all those Excel keyboard shortcuts? Now you don't have to! There are a lot of keyword shortcuts in Excel. You can scroll through a long list of them on Office.com...
• Apollo 11 & Excel – How did we do that?

  10 Aug 2011

  Today's post is brought to you by Sam Radakovitz, a program manager on the Office User Experience team. Thanks for all the support and kind words for our History Reimagined video series . We had a great time making these videos, especially the one about Excel 2010 and Apollo 11 . :-) After we posted...
• Free training: Take the next steps in growing your Excel skills

  28 Jun 2011

  In early May, we told you about the new video series Excel Skills Builder in our post " Take the first step in growing your Excel skills ." In that post, we announced the launch of lesson 1. Well, we've finally finished the rest of the lessons, and wanted to share this great resource with you! As a reminder...
• Rockin' out with PivotTables

  6 May 2011

  We recently discovered this music video by youarentbenjamin on YouTube titled "PivotTables Make Everything Just Right." The video gives some serious love to PivotTables . Props for the creativity, and here's hoping they got an A+ for their group project! --Amy Miller
• You asked about pivot tables (video)

  22 Mar 2011

  So many Office customers ask about "pivot table" that we've gathered the best answers in this blog post. Most likely, you are looking for information about how to create a PivotTable report that can help summarize and analyze your data. Or you already have your data in a PivotTable report and are looking...
• Excel table or PivotTable?

  18 Jan 2011

  In Excel there are tables and PivotTables. You may wonder why you'd need to create a table when the whole worksheet already looks like one. And you've heard about PivotTables and how complex they are. To be able to use either effectively, it helps to know what each of them does, and when to use one or...
• Top 5 Ways PowerPivot Helps Excel Pros

  1 Oct 2010

    This blog post is brought to you by Rob Collie CTO at PivotStream. Former co-founder of the PowerPivot team and Lead PM for Excel at Microsoft, broad-spectrum geek and cruncher of sports stats.   Hello Excel Pros! I’d like to start by saying this: You are my kind of people. I’ve met hundreds...
• Auto Format PivotTables to Match Source Data (Power Tips Series)

  21 Sep 2010

    Today’s author is Mike Alexander, a Microsoft Excel MVP who shows us how to run a Stored Procedure to get data from a SQL server. For more information, visit www.datapigtechnologies.com .   So summer is for practically over and I'm back to blogging topics that can actually help people. For...
• Scatter charts with PowerPivot

  24 Feb 2010

  Rob over at http://powerpivotpro.com has a interesting post on scatter charts and PowerPivot: At right is a list of all chart types in Excel. But not all of them are supported as PivotCharts. Try to use XY (Scatter), Bubble, or Stock as a PivotChart, and you’ll get an alert saying you cannot create it...
• Using PowerPivot with Excel 2010

  23 Oct 2009

  In this blog article, we’ll step through using PowerPivot for Excel 2010 for building a rich application in Excel. Note: following screenshots describe the SQL Server 2008 R2 August Community Technology Preview (CTP) functionality for a feature codenamed Gemini. As recently announced , Gemini will be...
• Introducing PowerPivot

  22 Oct 2009

  Today we have a guest author from the SQL Server Analysis Services team, Ashvini Sharma, to tell us about the PowerPivot (née Gemini) feature that you may have heard about recently. PowerPivot is the recently announced name of technologies this blog previously referred to by its codename, Gemini. This...
• A Few More PivotTable Improvements in Excel 2010

  15 Oct 2009

  Thanks to Diego Oppenheimer for putting together this post. In today’s post I will be covering a couple of smaller PivotTable features that we incorporated in Excel 2010. Most of these features have been longstanding customer requests or pain points that we felt could be addressed in this release. This...
• Excel 2010 PivotTable What-If Analysis (Writeback)

  12 Oct 2009

  Thanks to Diego Oppenheimer for putting together this post. When thinking of Excel as an OLAP analytical tool the first thing that usually comes to mind is the ability to quickly and easily analyze data from an OLAP data source. With the introduction of PivotTable What-If Analysis in Excel 2010 you can...
• Excel 2010: New Search Filter

  1 Oct 2009

  Exploring large data sets and creating filters has never been easier than with Excel 2010. Tables, PivotTables and PivotCharts now have a new search functionality that easily enables you to find what you need, filter and repeat for a faster more efficient way of navigating those enormous data sets. Filtering...
• Sneak Preview of Project Gemini

  15 Jul 2009

  On the topic of “teasers”, one of the things we’ll be talking about in the coming weeks is project Gemini. I won’t get into the details just yet (otherwise it wouldn’t be a teaser), other than to say it’s a powerful data analysis feature, it’s an add-in to Excel (i.e. not a built-in Excel feature), and...
• Analyzing Data: Functions or PivotTables

  23 Mar 2009

  Today’s author, Monica Poinescu, a Software Developer in Test on the Excel team, discusses two different approaches to analyzing data in Excel. Edit: I've attached a file at the bottom of this blog that contains spreadsheets of the examples discussed in this post. My earlier blog on the new Excel 2007...
• Quick and Easy Data Access with Excel Services

  5 Feb 2009

  Today’s author, John Campbell, a Program Manager on the Excel Services team, shows us the quick and easy way to get external data access working with your Excel Services spreadsheets. I have seen a lot of great blog posts that tell folks how to do great things with refreshed data in an Excel spreadsheet...
• Using PivotTables to Analyze Data From a SharePoint List

  6 Nov 2008

  Today's author, Diego Oppenheimer, a Program Manager on the Excel team, talks about connecting PivotTables to data stored in SharePoint Lists. Many of us on the Excel team have been approached by customers asking us how to create a connection to a SharePoint list. SharePoint lists can be exported easily...
• Using Office Data Connection files (.odc) and the DataConnections Web Part in SharePoint to Specify External Data Connections in Newly Created Excel Workbooks.

  15 Oct 2008

  Today's author, Christian Stich, a Program Manager on the Excel Services team, discusses how to enable users to quickly and easily create workbooks using external data connections specified in server based data connection files. Overview Excel and Excel Services support importing external data, which...