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

Etheridge, Denise

Softcover

ISBN 10: 0470132299 ISBN 13: 9780470132296

Publisher: John Wiley & Sons, 2007

Synopsis

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

About this title

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.

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 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

Edition details

• Publisher: John Wiley & Sons
• Publication date: 2007
• Language: English
• ISBN 10: 0470132299
• ISBN 13: 9780470132296
• Binding: Paperback
• Number of pages: 304