- Copyright
- About the Author
- About the Technical Editor
- Credits
- Acknowledgments
- Introduction
- Getting Started with Excel
- Working with Formulas and Functions
- Creating Charts and Graphics
- Using Advanced Excel Features
- Customizing the Excel User Interface
- Using Custom Number Formats
- Using Data Validation
- Creating and Using Worksheet Outlines
- Linking and Consolidating Worksheets
- Excel and the Internet
- Sharing Data with Other Office Applications
- Using Excel in a Workgroup
- Protecting Your Work
- Making Your Worksheets Error-Free
- Analyzing Data with Excel
- Getting Data from External Database Files
- Introducing Pivot Tables
- Analyzing Data with Pivot Tables
- Working with Non-Numeric Data
- Grouping Pivot Table Items
- Creating a Frequency Distribution
- Creating a Calculated Field or Calculated Item
- Filtering Pivot Tables with Slicers
- Referencing Cells within a Pivot Table
- Creating Pivot Charts
- Another Pivot Table Example
- Producing a Report with a Pivot Table
- Performing Spreadsheet What-If Analysis
- Analyzing Data Using Goal Seeking and Solver
- Analyzing Data with the Analysis ToolPak
- Programming Excel with VBA
- Appendixes
- Wiley Publishing, Inc. End-User License Agreement
Part V: Analyzing Data with Excel
IN THIS PART
Getting Data from External Database Files
Understanding Pivot Tables
Analyzing Data with Pivot Tables
Performing Spreadsheet What-If Analysis
Analyzing Data Using Goal Seeking and Solver
Analyzing Data with the Analysis ToolPak
Excel is a superb data analysis tool — if you know how to extract the information you really need. In this part, you'll learn how to obtain and analyze data in Excel. As you'll see, many of the data-analysis capabilities in Excel are both surprisingly powerful and easy to use.
-
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.