O'Reilly logo

Instant Creating Data Models with PowerPivot How-to by Leo Taehyung Lee

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Making the data look presentable (Simple)

We've put data in a pivot table and a pivot chart to make them comprehensible and easy-to-find trends. However, that is not enough. The easier it is to see the trends, the more effective the work is; and just like how famous brands use marketing to their advantage, we are going to package our little product to make it more appealing, more meaningful.

We will focus on features outside of pivot tables and pivot charts since there are millions of ways to represent the data in those two. Instead, we will build upon what we have prepared so far to redesign, organize, and clean up our data.

Getting ready

From the previous recipe, prepare the file CustomColumns_v1.xlsx. Open it up, copy the sheet DeliveryTime04 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required