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
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.
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.