- Copyright
- About the Author
- About the Technical Editor
- Credits
- Acknowledgments
- Introduction
- Getting Started with Excel
- Working with Formulas and Functions
- Creating Charts and Graphics
- Using Advanced Excel Features
- Customizing the Excel User Interface
- Using Custom Number Formats
- Using Data Validation
- Creating and Using Worksheet Outlines
- Linking and Consolidating Worksheets
- Excel and the Internet
- Sharing Data with Other Office Applications
- Using Excel in a Workgroup
- Protecting Your Work
- Making Your Worksheets Error-Free
- Analyzing Data with Excel
- Getting Data from External Database Files
- Introducing Pivot Tables
- Analyzing Data with Pivot Tables
- Working with Non-Numeric Data
- Grouping Pivot Table Items
- Creating a Frequency Distribution
- Creating a Calculated Field or Calculated Item
- Filtering Pivot Tables with Slicers
- Referencing Cells within a Pivot Table
- Creating Pivot Charts
- Another Pivot Table Example
- Producing a Report with a Pivot Table
- Performing Spreadsheet What-If Analysis
- Analyzing Data Using Goal Seeking and Solver
- Analyzing Data with the Analysis ToolPak
- Programming Excel with VBA
- Appendixes
- Wiley Publishing, Inc. End-User License Agreement
About the Technical Editor
Niek Otten started in data processing in 1967 in an insurance company. He ran into VisiCalc in 1980 and has been addicted to spreadsheets ever since. His first acquaintance with Excel (version 1!) was in 1985 on a Macintosh. Since 2005, Niek has been self-employed. He answers questions about Excel in newsgroups and forums, reviews and edits Excel books, writes articles, and develops Excel-related software, such as a high-performance actuarial add-in. Niek has been a Microsoft Most Valuable Professional (MVP) for Excel since 2001.
-
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.