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 ...
Get Professional Excel Development: The Definitive Guide to Developing Applications Using Microsoft Excel, VBA, and .NET, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
