Microsoft SQL Server 2008 R2 Especificações descarregar pdf (Página 215)

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

1 2 ... 210 211 212 213 214 215 216 217 218 219 220 ... 235 236

Sem comentários

Microsoft SQL Server 2008 R2 Especificações Página 215