Excel 2007 data analysis : your visual blueprint for creating and analyzing data, charts and PivotTables
著者
書誌事項
Excel 2007 data analysis : your visual blueprint for creating and analyzing data, charts and PivotTables
(Visual read less, learn more)
Wiley, c2007
- : pbk.
- タイトル別名
-
Microsoft Office Excel 2007 data analysis
大学図書館所蔵 件 / 全1件
-
該当する所蔵館はありません
- すべての絞り込み条件を解除する
注記
Includes index
内容説明・目次
内容説明
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
目次
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.
「Nielsen BookData」 より