Microsoft Excel is a powerful and popular program for organizing and analyzing data. One
of its most powerful capabilities is PivotTables, which enable you to pull meaningful information
from huge masses of seemingly meaningless data. The name PivotTable comes from
one of the most powerful features of Excel—the ability to quickly and easily “pivot” the
data to view them in different ways.
This book is about using Microsoft Excel to
analyze your data. Microsoft Excel is an electronic
worksheet you can use to maintain lists; perform
mathematical, financial, and statistical calculations; create
charts; analyze your data with a PivotTable; and much
more. Excel can help you locate data, find trends in your
data, and present your data to others.
Each Excel file is a workbook. Each workbook can have
multiple worksheets. Worksheets are made up of rows
and columns of cells you use to enter information....
If you need to create and interpret statistics in business or classroom settings, this easy-to-use guide is just what you need. It shows you how to use Excel's powerful tools for statistical analysis, even if you've never taken a course in statistics. Learn the meaning of terms like mean and median, margin of error, standard deviation, and permutations, and discover how to interpret the statistics of everyday life. You'll learn to use Excel formulas, charts, PivotTables, and other tools to make sense of everything from sports stats to medical correlations....
Excel Data Analysis: Your visual blueprint for creating and
analyzing data, charts, and PivotTables uses simple,
straightforward examples to teach you how to create
powerful and dynamic programs.
To get the most out of this book, you should read each
chapter in order, from beginning to end. Each chapter
introduces new ideas and builds on the knowledge
learned in previous chapters. When you become familiar with Excel Data Analysis: Your visual blueprint for creating and analyzing data, charts, and PivotTables, you can use this book as an informative desktop reference....
Experience learning made easy-and quickly teach yourself how to organize, analyze, and present data with Excel 2010. With STEP BY STEP, you set the pace-building and practicing the skills you need, just when you need them! Topics include creating formulas, calculating values, and analyzing data; presenting information visually with graphics, charts, and diagrams; building PivotTable dynamic views; using the new Excel Web App; reusing information from databases and other documents; creating macros to automate repetitive tasks and simplify your work; and other core topics....