Chapter 14. Data Manipulation Techniques

Chapter 14. Data Manipulation Techniques

In this chapter, we turn away slightly from VBA to examine how we can make the most of Excel's advanced data-manipulation features. Although the user interface is usually the only part of our applications that our users will know (or care) about, it is the quality and efficiency of our data processing that provides the solid foundation on which a great user interface can be built.

Excel provides some extremely powerful data-manipulation features, if used in the correct way. The most difficult aspect of organizing our data processing is often deciding which features to use in each situation, and how they can be efficiently combined.