Excel 2007 Power Programming with VBA (Mr. Spreadsheets Bookshelf) - page 1
- Table of Contents
- Table of Contents
- Back Cover
- Excel 2007 Power Programming with VBA
- Preface
- What You Need to Know
- What You Need to Have
- Conventions in This Book
- What the Icons Mean
- How This Book Is Organized
- About the Companion CD-ROM
- About the Power Utility Pak Offer
- How to Use This Book
- Reach Out
- Part I: Some Essential Background
- Chapter 1: Excel 2007-Where It Came From
- A Brief History of Spreadsheets
- Why Excel Is Great for Developers
- Excel s Role in Microsoft s Strategy
- Chapter 2: Excel in a Nutshell
- Thinking in Terms of Objects
- Workbooks
- Excel s User Interface
- Customizing the Display
- Data Entry
- Formulas, Functions, and Names
- Selecting Objects
- Formatting
- Protection Options
- Charts
- Shapes and SmartArt
- Database Access
- Internet Features
- Analysis Tools
- Add-Ins
- Macros and Programming
- File Format
- Excel s Help System
- Chapter 3: Formula Tricks and Techniques
- About Formulas
- Calculating Formulas
- Cell and Range References
- Using Names
- Formula Errors
- Array Formulas
- Counting and Summing Techniques
- Working with Dates and Times
- Creating Megaformulas
- Chapter 4: Understanding Excel s Files
- Starting Excel
- File Types
- Working with Template Files
- Inside an Excel File
- The QAT File
- The XLB File
- Add-In Files
- Excel Settings in the Registry
- Part II: Excel Application Development
- Chapter 5: What Is a Spreadsheet Application?
- Spreadsheet Applications
- The Developer and the End User
- Solving Problems with Excel
- Basic Spreadsheet Types
- Chapter 6: Essentials of Spreadsheet Application Development
- Determining User Needs
- Planning an Application That Meets User Needs
- Determining the Most Appropriate User Interface
- Concerning Yourself with the End User
- Other Development Issues
- Part III: Understanding Visual Basic for Applications
- Chapter 7: Introducing Visual Basic for Applications
- Some BASIC Background
- About VBA
- The Basics of VBA
- Introducing the Visual Basic Editor
- Working with the Project Explorer
- Working with Code Windows
- Customizing the VBE Environment
- The Macro Recorder
- About Objects and Collections
