Part I: Some essential background -- Excel 2010: Where it came from -- Excel in a nutshell -- Formula tricks and techniques -- Understanding excel files -- Part II: Excel application development -- What is a spreadsheet application? -- Essentials of spreadsheet application development -- Part III: Understanding visual basic for applications -- Introducing visual basic for applications -- VBA programming fundamentals -- Working with VBS sub procedures -- Creating function procedures -- VBA programming examples and techniques -- Part IV: Working with UserForms -- Custom dialog box alternatives -- Introducing UserForms -- UserForm examples -- Advanced UserForm techniques -- Part V: Advanced programming techniques -- Developing excel utilities with VBA -- Working with pivot tables -- Working with charts -- Understanding excel's events -- Interacting with other applications -- Creating and using add-ins -- Part VI: Developing applications -- Working with the ribbon -- Working with shortcut menues -- Providing help for your applications -- Developing user-oriented applications -- Part VII: Compatability issues -- Manipulating files with VBA -- Manipulating visual basic components -- Understanding class modules -- Working with colors -- Frequently asked questions about excel programming -- Part VIII: Appendixes -- Excel resources online -- VBA statements and functions reference -- VBA error codes -- What's on the cd-rom.