Browse by Tags

Introduction to the Data Model and Relationships in Excel 2013

This 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 features that will hopefully change the way you use Excel for data analysis forever. ...( read more ) Read More...

Published Thu, Aug 08 2012 3:00 AM by Excel Blog

Filed under: PivotTables, business intelligence, Excel 2013, msbi, relationships, data model

What's your favorite thing about Excel PivotTables?

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

Published Tue, Mar 03 2012 9:43 PM by Excel Blog

Filed under: PivotTables, Excel 2010

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...

Published Thu, Jan 01 2012 2:03 PM by Excel Blog

Filed under: PivotTables, Excel 2010, Percentages, Excel shortcuts

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...

Published Mon, Aug 08 2011 2:19 PM by Excel Blog

Filed under: Charting, PivotTables, Slicers, Excel

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...

Published Tue, Jun 06 2011 1:15 PM by Excel Blog

Filed under: Charting, Conditional Formatting, PivotTables, Data Validation, Formatting & Printing, Solver, Excel 2010, Sparklines, Slicers, Beginner, functions, Excel Web Apps, PowerPivot, macros, Excel, training, Basics, Web Apps, SmartArt, print

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...

Published Fri, May 05 2011 4:48 PM by Microsoft Excel

Filed under: PivotTables, Video, Excel 2010, Excel

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...

Published Tue, Mar 03 2011 4:18 PM by Microsoft Excel

Filed under: PivotTables

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...

Published Tue, Jan 01 2011 1:00 PM by Microsoft Excel

Filed under: Tables, PivotTables, Excel 2010, Beginner

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...

Published Fri, Oct 10 2010 12:37 PM by Microsoft Excel 2010

Filed under: PivotTables, Advanced, PowerPivot

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...

Published Tue, Sep 09 2010 8:31 PM by Microsoft Excel 2010

Filed under: PivotTables, Power Tips, Formatting & Printing

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...

Published Wed, Feb 02 2010 4:30 PM by Microsoft Excel 2010

Filed under: Charting, PivotTables

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:...

Published Fri, Oct 10 2009 8:45 PM by Microsoft Excel

Filed under: Analysis Services, PivotTables, Excel 2010, Gemini, Overview

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...

Published Thu, Oct 10 2009 11:27 PM by Microsoft Excel

Filed under: Analysis Services, PivotTables, Excel 2010, Overview

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...

Published Thu, Oct 10 2009 2:37 PM by Microsoft Excel

Filed under: Analysis Services, PivotTables, Excel 2010, Overview

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...

Published Mon, Oct 10 2009 4:34 PM by Microsoft Excel

Filed under: Analysis Services, PivotTables, Excel 2010, Overview

Syndication

Recent Posts

Tags

Archives

Introduction to the Data Model and Relationships in Excel 2013

What's your favorite thing about Excel PivotTables?

Five most popular posts on the Excel blog in 2011

Apollo 11 & Excel – How did we do that?

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

Rockin' out with PivotTables

You asked about pivot table (video)

Excel Table or PivotTable?

Top 5 Ways PowerPivot Helps Excel Pros

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

Scatter charts with PowerPivot

Using PowerPivot with Excel 2010

Introducing PowerPivot

A Few More PivotTable Improvements in Excel 2010

Excel 2010 PivotTable What-If Analysis (Writeback)