November 2016
Intermediate to advanced
192 pages
4h 26m
English
Content preview from MOS 2016 Study Guide for Microsoft Excel ExpertBecome an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
Index
Symbols
@ specifier 12
#All specifier 12
#Data specifier 12
#Headers specifier 12
#Totals specifier 12
+Body font 59
+Heading font 59
A
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
match_type 85
member_expression 115
minute 94
month 91
nper 117
path 10
pmt 117
property 115
pv 117
rank 115
rate 117
return_type 92
row_index_num 84
row_num 86
second 94
set 115
set_expression 116
sheetname 10
sort_by 116
sort_order 116
spaces in 10
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.