Microsoft Office Excel 2007 Data Analysis: Your Visual Blueprint for Creating and Analyzing Data, Charts, and PivotTables

Microsoft Office Excel 2007 Data Analysis: Your Visual Blueprint for Creating and Analyzing Data, Charts, and PivotTables

3.3 3
by Denise Etheridge
     
 

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

See more details below

Overview

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

Read More

Product Details

ISBN-13:
9780470132296
Publisher:
Wiley
Publication date:
07/10/2007
Series:
Visual Blueprint Series
Pages:
304
Product dimensions:
7.33(w) x 9.10(h) x 0.73(d)

Customer Reviews

Average Review:

Write a Review

and post it to your social network

     

Most Helpful Customer Reviews

See all customer reviews >