MARC details
000 -LEADER |
fixed length control field |
02651cam a22004455a 4500 |
001 - CONTROL NUMBER |
control field |
04669 |
003 - CONTROL NUMBER IDENTIFIER |
control field |
GSU |
005 - DATE AND TIME OF LATEST TRANSACTION |
control field |
20231124100638.0 |
008 - FIXED-LENGTH DATA ELEMENTS--GENERAL INFORMATION |
fixed length control field |
150515s2016 inua 001 0 eng d |
010 ## - LIBRARY OF CONGRESS CONTROL NUMBER |
LC control number |
2015941454 |
020 ## - INTERNATIONAL STANDARD BOOK NUMBER |
International Standard Book Number |
0789756293 |
020 ## - INTERNATIONAL STANDARD BOOK NUMBER |
International Standard Book Number |
9780789756299 |
035 ## - SYSTEM CONTROL NUMBER |
System control number |
(OCoLC)ocn911092018 |
040 ## - CATALOGING SOURCE |
Original cataloging agency |
YDXCP |
Language of cataloging |
eng |
Transcribing agency |
YDXCP |
Modifying agency |
BDX |
-- |
OPW |
-- |
IBI |
-- |
DLC |
-- |
GSU |
Description conventions |
rda |
042 ## - AUTHENTICATION CODE |
Authentication code |
lccopycat |
050 ## - LIBRARY OF CONGRESS CALL NUMBER |
Classification number |
HF5548.4.M523 |
Item number |
JEL |
100 1# - MAIN ENTRY--PERSONAL NAME |
Personal name |
Jelen, Bill, |
Relator term |
author. |
245 10 - TITLE STATEMENT |
Title |
Excel 2016 pivot table data crunching / |
Statement of responsibility, etc. |
Bill Jelen, Michael Alexander. |
264 #1 - PRODUCTION, PUBLICATION, DISTRIBUTION, MANUFACTURE, AND COPYRIGHT NOTICE |
Place of production, publication, distribution, manufacture |
Indianapolis, Indiana : |
Name of producer, publisher, distributor, manufacturer |
Que, |
Date of production, publication, distribution, manufacture, or copyright notice |
©2016. |
300 ## - PHYSICAL DESCRIPTION |
Extent |
xiv, 417 pages : |
Other physical details |
illustrations ; |
Dimensions |
24 cm. |
336 ## - CONTENT TYPE |
Content type term |
text |
Content type code |
txt |
Source |
rdacontent |
337 ## - MEDIA TYPE |
Media type term |
unmediated |
Media type code |
n |
Source |
rdamedia |
338 ## - CARRIER TYPE |
Carrier type term |
volume |
Carrier type code |
nc |
Source |
rdacarrier |
490 1# - SERIES STATEMENT |
Series statement |
MrExcel Library |
500 ## - GENERAL NOTE |
General note |
Includes index. |
505 0# - FORMATTED CONTENTS NOTE |
Formatted contents note |
Pivot table fundamentals -- Creating a basic pivot table -- Customizing a pivot table -- Grouping, sorting and filtering pivot data -- Performing calculations in pivot tables -- Using pivot charts and other visualizations -- Analyzing disparate data sources with pivot tables -- Sharing pivot tables with others -- Working with and analyzing OLAP data -- Mashing up data with power pivot -- Dashboarding with Power view and 3D map -- Enhancing pivot tables with macros -- Using VBA to create pivot tables -- Advanced pivot table tips and techniques -- Dr. Jekyll and Mr. GetPivotData. |
520 ## - SUMMARY, ETC. |
Summary, etc. |
"Use Excel 2016 pivot tables and pivot charts to produce powerful, dynamic reports in minutes instead of hours ... understand exactly what's going on in your business ... take control, and stay in control! Even if you've never created a pivot table before, this book will help you leverage all their amazing flexibility and analytical power. Drawing on more than 40 combined years of Excel experience, Bill Jelen and Michael Alexander offer practical 'recipes' for solving real business problems, help you avoid common mistakes, and present tips and tricks you'll find nowhere else!"--Back cover |
630 00 - SUBJECT ADDED ENTRY--UNIFORM TITLE |
Uniform title |
Microsoft Excel (Computer file) |
650 #0 - SUBJECT ADDED ENTRY--TOPICAL TERM |
Topical term or geographic name entry element |
Business |
General subdivision |
Computer programs. |
650 #0 - SUBJECT ADDED ENTRY--TOPICAL TERM |
Topical term or geographic name entry element |
Business intelligence |
General subdivision |
Computer programs. |
650 #0 - SUBJECT ADDED ENTRY--TOPICAL TERM |
Topical term or geographic name entry element |
Knowledge management |
General subdivision |
Computer programs. |
650 #0 - SUBJECT ADDED ENTRY--TOPICAL TERM |
Topical term or geographic name entry element |
Electronic spreadsheets |
General subdivision |
Computer programs |
650 #0 - SUBJECT ADDED ENTRY--TOPICAL TERM |
Topical term or geographic name entry element |
Microsoft Excel (Computer file) |
700 1# - ADDED ENTRY--PERSONAL NAME |
Personal name |
Alexander, Michael, |
Dates associated with a name |
1972- |
Relator term |
author. |
830 #0 - SERIES ADDED ENTRY--UNIFORM TITLE |
Uniform title |
MrExcel library. |
906 ## - LOCAL DATA ELEMENT F, LDF (RLIN) |
a |
0 |
b |
ibc |
c |
copycat |
d |
2 |
e |
ncip |
f |
20 |
g |
y-gencatlg |
942 ## - ADDED ENTRY ELEMENTS (KOHA) |
Source of classification or shelving scheme |
Library of Congress Classification |
Koha item type |
Books |
Suppress in OPAC |
No |