Home | Amazing | Today | Tags | Publishers | Years | Account | Search 
Pivot Table Data Crunching (Business Solutions)

Buy
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.

About author

Bill Jelen is the principal behind the leading Excel website, MrExcel.com. As an Excel consultant, he has written Excel VBA solutions for hundreds of clients around the English-speaking world. His website hosts more than 12 million page views annually. Prior to founding MrExcel.com, Bill spent 12 years "in the trenches," working as a financial analyst for the finance, marketing, accounting, and operations departments of a $500 million public company. His duties included turning large amounts of mainframe data into meaningful reports. Working initially with Lotus 1-2-3 and then Excel, Bill honed techniques to take massive amounts of data and produce meaningful reports in record time. Bill is the author of seven books on Microsoft Excel.

Michael Alexander is a Microsoft Certified Application Developer (MCAD) with more than 13 years' experience consulting and developing office solutions. Michael started his career in consulting and development at the White House Communications Agency in Washington D.C., later parleying his experience with VBA and VB into a successful career in the private sector, developing middleware and reporting solutions for a wide variety of industries. He currently lives in Plano, Texas, where he heads an analytical services group for a $700 million company. In his spare time he runs a free tutorial site, www.datapigtechnologies.com, where he shares basic Access and Excel tips with intermediate users.

(HTML tags aren't allowed.)

Essential C++
Essential C++
For the practicing programmer with little time to spare, Essential C++ offers a fast-track to learning and working with C++ on the job. This book is specifically designed to bring you up to speed in a short amount of time. It focuses on the elements of C++ programming that you are most likely to encounter and examines features and techniques that...
Mastering SQL Queries for SAP Business One
Mastering SQL Queries for SAP Business One

This book has been created to serve the needs of many SAP Business One users. If you have a chance to browse the SAP business One website between mid-2008 and mid-2011, you will find that my name is always on the top contributor's list. I have solved many SQL Query related problems faced by many users, and some such users have asked me...

Computer Vision and Action Recognition: A Guide for Image Processing and Computer Vision Community for Action Understanding
Computer Vision and Action Recognition: A Guide for Image Processing and Computer Vision Community for Action Understanding

The book is about computer vision and action recognition & understanding. If you have a basic knowledge on image processing and would like to study or to do research on action/activity understanding and recognition in computer vision and related arenas – then this is the book for you!

Throughout my endeavor to write...


IBM Cognos 8 Report Studio Cookbook
IBM Cognos 8 Report Studio Cookbook

Cognos Report Studio is widely used for creating and managing business reports in medium to large companies. It is simple enough for any business analyst, power user, or developer to pick up and start developing basic reports. However, when it comes to developing more sophisticated, fully functional business reports for wider audiences,...

Managing IaaS and DBaaS Clouds with Oracle Enterprise Manager Cloud Control 12c
Managing IaaS and DBaaS Clouds with Oracle Enterprise Manager Cloud Control 12c

Setting up a cloud environment is rarely smooth sailing but with this guide to Oracle Enterprise Manager Cloud Control, it just got a lot more manageable. Practical advice and lots of examples make it the ideal assistant.

Overview

  • Perform and set up your cloud environment one step at a time using this...
Managing Indoor Air Quality, Fourth Edition
Managing Indoor Air Quality, Fourth Edition
As predicted in the earlier editions, concerns over Indoor Air Quality (IAQ) have driven it to the forefront of current workplace problems. More than ever, health, economic and legal matters associated with IAQ seem destined to make it a dominant problem for developers, owners and managers of commercial and institutional properties well into this...
©2021 LearnIT (support@pdfchm.net) - Privacy Policy