Books about Crunching from Amazon.com

This book consolidates all the best functionality of pivot tables into one guide that provides you with a meaningful tutorial, offering practical solutions to day-to-day problems.

 

Within just the first 2 chapters, you will be creating basic pivot tables, increasing productivity, and producing reports in minutes instead of hours.

 

Within the first 6 chapters, you will learn how to use pivot tables to quickly highlight your top 10 customers or bottom 5 products in profitability; quickly create analysis comparing sales this period to last period by product or region or both; easily summarize daily transactional data by month or quarter or year in a few mouse clicks–all without knowing any formulas!

 

By the end of the book, you will truly be a pivot table guru, automating pivot tables using VBA, creating pivot tables with external data in OLAP cubes, and even creating dynamic reporting systems so that your managers can answer their own queries with a few mouse clicks.

 

• Take advantage of the numerous pivot table recipes

• Create powerful summary reports in seconds

• Build ad-hoc query tools with ease

• Enhance your Executive Reporting

• Filter reports to top 10 customers or products

• Add dynamic charts to reports

• Quickly summarize daily data by month, quarter, or year

 

 

 

 

Introduction . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1

1              Pivot Table Fundamentals . . . . . . . . . . . . . . . . . . . . . . . . . . . .11

2              Creating a Basic Pivot Table . . . . . . . . . . . . . . . . . . . . . . . . . .21

3              Customizing a Pivot Table . . . . . . . . . . . . . . . . . . . . . . . . . . . .45

4              Controlling the Way You View Your Pivot Data . . . . . . . . . . . .83

5              Performing Calculations Within Your Pivot Tables . . . . . . . . 117

6              Using Pivot Charts and Other Visualizations . . . . . . . . . . . . .141

7              Analyzing Disparate Data Sources with Pivot Tables . . . . . . 167

8              Sharing Pivot Tables with Others . . . . . . . . . . . . . . . . . . . . . .189

9              Working with and Analyzing OLAP Data . . . . . . . . . . . . . . . . 201

10           Enhancing Your Pivot Table Reports with Macros . . . . . . . . .215

11           Using VBA to Create Pivot Tables . . . . . . . . . . . . . . . . . . . . . 231

12           Common Pivot Table Issues and Questions . . . . . . . . . . . . . .291

A             Finding Pivot Table Commands on the Ribbon . . . . . . . . . . . .315

.
Price: $20.00 [Notify me when price goes down.]

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.

.
Price: $5.24 [Notify me when price goes down.]

Do you cringe when a linebacker flattens a quarterback? Hold your breath when a field goal sails toward the goalpost? Watch in amazement as a touchdown pass spirals down the field? Behind those big hits, long kicks, and sensational throws is a science that will give you a whole new perspective on the game of football.

A combination of Stephen Hawking and Mike Ditka, physicist and football fan Timothy Gay breaks down the fundamental laws of physics that govern America's most exciting spectator sport. To illustrate the science behind the game, he highlights some of football's recent memorable moments, along with legendary feats from the likes of Franco Harris and Joe Montana.

Did you Know?

• Newton's Second Law of Physics proves that Dick Butkus hit running backs with the force of a small killer whale.
• The average force with which a football must be kicked during kickoff is 450 lbs. But for an instant, the force may be as much as a ton.
• Shaun Rogers, firing off the line of scrimmage, can develop as much as four horsepower by himself.

.
Price: $0.79 [Notify me when price goes down.]

Hungry Caterpillar crunches and munches his way through the blackberry bush; all the while his friends Bumblebee, Sparrow and Butterfly are flying high in the sky soaring and swooping. Caterpillar wishes for nothing more than to fly! Butterfly has a secret and encourages Caterpillar to take a nap. After his long, deep sleep through the winter and his dreams of soaring in the blue sky above the trees and drifting toward the sun—Caterpillar awakens to find that his dreams have come true! .
Price: $3.17 [Notify me when price goes down.]

There are some topics or problems that have captured the interest of mathematicians for ages. Calculating pi is one of them. Although students often encounter pi in the mathematics classroom when applying various formulas, rarely do they use or explore pi in other contexts. This marvelous infinite number we know as pi shows up in many fascinating and mysterious ways. It can be found everywhere, from astronomy and probability, to the physics of sound and light. It is one of the most important numbers that exists.

Help your students discover the number that has intrigued mathematicians for centuries. Learn different ways pi has been calculated through the ages, use pi to figure your hat size, perform a variety of experiments to estimate the value of pi, or relate pi to the alphabet. These interesting and exciting activities encourage higher order thinking and offer a complete overview of this important number while giving students practice in important math skills.

This guide includes detailed lesson plans (referenced to NCTM standards) and reproducible student worksheets. Use them for Pi Day (March 14), as an enrichment or extension to your existing curriculum, or to challenge your most able math students..
Price: $6.75 [Notify me when price goes down.]

Every day, all around the world, programmers have to recycle legacy data, translate from one vendor's proprietary format into another's, check that configuration files are internally consistent, and search through web logs to see how many people have downloaded the latest release of their product. This kind of "data crunching," may not be glamorous, but knowing how to do it efficiently is essential to being a good programmer.

This book describes the most useful data crunching techniques, explains when you should use them, and shows how they will make your life easier. Along the way, it will introduce you to some handy, but under-used, features of Java, Python, and other languages. It will also show you how to test data crunching programs, and how data crunching fits into the larger software development picture.

.
Price: $13.97 [Notify me when price goes down.]

This Level 2 book is appropriate for children who are beginning to read alone.

Are animals nosy? Do they stick out their tongues? You'll be amazed at what animals do with their mouths and noses. Longer sentences and an expanded vocabulary make this series of 48-page books slightly more challenging: Level 2 is appropriate for children who have started to read but still need help. Information boxes full of background information will stimulate inquisitive minds. These books contain between 700 and 850 words, and they are approximately 70 percent pictures and 30 percent text. The Dorling Kindersley Readers combine an enticing visual layout with high-interest, easy-to-read stories to captivate and delight young bookworms who are just getting started. Written by leading children's authors and compiled in consultation with literacy experts, these engaging books build reader confidence along with a lifelong appreciation for nonfiction, classic stories, and biographies. There is a DK Reader to interest every child at every level, from preschool to grade 4..
Price: $0.50 [Notify me when price goes down.]

This digital document is an article from Mississippi Business Journal, published by Venture Publications on March 3, 2003. The length of the article is 873 words. The page length shown above is based on a typical 300-word page. The article is delivered in HTML format and is available in your Amazon.com Digital Locker immediately after purchase. You can view it with any web browser.

Citation Details
Title: Crunching numbers: interstates shaping population growth. (From the Ground Up).
Author: Phil Hardwick
Publication:Mississippi Business Journal (Magazine/Journal)
Date: March 3, 2003
Publisher: Venture Publications
Volume: 25 Issue: 9 Page: 23(1)

Distributed by Thomson Gale.
Price: $5.95 [Notify me when price goes down.]