Havish Madhvapaty: 5 books

You probably know the basics of Excel and use it on a regular basis, and are looking to learn more. But how much more? And more importantly, learn what? Excel is arguably the most powerful application in the MS Office suite. The huge variety of tools and functionalities range from the basic SUM formula...

Business Intelligence and Analytics (BI&A) has been one of the leading technological trends in recent years and is one of the top most priority technology investments. Enterprises require the support of extensive data processing and analytical techniques to bolster their processes. The book comes...

Microsoft Excel is a one of the most powerful data analysis tools available to everyone, major corporations and small businesses alike. Most Excel users will never bother to explore VBA programming, and might even actively find reasons to avoid working on it. Inertia aside, VBA programming...

Pivot Tables are an interesting topic to discuss – since nearly every intermediate to advanced Excel user uses them but are unaware of dozens of useful inbuilt functionalities. When coupled with creation of Ranges and Tables, the concept of structured references introduces a completely fresh way...

Excel has several financial features that act as powerful tools for building worksheets. These can be used to handle both personal and business finances. These functions can be used to calculate such things as the monthly payment on a loan, the future value of an annuity, the internal rate of return...