Synopses & Reviews
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
Excel is a spreadsheet / data analysis tool attached to the Microsoft Office suite and is available in all Office offerings. Office holds 80-900f the market share for productivity suites. Though many consumers know the basics of using Excel, they may not know the full power of the program. With Excel, you can harness the power of your data, manipulate it to suite your needs, and achieve more by doing less work. Charts are interactive, allowing the consumer to tweak results with the click of a mouse. Pivot tables allow you to fuse data from several sources into one document. Excel has an enhanced Find function, allowing users to easily search entire workbooks, and search worksheets by cell format. Excel supports XML as a file format for easy importing or exporting of XML data. Excel also includes enhancements for saving files as Web pages, and enhancements to Pivot Tables.
About the Author
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.