Microsoft Office Excel 2007 Data Analysis

Your Visual Blueprint for Creating and Analyzing Data, Charts and Pivot Tables

Denise Etheridge (Autor)

Buch | Softcover

304 Seiten

2007
John Wiley & Sons Ltd (Verlag)
978-0-470-13229-6 (ISBN)

Titel ist leider vergriffen;
keine Neuauflage

Artikel merken

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.

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.

Erscheint lt. Verlag	24.7.2007
Reihe/Serie	Read Less, Learn More
Zusatzinfo	Illustrations
Verlagsort	Chichester
Sprache	englisch
Maße	188 x 231 mm
Gewicht	608 g
Einbandart	Paperback
Themenwelt	Informatik ► Office Programme ► Excel
ISBN-10	0-470-13229-9 / 0470132299
ISBN-13	978-0-470-13229-6 / 9780470132296
Zustand	Neuware