Accessing and Analyzing Data with Microsoft Excel (Bpg-Other)
Accessing and Analyzing Data with Microsoft Excel (Bpg-Other)
ISBN: 073561895X
EAN: 2147483647
EAN: 2147483647
Year: 2006
Pages: 137
Pages: 137
Authors: Paul Cornell
- Table of Contents
- BackCover
- Accessing and Analyzing Data with Microsoft Excel
- Foreword
- Introduction
- Using the Accompanying CD
- System Requirements
- Support
- Chapter 1: Making Sense of Data
- The Types of Data That You Can Analyze
- Using Data to Make Decisions
- Developing a Data Analysis Strategy
- Understanding Microsoft Data Analysis Software and Features
- Summary
- Chapter 2: Basic Data Analysis Techniques
- Sorting Data
- Summarizing Data
- Trending Data
- Filtering Data
- Formatting Data
- Importing, Exporting, and Querying Data
- Charting Data
- Pivoting Data
- Working with Data Lists
- Working with Relational and Multidimensional Data
- Working with XML Data
- Summary
- Chapter 3: Analyzing Data with Microsoft Excel
- Sorting and Filtering Data
- Using Worksheet Functions
- Applying Conditional Formatting
- Working with Charts
- Importing External Data
- Querying External Data
- Analyzing Data in Lists
- Using the Analysis ToolPak
- Using the Solver Add-In
- Summary
- Chapter 4: Analyzing Data with PivotTable and PivotChart Reports
- Understanding PivotTable and PivotChart Reports
- Analyzing Data with PivotTable Reports
- Analyzing Data with PivotChart Reports
- Summary
- Chapter 5: Analyzing Data with Microsoft Access
- Understanding Relational and Nonrelational Data
- Connecting to External Data
- Sorting and Filtering Data
- Querying Data
- Creating Reports
- Analyzing Data with PivotTable and PivotChart Views
- Using Access to Integrate with SQL Server Databases
- Analyzing Access Data over the Web
- Summary
- Chapter 6: Analyzing Data with the Office Web Components
- Introducing the Office Web Components
- Creating Office Web Components
- Using the Spreadsheet Component
- Using the PivotTable Component
- Using the Chart Component
- Summary
- Chapter 7: Introducing Online Analytical Processing
- The Case for OLAP
- What Is OLAP?
- Using OLAP Data to Make Better Business Decisions
- Understanding Online Transaction Processing
- Data Storage Options
- Using Microsoft Office to Analyze OLAP Data
- Summary
- Chapter 8: Analyzing OLAP Data with Microsoft Excel
- Connecting to OLAP Data
- Working with OLAP Data
- Creating Offline Cubes
- Summary
- Chapter 9: Analyzing OLAP Data with Microsoft Data Analyzer
- Introducing Microsoft Data Analyzer
- Connecting to OLAP Data
- Viewing and Analyzing Data with Data Analyzer
- Creating Custom Measures
- Making Better Business Decisions
- Summary
- Chapter 10: Working with XML Data in Excel and Access
- The Case for XML
- Making Sense of XML Data
- Analyzing XML Data with Microsoft Excel
- Working with XML Data with Microsoft Access
- Summary
- Chapter 11: Extending Office Data Analysis Features with Code
- Understanding Office Code: Macros and Procedures
- Understanding Office Code: Programmatic Object Models
- Extending the Data Analysis Features in Microsoft Excel
- Programming the Data Analysis Features in Microsoft Access
- Extending the Data Analysis Features in the Microsoft Office Web Components
- Extending the Data Analysis Features in Microsoft Data Analyzer
- Summary
- Chapter 12: Maintaining Data Reporting and Analysis Systems
- Creating and Implementing Database Maintenance Plans
- Maintaining SQL Server 2000 Databases
- Maintaining SQL Server 2000 Desktop Engine Databases
- Maintaining Access Databases
- Maintaining SQL Server 2000 Analysis Services Systems
- Additional Reading
- Summary
- Appendix A: Data Analysis Quick Reference
- Working with OLAP Data in Excel
- PivotTable Reports and PivotChart Reports
- Microsoft Access
- Microsoft Office Web Components
- Microsoft Data Analyzer
- Appendix B: Additional Tools and Resources
- Online Data Analysis Resources
- Index
- Index_A
- Index_B
- Index_C
- Index_D
- Index_E
- Index_F
- Index_G
- Index_H
- Index_I
- Index_K-L
- Index_M
- Index_N
- Index_O
- Index_P
- Index_Q
- Index_R
- Index_S
- Index_T
- Index_U
- Index_V
- Index_W
- Index_X
- List of Figures
- List of Code Examples
- CD Content
Accessing and Analyzing Data with Microsoft Excel (Bpg-Other)
ISBN: 073561895X
EAN: 2147483647
EAN: 2147483647
Year: 2006
Pages: 137
Pages: 137
Authors: Paul Cornell