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

Simon, Jinjer

Softcover

ISBN 10: 0764597809 ISBN 13: 9780764597800

Publisher: John Wiley & Sons, 2005

Synopsis

Excel is a spreadsheet / data analysis tool attached to the Microsoft Office suite and is available in all Office offerings. Office holds 80–90% of the market share for productivity suites. Though many consumers know the basics of using Excel, they may not know the full power of the program. With Excel, you can harness the power of your data, manipulate it to suit your needs, and achieve more by doing less work. Charts are interactive, allowing the consumer to tweak results with the click of a mouse. Pivot tables allow you to fuse data from several sources into one document. Excel has an enhanced Find function, allowing users to easily search entire workbooks, and search worksheets by cell format. Excel supports XML as a file format for easy importing or exporting of XML data. Excel also includes enhancements for saving files as Web pages, and enhancements to Pivot Tables.

About this title

About the Author

Jinjer Simon has been actively involved in the computer industry for the past 18 years. Her involvement includes 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, and Windows CE 2 For Dummies.

From the Back Cover

Excel Data Analysis 2nd Edition

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

• High–resolution screen shots demonstrate each task
• Succinct explanations walk you through step by step
• Two–page lessons break big topics into bite–sized modules
• "Apply It" and "Extra" sidebars highlight useful tips

Edition details

• Publisher: John Wiley & Sons
• Publication date: 2005
• Language: English
• ISBN 10: 0764597809
• ISBN 13: 9780764597800
• Binding: Paperback
• Edition number: 2
• Number of pages: 304