- 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
Part VII: Appendixes
IN THIS PART
Worksheet Function Reference
What's on the CD-ROM
Additional Excel Resources
Excel Shortcut Keys
This part contains some very useful appendixes. Appendix A provides a complete reference of all the worksheet functions. Appendix B gives you the run-down on all the great sample files on the CD-ROM that accompanies this book. Appendix C contains some great additional Excel resources; discover Excel shortcut keys in Appendix D.
-
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.