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
OpenSSH: A Survival Guide for Secure Shell Handling (Version 1.0)
Step 3.3 Use WinSCP as a Graphical Replacement for FTP and RCP
Step 4.7 Using Public Key Authentication for Automated File Transfers
Step 5.1 General Troubleshooting
Step 5.2 Troubleshooting Common OpenSSH Errors/Problems
Conclusion
Kanban Made Simple: Demystifying and Applying Toyotas Legendary Manufacturing Process
Conduct Data Collection
Size the Kanban
Improving the Kanban
Appendix A MRP vs. Kanban
Appendix B Kanban Supermarkets
Professional Java Native Interfaces with SWT/JFace (Programmer to Programmer)
Menus, Toolbars, Cool, Bars, and Actions
Scales, Sliders, and Progress Bars
Drag and Drop and the Clipboard
Printing
Drawing Diagrams with Draw2D
Managing Enterprise Systems with the Windows Script Host
Introduction
Logon Scripts and Scheduling
Application Automation
Messaging Operations
Exchange Server
C & Data Structures (Charles River Media Computer Engineering)
C Operators
Preprocessing
Problems in Linked Lists
Problems in Strings
Miscellaneous Problems
PostgreSQL(c) The comprehensive guide to building, programming, and administering PostgreSQL databases
Adding New Records to a Table
DELETE
Extending PostgreSQL
Other Features
Client 2Adding Error Checking
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