Mastering Excel 97

Part - 1: Getting Started The Excel Environment Managing Workbooks, Worksheets and Windows Working inside Worksheets Part - 2: Basic Skills Using Formulas and Functions Formatting Worksheets Printing Worksheets Enhancing Your Productivity Part - 3: Tapping Excell's Power The Power of Names Essential Worksheets Functions Using Templates Auditing and Protecting Your Work Part - 4: Graphics and Charts Working with Graphic Objects Charting Basics Creating Custom Charts Constructing Complex Charts using Advanced Techniques Special Chart Types Part - 5: Working Effectively with Databases Working with Internal Databases Getting More Power from Worksheet Databases Accessing External Databases Part - 6: PIVOT Tables Understanding Pivot Tables Mastering Pivot Tables Advanced Pivot Tables Part - 7: Customizing Excel Using Custom Controls on Worksheets Effectively Using the Macro Recorder Building a Data Driven Model Part - 8: Solving Real World Problems Consolidating and Outlining What if Analysis Using Excel Add-Ins Excel and the World Outside Appendix - A: Alphabetical List of Worksheet Functions Appendix - B: Keyboard Shortcuts Appendix - C: Numeric Formatting Symbols Master's References Index