Accessing and Analyzing Data with Microsoft Excel

Paul Cornell

400 pages, parution le 25/02/2003

Ajouter à une liste

Indisponible

Résumé

The business person's one-stop guide to data analysis with Microsoft Office

Business runs on information-and this essential guide explains how to use Microsoft Excel and other Microsoft Office tools to capture and analyze data for better decision making and problem solving. The author, a member of the Microsoft Office team, provides expert insights and guidance for business information workers at all levels-from the sales rep tracking quotas on a spreadsheet to the executive making critical go and no-go decisions for an entire division. The book introduces the data analysis and storage tools in Office 2000 and Office XP, including Excel spreadsheets, PivotTable and PivotChart dynamic views, Microsoft Access databases, Office Web components, and Microsoft Data Analyzer. Readers learn when and how to use these tools to capture, analyze, manipulate, refine, and present data to support key business processes. Advanced data analysts and solution developers will also find information on online analytical processing (OLAP) systems, XML data, and automating data reporting and analysis.

Contents

Making Sense of Data
Basic Data Analysis Techniques
Analyzing Data with Microsoft Excel
Analyzing Data with PivotTable and PivotChart Reports
Analyzing Data with Microsoft Access
Analyzing Data with the Office Web Components
Introducing Online Analytical Processing
Analyzing OLAP Data with Microsoft Excel
Analyzing OLAP Data with Microsoft Data Analyzer
Working with XML Data in Excel and Access
Extending Office Data Analysis Features with Code
Maintaining Data Reporting and Analysis Systems

A Data Analysis Quick Reference
B Additional Tools and Resources

L'auteur - Paul Cornell

Paul Cornell has been with Microsoft for five years, serving as an inside sales representative, a sales trainer, and a documentation specialist. For the last two-and-a-half years he has been working as a writer and an editor in Office User Assistance. He also currently works for the MSDN Online Office Developer Center and the Microsoft Office Business Intelligence initiative. His projects have included work on the Microsoft Office XP Visual Basic® for Applications Language Reference, the Microsoft Office XP Web Services Toolkit, the Microsoft Office XP Fabrikam 2.0 Solution Sample, and the Microsoft Data Analyzer Tutorial. He writes the "Office Talk" column for MSDN at http://msdn.microsoft.com/columns/office.asp and contributes to the "Office Power User Corner" column for the Microsoft Office Assistance Center at http://office.microsoft.com/assistance.

Autres livres de Paul Cornell

La mort de wolverine: prélude

Deadshot & les secret six - Tome 4

Découvrir tous les livres de Paul Cornell

Caractéristiques techniques

	PAPIER
Éditeur(s)	Microsoft Press
Auteur(s)	Paul Cornell
Parution	25/02/2003
Nb. de pages	400
Format	18,5 x 22,8
Couverture	Broché
Poids	825g
Intérieur	Noir et Blanc
EAN13	9780735618954
ISBN13	978-0-7356-1895-4