Part I: Some Essential Background
CHAPTER 1
Excel 2010: Where It Came From
CHAPTER 2
Excel in a Nutshell
CHAPTER 3
Formula Tricks and Techniques
CHAPTER 4
Understanding Excel's Files
- Cover
- Table of Contents
- Title Page
- Introduction
- Part I: Some Essential Background
- Chapter 1: Excel 2010: Where It Came From
- 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
- Chapter 4: Understanding Excel Files
- Part II: Excel Application Development
- Part III: Understanding Visual Basic for Applications
- Chapter 7: Introducing Visual Basic for Applications
- Getting Some BASIC Background
- Delving in to VBA
- Covering 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
- Properties and Methods
- The Comment Object: A Case Study
- Some Useful Application Properties
- Working with Range Objects
- Things to Know about Objects
- Chapter 8: VBA Programming Fundamentals
- Chapter 9: Working with VBA Sub Procedures
- Chapter 10: Creating Function Procedures
- Sub Procedures versus Function Procedures
- Why Create Custom Functions?
- An Introductory Function Example
- Function Procedures
- Function Arguments
- Function Examples
- Emulating Excel's SUM function
- Extended Date Functions
- Debugging Functions
- Dealing with the Insert Function Dialog Box
- Using Add-ins to Store Custom Functions
- Using the Windows API
- Chapter 11: VBA Programming Examples and Techniques
- Chapter 7: Introducing Visual Basic for Applications
- Part IV: Working with UserForms
- Chapter 12: Custom Dialog Box Alternatives
- Chapter 13: Introducing UserForms
- How Excel Handles Custom Dialog Boxes
- Inserting a New UserForm
- Adding Controls to a UserForm
- Toolbox Controls
- Adjusting UserForm Controls
- Adjusting a Control's Properties
- Displaying a UserForm
- Closing a UserForm
- Creating a UserForm: An Example
- Understanding UserForm Events
- Referencing UserForm Controls
- Customizing the Toolbox
- Creating UserForm Templates
- A UserForm Checklist
- Chapter 14: UserForm Examples
- Chapter 15: Advanced UserForm Techniques
- A Modeless Dialog Box
- Displaying a Progress Indicator
- Creating Wizards
- Emulating the MsgBox Function
- A UserForm with Movable Controls
- A UserForm with No Title Bar
- Simulating a Toolbar with a UserForm
- A Resizable UserForm
- Handling Multiple UserForm Controls with One Event Handler
- Selecting a Color in a UserForm
- Displaying a Chart in a UserForm
- Making a UserForm Semitransparent
- An Enhanced Data Form
- A Puzzle on a UserForm
- Video Poker on a UserForm
- Part V: Advanced Programming Techniques
- Chapter 16: Developing Excel Utilities with VBA
- Chapter 17: Working with Pivot Tables
- Chapter 18: Working with Charts
- Getting the Inside Scoop on Charts
- Creating an Embedded Chart
- Creating a Chart on a Chart Sheet
- Using VBA to Activate a Chart
- Moving a Chart
- Using VBA to Deactivate a Chart
- Determining Whether a Chart Is Activated
- Deleting from the ChartObjects or Charts Collection
- Looping through All Charts
- Sizing and Aligning ChartObjects
- Exporting a Chart
- Changing the Data Used in a Chart
- Using VBA to Display Arbitrary Data Labels on a Chart
- Displaying a Chart in a UserForm
- Understanding Chart Events
- Discovering VBA Charting Tricks
- Animating Charts
- Creating an Interactive Chart without VBA
- Working with Sparkline Charts
- Chapter 19: Understanding Excel's Events
- Chapter 20: Interacting with Other Applications
- Chapter 21: Creating and Using Add-Ins
- Part VI: Developing Applications
- Part VII: Other Topics
- Part VIII: Appendixes
-
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.