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
The Goals and Objectives of a Risk Assessment
Understanding the Attacker
Preparing the Final Report
Vulnerability Management
Conclusions
Java for RPG Programmers, 2nd Edition
The World Of Java
The Java Onion
Threads
Appendix B Mixing RPG And Java
Appendix C Obtaining The Code Samples
C & Data Structures (Charles River Media Computer Engineering)
The printf Function
Address and Pointers
Structures
Files
Trees
Competency-Based Human Resource Management
An Overview of Competency-Based HR Management Practices
Competency-Based HR Planning
Competency-Based Employee Recruitment and Selection
The Transformation to Competency-Based HR Management
Competency-Based HR Management The Next Steps
The New Solution Selling: The Revolutionary Sales Process That Is Changing the Way People Sell [NEW SOLUTION SELLING 2/E]
Chapter One Solutions
Chapter Eight Creating Visions Biased to Your Solution
Chapter Eleven Gaining Access to People with Power
Chapter Fourteen Getting Started with the Process
Chapter Sixteen Creating and Sustaining High-Performance Sales Cultures
Microsoft VBScript Professional Projects
Conditional Logic and Iterative Structures
Customizing the Desktop
Mapping Network Printers and Disks
Collecting Remote Summary Reports
Converting Reports to HTML Pages
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