For a user … By a user
This book is a collection of general techniques that can be easily combined to create a wide variety of spreadsheet based solutions.
Written for a typical analyst/manager business owner (who spends a lot of time combining & processing inputs from different sources and then sends different outputs to different stakeholder), instead of diving deep into minute details, the book focuses on techniques that:
– can be used frequently
– have practical utility
– are easy to learn
– are flexible enough to be combined with at least one other technique.
Techniques to work on data in an Excel workbook & also integrate Excel with MS Word, MS PowerPoint, MS Outlook, Lotus Notes & databases.Main focus is on automation with VBA code but, formula based methods are also described.
The book is divided as follows:
Part I–Data in a workbook
Starts off with basic keystrokes & VBA code needed for moving around on a worksheet & performing some basic operations.
Explores the Range object-fundamental object for writing macros. Various methods are shown that provide a reference to a specific range on a worksheet.