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

by Denise Etheridge

Paperback

$22.82 $26.99 Save 15% Current price is $22.82, Original price is $26.99. You Save 15%.

Temporarily Out of Stock Online

Eligible for FREE SHIPPING

Overview

Microsoft Office Excel 2007 Data Analysis: Your Visual Blueprint for Creating and Analyzing Data, Charts, and PivotTables 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 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

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)

About the Author

Denise Etheridge is a certified public accountant as well as the president and founder of Baycon Group, Inc. She publishes Web sites, provides consulting services on accounting-related software, and authors computer-related books.

Read an Excerpt

Click to read or download

Table of Contents

CHAPTER 1: GETTING STARTED.

CHAPTER 2: CREATING FORMULAS.

CHAPTER 3: CREATING AND USING FUNCTIONS.

CHAPTER 4: USING FINANCIAL FUNCTIONS.

CHAPTER 5: USING STATISTICAL FUNCTIONS AND TOOLS.

CHAPTER 6: ORGANIZING WORKSHEET DATA.

CHAPTER 7: WORKING WITH PIVOTTABLES.

CHAPTER 8: CHARTING DATA.

CHAPTER 9: WORKING WITH EXTERNAL DATA.

CHAPTER 10: USEFUL DATA ANALYSIS TOOLS AND TECHNIQUES.

CHAPTER 11: SHARING YOUR WORKBOOK WITH OTHERS.

CHAPTER 12: AUTOMATING WITH MACROS.

APPENDIX A: EXCEL KEYBOARD SHORTCUTS.

APPENDIX B: EXCEL FUNCTION QUICK REFERENCE.

APPENDIX C: FORMULA BASICS.

INDEX.

Customer Reviews

Most Helpful Customer Reviews

See All Customer Reviews

Microsoft Office Excel 2007 Data Analysis: Your Visual Blueprint for Creating and Analyzing Data, Charts, and PivotTables 3.3 out of 5 based on 0 ratings. 3 reviews.
Guest More than 1 year ago
Unlike some other books on various versions of Excel, Etheridge's presentation accentuates a strong visual pedagogy. She has also hewed to a style where very 2 facing pages discusses some operation you can do. Those of you who read the O'Reilly books will recognise this as analogous to the O'Reilly Hacks series. So what Etheridge offers is really a set of bite-sized tasks. Easy to learn and immediately apply. The tasks are diverse. Like doing date computations. Or using the built in future value function. Or the interest rate, compounded over several payment periods. Some tasks relate to the visual display of the tables. As in changing a table's style. Or making a PivotTable. The tasks are not comprehensive. The book should not be considered as such. This is not an official Excel manual, per se. Instead, enough is shown to be useful, of common activities that you are likely to perform. Well suited for an Excel novice.
Anonymous More than 1 year ago
Anonymous More than 1 year ago
This book was a major disappointment, The author did not show much creativity. I was not inspired by the limited number of examples compared to what I have in other books on earlier versions of Excel. I have learned more from online web tutorials. Save your money.