Specifications

PowerPivot for Excel CHAPTER 10 195
FIGURE 10-5 Filtering a numeric column by value
IMPORTANT Use of a lter is not a security measure. Although a lter effectively hides
data from a presentation, anyone who can open the Excel workbook can also clear the
lters and view the data if he or she has installed the PowerPivot add-in.
Columns
As part of the data preparation process, you might need to make changes to column proper-
ties. On the Home tab of the PowerPivot ribbon, you can access tools to make some of these
changes, as shown in Figure 10-6. For example, you can select a column in the table and then
use the ribbon buttons to change the formatting of the column. You can also change the
width of the column for better viewing of its contents, or you can freeze a column to make it
easier to explore the data as you scroll horizontally.
FIGURE 10-6 The Home tab of the PowerPivot ribbon
Although the Table Import Wizard detects and sets column data types, you can use the
Data Type drop-down list on the ribbon to change a data type if necessary. You might need
to adjust data types to create a relationship between two tables, for example. PowerPivot
supports only the following data types:
■
Currency
■
Decimal Number
■
Text
■
TRUE/FALSE
■
Whole Number