Table Of ContentCHAPTER 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.
SynopsisWelcome to the only guidebook series that takes a visual approach to professional-level computer topics., 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, 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, Welcome to the only guidebook series that takes a visual approach to professionallevel computer topics. Open the book and you'll discover stepbystep 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) Highresolution screen shots demonstrate each task Succinct explanations walk you through step by step Twopage lessons break big topics into bitesized modules "Apply It" and "Extra" sidebars highlight useful tips