Flylib.com
Accessing and Analyzing Data with Microsoft Excel (Bpg-Other)
Accessing and Analyzing Data with Microsoft Excel (Bpg-Other)
ISBN: 073561895X
EAN: 2147483647
Year: 2006
Pages: 137
Authors:
Paul Cornell
BUY ON AMAZON
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
Year: 2006
Pages: 137
Authors:
Paul Cornell
BUY ON AMAZON
Inside Network Security Assessment: Guarding Your IT Infrastructure
Network Vulnerability Assessment
Why Risk Assessment
Scoping the Project
Ranking Your Findings
Conclusions
Network Security Architectures
Everything Is a Target
Ten Steps to Designing Your Security System
High-End Resilient Edge Security Design
Campus Trust Model
Secure Network Management and Network Security Management
Special Edition Using Crystal Reports 10
Choosing a Formula Language: Crystal Versus Basic Syntax
DHTML Report Design Wizard
Introduction to the Crystal Enterprise Professional Object Model
Creating and Responding to Crystal Enterprise Alerts
An Introduction to SQL
Persuasive Technology: Using Computers to Change What We Think and Do (Interactive Technologies)
Computers as Persuasive Tools
Computers as Persuasive Social Actors
Credibility and Computers
Credibility and the World Wide Web
Captology Looking Forward
Oracle SQL*Plus: The Definitive Guide (Definitive Guides)
Why Master SQL*Plus?
Totals and Subtotals
Report Headers and Footers
Limitations of SQL*Plus
SQL*Plus Settings You Can Control
.NET-A Complete Development Cycle
References for Further Reading
Design of the Image-Processing Components Using Late Binding
Unit Tests
Performance Optimization, Multithreading, and Profiling
Conclusion
flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net
Privacy policy
This website uses cookies. Click
here
to find out more.
Accept cookies