Wiley
Wiley.com
Print this page Share

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

ISBN: 978-0-470-13229-6
304 pages
July 2007
Microsoft Office Excel 2007 Data Analysis: Your Visual Blueprint for Creating and Analyzing Data, Charts, and PivotTables (0470132299) cover image
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
See More
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.

See More
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.
See More
Download TitleSizeDownload
Chapter 1 - example files
The code examples for this title are stored in a ZIP archive. To open it, you will need a computer with software capable of opening ZIP files. If you do not already have this capability, you can download a free trial of WinZip.
37.12 KB Click to Download
Chapter 2 - example files
The code examples for this title are stored in a ZIP archive. To open it, you will need a computer with software capable of opening ZIP files. If you do not already have this capability, you can download a free trial of WinZip.
64.27 KB Click to Download
Chapter 3 - example files
The code examples for this title are stored in a ZIP archive. To open it, you will need a computer with software capable of opening ZIP files. If you do not already have this capability, you can download a free trial of WinZip.
102.96 KB Click to Download
Chapter 4 - example files
The code examples for this title are stored in a ZIP archive. To open it, you will need a computer with software capable of opening ZIP files. If you do not already have this capability, you can download a free trial of WinZip.
107.40 KB Click to Download
Chapter 5 - example files
The code examples for this title are stored in a ZIP archive. To open it, you will need a computer with software capable of opening ZIP files. If you do not already have this capability, you can download a free trial of WinZip.
84.45 KB Click to Download
Chapter 6 - example files
The code examples for this title are stored in a ZIP archive. To open it, you will need a computer with software capable of opening ZIP files. If you do not already have this capability, you can download a free trial of WinZip.
334.40 KB Click to Download
Chapter 7 - example files
The code examples for this title are stored in a ZIP archive. To open it, you will need a computer with software capable of opening ZIP files. If you do not already have this capability, you can download a free trial of WinZip.
77.04 KB Click to Download
Chapter 8 - example files
The code examples for this title are stored in a ZIP archive. To open it, you will need a computer with software capable of opening ZIP files. If you do not already have this capability, you can download a free trial of WinZip.
115.72 KB Click to Download
Chapter 9 - example files
The code examples for this title are stored in a ZIP archive. To open it, you will need a computer with software capable of opening ZIP files. If you do not already have this capability, you can download a free trial of WinZip.
97.28 KB Click to Download
Chapter 10 - example files
The code examples for this title are stored in a ZIP archive. To open it, you will need a computer with software capable of opening ZIP files. If you do not already have this capability, you can download a free trial of WinZip.
158.41 KB Click to Download
Chapter 11 - example files
The code examples for this title are stored in a ZIP archive. To open it, you will need a computer with software capable of opening ZIP files. If you do not already have this capability, you can download a free trial of WinZip.
70.25 KB Click to Download
Appendix
The code examples for this title are stored in a ZIP archive. To open it, you will need a computer with software capable of opening ZIP files. If you do not already have this capability, you can download a free trial of WinZip.
6.93 KB Click to Download
See More
Buy Both and Save 25%!
+

Microsoft Office Excel 2007 Data Analysis: Your Visual Blueprint for Creating and Analyzing Data, Charts, and PivotTables (US $26.99)

-and- Excel 2010 For Dummies Quick Reference (US $18.99)

Total List Price: US $45.98
Discounted Price: US $34.48 (Save: US $11.50)

Buy Both
Cannot be combined with any other offers. Learn more.
Back to Top