Microsoft Office Excel 2007 Data Analysis

Your Visual Blueprint for Creating and Analyzing Data, Charts, and PivotTables

• Author(s): Denise Etheridge,
• Publisher: John Wiley & Sons
• Pages: 289
• ISBN_10: 0470132299
  ISBN_13: 9780470132296
  
• Language: en
• Categories: Computers / Software Development & Engineering / General , Computers / Business & Productivity Software / Spreadsheets , Computers / Desktop Applications / General ,

Description:...

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