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
Secure Programming Cookbook for C and C++: Recipes for Cryptography, Authentication, Input Validation & More
Strings and Text
Splitting a String
Computing a Dot Product
Implementing a Constant-Sized Matrix
Evaluating an XPath Expression
Building Web Applications with UML (2nd Edition)
Client-Side Risks
Defining the Architecture
Web Application Presentation Tier: Architectural Patterns
Glossary
Implementation
Google Maps Hacks: Tips & Tools for Geographic Searching and Remixing
Hack 8. Generate Links to Google Maps in a Spreadsheet
Hack 43. Dont Believe Everything You Read on a Map
Hack 49. Generate Geocoded RSS from Any Google Map
Hack 56. Pin Your Own Maps to Google Maps with TPhoto
Hack 58. Find the Right Zoom Level
Twisted Network Programming Essentials
Installing from Source Files
Using SMTP as a User Interface
NNTP Clients and Servers
Running Commands on a Remote Server
Setting Limits on an Applications Permissions
802.11 Wireless Networks: The Definitive Guide, Second Edition
MAC Access Modes and Timing
Authentication
Characteristics of the FH PHY
Agere (Lucent) Orinoco
Standards Work
DNS & BIND Cookbook
Limiting Concurrent TCP Clients
Dynamically Updating a Zone
Configuring a Resolver to Append Multiple Domain Names to Arguments
Signing Queries and Dynamic Updates with TSIG Programmatically
Reverse-Mapping an Address with dig
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