Microsoft Office Excel 2007 Data Analysis: Your Visual Blueprint for Creating and Analyzing Data, Charts and Pivot Tables - Tapa blanda

Etheridge, Denise

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

Sinopsis

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

"Sinopsis" puede pertenecer a otra edición de este libro.

Acerca del autor

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.

De la contraportada

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

"Sobre este título" puede pertenecer a otra edición de este libro.