The Excel DeveloperExcel developers can be divided into five general categories, based on their experience and knowledge of Excel and VBA. To varying degrees, this book has something to offer each of them, but with a focus on the more advanced topics. Putting yourself into one of these categories might help you decide whether this is the right book for you.Chapter 4 Worksheet Design details the best practices to use when designing and laying out a worksheet for data entry, Chapter 14 Data Manipulation Techniques explains how to structure a worksheet and which functions and features to use to manipulate their lists, and Chapter 15 Advanced Charting Techniques, explains how to get the most from Excel's chart engine. The techniques suggested in these chapters should help the basic Excel user avoid some of the pitfalls often encountered as their experience and the complexity of their spreadsheets increases.The Excel power user has a wide understanding of Excel's functionality, knows which tool or function is best to use in a given situation, creates complex spreadsheets for his own use and is often called on to help develop colleagues' spreadsheets or to identify why colleagues' spreadsheets do not work as intended. Occasionally power users include small snippets of VBA they found on the Internet or created using the macro recorder, but struggle to adapt the code to their needs. As a result, they produce code that is untidy, slow and hard to maintain. Although this book is not a VBA tutorial, the power user has much to gain from following the best practices we suggest for both worksheets and code modules. Most of the chapters in the book are relevant to power users who have an interest in improving their Excel and VBA development skills.  |
لطفا منتظر باشید ...
