- 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 VI: Programming Excel with VBA
IN THIS PART
Introducing Visual Basic for Applications
Creating Custom Worksheet Functions
Introducing UserForms
Using UserForm Controls in a Worksheet
Working with Excel's Events
VBA Examples
Creating Custom Excel Add-Ins
If you've ever wanted to do a bit more or automate routine operations so that you don't always have to perform boring, repetitious tasks manually, this part is for you. This part is also aimed at those Excel users who want to develop Excel-based applications for other users. VBA — Visual Basic for Applications — is the powerful programming language that you can use for these tasks as well as for more esoteric purposes, such as developing that specialized worksheet function that you simply can't find in Excel.
-
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.