Excel 2007 data analysis : your visual blueprint for creating and analyzing data, charts and PivotTables
Author(s)
Bibliographic Information
Excel 2007 data analysis : your visual blueprint for creating and analyzing data, charts and PivotTables
(Visual read less, learn more)
Wiley, c2007
- : pbk.
- Other Title
-
Microsoft Office Excel 2007 data analysis
Available at 1 libraries
  Aomori
  Iwate
  Miyagi
  Akita
  Yamagata
  Fukushima
  Ibaraki
  Tochigi
  Gunma
  Saitama
  Chiba
  Tokyo
  Kanagawa
  Niigata
  Toyama
  Ishikawa
  Fukui
  Yamanashi
  Nagano
  Gifu
  Shizuoka
  Aichi
  Mie
  Shiga
  Kyoto
  Osaka
  Hyogo
  Nara
  Wakayama
  Tottori
  Shimane
  Okayama
  Hiroshima
  Yamaguchi
  Tokushima
  Kagawa
  Ehime
  Kochi
  Fukuoka
  Saga
  Nagasaki
  Kumamoto
  Oita
  Miyazaki
  Kagoshima
  Okinawa
  Korea
  China
  Thailand
  United Kingdom
  Germany
  Switzerland
  France
  Belgium
  Netherlands
  Sweden
  Norway
  United States of America
Note
Includes index
Description and Table of Contents
Description
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
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.
by "Nielsen BookData"