O'Reilly logo

Professional Excel Development: The Definitive Guide to Developing Applications Using Microsoft Excel, VBA, and .NET, Second Edition by John Green, Stephen Bullen, Dennis Wallentin, Rob Bovey

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 20. Data Manipulation Techniques

In this chapter, we examine how to make the most of Excel’s advanced data-manipulation features. While 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 is built. Excel provides some powerful data manipulation features. 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 groups. Most worksheet functions are designed to operate on individual items ...

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