PowerPivot – Working with Column Properties in PowerPivot for Excel 2010

In the previous post, we saw how to combine data from multiple relational sources into a single table in PowerPivot. In this post, let us see some of the common properties/features associated with columns in PowerPivot.

This tip will cover the following topics:

  • How to set Description for Columns in PowerPivot
  • How to set and modify Column Data Types in PowerPivot
  • How to apply formatting to Column Data in PowerPivot
  • How to Show or Hide the Columns in PowerPivot
  • How to Sort Data in one Column with Data in another Column in PowerPivot

To work through the steps outlined in this post, you need to set up your Excel/PowerPivot Workbook by following the steps outlined in the below listed posts in the same sequence specified.

To read the full article, go to this link: Working with Columns and Properties in PowerPivot for Excel.

Advertisements

About Dattatrey Sindol (Datta)

Datta is a Microsoft BI Enthusiast, passionate developer, and a blogger. View Full Profile

Posted on March 15, 2013, in MS Excel, MS Office, Power Pivot, Self-Service BI, SQL Server and tagged , , , , , , , , . Bookmark the permalink. 1 Comment.

What are your thoughts?

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: