Results for:
Pivot Tables

• 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...
• 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 the Data Model and Relationships in Excel 2013

  23 Aug 2012

  This blog post is brought to you by Diego Oppenheimer a Program Manager on the Excel team. I am very happy to be writing this blog post today. Not just because I will be showing you another way Excel can make your data analysis easier but also because I will be introducing the new Data Model and Relationships...
• Webinar: Excel PivotTables and Slicers

  11 Jun 2012

  In this week’s webinar, you’ll get an overview of two tools in Excel for crunching numbers so you can know what the numbers mean to your business: PivotTables and Slicers (new to Office 2010). References for this webinar: So you asked about PivotTables Quick Start: Create a PivotTable report...
• Quick Trick: Resizing column widths in pivot tables

  14 May 2012

  (Who could be better than a Business Intelligence analyst at teaching us a thing or two about Excel? We asked our own number-crunching wizard Stacey Armstrong to share some Excel tricks she's learned along the way.) Issue: Excel automatically makes column widths too wide I often work with pivot tables...