Synopsis
* 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 Excel's PivotTable utility
* Covers data analyzing techniques for statistical functions, financial functions, data sharing, PivotTables and PivotCharts, Solver, and BackSolver
"synopsis" may belong to another edition of this title.
About the Author
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.
From the Back Cover
Welcome to the only guidebook series that takes a visual approach to professional-level computer topics. Open the book and you’ll discover step-by-step screen shots that demonstrate over 100 key Excel data analysis techniques, including:
- Creating PivotTables and PivotCharts
- Importing and linking data
- Compiling data from various sources
- Filtering a list
- Creating an amortization table
- Manipulating data within a chart
- Editing external database tables
- Using an Excel function in a macro
- Building PivotTable formulas
- Using Analysis ToolPak Add-ins
Data analysis tools on CD-ROM!
- Trial versions of FinOptions XL, Analyse-It, Sigma XL, 4TOPS Data Analysis, and XLSTAT Pro
- UNISTAT demo version
- Macro codes
- A searchable e-version of the book
"About this title" may belong to another edition of this title.
- PublisherVisual
- Publication date2003
- ISBN 10 0764537547
- ISBN 13 9780764537547
- BindingPaperback
- LanguageEnglish
- Edition number1
- Number of pages304
- Rating
Other Popular Editions of the Same Title
Search results for Excel Data Analysis: Your visual blueprint for analyzing...
Stock Image
Excel Data Analysis: Your visual blueprint for analyzing data, charts, and PivotTables
Seller: BooksRun, Philadelphia, PA, U.S.A.
Seller rating 5 out of 5 stars
Paperback. Condition: Good. 1. Ship within 24hrs. Satisfaction 100% guaranteed. APO/FPO addresses supported. Seller Inventory # 0764537547-11-1
Quantity: 1 available
Stock Image
Excel Data Analysis: Your visual blueprint for analyzing data, charts, and PivotTables (Visual Read Less, Learn More)
Seller: Wonder Book, Frederick, MD, U.S.A.
Seller rating 5 out of 5 stars
Condition: Very Good. Very Good condition. A copy that may have a few cosmetic defects. May also contain light spine creasing or a few markings such as an owner's name, short gifter's inscription or light stamp. Bundled media such as CDs, DVDs, floppy disks or access codes may not be included. Seller Inventory # O05C-01935
Quantity: 1 available
Stock Image
Excel Data Analysis: Your visual blueprint for analyzing data, charts, and PivotTables (Visual Read Less, Learn More)
Seller: Half Price Books Inc., Dallas, TX, U.S.A.
Seller rating 5 out of 5 stars
Paperback. Condition: Very Good. Connecting readers with great books since 1972! Used books may not include companion materials, and may have some shelf wear or limited writing. We ship orders daily and Customer Service is our top priority! Seller Inventory # S_412264025
Quantity: 1 available
Stock Image
Excel Data Analysis: Your visual blueprint for analyzing data, charts, and PivotTables
Seller: HPB-Emerald, Dallas, TX, U.S.A.
Seller rating 5 out of 5 stars
paperback. Condition: Very Good. Connecting readers with great books since 1972! Used books may not include companion materials, and may have some shelf wear or limited writing. We ship orders daily and Customer Service is our top priority! Seller Inventory # S_413151298
Quantity: 1 available
Stock Image
Excel Data Analysis: Your visual blueprint for analyzing data, charts, and PivotTables (Visual Read Less, Learn More)
Seller: The Book Spot, Sioux Falls, MN, U.S.A.
Seller rating 4 out of 5 stars
Paperback. Condition: New. Seller Inventory # Abebooks153384
Quantity: 1 available
Stock Image
Excel Data Analysis: Your visual blueprint for analyzing data, charts, and PivotTables
Seller: De Boeken van Wouter, Amsterdam, NEDER, Netherlands
Seller rating 4 out of 5 stars
Please note: below is a general description of how we classify our condition types. If you would like a closer look or have any specific questions, please feel free to send us a message, and we will gladly check it for you. Condition descriptions: UsedlikeNew: Barely any signs of use, almost like new. UsedGood: May show some light signs of use, such as slight discoloration or a name written on the front endpaper, but generally no markings or notes in the text. UsedAcceptable: Book in acceptable condition. May show signs of use, such as some discoloration, reading creases in the spine, underlining, notes, slight dirt on edges, dog-eared pages, or a bent spine. New: Book is new. ON 10-0 180918 EA. Seller Inventory # 9780764537547
Quantity: 1 available