O'Reilly logo

Professional Excel Development: The Definitive Guide to Developing Applications Using Microsoft® Excel and VBA® by John Green, Rob Bovey, Stephen Bullen

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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.

Excel's Data Structures

Excel's data-handling features fall into two distinct ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required