Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.
The Excel Team Blog » All Tags » PivotTables (RSS)

Browse by Tags

  • Five most popular posts on the Excel blog in 2011

    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, or you can download Quick Reference Cards from our blog and pin them to your corkboard. There are cards for Keyboard shortcuts with theCtrl keys , Keyboard shortcuts with Function keys...

  • Apollo 11 & Excel – How did we do that?

    A couple of weeks ago, as part of our Watch History Reimagined series, we posted a video to show you how Excel might've helped the team at NASA work through some of the tensest moments in American history. Some of you asked us how we created certain visualizations that appear in the video. In today's post, we point you to the source workbook and data used to make the video and show you how to recreate a couple of the chart and slicer effects. Enjoy! ...( read more ) Read More...

  • Free training: Take the next steps in growing your Excel skills

    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, the skills builder is a video series that comprises short (typically under 5 minutes each) videos that give you an overview of a task or feature in Excel. The videos are grouped...

  • Rockin' out with PivotTables

    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! ...( read more ) Read More...

  • You asked about pivot table (video)

    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 for information about how to pivot it. ...( read more ) Read More...
    Filed under:

  • Excel Table or PivotTable?

    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 the other. Continue reading to learn more about the differences between tables and PivotTables. ...( read more ) Read More...

  • Top 5 Ways PowerPivot Helps Excel Pros

      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 of you over the years that I worked on Excel (and other teams) at Microsoft, and I meet more of you all the time today. I like to think of myself as one of you, in fact. I know the “secret,” that...

  • Auto Format PivotTables to Match Source Data (Power Tips Series)

      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 my first post back, I'll come out big with one of the best pieces of code I've ever written. A few weeks ago Dick Kusleika posted a small but brilliant piece of code that auto formats the...

  • Scatter charts with PowerPivot

    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 with pivot data. So, do you give up? Nope. Remember the post where I converted a PivotTable to Cube Formulas using that button on the ribbon? This is a wonderful opportunity to use that feature in an...
    Filed under: ,

  • Using PowerPivot with Excel 2010

    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 released under the PowerPivot brand. After installation, Gemini appears on the Excel 2010 ribbon: Importing Data Selecting the ‘Load & Prepare Data’ button launches the PowerPivot client window:...

  • Introducing PowerPivot

    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 article describes why there is a need for such a tool, and briefly what PowerPivot provides. More information is available on the PowerPivot blog . The Need for PowerPivot PivotTables continue to be...

  • A Few More PivotTable Improvements in Excel 2010

    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 includes fixing functionality that worked in versions of Excel previous to Excel 2007 (Filtering on calculated members) as well as making it easier to access features that historically our users have...

  • Excel 2010 PivotTable What-If Analysis (Writeback)

    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 now easily modify this data as well. Put simply, PivotTable What-If Analysis is the ability to modify values in PivotTable cells, recalculate the PivotTable with those values and, if the results are...

  • PivotTable Named Sets in Excel 2010

    Thanks to Diego Oppenheimer for putting together this post. When working with PivotTables, you often come across scenarios where you want to work with the same set of items from the data over and over again. For example, you might be a regional manager and you want to create a set of reports about the branches in your particular region, but the list of which are “your” branches isn’t in the data source, so you always have to filter to the same eight branches, like so: Example of two PivotTable reports...

  • Excel 2010: New Search Filter

    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 FAST! In Excel 2010 when you click on the dropdown for autofilters, tables, PivotTables and PivotCharts you will now find a new search interface that enable swift navigation of extremely large...
1 2 Next >
Copyright Excel User Group and the relevant contributors, 2010. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.