O'Reilly logo

MOS 2016 Study Guide for Microsoft Excel Expert by Paul McFedries

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

Index

Symbols

@ specifier 12

#All specifier 12

#Data specifier 12

#Headers specifier 12

#Totals specifier 12

+Body font 59

+Heading font 59

A

AND function 72, 74

Any Value data validation type 39

area_num argument 86

arguments

area_num 86

caption 115

col_index_num 83

column_num 86

connection 115

day 91

days 94

end_date 94

fv 117

GETPIVOTDATA function 157

holidays 94

hour 94

kpi_name 115

kpi_property 115

lookup_array 85

lookup_value 8385

match_type 85

member_expression 115

minute 94

month 91

nper 117

path 10

pmt 117

property 115

pv 117

range_lookup 8384

rank 115

rate 117

reference 10, 86

return_type 92

row_index_num 84

row_num 86

second 94

serial_number 92, 95

set 115

set_expression 116

sheetname 10

sort_by 116

sort_order 116

spaces in 10

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