09-29-2011, 11:20 AM
Microsoft Office Excel 2007 Data Analysis: Your Visual Blueprint for Creating and Analyzing Data, Charts, and PivotTables
Author: Denise Etheridge | Size: 31.12 MB | Format: PDF | Publisher: Visual | Year: July 23, 2007 | pages: 304 | ISBN: 0470132299
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 110 Excel data analysis techniques, including:
* Identifying trends in your data
* Sorting, filtering, and identifying lists
* Creating, editing, and checking formulas
* Calculating interest rates and depreciation
* Performing simple sorts and filters
* Hiding rows or columns in a PivotTable
* Adding and removing chart data
* Querying an Access database
* Assigning digital signatures
* Solving a formula with a data table
"I was stuck on an Excel problem for two days. Finally, I opened one of your books, and there was a macro to accomplish exactly what I needed! You made me look good to the boss."
—Rob L. Meerscheidt(The Woodlands, TX)
* 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
Code:
***************************************
Content of this section is hidden, You must be registered and activate your account to see this content. See this link to read how you can remove this limitation:
http://forum.civilea.com/thread-27464.html
***************************************
Excel Data Analysis: Your Visual Blueprint for Creating and Analyzing Data, Charts and PivotTables
Author: Jinjer Simon | Size: 10.97 MB | Format: PDF | Publisher: Visual | Year: March 3, 2003 | pages: 352 | ISBN: 0764537547
This is earlier version of the previous book.
* 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
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
Code:
***************************************
Content of this section is hidden, You must be registered and activate your account to see this content. See this link to read how you can remove this limitation:
http://forum.civilea.com/thread-27464.html
***************************************