Gopalkrishnan Harish. Advanced Excel Solutions: A user's cookbook

Amazon Digital Services, 2016. — 783 р. — ASIN B01HA3FB12.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.