Excel Data Analysis: Your visual blueprint for analyzing data, charts, and PivotTables

by Jinjer Simon (Professional Programmer)

• ISBN13: 9780764537547
• ISBN10: 0764537547
• Edition: 1st
• Format: Paperback
• Copyright: 2003-01-01
• Publisher: Visual

Summary

Essential for those who know basic Excel and want to explore the full potential of the program Teaches how to manipulate data to suit specific needs and achieve more by doing less work Self-contained two-page lessons, featuring high-resolution screen shots and minimal text, show how to create custom functions, retrieve data from databases, use value chains, and slice and pivot information from the Web with Excel2s PivotTable utility Covers data analyzing techniques for statistical functions, financial functions, data sharing, PivotTables and PivotCharts, Solver, and BackSolver

Author Biography

Jinjer Simon has been actively involved in the computer industry for the past 18 years. Her involvement in the industry has included programming, providing software technical support, training end-users, developing written and online user documentation, creating software tutorials, and developing Web sites. She is the author of several computer books, including Excel Programming: Your visual blueprint for creating interactive spreadsheets, Windows CE For Dummies, and Windows CE 2 For Dummies.

Table of Contents

HOW TO USE THIS BOOK.

1) GETTING STARTED WITH EXCEL.

Excel Data Analysis Options.

Excel Data Types.

Locate a Value in a Worksheet.

Select a Range of Cells.

Name a Range.

Create Label Ranges.

Modify Named Ranges.

Copy and Paste a Range of Cells.