Coverart for item
The Resource Pivot table data crunching, Bill Jelen, Michael Alexander

Pivot table data crunching, Bill Jelen, Michael Alexander

Label
Pivot table data crunching
Title
Pivot table data crunching
Statement of responsibility
Bill Jelen, Michael Alexander
Creator
Contributor
Subject
Language
eng
Summary
Become a savvy Microsoft Excel user. Pivot tables are a great feature in Excel that help you organize and analyze data, but not many Excel users know how to use pivot tables. Pivot Table Data Crunching offers a comprehensive review of all the functionalities of Pivot Tables from author Bill Jelen , otherwise known as Mr. Excel from www.mrexcel.com, and Michael Alexander , a Microsoft Certified Application Developer. The authors' practical scenarios and real-world advice demonstrate the benefits of Pivot Tables and how to avoid the common pitfalls of every day data crunching. Each solution presented in the book can be accomplished with resources available in the Excel interface, making Pivot Table Data Crunching a beneficial resource for all levels of Excel users
Member of
Cataloging source
JTD
http://library.link/vocab/creatorName
Jelen, Bill
Dewey number
005.55
Illustrations
illustrations
Index
no index present
LC call number
HF5548.4.M523
LC item number
J453 2005
Literary form
non fiction
Nature of contents
dictionaries
http://library.link/vocab/relatedWorkOrContributorName
Alexander, Michael
Series statement
Business solutions
http://library.link/vocab/subjectName
  • Electronic spreadsheets
  • Business
  • Business
  • Electronic spreadsheets
  • Commerce
  • Business & Economics
  • Marketing & Sales
Label
Pivot table data crunching, Bill Jelen, Michael Alexander
Instantiates
Publication
Carrier category
online resource
Carrier category code
  • cr
Carrier MARC source
rdacarrier
Content category
text
Content type code
  • txt
Content type MARC source
rdacontent
Contents
  • 5.
  • Controlling the way you view your pivot data
  • 6.
  • Performing calculations within your pivot tables
  • 7.
  • Creating and using pivot charts
  • 8.
  • Using disparate data sources for your pivot table
  • 9.
  • Using external data sources for your pivot table
  • 1.
  • 10.
  • Leveraging the power of OLAP cubes
  • 11.
  • Enhancing your pivot table reports with macros
  • 12.
  • Using VBA to create pivot tables
  • Pivot table fundamentals
  • 2.
  • Creating a basic pivot table
  • 3.
  • Customizing fields in a pivot table
  • 4.
  • Formatting your pivot table report
Control code
74459505
Dimensions
unknown
Extent
1 online resource (288 pages)
Form of item
online
Isbn
9780132714310
Media category
computer
Media MARC source
rdamedia
Media type code
  • c
Other physical details
illustrations.
Sound
unknown sound
Specific material designation
remote
System control number
(OCoLC)74459505
Label
Pivot table data crunching, Bill Jelen, Michael Alexander
Publication
Carrier category
online resource
Carrier category code
  • cr
Carrier MARC source
rdacarrier
Content category
text
Content type code
  • txt
Content type MARC source
rdacontent
Contents
  • 5.
  • Controlling the way you view your pivot data
  • 6.
  • Performing calculations within your pivot tables
  • 7.
  • Creating and using pivot charts
  • 8.
  • Using disparate data sources for your pivot table
  • 9.
  • Using external data sources for your pivot table
  • 1.
  • 10.
  • Leveraging the power of OLAP cubes
  • 11.
  • Enhancing your pivot table reports with macros
  • 12.
  • Using VBA to create pivot tables
  • Pivot table fundamentals
  • 2.
  • Creating a basic pivot table
  • 3.
  • Customizing fields in a pivot table
  • 4.
  • Formatting your pivot table report
Control code
74459505
Dimensions
unknown
Extent
1 online resource (288 pages)
Form of item
online
Isbn
9780132714310
Media category
computer
Media MARC source
rdamedia
Media type code
  • c
Other physical details
illustrations.
Sound
unknown sound
Specific material designation
remote
System control number
(OCoLC)74459505

Library Locations

    • Ellis LibraryBorrow it
      1020 Lowry Street, Columbia, MO, 65201, US
      38.944491 -92.326012
    • Engineering Library & Technology CommonsBorrow it
      W2001 Lafferre Hall, Columbia, MO, 65211, US
      38.946102 -92.330125
Processing Feedback ...