- ホーム
- > 洋書
- > 英文書
- > Computer / Spreadsheets
Full 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
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.
